[oracle@test-node1 ~]$ sqlplus tms/tms@PDB
SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 1 15:02:50 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
sql developer
select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
2 PDB$SEED READ ONLY
3 PDB1 MOUNT
[oracle@test-node1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 1 15:43:24 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> alter pluggable database all open;
SQL> ALTER PLUGGABLE DATABASE "PDB1" SAVE STATE
Pluggable database altered.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=PDB1;
Session altered.
SQL> show user
USER is "SYS"
SQL> alter system register;
System altered.
[oracle@test-node1 ~]$ sqlplus tms/tms@PDB
SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 1 15:44:49 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Mon Aug 22 2016 16:45:56 +03:00
Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL>
--------------------------------------------------------
[oracle@test-node2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 1 15:43:24 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> alter pluggable database all open;
SQL> ALTER PLUGGABLE DATABASE "PDB1" SAVE STATE
Pluggable database altered.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=PDB1;
Session altered.
SQL> show user
USER is "SYS"
SQL> alter system register;
System altered.
[oracle@test-node2 ~]$ sqlplus tms/tms@PDB
SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 1 15:44:49 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Mon Aug 22 2016 16:45:56 +03:00
Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL>
---------------
sql developer
select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
2 PDB$SEED READ ONLY
3 PDB1 READ WRITE
SQL> col con_name format A10
SQL> col instance_name format A10
SQL> col state format A10
SQL> SELECT con_name, instance_name, state FROM dba_pdb_saved_states;
CON_NAME INSTANCE_N STATE
---------- ---------- ----------
PDB1 erptest_1 OPEN
PDB1 erptest_2 OPEN