Upgrade from 12c to 19c - EBS database

[satish]

Dear Erman,

I think, you can only help us quickly on this.


Using Oracle 19c Oracle RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2 (Doc ID 2530665.1)

Section 6: Upgrading the Existing Oracle 11g or 12c Database to Oracle Database 19c

6.1 Perform Pre-Steps Before the Database Upgrade

Create an initialization parameter setup file containing the non-default customized initialization parameters from the source database along with some 19c parameter specific to Oracle E-Business Suite. Run the following command to create this file <DB_NAME>_initparam.sql along with some other files as mentioned in the following text. These files will be used later after database upgrade and during create PDB in Section 7.
 
In a separate terminal, source the non-CDB database environment file.
 
If the source non-CDB database is single instance, run txkOnPremPrePDBCreationTasks.pl as in the following example:

Running below command:
 
If the source non-CDB database is Oracle RAC, shut down all other Oracle RAC instances and run the following commands:

[orauat@erpuatdb1 ~]$ . /u02/UATDB/12.1.0/UATDB1_erpuatdb1.env
[orauat@erpuatdb1 ~]$  cd /u02/UATDB/12.1.0/appsutil
[orauat@erpuatdb1 appsutil]$ . ./txkSetCfgCDB.env dboraclehome=/u02/UATDB/12.1.0

Oracle Home being passed: /u02/UATDB/12.1.0
[orauat@erpuatdb1 appsutil]$ perl $ORACLE_HOME/appsutil/bin/txkOnPremPrePDBCreationTasks.pl -dboraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -dbsid=UATDB1 -appsuser=apps -skipdbshutdown=yes -israc=yes
Enter the APPS Password:



Script Name    : txkOnPremPrePDBCreationTasks.pl
Script Version : 120.0.12020000.13
Started        : Mon Jan 23 13:53:17 IST 2023

Log File       : /u02/UATDB/12.1.0/appsutil/log/TXK_PRE_PDB_Mon_Jan_23_13_53_11_2023/txkOnPremPrePDBCreationTasks.log


-----------
Values used
-----------
DB Oracle Home        : /u02/UATDB/12.1.0
OUT Directory         : /u02/UATDB/12.1.0/appsutil/log
Skip DB shutdown      : yes
EBS SID               : UATDB1
APPS Schema Username  : apps
Is RAC?               : yes
Logical Hostname      :




=========================
Validating oracle home...
=========================
Oracle Home: /u02/UATDB/12.1.0 exists.


===========================
Validating out directory...
===========================
Out directory: /u02/UATDB/12.1.0/appsutil/log exists.


============================
Inside getDBHostDetails()...
============================
DB Hostname : erpuatdb1
DB Domain   : ttd.com
Logical hostname is not passed, hence using physical hostname details.
Logical hostname: erpuatdb1.ttd.com


==========================
Inside setContextName()...
==========================
CONTEXT_NAME: UATDB1_erpuatdb1


============================
Inside setFileLocations()...
============================


=====================
Inside getDBName()...
=====================
Generating SQL file : /u02/UATDB/12.1.0/appsutil/log/TXK_PRE_PDB_Mon_Jan_23_13_53_11_2023/get_db_name.sql
SQL output file     : /u02/UATDB/12.1.0/appsutil/log/TXK_PRE_PDB_Mon_Jan_23_13_53_11_2023/get_db_name.out
Spool File          : /u02/UATDB/12.1.0/appsutil/log/TXK_PRE_PDB_Mon_Jan_23_13_53_11_2023/spool_get_db_name.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...

Execute SYSTEM command : sqlplus /nolog @/u02/UATDB/12.1.0/appsutil/log/TXK_PRE_PDB_Mon_Jan_23_13_53_11_2023/get_db_name.sql


==============================
Inside searchFileContents()...
==============================
log_file: /u02/UATDB/12.1.0/appsutil/log/TXK_PRE_PDB_Mon_Jan_23_13_53_11_2023/get_db_name.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
Removing the file: /u02/UATDB/12.1.0/appsutil/log/TXK_PRE_PDB_Mon_Jan_23_13_53_11_2023/get_db_name.sql

EXIT STATUS: 0
Getting the value of DB Name...
db_name: UATDB

PDB_DESC_XML: /u02/UATDB/12.1.0/dbs/UATDB_PDBDesc.xml
INITPARAM_FILE: /u02/UATDB/12.1.0/dbs/UATDB_initparam.sql
DATATOP_FILE: /u02/UATDB/12.1.0/dbs/UATDB_datatop.txt


========================
Inside getDBVersion()...
========================
DB_VERSION = db121



