Oracle Database/ERP/Cloud/RAC/Misc Solutions

How to check OCR keys using OCRDUMP on RAC 12c To check the OCR keys values using ocrdump utility, please run below command: /u01/app/12.1.0/grid/bin/ocrdump.bin -stdout -keyname SYSTEM.version.hostnames [SYSTEM.version.hostnames] UNDEF : SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} [SYSTEM.version.hostnames.rac_node1] ORATEXT : 12.1.0.2.0 SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} [SYSTEM.version.hostnames.rac_node1.patchlevel] UB4 (10) : 0 SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} [SYSTEM.version.hostnames.rac_node2] ORATEXT : 12.1.0.2.0 SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME :...

Oracle Database Health Check Script Run this script has sysdba user or any user having DBA Role Change the spool file patch to correct directory. In this example it is set to  /export/home/oraprod/ $ cat Health_Check_Script.sql set pagesize 1100 SET MARKUP HTML ON SPOOL ON spool /export/home/oraprod/health_check_new.html set feedback off set linesize 200; set pages 50 set lines 1000 set pages 70 set heading on PROMPT================================================================ prompt PROMPT PROMPT Daily_Monitoring Checkup Report prompt ================================================================================================================================================= PROMPT REPORT DATE select to_char(sysdate,'DD-MON-YYYY:HH:MI:SS') "Report Run Date" from dual; prompt DATABASE NAME PROMPT ============== select instance_name,host_name,version,status from gv$instance ,v$database a; PROMPT DATABASE INFO PROMPT =============...

While running ADOP / ADPATCH the below error occurs: The ORACLE username specified below for Application Object Library uniquely identifies your existing product group: APPLSYS Enter the ORACLE password of Application Object Library [APPS] : ***** AutoPatch is verifying your username/password. Connecting to APPS......Connected successfully. Error: Unable to execute statement < Begin ad_jar.get_jripasswords(:l_storepass, :l_keypass); End; > len = 63 AutoPatch error: ORA-06550: line 3, column 1: PLS-00201: identifier 'AD_JAR.GET_JRIPASSWORDS' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored AutoPatch error: Unable to get passwords from Vault CAUSE The AD_JAR object not available in apps schema.   SQL> desc AD_JAR ERROR: ORA-04043: object AD_JAR does not exist SOLUTION 1. Please login as applmgr (Unix user that own application binaries ) 2. Source the application environment file . (APPS.env) 3. cd $AD_TOP/patch/115/sql/ 4. Login to dat...