Re: About Oracle database 12c CDB and PDB

  • From: Martin Klier <usn@xxxxxxxxx>
  • To: kamusis@xxxxxxxxx
  • Date: Mon, 15 Jul 2013 14:34:27 +0200

Hi Kamus,

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

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


Other related posts: