search

tanelpoder / tpt-oracle

Tanel Poder's Performance & Troubleshooting Tools for Oracle Databases
https://tanelpoder.com
Other
657 stars 312 forks source link

Latchprof - ORA-65011: Pluggable database does not exist.- 12.2.0.1 PSU Jan 2019 #21

Open jacobvz-1 opened 4 years ago

jacobvz-1 commented 4 years ago

[oracle@cltsadm01vm01 tpt-oracle-master]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jun 3 13:35:47 2020

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to: Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production

SQL> alter session set container=PRD605 2 /

Session altered.

SQL> @latchprof sid,name % % 1000000

-- LatchProf 2.10 by Tanel Poder ( https://blog.tanelpoder.com ) old 5: &_lhp_what new 5: sid,name old 8: , COUNT() / &_lhp_samples total_samples_pct new 8: , COUNT() / 1000000 total_samples_pct old 10: (SELECT /+ NO_MERGE / 1 FROM DUAL CONNECT BY LEVEL <= &_lhp_samples) s, new 10: (SELECT /+ NO_MERGE / 1 FROM DUAL CONNECT BY LEVEL <= 1000000) s, old 20: l.sid LIKE '&_lhp_sid' new 20: l.sid LIKE '%' old 21: AND (LOWER(l.name) LIKE LOWER('%&_lhp_name%') OR LOWER(RAWTOHEX(l.laddr)) LIKE LOWER('%&_lhp_name%')) new 21: AND (LOWER(l.name) LIKE LOWER('%%%') OR LOWER(RAWTOHEX(l.laddr)) LIKE LOWER('%%%')) old 24: &_lhp_what new 24: sid,name old 30: &_lhp_what new 30: sid,name old 34: , s.total_samples / &_lhp_samples 100 latchprof_pct_total_samples new 34: , s.total_samples / 1000000 100 latchprof_pct_total_samples old 35: , (t2.hsecs - t1.hsecs) 10 s.total_samples / &_lhp_samples latchprof_total_ms new 35: , (t2.hsecs - t1.hsecs) 10 s.total_samples / 1000000 latchprof_total_ms old 37: , (t2.hsecs - t1.hsecs) 10 s.total_samples / dist_samples / &_lhp_samples latchprof_avg_ms new 37: , (t2.hsecs - t1.hsecs) 10 s.total_samples / dist_samples / 1000000 latchprof_avg_ms t1, * ERROR at line 39: ORA-65011: Pluggable database does not exist.

SQL> exit Disconnected from Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production [oracle@cltsadm01vm01 tpt-oracle-master]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jun 3 13:40:18 2020

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to: Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production

SQL> @latchprof sid,name % % 1000000

-- LatchProf 2.10 by Tanel Poder ( https://blog.tanelpoder.com ) old 5: &_lhp_what new 5: sid,name old 8: , COUNT() / &_lhp_samples total_samples_pct new 8: , COUNT() / 1000000 total_samples_pct old 10: (SELECT /+ NO_MERGE / 1 FROM DUAL CONNECT BY LEVEL <= &_lhp_samples) s, new 10: (SELECT /+ NO_MERGE / 1 FROM DUAL CONNECT BY LEVEL <= 1000000) s, old 20: l.sid LIKE '&_lhp_sid' new 20: l.sid LIKE '%' old 21: AND (LOWER(l.name) LIKE LOWER('%&_lhp_name%') OR LOWER(RAWTOHEX(l.laddr)) LIKE LOWER('%&_lhp_name%')) new 21: AND (LOWER(l.name) LIKE LOWER('%%%') OR LOWER(RAWTOHEX(l.laddr)) LIKE LOWER('%%%')) old 24: &_lhp_what new 24: sid,name old 30: &_lhp_what new 30: sid,name old 34: , s.total_samples / &_lhp_samples 100 latchprof_pct_total_samples new 34: , s.total_samples / 1000000 100 latchprof_pct_total_samples old 35: , (t2.hsecs - t1.hsecs) 10 s.total_samples / &_lhp_samples latchprof_total_ms new 35: , (t2.hsecs - t1.hsecs) 10 s.total_samples / 1000000 latchprof_total_ms old 37: , (t2.hsecs - t1.hsecs) 10 s.total_samples / dist_samples / &_lhp_samples latchprof_avg_ms new 37: , (t2.hsecs - t1.hsecs) 10 s.total_samples / dist_samples / 1000000 latchprof_avg_ms t1, * ERROR at line 39: ORA-65011: Pluggable database does not exist.

SQL> SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED
     2 PDB$SEED                       READ ONLY  NO
     3 IBMSPDB1                       READ WRITE NO
     4 PRD605                         READ WRITE NO

SQL>