How To Create Pluggable Database In Oracle 12c
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 [oracle@node1 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 2 16:46:10 2022 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startupORACLE instance started. Total System Global Area 1912602624 bytesFixed Size 8794168 bytesVariable Size 1191186376 bytesDatabase Buffers 704643072 bytesRedo Buffers 7979008 bytesDatabase mounted.Database opened.SQL>SQL>SQL> select name , open_mode from v$database; NAME OPEN_MODE--------- --------------------PRIM READ WRITE SQL>SQL>SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBPRIM MOUNTEDSQL>SQL>SQL> alter pluggable database all open; Pluggable database altered. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBPRIM READ WRITE NOSQL>[oracle@node1 ~]$ cd $ORACLE_HOME/bin[oracle@node1 bin]$ ./dbca
Now Connect to Sqlplus utility, check pdbs.
1234567891011121314151617181920 [oracle@node1 bin]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 2 17:08:10 2022 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL>SQL>SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBPRIM READ WRITE NO 4 PDB1 READ WRITE NO
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | [oracle@node1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 2 16:46:10 2022Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 1912602624 bytesFixed Size 8794168 bytesVariable Size 1191186376 bytesDatabase Buffers 704643072 bytesRedo Buffers 7979008 bytesDatabase mounted.Database opened.SQL>SQL>SQL> select name , open_mode from v$database;NAME OPEN_MODE--------- --------------------PRIM READ WRITESQL>SQL>SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBPRIM MOUNTEDSQL>SQL>SQL> alter pluggable database all open;Pluggable database altered.SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBPRIM READ WRITE NOSQL>[oracle@node1 ~]$ cd $ORACLE_HOME/bin[oracle@node1 bin]$ ./dbca |
Now Connect to Sqlplus utility, check pdbs.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | [oracle@node1 bin]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 2 17:08:10 2022Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL>SQL>SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBPRIM READ WRITE NO 4 PDB1 READ WRITE NO |
No comments:
Post a Comment