Forum Stats

  • 3,851,381 Users
  • 2,263,969 Discussions
  • 7,904,691 Comments

Discussions

ORA-65011: Pluggable database PDBORCL does not exist.

Tony007
Tony007 Member Posts: 4,256 Bronze Trophy
edited Oct 18, 2017 3:31AM in Multitenant

hi i did the folowing

SQL> connect /as sysdbaConnected.SQL> alter pluggable database pdborcl open;alter pluggable database pdborcl open*ERROR at line 1:ORA-01109: database not openSQL> alter session set container=pdborcl;Session altered.SQL> startupORA-65054: Cannot open a pluggable database in the desired mode.

SQL> shutdownORA-65011: Pluggable database PDBORCL does not exist.SQL> select * from  v$pdbs;    CON_ID       DBID    CON_UID GUID---------- ---------- ---------- --------------------------------NAME                           OPEN_MODE  RES------------------------------ ---------- ---OPEN_TIME---------------------------------------------------------------------------CREATE_SCN TOTAL_SIZE BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID---------- ---------- ---------- -------- ----------------------         3 2643978541 2643978541 18E7C1E9404F4FE3B4564526E37EC139PDBORCL                        MOUNTED   2244208          0       8192 ENABLED                       0SQL> select * from cdb_pbs;select * from cdb_pbs              *ERROR at line 1:ORA-01219: database or pluggable database not open: queries allowed on fixedtables or views onlySQL> alter pluggable database pdborcl open;alter pluggable database pdborcl open*ERROR at line 1:ORA-65054: Cannot open a pluggable database in the desired mode.SQL> shutdownORA-65011: Pluggable database PDBORCL does not exist.SQL> startupORA-65011: Pluggable database PDBORCL does not exist.i did this alsoSQL> select name, open_mode from v$pdbs;NAME                           OPEN_MODE------------------------------ ----------PDB$SEED                       READ ONLYPDBORCL                        MOUNTEDSQL> alter pluggable database PDBORCL open;alter pluggable database PDBORCL open*ERROR at line 1:ORA-65011: Pluggable database PDBORCL does not exist.
Emad Al-MousaDineshKDubeyvanpupi

Best Answer

  • Unknown
    edited Oct 17, 2017 10:19PM Answer ✓
    I try with : alter pluggable database pdborcl open;good

    You can't open a PDB until you startup the instance to open the root/cdb.

    Hopefully the reason OP hasn't responded in a while is because they finally started the DB.

    SQL> alter session set container=pdborcl;. . .  Session altered.. . .  SQL> startupORA-65054: Cannot open a pluggable database in the desired mode.

    You don't use 'startup' for PDBs - you open them.

    Most likely OP never did a 'startup' to the database instance but then tried to use 'startup' with a PDB.

