txkGenCDBTnsAdmin.pl - Upgrade 19c

[satish]

Dear erman,

Please, We need your guidance regarding below step during the upgrade.


Create CDB TNS Files

Oracle EBS Network Configuration has always been different to the standard database network configuration as you know that the TNS_ADMIN in database of EBS points to $ORACLE_HOME/network/admin/<CONTEXT_NAME>. So we need to create the TNS files for EBS specifically using txkGenCDBTnsAdmin.pl.

cd $ORACLE_HOME/appsutil
. ./txkSetCfgCDB.env dboraclehome=/u02/oratest/app/oracle/19.3
cd $ORACLE_HOME/appsutil/bin
perl txkGenCDBTnsAdmin.pl -dboraclehome=/u02/oratest/app/oracle/19.3 -cdbname=testcdb \
-cdbsid=testcdb -dbport=1521 -outdir=/u02/oratest/app/oracle/19.3/appsutil/log


1)

Do we need to set tns admin to $ORACLE_HOME/network/admin/CONTEXT_NAME folder before running the above script.Where does this script expected to create configuration files either in $ORACLE_HOME/network/admin or $ORACLE_HOME/network/admin/CONTEXT_NAME

2)
In 12c,i$ORACLE_HOME/network/admin/CONTEXT_NAME contain tnsname, listener,sqlnet and it used by EBS. Is ther any role for it in 19c?

Pls advice.

Thanks,
Satish

[ErmanArslansOracleBlog]

Just set your env with ". ./txkSetCfgCDB.env dboraclehome=<full path of ORACLE_HOME>".. Don't set anything else related to Oracle EBS at that moment.

Follow MOS.. (not other sources..:) )

I couldn't understand your second question.. One is in 19C home, other one (as you mentioned) is in 12C home.. So I couldn't understand the reason that made you ask this question.

[satish]

Dear erman,

Thanks for the update.How is this $ORACLE_HOME/network/admin/CONTEXT_NAME used in 19c?Will listener.ora used by EBS...

Thank you

[ErmanArslansOracleBlog]

19C in EBS environments is multitenant as you may already know.
So the one with the context_name is related to the PDB env, and the one without the context_name is related with the CDB env.
You can set those environments and see. You can check the tnsnames and listener.ora files located in both of those TNS_ADMIN directories..

When I quickly checked my single instance LAB env, I see that mostly DB env is in use for tns related purposes (i.e for starting the instance)
 
TNS_ADMIN pointed by PDB env should also be there. I couldn't find time to check it with all its details, but it may be required.. For instance it may be used by the AD tools in ORACLE_HOME (but didn't dive deep and checked) -- just giving my comments.. tnsnames.ora in PDB env has some detailed TNS entries for failover connections, load balance connections and so on.. (this may become handy in RAC environments -- I didn't check a RAC 19C DB but just giving my comments)

And yes listener starts from CDB env.. (ad listener start script starts the listener from CDB env..)  But we have a listener defined in the PDB env as well.. Maybe this is due to having a seperate config for CDB and PDB.. For instance you can define a listener for CDB and a seperate listener for PDB.. (btw, there is no EBS specific example like that) .. Just giving my comments

So don't delete any of those directories.. Autoconfig creates them, they should be there.