OCI-c: Running autoconfig on a standby DBcs for R12.1.3/11gR2

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;

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s