DBA Hub

📋Steps in this guide1/1

How To Create Pluggable Database In Oracle 12c

In this blog, We will see How  to create the pluggable database in oracle 12c.

oracle configurationintermediate
by OracleDba
12 views
1

Overview

In this blog, We will see How  to create the pluggable database in oracle 12c. Now Connect to Sqlplus utility, check pdbs.

Code/Command (click line numbers to comment):

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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
[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> startup
ORACLE instance started.

Total System Global Area 1912602624 bytes
Fixed Size                  8794168 bytes
Variable Size            1191186376 bytes
Database Buffers          704643072 bytes
Redo Buffers                7979008 bytes
Database 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                        MOUNTED
SQL>
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 NO
SQL>
[oracle@node1 ~]$ cd $ORACLE_HOME/bin
[oracle@node1 bin]$ ./dbca

[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
SQL>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!