Opatch fails with Lock file error
While applying Oracle Patch, Opatch reports the below error : OUI-67064:OPatchSession cannot load inventory for the given Oracle Home /ora01/app/oracbr/product/11.2.0/dbhome_1. Possible causes are: …
Read MoreINCOIN The concurrent program for your request exited without calling standard Application Object Library exit routines or the process could have been terminated by the operating system
1.Check with the DBA about the field LFILE_SIZE in the table FND_CONCURRENT_REQUESTS is set to what value. 2.Check if log file is created properly with LFILE_SIZE > 0. If…
Read MoreQuery To Get Internal Manager (ICM) Log File Location
Query To Get Internal Manager (ICM) Log File Location ———————————————————————– SELECT ‘ICM_LOG_NAME=’ || fcp.logfile_name FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id AND fcp.queue_application_id = fcq.application_id AND …
Read MoreTNS-00583: Valid node checking: unable to parse configuration parameters
TNS-12560: TNS:protocol adapter error TNS-00583: Valid node checking: unable to parse configuration parameters I Received following errors when trying to startup my listener. I verified the listener.ora and sqlnet.ora files…
Read MoreTroubleshooting ASM Proxy instance startup
I had trouble starting ASM proxy instance on one of the nodes in my 2 node flex cluster having nodes host01 and host02. As a result I could not access…
Read MoreHow to get the output xml file (.out) file of the specific concurrent request in application R12.
How to get the output xml file (.out) file of the specific concurrent request in application R12. Requirements: 1.Concurrent program Request ID. 2.Output file destination. Steps: 1.End user ask for…
Read MoreQuery to check assigned responsibility of FND User.
Query to check assigned responsibility of FND User. —————————————————————- select usr.user_id, usr.user_name, res.RESPONSIBILITY_ID, res.RESPONSIBILITY_NAME from apps.FND_USER usr, apps.FND_RESPONSIBILITY_TL res, apps.FND_USER_RESP_GROUPS grp where upper(res.RESPONSIBILITY_NAME) like upper(‘%’ || NVL(‘&EnterResponsibilityName’, ‘INV’)|| ‘%’) and…
Read MoreQuery for High CPU consuming queries since past one day
set pages 50000 lines 32767 select * from ( select SQL_ID, sum(CPU_TIME_DELTA),sum(DISK_READS_DELTA),count(*) from DBA_HIST_SQLSTAT a, dba_hist_snapshot s where s.snap_id = a.snap_id and s.begin_interval_time > sysdate -1 group by SQL_ID order…
Read MoreORA-19566: Exceeded limit of 0 corrupt blocks for file:
**ORA-19566: Exceeded limit of 0 corrupt blocks for file: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571:…
Read MoreORA-02374: Conversion error loading table during impdp
Error: ORA-02374: conversion error loading table “SCHEMA”.”TABLENAME” ORA-12899: value too large for column ENAME (actual: 66, maximum: 64) ORA-02372: data for row: ENAME : 0X’45737061C3B16F6C2020202020202020202020202020202020′ More About the Error: 1. …
Read More