Apps DBA Workshop

I was installing Oracle 12.1.0.1 Database  software in a preparation of upgrading Oracle EBS R12.2 Database from version 11.2.0.3 to 12.1.0.1. When i started Installer from the stage location then it encountered error related to Inventory "[INS-21003] Installer has detected that an invalid inventory pointer location file was specified.." Error Stack from the Installation log file: INFO: Setting value for the property:id in the bean:configcmd INFO: Setting value for the property:platformcmdmap in the bean:configcmd INFO: Setting value for the property:id in the bean:configcmd INFO: Setting value for the property:platformcmdmap in the bean:configcmd INFO: Setting value for the property:id in the bean:configcmd INFO: Setting value for the property:platformcmdmap in the bean:configcmd INFO: Setting value for the property:id in the bean:configcmd INFO: Setting value for the property:platformcmdmap in the bean:configcmd INFO: Setting value for the property:configcmds in t...

 We were not able to create the container database and it encountered following Error: [pool-1-thread-1] [ 2021-08-17 15:25:52.277 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName [pool-1-thread-1] [ 2021-08-17 15:25:52.277 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName:nodenumber: 1 [pool-1-thread-1] [ 2021-08-17 15:25:52.279 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName:nodename: erp-preprod-db01 INFO: Aug 17, 2021 3:25:52 PM oracle.assistants.dbca.util.NodeSelectionHelper reorderLocalNodeIndex INFO: Local node found at index:0 localnode:erp-preprod-db01 INFO: Aug 17, 2021 3:25:52 PM oracle.assistants.dbca.action.DBIdentificationAction updateRACConfiguration INFO: Added: [erp-preprod-db01, erp-preprod-db02] to the node list in the bean [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [has.UtilNative.Native] prsr_trace: Native: getCRSHome [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [has.UtilNa...

The following post will provide the list of steps that needs to be performed while performing a manual switchover to DR database when Data guard is configured between these database. These commands are helpful if we are not using broker for switchover operations: Primary DB -  ERPDB Standby DB  DERPDB*   STEP1:(ERPDB) srvctl status database -d ERPDB srvctl stop instance  -d ERPDB  -i ERPDB2 -o immediate srvctl status database -d ERPDB STEP2: (DERPDB) srvctl status database -d DERPDB srvctl stop instance  -d DERPDB  -i DERPDB1 -o immediate srvctl status database -d DERPDB STEP3:(ERPDB) SELECT  NAME,DB_UNIQUE_NAME,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE; STEP4:(DERPDB) SELECT  NAME,DB_UNIQUE_NAME,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE; STEP5:(ERPDB) - Convert ERPDB to Physical standby database ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN; SHUTDOWN IMMEDI...