12c database syntaxes - Revision history

Ittichai at 16:36, 13 August 2013

2013-08-13T16:36:34Z

Ittichai at 15:36, 13 August 2013

2013-08-13T15:36:06Z

Ittichai at 15:29, 13 August 2013

2013-08-13T15:29:44Z

Ittichai at 15:06, 13 August 2013

2013-08-13T15:06:59Z

Ittichai at 15:06, 13 August 2013

2013-08-13T15:06:07Z

Ittichai at 21:23, 5 August 2013

2013-08-05T21:23:22Z

Ittichai: Created page with "1. At first, create pluggable database. create pluggable database my_plug01 admin user my_admin identified by my_admin; alter pluggable database my_plug01 open; 2. Next, create ..."

2013-08-05T21:21:39Z

Created page with "1. At first, create pluggable database. create pluggable database my_plug01 admin user my_admin identified by my_admin; alter pluggable database my_plug01 open; 2. Next, create ..."

New page

1. At first, create pluggable database.
create pluggable database my_plug01 admin user my_admin identified by my_admin;
alter pluggable database my_plug01 open;

2. Next, create user in pluggable database.
alter session set container=MY_PLUG01;
create user test identified by test;

3. Regist the pluggable database in tnsnames.ora
$ cd $ORACLE_HOME/network/admin
$ vi tnsnames.ora
MY_PLUG01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME= MY_PLUG01)
)
)

4. Connect!
$ sqlplus test/test@my_plug01

[[Category: Oracle Database]]
[[Category: Oracle 12c]]

@@ Line 18: / Line 18: @@
 PDB$SEED	     NORMAL
 PDB12C2 	     NEW
 SQL> alter pluggable database pdb12c open;

@@ Line 10: / Line 10: @@
 FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb12c/pdbseed','/u01/app/oracle/oradata/cdb12c/pdb12c2');
 Pluggable database created.
 SQL> alter pluggable database pdb12c open;

@@ Line 1: / Line 1: @@
-* Create a pluggable database.
+* Create a pluggable database from the seed PDB.
 <pre>
 SQL> create pluggable database pdb12c admin user john identified by doe;
 SQL> alter pluggable database pdb12c open;
 </pre>

@@ Line 46: / Line 46: @@
 SQL> alter session set container=pdb12c;
 Session altered.
 SQL> create user test identified by test;

@@ Line 1: / Line 1: @@
-* Create a pluggable database.
+CON_ID
 <pre>
-create pluggable database pdb12c admin user john identified by doe;
+SQL> select name, con_id from v$active_services order by 1;
-alter pluggable database pdb12c open;
 </pre>
 * Create a user in the pluggable database.
 <pre>
-alter session set container=pdb12c;
+-- Cannot create a user in the container database.
-create user test identified by test;
+SQL> create user test identified by test;
 </pre>
 [[Category: Oracle Database]]
 [[Category: Oracle 12c]]