EBS R12 is supported in Multitenant mode for Oracle Database 19c. If you try to generate a tkprof report explain plan generation on the Database, you will errors for the Invalid username /password in the trace file generated
tkprof test.trc test.txt sys=no explain=apps/apps sort=prsela,exeela,fchela
The reason for this is that apps is the user in the PDB only. It is not a user in the CDB
If you try to set ORACLE_PDB_SID to remove this error, it will still give the same issues.
export ORACLE_PDB_SID=EBS
tkprof test.trc test.txt sys=no explain=apps/apps sort=prsela,exeela,fchela
The reason for that is ORACLE_PDB_SID supports login for sysdba only.
The correct way to do that would be to source the PDB environment or set the TNS_ADMIN to the PDB tnsnames
cd $ORACLE_HOME
. ./EBS_TECH.env
tkprof test.trc test.txt sys=no explain=apps/apps@EBS sort=prsela,exeela,fchela
or you can just set the TNS_ADMIN to that directory which has the PDB name in tnsnames.ora
export TNS_ADMIN=$ORACLE_HOME/network/admin/pdb_techgo
tkprof test.trc test.txt sys=no explain=apps/apps@EBS sort=prsela,exeela,fchela
I hope you find this useful. Please do provide the feedback
Related Articles
SQL trace, 10046 event in Oracle
Java web start in R12
Leave a Reply