• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Ebuisness Suite » How to generate tkprof in EBS in 19c

How to generate tkprof in EBS in 19c

March 13, 2023 by techgoeasy Leave a Comment

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/[email protected] 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/[email protected] 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

Filed Under: Oracle, Oracle Ebuisness Suite

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to generate tkprof in EBS in 19c
  • Oracle tkprof utility
  • What is Skew in Database?
  • how to find file based on size in linux
  • SQL trace, 10046 event in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us