Posted by
satish on
Jan 27, 2023; 6:14am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Implementing-Autoconfig-on-RAC-after-EBS-database-upgrade-to-19c-tp11514.html
Dear Erman,
We have 2 node RAC.We are Running below statement on node 2:
8. Implement AutoConfig on the PDBs on the Remaining Oracle RAC Nodes in the Cluster
Copy the $ORACLE_HOME/appsutil directory from the first node to the $ORACLE_HOME/appsutil directory.
Ensure the local listener of the CDB is registered with the Oracle E-Business Suite listener or grid listener and remote listener is configured pointing to the SCAN listener.
To implement AutoConfig, run the txkCfgPDBRACNode.pl script using the following commands and provide the apps password when prompted:
$ cd <19c ORACLE_HOME>/appsutil
$ . ./txkSetCfgCDB.env dboraclehome=<19c ORACLE_HOME>
$ export ORACLE_SID=<CDB_SID>
$ perl $ORACLE_HOME/appsutil/bin/txkCfgPDBRACNode.pl -dboraclehome=<19c ORACLE_HOME> \
-outdir=<19c ORACLE_HOME>/appsutil/log -cdbname=<CDB Name> -dbuniquename=<CDB db_unique_name> \
-cdbsid=<CDB Instance Name> -pdbsid=<PDB Name> -appsuser=apps -israc=yes \
-virtualhostname=<VIP Hostname> -dbport=<EBS DB port> -scanhostname=<Scan name> \
-scanport=<Scan Port> -servicetype=onpremise
========================
Shutting down the PDB...
========================
==========================
Inside checkPDBStatus()...
==========================
Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/check_pdb_status.sql
SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/check_pdb_status.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/check_pdb_status.sql
==============================
Inside searchFileContents()...
==============================
log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/check_pdb_status.out
pattern: MOUNTED
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
PDB is open. Proceeding to close it.
Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/close_PDB.sql
SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/close_PDB.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/close_PDB.sql
==============================
Inside searchFileContents()...
==============================
log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/close_PDB.out
pattern: ERROR
================
Pattern found...
================
EXIT STATUS: 1
SQL execution did not go through successfully.
LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/close_PDB.out.
*******FATAL ERROR*******
PROGRAM : (/u02/UAT19CBASE/19chome/appsutil/bin/txkCfgPDBRACNode.pl)
TIME : Fri Jan 27 11:34:36 2023
FUNCTION: main::shutdownDatabase [ Level 1 ]
ERRORMSG: SQL execution did not go through successfully.
*******FATAL ERROR*******
PROGRAM : (/u02/UAT19CBASE/19chome/appsutil/bin/txkCfgPDBRACNode.pl)
TIME : Fri Jan 27 11:34:36 2023
FUNCTION: main::shutdownDatabase [ Level 1 ]
ERRORMSG: SQL execution did not go through successfully.
[orauat@erpuatdb2 appsutil]$
Node 2:
======
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 UATDB MOUNTED
SQL> alter session set container=UATDB;
Session altered.
SQL> alter pluggable database UATDB close immediate;
alter pluggable database UATDB close immediate
*
ERROR at line 1:
ORA-65020: pluggable database UATDB already closed
Node 1:
======
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 UATDB READ WRITE NO
SQL> alter session set container=UATDB;
Session altered.
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 UATDB READ WRITE NO
Do we need to close the PDB in node 1 as well?
Do we need to shut down uatcdb1 on node 1 before running above statement?
Please guide.
Thanks,
Satish