Query 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 MoreERROR: ORA-17627: ORA-01041: internal error. hostdef extension doesn’t exist ORA-19849: error while reading backup piece from service PROD ORA-03113: end-of-file on communication channel ORA-19558: error de-allocating device ORA-19557: device error,…
Read MoreError: Autoconfig could not process the following files: Directory: $ORA_CONFIG_HOME/10.1.3/Apache/Apache/bin .apachectl BINCPY .apachectl BINCPY AutoConfig is exiting with status 2 Solution: Change owner for apachectl in below mentioned locations, cd…
Read More