1.查看CDB名称和PDB名称http://www.cndba.cn/hbhe0316/article/4707http://www.cndba.cn/hbhe0316/article/4707http://www.cndba.cn/hbhe0316/article/4707http://www.cndba.cn/hbhe0316/article/4707

SQL> select name from v$database;

NAME
---------------------------
ORCL

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 PDB                  READ WRITE NO

2.修改/u01/app/oracle/product/19.3.0/dbhome_1/network/admin/tnsnames.ora文件

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = node01)(PORT = 1521))

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node01)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

PDB01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node01)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdb)
    )
   )

3.测试

[oracle@node01 ~]$ tnsping PDB01

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 13-SEP-2021 08:44:23

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/19.3.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node01)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb)))
OK (0 msec)
[oracle@node01 ~]$ tnsping orcl

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 13-SEP-2021 08:44:27

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/19.3.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node01)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle,linux