- Kiran Dalvi
- 10 Jun, 2019
- 0 Comments
- 1 Min Read
How to Create Pluggable database Manually-Oracle 12C administration
Follow the below steps to create pluggable database manually:
[oracle@prim ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 11 14:46:12 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> SQL> SQL> startup ORACLE instance started. Total System Global Area 1744828000 bytes Fixed Size 9135712 bytes Variable Size 452984832 bytes Database Buffers 1275068416 bytes Redo Buffers 7639040 bytes Database mounted. Database opened. SQL> SQL> SQL> SQL> SQL> select name, open_mode from v$database; NAME OPEN_MODE --------- -------------------- TESTDB READ WRITE SQL> SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBDB MOUNTED 4 ABC MOUNTED SQL> SQL> SQL> create pluggable database pdb1 admin user testuser identified by "testuser" default tablespace users datafile '/data/app/oracle/oradata/TESTDB/users02.dbf' size 10M AUTOEXTEND ON FILE_NAME_CONVERT=('/data/app/oracle/oradata/TESTDB/pdbseed','/data/app/oracle/oradata/TESTDB/PDB1'); SQL> 2 3 4 5 Pluggable database created. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBDB MOUNTED 4 ABC MOUNTED 5 PDB1 MOUNTED SQL> SQL> SQL> alter pluggable database pdb1 open; Pluggable database altered. SQL> SQL>