STARTUP and SHUTDOWN CDB AND PDB
in this blog i have explain STARTUP and SHUTDOWN CDB AND PDB
oracle configurationintermediate
by OracleDba
11 views
📋Steps in this guide1/1
1
Overview
STARTUP and SHUTDOWN CDB AND PDB
Code/Command (click line numbers to comment):
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406
[oracle@localhost ~]$ cat /etc/oratab | grep -i CDB2
CDB2:/u01/app/oracle/product/12.2.0.1:N
[oracle@localhost ~]$
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [CDB2] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 15 17:30:11 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1577058304 bytes
Fixed Size 8793208 bytes
Variable Size 503317384 bytes
Database Buffers 1056964608 bytes
Redo Buffers 7983104 bytes
Database mounted.
Database opened.
SQL>
SQL> select name,open_mode,cdb from v$database;
NAME OPEN_MODE CDB
--------- -------------------- ---
CDB2 READ WRITE YES <------
SQL>
SQL> show con_id con_name
CON_ID
------------------------------
1
CON_NAME
------------------------------
CDB$ROOT <-----
SQL>
SQL> col name for a30
SQL> select name,open_mode,con_id,dbid from v$containers;
NAME OPEN_MODE CON_ID DBID
------------------------------ ---------- ---------- ----------
CDB$ROOT READ WRITE 1 680230459
PDB$SEED READ ONLY 2 2993936271
PDB1 MOUNTED 3 627484885
PDB2 MOUNTED 4 891811039
PDB3 MOUNTED 5 424568091
PDB4 MOUNTED 6 2306285303
6 rows selected.
SQL>
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED <------
4 PDB2 MOUNTED
5 PDB3 MOUNTED
6 PDB4 MOUNTED
SQL>
SQL> ALTER PLUGGABLE DATABASE PDB1 OPEN;
Pluggable database altered.
SQL>
SQL> select name,open_mode,con_id,dbid from v$containers;
NAME OPEN_MODE CON_ID DBID
------------------------------ ---------- ---------- ----------
CDB$ROOT READ WRITE 1 680230459
PDB$SEED READ ONLY 2 2993936271
PDB1 READ WRITE 3 627484885 <----
PDB2 MOUNTED 4 891811039
PDB3 MOUNTED 5 424568091
PDB4 MOUNTED 6 2306285303
6 rows selected.
SQL>
-- Switch to PDB from CDB
SQL> alter session set container=PDB2; <----
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDB2
SQL> show con_id
CON_ID
------------------------------
4
SQL>
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
4 PDB2 MOUNTED <-----
SQL>
SQL> startup;
Pluggable Database opened.
SQL>
-- OR --
SQL> ALTER DATABASE OPEN;
Database altered.
SQL>
-- OR --
SQL> ALTER PLUGGABLE DATABASE OPEN;
Pluggable database altered.
SQL>
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
4 PDB2 READ WRITE NO
SQL>
SQL> select CON_ID,NAME,OPEN_MODE from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
4 PDB2 READ WRITE <------
SQL>
-- Switch to CDB from PDB
SQL> conn / as sysdba
Connected.
SQL>
SQL> select name,open_mode,cdb from v$database;
NAME OPEN_MODE CDB
------------------------------ -------------------- ---
CDB2 READ WRITE YES <----
SQL> show con_id
CON_ID
------------------------------
1
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT <---
SQL>
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
Pluggable database altered.
SQL>
SQL> SHOW PDBS;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO
6 PDB4 READ WRITE NO
SQL>
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> SHOW PDBS;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO
6 PDB4 READ WRITE NO
SQL>
SQL> ALTER PLUGGABLE DATABASE PDB1 CLOSE IMMEDIATE;
Pluggable database altered.
SQL>
SQL> SHOW PDBS;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED <-----
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO
6 PDB4 READ WRITE NO
SQL>
-- Switch to PDB from CDB
SQL> ALTER SESSION SET CONTAINER=PDB2; <----
Session altered.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
PDB2 <-----
SQL>
SQL> SHOW PDBS;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
4 PDB2 READ WRITE NO <------ R/W
SQL>
SQL> ALTER DATABASE CLOSE; <-- This command work only inside CDB
ALTER DATABASE CLOSE
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
SQL>
SQL> ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;
Pluggable database altered.
SQL>
--- OR ---
SQL> SHUT IMMEDIATE; -- PLEASE DO NOT RUN FROM CDB, IT WILL CLOSE CDB AND ALL PDBs inside CDB
Pluggable Database closed.
SQL>
SQL> SHOW PDBS;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
4 PDB2 MOUNTED <----
SQL>
-- Switch to CDB from PDB
SQL> CONN / AS SYSDBA
Connected.
SQL>
SQL> SHOW CON_NAME
CON_NAME
------------------------------
CDB$ROOT <----
SQL>
SQL> SHOW PDBS;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
4 PDB2 MOUNTED
5 PDB3 READ WRITE NO
6 PDB4 READ WRITE NO
SQL>
SQL> ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE;
Pluggable database altered.
SQL>
SQL> SHOW PDBS;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
4 PDB2 MOUNTED
5 PDB3 MOUNTED
6 PDB4 MOUNTED
SQL>
SQL> select name,open_mode,con_id,dbid from v$containers;
NAME OPEN_MODE CON_ID DBID
------------------------------ ---------- ---------- ----------
CDB$ROOT READ WRITE 1 680230459 <-- R/W
PDB$SEED READ ONLY 2 2993936271
PDB1 MOUNTED 3 627484885
PDB2 MOUNTED 4 891811039
PDB3 MOUNTED 5 424568091
PDB4 MOUNTED 6 2306285303
6 rows selected.
SQL>
SQL> SHOW CON_NAME
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> SHUT IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> !ps -ef | grep pmon
oracle 13612 12669 0 19:00 pts/0 00:00:00 /bin/bash -c ps -ef | grep pmon
oracle 13614 13612 0 19:00 pts/0 00:00:00 grep pmon
SQL>
SQL> col name for a30
SQL> select name,open_mode,con_id,dbid from v$containers;
NAME OPEN_MODE CON_ID DBID
------------------------------ ---------- ---------- ----------
CDB$ROOT READ WRITE 1 680230459
PDB$SEED READ ONLY 2 2993936271
PDB1 READ WRITE 3 627484885
PDB2 READ WRITE 4 891811039
PDB3 READ WRITE 5 424568091
PDB4 READ WRITE 6 2306285303
6 rows selected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT <----
SQL>
SQL> ALTER DATABASE CLOSE IMMEDIATE;
Database altered.
SQL>
SQL> select name,open_mode,con_id,dbid from v$containers;
NAME OPEN_MODE CON_ID DBID
------------------------------ ---------- ---------- ----------
CDB$ROOT MOUNTED 1 680230459
PDB$SEED MOUNTED 2 2993936271
PDB1 MOUNTED 3 627484885
PDB2 MOUNTED 4 891811039
PDB3 MOUNTED 5 424568091
PDB4 MOUNTED 6 2306285303
6 rows selected.
SQL>
SQL> shut immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> !ps -ef | grep pmon
oracle 14495 12669 0 19:16 pts/0 00:00:00 /bin/bash -c ps -ef | grep pmon
oracle 14497 14495 0 19:16 pts/0 00:00:00 grep pmon
SQL>Comments (0)
Please to add comments
No comments yet. Be the first to comment!