oracle 19c连接容器数据库

方法1:
sqlplus sys/oracle@192.168.162.101/pdb1 as sysdba


方法二:
修改tnsnames.ora文件,添加对应容器数据库服务
PDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.101)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdb1)
    )
  )

连接:
sqlplus sys/oracle@pdb1 as sysdba

方法3:
进入cdb,再切换到pdb
alter session set container=pdb1;

  

posted @ 2022-08-09 15:05  orcl  阅读(877)  评论(0编辑  收藏  举报