Erman Arslan's Oracle Forum - Upgrade from 12c to 19c

Upgrade from 12c to 19c - EBS database

Posted by satish on Jan 23, 2023; 8:54am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Upgrade-from-12c-to-19c-EBS-database-tp11493.html

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