oracle 12c 멀티테넌트 환경에서 pdb01 접속

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 12.1.0.1 RAC 2Node 멀티테넌트

쿼리 : oracle 12c 멀티테넌트 환경에서 pdb01 접속

rac 설치 후 node1 tnsnames.ora 파일 수정

vi /app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora

기존내용
RACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-cluster-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = racdb)
    )
  )
아래에 아래 내용 추가
PDB01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP) (HOST = rac-cluster-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdb01)
    )

 

이후 접속

sqlplus sys/oracle@pdb01 as sysdba

또는

sqlplus /nolog
conn sys/oracle@pdb01 as sysdba

참조 :  http://en.community.dell.com/techcenter/enterprise-solutions/w/oracle_solutions/5063.how-to-connect-to-pluggable-databases-in-oracle-rac-12cr1