The environment is running eBS R12.1.3 with the database running 11.2.0.4 on an OCI-C DBcs. Perform the following steps to configure autoconfig on the standby dbsystem after the database got duplicated from the primary.
This note is written in the context of an eBS 12.1.3/11gR2 standby setup as described in this master note.
It is assumed that
- preclone has already been run on the primary environment.
- The primary db is called vis121p
- The secondary db is called vis121s
#1) Copy appsutil from the primary
cd $ORACLE_HOME scp -r <primary>:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil .
#2) Stop the listener if already started to complete the rman duplicate
lsnrctl stop
Failure to do so may prevent to reuse the 1521 port and keep the same ports as the primary system.
#3) Set the perl PATH
export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0 export PATH=$ORACLE_HOME/perl/bin:$PATH
Failure to do so may return the following error:
Running perl adcfgclone.pl dbTechstack on a DBCS system may fell with the following error: Perl lib version (5.10.1) doesn't match executable version (v5.10.0) at /usr/lib64/perl5/Config.pm line 50
#4) Run the cr9idata.pl script
cd $ORACLE_HOME/nls/data/old perl cr9idata.pl
#5) Run adcfgclone.pl dbTechStack
cd $ORACLE_HOME/appsutil/clone/bin perl adcfgclone.pl dbTechStack
Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA Oracle Applications Rapid Clone Version 12.0.0 adcfgclone Version 120.31.12010000.12 Enter the APPS password : Running: /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/java:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/xmlparserv2.jar:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_2026.lst -stage /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone -dbTechStack 2> /tmp/adcfgclone_2026.err; echo $? > /tmp/adcfgclone_2026.res Log file located at /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/CloneContext_0411172705.log Provide the values required for creation of the new Database Context file. Target System Hostname (virtual or normal) [vis121s] : Target Instance is RAC (y/n) [n] : Target System Database SID : vis121s Target System Base Directory : /u01/app/oracle Target System utl_file_dir Directory List : /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/outbound/vis121s_vis121s Number of DATA_TOP's on the Target System [2] : 1 Target System DATA_TOP Directory 1 : /u02/app/oracle/oradata/vis121s Target System RDBMS ORACLE_HOME Directory [/u01/app/oracle/db/tech_st/11.2.0] : /u01/app/oracle/product/11.2.0/dbhome_1 Do you want to preserve the Display [vis121p:0.0] (y/n) : n Target System Display [vis121s:0.0] : Do you want the the target system to have the same port values as the source system (y/n) [y] ? : y Complete port information available at /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/out/vis121s_vis121s/portpool.lst Backing up /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/vis121s_vis121s.xml to /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/vis121s_vis121s.xml2.bak Creating the new Database Context file from : /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/template/adxdbctx.tmp The new database context file has been created : /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/vis121s_vis121s.xml Log file located at /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/CloneContext_0411172705.log Check Clone Context logfile /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/CloneContext_0411172705.log for details. Running Rapid Clone with command: perl /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/adclone.pl java=/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/../jre mode=apply stage=/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/vis121s_vis121s.xml showProgress contextValidated=true Running: perl /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/adclone.pl java=/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/../jre mode=apply stage=/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/vis121s_vis121s.xml showProgress contextValidated=true APPS Password : Beginning rdbms home Apply - Wed Apr 11 17:27:58 2018 /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/u01/app/oracle/product/11.2.0/dbhome_1/oui -classpath /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/xmlparserv2.jar:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/ojdbc5.jar:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/java:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/ewt3.jar:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/share.jar:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/oui/srvm.jar:/u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTechStack -e /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/vis121s_vis121s.xml -stage /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/clone -showProgress APPS Password : Log file located at /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/log/vis121s_vis121s/ApplyDBTechStack_04111727.log / 0% completed Completed Apply... Wed Apr 11 17:28:55 2018 Starting database listener for vis121s: Running: /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/scripts/vis121s_vis121s/addlnctl.sh start vis121s Logfile: /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/log/vis121s_vis121s/addlnctl.txt You are running addlnctl.sh version 120.1.12010000.4 Starting listener process vis121s ... LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 11-APR-2018 17:28:55 Copyright (c) 1991, 2013, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/vis121s_vis121s/listener.ora Log messages written to /u01/app/oracle/product/11.2.0/dbhome_1/admin/vis121s_vis121s/diag/tnslsnr/vis121s/vis121a/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vis121s.compute-aXXXXXX.oraclecloud.internal)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vis121s.compute-aXXXXXX.oraclecloud.internal)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias vis121s Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 11-APR-2018 17:28:55 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/vis121s_vis121s/listener.ora Listener Log File /u01/app/oracle/product/11.2.0/dbhome_1/admin/vis121s_vis121s/diag/tnslsnr/vis121s/vis121a/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vis121s.compute-aXXXXXX.oraclecloud.internal)(PORT=1521))) Services Summary... Service "vis121s" has 1 instance(s). Instance "vis121s", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully addlnctl.sh: exiting with status 0 addlnctl.sh: check the logfile /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/log/vis121s_vis121s/addlnctl.txt for more information ...
#6) Bounce the database since executables were relinked
sqlplus / as sysdba <EOF shutdown immediate startup EOF
#7 Verify that the DG broker is still running
DGMGRL> SHOW CONFIGURATION; Configuration - dg_vis121a Protection Mode: MaxPerformance Databases: vis121a - Primary database vis121as - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS
Optionally, force a log switch from the primary
SQL> ALTER SYSTEM SWITCH LOGFILE;