Oracle 19c 连接PDB

最新推荐文章于 2024-07-23 02:44:56 发布

hbhe0316

最新推荐文章于 2024-07-23 02:44:56 发布

阅读量1.3k

点赞数

分类专栏： Oracle 文章标签： oracle

本文链接：https://blog.csdn.net/hbhe0316/article/details/120676563

版权

本文介绍了如何连接Oracle 19c的PDB，包括查看CDB和PDB名称，修改tnsnames.ora配置文件，并进行连接测试。

摘要由CSDN通过智能技术生成

1.查看CDB名称和PDB名称

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.测试