select ‘Soft Parses ‘ “Ratio” ,round( ((select sum(value) from v$sysstat where name = ‘parse count (total)’) – (select sum(value) from v$sysstat where name = ‘parse count (hard)’)) /(select sum(value) from…
Read MoreAutoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2 /u01/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 2 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status…
Read MoreQuery to check if DMZ is enabled select p.user_profile_option_name “Profile Name”, decode(v.profile_option_value, 1, ‘Admin’, 2, ‘Normal’, 3, ‘External’, ‘Unknown’) Value, decode(v.level_id, 10001, ‘SITE’, 10002, (select ‘App:’||a.application_short_name from fnd_application a where…
Read MoreQuery To Get Archive Log Apply Rate Speed of a Standby Database set linesize 180 col Values for a70 col Recovery_start for a21 select to_char(START_TIME,’dd.mm.yyyy hh24:mi:ss’) “Recovery_start”, to_char(item)||’ =…
Read MoreQuery to check user session statistics col pid format 9999 heading ‘PID’ col spid format a6 heading ‘SERVER|PID’ col sid format 9999 heading ‘SID’ col serial# format 99999 heading ‘SERIAL’…
Read MoreError: adpatch Fails After Restart With Error: “Unable to read file format id from file adainit.rf9” Solution: cd <$APPL_TOP>/admin/AXMD/restart/ Rename the file adainit.rf9 mv adainit.rf9 adainit.rf9.org
Read MoreERROR: $opatch lsinventory OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred: Can not get a list of inventory on this home. ERROR: OPatch failed because of Inventory problem. Solution:…
Read MoreERROR: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database 12c Database: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database CloneContext_***.log Shows the Message: Exception occurred: java.sql.SQLException:…
Read MoreISSUE: Unable to connect sqlplus after cloning oracle_home Solution: OSDBA_GROUP should be mentioned while cloning ORACLE_HOME as mentioned below $ORACLE_HOME/perl/bin/perl clone.pl ORACLE_BASE=”/scratch/aime/clone” ORACLE_HOME=”/u01/app/oracle/dbhome” OSDBA_GROUP=dba OSOPER_GROUP=oper -defaultHomeName OR Take Backup of…
Read MoreORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA ERRORCODE = 1 ERRORCODE_END $ Solution ========= s_instLocalListener is not correct in database server context file 1. Take Backup of Context…
Read More