APP-FND-01388: Cannot read value for profile option FND_MGR_STRTUP_THRES_TIME in routine &ROUTINE.

Issue: APP-FND-01388: Cannot read value for profile option FND_MGR_STRTUP_THRES_TIME in routine &ROUTINE.

Routine FDPCRQ encountered an ORACLE error. ORA-04031: unable to

allocate 32 bytes of shared memory ("shared pool".

Review your error messages for the cause of the error. (=<POINTER>)

Solution:

If the database parameter named _memory_broker_stat_interval has not been explicitely set to a value of 999 as per solution #3 of note 'Common Cause for ORA-4031 in 10gR2, Excess "KGH: NO ACCESS" Memory Allocation [Video]' (Doc ID 801787.1) then I would start with solution #3to see if that change alone is enough to avoid further ORA-04031 errors (especially if the failed allocation requests are for 32 bytes).

ALTER SYSTEM SET "_memory_broker_stat_interval"=999 SCOPE=SPFILE;
Then the instance would need to be restarted for the change to take effect.

how to spool xls file in oracle sqlplus

[prompt#] sqlplus / as sysdba

SQL> set markup html on;

SQL&gt; spool details.xls 

SQL&gt; select * from v$session;

SQL&gt;spool off

SQL&gt;exit

how to check blockers in oracle 10g, 11g

set echo off

column blocker format a11;

column blockee format a10;

column sid format 99999;

select

           (select username from v$session where sid=a.sid) blocker,

         a.sid,

       ' is blocking ' "IS BLOCKING",

         (select username from v$session where sid=b.sid) blockee,

             b.sid

    from v$lock a, v$lock b

   where a.block = 1

     and b.request > 0

     and a.id1 = b.id1

     and a.id2 = b.id2

/

select ctime/60,sid from v$lock where block>0;  

select program,ACTION,STATUS,serial# from v$session where sid='&sid';

SELECT substr(DECODE(request,0,'Holder: ','Waiter: ')||sid,1,12) sess, id1, id2, lmode, request, type FROM GV$LOCK WHERE (id1, id2, type) IN (SELECT id1,id2,type FROM GV$LOCK WHERE request>0) order by id1;

select sid, serial#, action, module, program, status, last_Call_ET/60 as LCET_min from gv$session where sid in

(select session_id from dba_locks where blocking_others='Blocking')

select sid, b.serial#, osuser, b.username, status, process, paddr, spid

from v$process a,v$session b

where sid = '&sid'

and a.addr = b.paddr

and b.username != ' '

order by 1

select sql_text

  from   v$session, v$sqltext

  where v$session.sql_address = v$sqltext.address

  and   V$session.sql_hash_value = v$sqltext.hash_value

  and  sid = &sid

order by piece

ORA-32593: database supplemental logging attributes in flux

For databases with high activity where there are always active transactions the supplemental logging can be enabled by bouncing the database and running the statement manually:
STARTUP MOUNT
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE OPEN;


Cause:


When you enable supplemental logging, additional information is recorded in the redo stream that is needed to make the information in the
redo log files useful to you.

The amount of redo generated when supplemental logging is enabled is quite high when compared to when supplemental logging is disabled

1)This may significantly increase the size of redo logs and will have some impact on performace of database.
2)No
3)You must enable supplemental logging prior to generating log files that will be analyzed by LogMiner.

Review Note 750198.1 Effect of Supplemental Logging on LogMiner with Example

If you do not intend to use Logminer , you must disable supplemental logging

You can turn off Supplemental Logging by following command.

SQL> ALTER DATABASE DROP SUPPLEMENTAL LOG DATA;

unable to create users in R12 after OAM/OID integration R12. (Register and De-Register instance in OAM/OID)

1. Shutdown application services using adstpall.sh

Deregistering this instance from OID Server.
=============================

bash-3.00$ $FND_TOP/bin/txkrun.pl -script=SetSSOReg -deregisteroid=yes



De-Register Instance.
===============
bash-3.00$ $FND_TOP/bin/txkrun.pl -script=SetSSOReg -deregisterinstance=yes


De-Registering of References

===================
bash-3.00$ $FND_TOP/bin/txkrun.pl -script=SetSSOReg -removereferences=Yes


Register Instance
===========
bash-3.00$ $FND_TOP/bin/txkrun.pl -script=SetSSOReg -registerinstance=yes

Register Instance with OID
==================


$FND_TOP/bin/txkrun.pl \
-script=SetSSOReg \
-registeroid=yes \
-ldaphost=www.domain.com \
-ldapport=3060 \
-oidadminuser=cn=orcladmin \
-oidadminuserpass=Welcome1234 \
-appspass=appspwd \
-instpass=Welcome1234 \
-appname=INSTANCENAME \
-svcname=SERVICENAME\
-provisiontype=4 \
-dbldapauthlevel=0

Start the services using adstrtal.sh

Check the value for profile: "Applications SSO Type "

This should be set to "SSWA w/SSO" ; if not set it and bounce OPMN processes on E-Biz.

Re-test the issue 

Create a new test user in E-Biz

SP2-1503: Unable to initialize Oracle call interface (11g db upgrade issue)

Issue:

error while running sqlplus command.
[oravis@orafin02 11.2.0]$ sqlplus

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Solution:
[oravis@orafin02 11.2.0]$ cd $ORACLE_HOME/oracore/zoneinfo
[oravis@orafin02 zoneinfo]$
[oravis@orafin02 zoneinfo]$
[oravis@orafin02 zoneinfo]$ ln -s timezone_11.dat timezone.dat
[oravis@orafin02 zoneinfo]$ ln -s timezlrg_11.dat timezlrg.dat
[oravis@orafin02 zoneinfo]$
[oravis@orafin02 zoneinfo]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Apr 7 01:11:35 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>

How to remove archives for a specific date

$cd <archive_location>
$rm `ls -l|grep "Apr 13" |awk '{print $9}'`