Oracle Database 12c Local connection to PDB with SQLPlus
Hi all,
Regarding PDB (Pluggable DB) of Database 12c, is it possible to connect locally to PDB using SQLPlus like below?
It errors in my test computer.
--------------------------------------------------------
C:\Users\Administrator>set oracle_sid=pdb1 ("pdb1" is the name of PDB)
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on 木 8月 15 16:53:54 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
--------------------------------------------------------
Would you please tell me whether a local connection to PDB is possible or not and how?
My environment:
Oracle database 12c on Windows server 2008
The local connection to CDB works fine.
And I can connect remotely to pdb. (> sqlplus sys/pwd@hostname:1521/pdb1 as sysdba)
Regarding PDB (Pluggable DB) of Database 12c, is it possible to connect locally to PDB using SQLPlus like below?
It errors in my test computer.
--------------------------------------------------------
C:\Users\Administrator>set oracle_sid=pdb1 ("pdb1" is the name of PDB)
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on 木 8月 15 16:53:54 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
--------------------------------------------------------
Would you please tell me whether a local connection to PDB is possible or not and how?
My environment:
Oracle database 12c on Windows server 2008
The local connection to CDB works fine.
And I can connect remotely to pdb. (> sqlplus sys/pwd@hostname:1521/pdb1 as sysdba)
2