Skip to main content

Posts

Showing posts from August, 2022

Start & Stop Container & Pluggable DB

Start and stop the Pluggable & Container Database 1. Check the current session container. Note: I am login in CDB$ROOT container. SQL> show con_name CON_NAME -------------- CDB$ROOT Start and Stop pluggable database You should login in the pluggable or CDB$ROOT container. PDB shutdown can be managed from CDB$ROOT or by own PDB login. First step we will explain from CDB$ROOT connectivity. Second step will explain from direct PDB connectivity. 1. From CDB$ROOT container -- Check status from CDB$ROOT col name for a10 Select name,open_mode from v$pdbs; NAME OPEN_MODE ---------- ---------- PDB$SEED READ ONLY XEPDB1 READ WRITE PDB2 READ WRITE --Shutdown the PDB2 database alter pluggable database PDB2 close immediate; Pluggable database altered. ---Note: Shutdown change OPEN_MODE value to MOUNTED. --Start the PDB2 database alter pluggable database PDB2 open; Pluggable database altered. 2. From PDB direct connectivity --check you are in PDB show con_name CON...

Create Pluggable seed database

oracle@localhost ~ $ sqlplus SQL*Plus: Release 12.2.0.1.0 Production on Sat Aug 20 09:28:54 2022 Copyright (c) 1982, 2016, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 MDB READ WRITE NO SQL> CREATE PLUGGABLE DATABASE MDB2 ADMIN USER PDBADMIN IDENTIFIED BY "monu" DEFAULT TABLESPACE USERS DATAFILE '/u01/app/oracle/oradata/ORCLPDB/MDB2/users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED FILE_NAME_CONVERT=('/u01/app/oracle/oradata/ORCLPDB/pdbseed/','/u01/app/oracle/oradata/ORCLPDB/MDB2/'); 2 CREATE PLUGGABLE DATABASE MDB2 ADMIN USER PDBADMIN IDENTIFIED BY "monu" DEFAULT TABLESPACE USERS DATA...