Forum Stats

  • 3,872,914 Users
  • 2,266,489 Discussions
  • 7,911,381 Comments

Discussions

Cannot get explain plan in tkprof trace file for a pluggable database

Laury
Laury Member Posts: 1,672 Silver Badge

Hi,

I am working with an Oracle 19c container database.

If I attenpt with tkprof to generate a readable trace file fro an existing file, I get this error:

-- TNS for PDB: MARKTT01

tkprof ASGARD_ora_11327.trc TKPROF_2_ASGARD_ora_11327.trc [email protected] as sysdba

I get this:

---

TKPROF: Release 19.0.0.0.0 - Development on Sat Sep 17 15:25:06 2022

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

password =

---

If I provide the password, the trace file is creted, but inside it I find this ORA- error:

---

error connecting to database using: sysdba

ORA-01017: invalid username/password; logon denied

---

Does someone know how to get the explain plan with tkprof for a pluggable database?

Kind Regards

Answers