Re: About Oracle database 12c CDB and PDB

1. Can I set a PDB open automatically when the CDB is opened?

You can write a trigge that will open all the PDB's, after the CDB is started up. Please refer to the section "Managing CDB's and PDB's", in the Oracle Learning Library OBE, "Performing Basic Tasks in Oracle MultiTenant". http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_basics/pdb_basics.html

create or replace trigger Sys.After_Startup after startup on database begin

   execute immediate 'alter pluggable database all open'; end After_Startup;
/

shutdown immediate

startup

select name, open_mode from v$pdbs;

-Rajeev.

-----Original Message-----

From: Kamus <kamusis_at_gmail.com>
To: Oracle-L <Oracle-L_at_freelists.org> Sent: Mon, Jul 15, 2013 6:15 am
Subject: About Oracle database 12c CDB and PDB

Hi all
I'm doing some tests for 12c new feature. I knew you guys are all experts willing to learn the new technology so I hope someone can answer my question even 12c is just released several days ago. 1. Can I set a PDB open automatically when the CDB is opened?

2. Is there a view that showed all the databases (including CDB and all the PDBs) information? like V$DATABASES for all the databases.

3. When will the ORA-24543 should occurred? Yesterday I tried to using "startup" to open the PDB, I got ORA-24543 error.

SQL> startup ORA-24543: instance startup OR shutdown NOT allowed IN pluggable DATABASE Today I tried again, it worked. What I modified is enable the multi-threaded database mode by setting threaded_execution=TRUE. Does it related?

SQL> SHOW USER USER IS "SYS" SQL> startup Pluggable DATABASE opened. SQL> SQL>

SHOW con_name   CON_NAME ------------------------------ PDBTEST

--

Kamus <kamusis_at_gmail.com>

Visit my blog for more : http://www.dbform.com Join ACOUG: http://www.acoug.org

--

http://www.freelists.org/webpage/oracle-l  

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 15 2013 - 14:12:10 CEST