Himanshu Sinha - Oracle Apps DBA , Oracle DBA, Oracle Cloud DBA , Enterprise Architect.

After Login to Oracle Application 11i ,Getting below error: <PRE>Unable to create anonymous session. Your session is no longer valid. Oracle error 29285: java.sql.SQLException: ORA-29285: file write error ORA-06512: at &#34;SYS.UTL_FILE&#34;, line 183 ORA-06512: at &#34;SYS.UTL_FILE&#34;, line 1169 ORA-06512: at &#34;APPS.FND_CORE_LOG&#34;, line 406 ORA-06512: at &#34;APPS.FND_CORE_LOG&#34;, line 390 ORA-06512: at &#34;APPS.FND_CORE_LOG&#34;, line 130 ORA-06512: at &#34;APPS.FND_GLOBAL&#34;, line 1977 ORA-06512: at &#34;APPS.FND_GLOBAL&#34;, line 2309 ORA-06512: at &#34;APPS.FND_GLOBAL&#34;, line 2447 ORA-06512: at &#34;APPS.FND_SESSION_MANAGEMENT&#34;, line 884 ORA-06512: at &#34;APPS.FND_SESSION_MANAGEMENT&#34;, line 1189 ORA-06512: at &#34;APPS.FND_AOLJ_UTIL&#34;, line 421 ORA-06512: at &#34;APPS.FND_AOLJ_UTIL&#34;, line 236 ORA-06512: at line 1 has been detected in createSession...

Had a Challenge that wanted to keep Same Password to keep Application Running because even application team didn't know at how many places this password was used. When I checked the password it was in EXPIRE (GRACE) Status,  SQL> select USERNAME,ACCOUNT_STATUS,LOCK_DATE,EXPIRY_DATE,PROFILE from dba_users where username='WYSE'; USERNAME                       ACCOUNT_STATUS                   LOCK_DATE EXPIRY_DA PROFILE ------------------------------ -------------------------------- --------- --------- ------------------------------ WYSE                           EXPIRED(GRACE)                                                 DEFAULT While "ALTER USER WYSE PASSWORD EXPIRE" exists, the “PAS...

To find out blocker & waiter in RAC Instance (specially useful  in EBS) set lines 200 col WMOD for a20 col WCID for a20 col BCID for a20 col BMOD for a20 col BLOCKER for a12 col WAITER for a10 select vsb.sid bsid, vsb.inst_id binst, vsb.username blocker, vsb.client_identifier bcid, vsb.module bmod,        vsw.sid wsid, vsw.inst_id winst, vsw.username waiter, vsw.client_identifier wcid, vsw.module wmod,        trunc(vlw.ctime/60) minutes   from (select inst_id,sid, id1, id2, ctime from gv$lock where request > 0) vlw,        (select inst_id,sid, id1, id2, ctime from gv$lock where block > 0) vlb,        gv$session vsb,        gv$session vsw   where vsw.sid=vlw.sid     and vsb.sid=vlb.sid     and vsb.inst_id=vlb.inst_id     and vsw.inst_id=vlw.inst_id     and vlb.id1=vlw.id1     and vlb.id2=vlw.id...

Connect to APPS user and create following package to get Application user password. Package Specification: ------------------------------------------------------------------------------------------------------------ CREATE OR REPLACE PACKAGE get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2; END get_pwd; / Package Body: ------------------------------------------------------------------------------------------------------------ CREATE OR REPLACE PACKAGE BODY get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2    AS       LANGUAGE JAVA       NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; END get_pwd; / Query: ------------------------------------------------------------------------------------------------------------ SEL...

Find consuming sql from process id Get cpu consuming PID from top command and then execute below script to find relevant SQL statements along with SQL ID & Username prompt "Please Enter The UNIX Process ID" set lines 200 set long 20000 set pages 0 select s.username su, sa.SQL_ID, sa.sql_fulltext from v$process p, v$session s, v$sqlarea sa where p.addr=s.paddr and s.username is not null and s.sql_address=sa.address(+) and s.sql_hash_value=sa.hash_value(+) and spid=&SPID; for eg, [oracle@igrexandc003d02 ~]$ top top - 09:14:40 up 86 days, 10 min,  3 users,  load average: 13.56, 13.70, 14.04 Tasks: 818 total,  14 running, 804 sleeping,   0 stopped,   0 zombie Cpu(s): 56.4%us,  0.9%sy,  0.0%ni, 42.5%id,  0.0%wa,  0.0%hi,  0.2%si,  0.0%st Mem:  148704036k total, 113554696k used, 35149340k free,  1573068k buffers Swap: 25165816k total,     3712k use...

1. Enable Trace at the Report Definition.     Go to System Administrator -> Concurrent Programs -> Define , Query the report and check the 'Enable trace' check box ( Navigate to:   Profile->system   Query on the Profile Option: "Concurrent: Allow Debugging"   This should be set to 'yes' at 'Site' level.   If it isn't set, then set it, then logout and bounce the APPS services.   The 'Debug Options' button on the concurrent program will now be enabled. ) 2. Run the report for Step 1. above 3. Get the request id from below query. i.e. Request id = XXXXXXX select fcr.request_id "Request ID" --, fcr.oracle_process_id "Trace ID" , p1.value||'/'||lower(p2.value)||'_ora_'||fcr.oracle_process_id||'.trc' "Trace File" , to_char(fcr.actual_completion_date, 'dd-mon-yyyy hh24:mi:ss') "Completed" , fcp.user_concurrent_program_name "Program" ,...