12c database syntaxes

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