My Oracle Support Banner

ORA-65011: Pluggable Database Does Not Exist (Doc ID 2443851.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Getting below error while connecting to PDB:

SQL> alter session set container=N0039119; 
ERROR:
ORA-65011: Pluggable database N0039119 does not exist.


v$pdbs shows database is "READ WRITE"

SQL> select con_id,OPEN_MODE,RESTRICTED,OPEN_TIME,RECOVERY_STATUS from v$pdbs where NAME = 'N0039119';

  CON_ID OPEN_MODE RES OPEN_TIME RECOVERY
---------- ---------- --- --------------------------------------------------------------------------- --------
3 READ WRITE NO 25-AUG-18 11.24.52.460 AM -07:00 ENABLED

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 N0039119 READ WRITE NO <<<<<<<<<

4 N0031222 READ WRITE NO

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.