Oracle PDB配置SID访问-526互联

1、lsnrctl status 确保PDB容器监听正常

2、确保PDB容器读写正常

sqlplus / as sysdba

show pdbs;

3、修改 tnsname.ora文件

cd /opt/oracle/product/19c/dbhome_1/network/admin

vi tnsnames.ora (追加，保持原有内容不变，在后面追加下面内容)

ORA19CPDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORA19CPDB)
    )
  )

ORA19CPDB_SID =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = ORA19CPDB)
    )
  )