Implementing Autoconfig on RAC after EBS database upgrade to 19c

[satish]

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

[satish]

[orauat@erpuatdb2 appsutil]$ cat /u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_10_39_48_2023/close_PDB.sql
connect / as sysdba
alter pluggable database "uatdb" close immediate;
exit;
[orauat@erpuatdb2 appsutil]$ cat /u02/UAT19CBASE/19chome/appsutil/log/TXK_CFG_PDB_RACNODE_Fri_Jan_27_11_33_46_2023/close_PDB.out

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 27 11:34:35 2023
Version 19.17.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Connected.
alter pluggable database "uatdb" close immediate
*
ERROR at line 1:
ORA-65011: Pluggable database uatdb does not exist.


Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
[orauat@erpuatdb2 appsutil]$

[ErmanArslansOracleBlog]

Oracle Support states the following:

"Start the CDB instance on the other Oracle RAC nodes of the cluster, and open the PDB in read write mode"

So, your PDB should be up.
But according to the log, it can be down as well.. It seems that the script checks it. If it sees the PDB in open state, it just closes it.
But in your case, the script doesn't like the output.. I expects the log to contain the string "MOUNTED", but it seems the log doesn't have it.

A PDB can be one of the following modes:

MOUNTED
READ WRITE
READ ONLY
MIGRATE


Anyways, your PDB is already closed. (MOUNTED)

Run the script while your PDB is closed and see if it helps.. (we may work around the problem  this way)
If you fail, send me the "close_PDB.sql" & "close_PDB.out" that will be generated by txkCfgPDBRACNode.pl

[ErmanArslansOracleBlog]

That lowercase "uatdb" may be the problem bythway.
Check your inputs..