Re: Upgrade EBS database 12c to 19c - RAC

Posted by ErmanArslansOracleBlog on Jan 27, 2023; 3:45pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Upgrade-EBS-database-12c-to-19c-RAC-tp11505p11521.html

as far as I remember, that script doesn't connect to the database.. (but you can check it.. It is a perl script open it with the a text editor(like "vi") and check.. If so, no need to be a listener up and ready to make the script be executed properly..

And, if you plan to use grid listener for EBS Databsae, then set -dbport value to grid listener port , otherwise supply the listener port of the listener that you are planning to use. Just do what the document says.

Some examples for RAC:

NODE1
set 19 ENV
export ORACLE_SID=TEST19C1
$ cd <19c ORACLE_HOME>/appsutil
$ . ./txkSetCfgCDB.env dboraclehome=/u01/app/oracle/product/19.0.0.0/dbhome_2

$ perl $ORACLE_HOME/appsutil/bin/txkGenCDBTnsAdmin.pl -dboraclehome=/u01/app/oracle/product/19.0.0.0/dbhome_2 -cdbname=TEST19C -cdbsid=TEST19C1 -dbport=1521 -outdir=/tmp -israc=YES -virtualhostname=erman01-vip

NODE2
set 19C ENV
export ORACLE_SID=TEST19C2
$ cd <19c ORACLE_HOME>/appsutil
$ . ./txkSetCfgCDB.env dboraclehome=/u01/app/oracle/product/19.0.0.0/dbhome_2

$ perl $ORACLE_HOME/appsutil/bin/txkGenCDBTnsAdmin.pl -dboraclehome=/u01/app/oracle/product/19.0.0.0/dbhome_2 -cdbname=TEST19C -cdbsid=TEST19C2 -dbport=1521 -outdir=/tmp -israc=YES -virtualhostname=erman02-vip