Answers

  • rchem
    rchem Member Posts: 972 Bronze Trophy
    edited Aug 8, 2017 2:03PM

    What is the open mode for the CDB ?

    select open_mode from v$database?

  • Tony007
    Tony007 Member Posts: 4,256 Bronze Trophy
    edited Aug 8, 2017 2:14PM

    this is what am geting

    SQL> select name, open_mode from v$pdbs;NAME                          OPEN_MODE------------------------------ ----------PDB$SEED                      READ ONLYPDBORCL                        MOUNTEDSQL> alter pluggable database PDBORCL open;alter pluggable database PDBORCL open*ERROR at line 1:ORA-65011: Pluggable database PDBORCL does not exist.SQL> select open_mode from v$database;OPEN_MODE--------------------READ WRITESQL> ALTER SESSION SET CONTAINER=PDBORCL;ERROR:ORA-65011: Pluggable database PDBORCL does not exist.
  • Vlad Visan-Oracle
    Vlad Visan-Oracle Member Posts: 1,249 Bronze Crown
    edited Aug 8, 2017 2:35PM

    Please have a look in PDB_PLUG_IN_VIOLATIONS view to see why the PDB cannot be opened.

  • Tony007
    Tony007 Member Posts: 4,256 Bronze Trophy
    edited Aug 8, 2017 2:57PM

    am geting this

    SQL> select  message from  PDB_PLUG_IN_VIOLATIONS;MESSAGE--------------------------------------------------------------------------------CDB parameter shared_pool_size mismatch: Previous 800M Current 0CDB parameter large_pool_size mismatch: Previous 64M Current 0CDB parameter java_pool_size mismatch: Previous 208M Current 0CDB parameter db_cache_size mismatch: Previous 16M Current 0CDB parameter pga_aggregate_target mismatch: Previous 64M Current 804MCDB parameter statistics_level mismatch: Previous 'BASIC' Current 'TYPICAL'Sync PDB failed with ORA-01955 while performing 'ALTER USER "ILS" DEFAULT ROLE "DBA"'Character set mismatch: PDB character set WE8MSWIN1252. CDB character set AL32UTF8.MESSAGE--------------------------------------------------------------------------------Character set mismatch: PDB character set WE8MSWIN1252. CDB character set AL32UTF8.Sync PDB failed with ORA-959 during 'ALTER USER "ILSLOG"DEFAULT TABLESPACE "USERS"TEMPORARY TABLESPACE "TEMP"ACCOUNT UNLOCK'Sync PDB failed with ORA-959 during 'ALTER USER "ILS"DEFAULT TABLESPACE "USERS"MESSAGE--------------------------------------------------------------------------------TEMPORARY TABLESPACE "TEMP"ACCOUNT UNLOCK'Sync PDB failed with ORA-959 during 'ALTER USER "SMS01" QUOTA 5242880 ON "USERS"'
  • Unknown
    edited Aug 8, 2017 6:29PM

    Sounds like there is a lot of 'something' you aren't telling us.

    Like you tried to plug in that PDB from some other system and the plug-in process failed.

    If you want help you have to SHOW US:

    1. WHAT you did

    2. HOW you did it

    3. WHAT results you got

    And if you are trying to move PDBs around you need to follow ALL of the instructions in the documentation. So if that is what you tried then post a link to the doc you used.

    DineshKDubey
  • Tony007
    Tony007 Member Posts: 4,256 Bronze Trophy
    edited Aug 9, 2017 4:20AM

    i did this it works

    SQL> alter pluggable database pdborcl open;alter pluggable database pdborcl open*ERROR at line 1:ORA-00704: bootstrap process failureORA-00604: error occurred at recursive SQL level 1ORA-65108: invalid use of a cursor belonging to another containerSQL> select name, open_mode from v$pdbs;NAME                           OPEN_MODE------------------------------ ----------PDB$SEED                       READ ONLYPDBORCL                        MOUNTEDSQL> alter session set container=pdborcl;Session altered.SQL> startupPluggable Database opened.SQL>  select name, open_mode from v$pdbs;NAME                           OPEN_MODE------------------------------ ----------PDBORCL                        READ WRITE
  • Unknown
    edited Aug 9, 2017 12:05PM
    i did this it works

    No - does NOT work - if 'it works' you wouldn't be getting an exception.

    Reread my reply and others.

    You can't open a PDB that doesn't exist.

    That supposed PDB had to come from somewhere - you either unplugged it from another DB and tried to plug it in or you tried to create it. Whatever you did is unknown to us but it failed.

    If you want help you have to SHOW US

    1. WHAT you did

    2. HOW you did it

    3. WHAT results you got

    4. WHAT doc you followed and what steps you took to create the pdb to begin with

    Emad Al-Mousavanpupi
  • user9274250
    user9274250 Member Posts: 5 Red Ribbon
    edited Oct 17, 2017 9:45PM

    I try with :

    alter pluggable database pdborcl open;

    good

  • Unknown
    edited Oct 17, 2017 10:19PM Answer ✓
    I try with : alter pluggable database pdborcl open;good

    You can't open a PDB until you startup the instance to open the root/cdb.

    Hopefully the reason OP hasn't responded in a while is because they finally started the DB.

    SQL> alter session set container=pdborcl;. . .  Session altered.. . .  SQL> startupORA-65054: Cannot open a pluggable database in the desired mode.

    You don't use 'startup' for PDBs - you open them.

    Most likely OP never did a 'startup' to the database instance but then tried to use 'startup' with a PDB.

This discussion has been closed.