Re: About Oracle database 12c CDB and PDB

you may want to have a general look at the CDB_ views, for example CDB_PDBS and others. They are usually same as DBA_ views, but extended with a CON_ID identifying the pluggable DB.

Regards
Martin

Kamus schrieb:

> 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

-- 
Usn's IT Blog for Oracle and Linux
http://www.usn-it.de

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