Oracle Database/ERP/Cloud/RAC/Misc Solutions

Patch 26834480: adgrants.sql execution gives WARNINGS For the patch 26834480, we have to run the adgrants.sql , after comparing the highest version of this file present in $APPL_TOP/admin and the patch directory.  The highest version of adgrants.sql has to be copied to database home  $ORACLE_HOME/appsutil/admin directory The script will give the necessary grants and permissions and in the end, it will show warnings. SQL> @adgrants.sql apps Connected. . . . . ........... ......... The following ERRORS and WARNINGS have been encountered during this adgrants session: TIME_STAMP           SESSION_ID LOG_MODULE                                 LOG_LEVEL -------------------- ---------- ------------------------------------------ ---------- LOG_MESSAGE -----------------------------------------------------------------------------------------...

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...

Patch DN1F is mutually exclusive and cannot coexist with patch(es): CIH8 While applying a patch on WLS, we encounter the error: Patch DN1F is mutually exclusive and cannot coexist with patch(es): CIH8 Solution: Remove the conflicting patch using below command: [applmgr@oel7 bsu]$ ./bsu.sh -prod_dir=/u01/apps/TEST/fs1/FMW_Home/wlserver_10.3 -patchlist=CIH8 -verbose -remove Checking for conflicts........ No conflict(s) detected Starting removal of Patch ID: CIH8 Removing /u01/apps/TEST/fs1/FMW_Home/patch_wls1036/patch_jars/AppsAdapter.jar Removing /u01/apps/TEST/fs1/FMW_Home/patch_wls1036/patch_jars/bpm-infra.jar Removing /u01/apps/TEST/fs1/FMW_Home/patch_wls1036/patch_jars/DBAdapter.jar Removing /u01/apps/TEST/fs1/FMW_Home/patch_wls1036/patch_jars/dbws.jar Removing /u01/apps/TEST/fs1/FMW_Home/patch_wls1036/patch_jars/jca-binding-api.jar Updating /u01/apps/TEST/fs1/FMW_Home/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar Old manifest value...

In some case adop prepare phase fails due to some issues and if you wish to apply any patch in hotpatch mode, it will fail with below errors [STATEMENT] There is already a session which is incomplete. Details are: [STATEMENT]     Session Id: 2 [STATEMENT]     Prepare phase status: R [STATEMENT]     Apply phase status: N [STATEMENT]     Cutover  phase status: N [STATEMENT]     Abort phase status: N [STATEMENT]     Session status: F [ERROR]     Cannot apply hotpatch as another online patching cycle is going on [ERROR]     Unrecoverable error occured. Exiting the current session. [STATEMENT] [START 2019/10/22 16:13:00] Unlocking sessions table [STATEMENT] [END   2019/10/22 16:13:00] Unlocking sessions table [STATEMENT] Log file: /adop_20191022_161221.log [STATEMENT] [START 2019/10/22 16:13:02] Unlocking sessions table [STATEMENT] [E...

There is a very nice explanation of how to connect to an Oracle Cloud VM using putty.  Connect to a Cloud VM on Windows with PuTTY https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/ggcs/Connect_to_a_cloud_VM_on_Windows_with_Putty/connect_to_a_cloud_VM_using_Putty.html#summary PS: Instead of using the auto-login (oracle) user name use (opc). It worked for me.  Enjoy ur VM

There has been a structural changes on the primary DB ( like adding of data files,etc) and during the time, tried to connect from standby database using rman as below rman target / catalog rman/rman@dbcat Recovery Manager: Release 11.2.0.4.0 - Production on Mon Oct 21 13:30:38 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. connected to target database: SPROD (DBID=1981104798) connected to recovery catalog database RMAN> show all; 2> ; ORA-20079: full resync from primary database is not done doing automatic resync from primary resyncing from database with DB_UNIQUE_NAME SPROD RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of show command at 10/21/2019 11:00:29 RMAN-03014: implicit resync of recovery catalog failed RMAN-03009: fai...