==================================
Validating content of TNS_ADMIN...
==================================
*******FATAL ERROR*******
PROGRAM : (/u02/UATDB/12.1.0/appsutil/bin/txkOnPremPrePDBCreationTasks.pl)
TIME    : Mon Jan 23 13:53:17 2023
FUNCTION: main::validateTnsAdminContent [ Level 1 ]
ERRORMSG: File /u02/UATDB/12.1.0/network/admin/UATDB1_erpuatdb1/sqlnet.ora does not exist. Copy it from old Oracle Home to /u02/UATDB/12.1.0/network/admin/UATDB1_erpuatdb1
*******FATAL ERROR*******
PROGRAM : (/u02/UATDB/12.1.0/appsutil/bin/txkOnPremPrePDBCreationTasks.pl)
TIME    : Mon Jan 23 13:53:17 2023
FUNCTION: main::validateTnsAdminContent [ Level 1 ]
ERRORMSG: File /u02/UATDB/12.1.0/network/admin/UATDB1_erpuatdb1/sqlnet.ora does not exist. Copy it from old Oracle Home to /u02/UATDB/12.1.0/network/admin/UATDB1_erpuatdb1


On node1 We have UATDB_erpuatdb1 instead of UATDB1_erpuatdb1
On node2 We have UATDB_erpuatdb2 instead of UATDB2_erpuatdb2

[orauat@erpuatdb1 appsutil]$ ls -lrt /u02/UATDB/12.1.0/network/admin/UATDB1_erpuatdb1/sqlnet.ora
ls: cannot access /u02/UATDB/12.1.0/network/admin/UATDB1_erpuatdb1/sqlnet.ora: No such file or directory


We have it under:

[orauat@erpuatdb1 UATDB_erpuatdb1]$ ls -lrt /u02/UATDB/12.1.0/network/admin/UATDB_erpuatdb1/sqlnet.ora
-rw-r----- 1 orauat dba 836 Jan 20 18:57 /u02/UATDB/12.1.0/network/admin/UATDB_erpuatdb1/sqlnet.ora
[orauat@erpuatdb1 UATDB_erpuatdb1]$


[orauat@erpuatdb1 UATDB1_erpuatdb1]$ cd $TNS_ADMIN
[orauat@erpuatdb1 UATDB_erpuatdb1]$ pwd
/u02/UATDB/12.1.0/network/admin/UATDB_erpuatdb1
[orauat@erpuatdb1 UATDB_erpuatdb1]$ ls
ERPPROD_erpproddb_ifile.ora            sqlnet1704285PM2208.bak    UATDB_erpuatdb1auto                    UATDB_erpuatdb1_ifile.ora_bkp231017
ERPPROD_erpproddb_ifile.ora_Bkp220217  sqlnet_ifile.ora           UATDB_erpuatdb1_ifile.ora              UATDB_erpuatdb1_ifile.orabkpkamesh
listener1704285PM2208.bak              sqlnet.ora                 UATDB_erpuatdb1_ifile.ora_             UATDB_erpuatdb1_ifile.orabkppppppppppp
listener_ifile.ora                     sqlnet.ora-bkp1711         UATDB_erpuatdb1_ifile.ora1             UATDB_erpuatdb1_ifile.oradollar
listener_ifile.ora_G1                  tnsnames1704285PM2208.bak  UATDB_erpuatdb1_ifile.ora_bkp
listener.ora                           tnsnames.ora               UATDB_erpuatdb1_ifile.ora_bkp07112017
nohup.out                              UATDB_erpuatdb1            UATDB_erpuatdb1_ifile.orabkp12345
[orauat@erpuatdb1 UATDB_erpuatdb1]$

Can we modify the dbsid=UATDB as below and run it,Will it cause any issues later. Need your expertise.

perl $ORACLE_HOME/appsutil/bin/txkOnPremPrePDBCreationTasks.pl -dboraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -dbsid=UATDB -appsuser=apps -skipdbshutdown=yes -israc=yes

Thanks,
Satish

[ErmanArslansOracleBlog]

The error already state what you need to do.
It say copy it.. "to" and it gives you the destination directory.. So you should know what you need to do. Do what is says.

[ErmanArslansOracleBlog]

And some example commands for RAC..

execute node 1 (shutdown node2)
$ perl $ORACLE_HOME/appsutil/bin/txkOnPremPrePDBCreationTasks.pl -dboraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -dbsid=EBSTEST1 -appsuser=APPS -skipdbshutdown=yes -israc=yes

shutdown node1, and execute on node 2
$ perl $ORACLE_HOME/appsutil/bin/txkOnPremPrePDBCreationTasks.pl -dboraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -dbsid=EBSTEST2 -appsuser=APPS -skipdbshutdown=yes -israc=yes