Shulou(Shulou.com)05/31 Report--

This article mainly shows you "oracle 12c how to check the status of pdb database", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "oracle 12c how to check the status of pdb database" this article.

To keep these two views in mind in your daily work, check the pdb status $sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 20 17:52:42 2018Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL > show con_nameCON_NAME--CDB$ROOTSQL > desc cdb_pdbs; Name Null? Type-PDB_ID NOT NULL NUMBER PDB_NAME NOT NULL VARCHAR2 (128) DBID NOT NULL NUMBER CON_UID NOT NULL NUMBER GUID RAW (16) STATUS VARCHAR2 (9) CREATION_SCN NUMBER VSN NUMBER LOGGING VARCHAR2 (9) FORCE_LOGGING VARCHAR2 (3) FORCE_NOLOGGING VARCHAR2 (3) CON_ID NOT NULL NUMBERSQL > col pdb_name for a30SQL > select pdb_id Pdb_name,status from cdb_pdbs PDB_ID PDB_NAME STATUS--2 PDB$SEED NORMAL 3 PDB1 NORMAL 4 PDB2 NORMAL 5 PDB3 NORMAL 6 PDB4 NORMALSQL > desc v$pdbs Name Null? Type-CON_ID NUMBER DBID NUMBER CON_UID NUMBER GUID RAW (16) NAME VARCHAR2 (30) OPEN_MODE VARCHAR2 (10) RESTRICTED VARCHAR2 (3) OPEN_TIME TIMESTAMP (3) WITH TIME ZONE CREATE_SCN NUMBER TOTAL_SIZE NUMBER BLOCK_SIZE NUMBER RECOVERY_STATUS VARCHAR2 (8) SNAPSHOT_PARENT_CON_ID NUMBERSQL > set line 200SQL > select con_id Name,open_mode from v$pdbs CON_ID NAME OPEN_MODE -2 PDB$SEED READ ONLY 3 PDB1 READ WRITE 4 PDB2 READ WRITE 5 PDB3 READ WRITE 6 PDB4 READ WRITESQL > above is all the content of the article "how oracle 12c checks the status of pdb databases" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.