客户端连接pdb

最新推荐文章于 2025-12-02 19:00:00 发布

原创最新推荐文章于 2025-12-02 19:00:00 发布 · 479 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

oracle 专栏收录该内容

26 篇文章

订阅专栏

本文档详细介绍了如何配置Oracle客户端以连接到PDBORCL。主要涉及tnsnames.ora和listener.ora文件的修改，以及重启服务后的数据库状态切换。通过指定的SQL命令，展示了从CDB$ROOT切换到PDBORCL并验证连接成功的过程。

connect infa_training/infa_training@pdborcl as sysdba

没有配置成功,虽然创建了用户,但是无法连接db

次のコマンドの開始中にエラーが発生しました : 行 20 -
connect ...
エラー・レポート -
接続に失敗しました
USER = infa_training
URL = jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATEDL) (SERVICE_NAME = pdborcl) ) )
エラー・メッセージ = ORA-01017: invalid username/password; logon denied
Commit

需要进行如下两步配置修改

C:\app\ora\product\12.1.0\dbhome_1\NETWORK\ADMIN

tnsnames.ora

pdborcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATEDL)
(SERVICE_NAME = pdborcl)
)
)

C:\app\ora\product\12.1.0\dbhome_1\NETWORK\ADMIN

listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = pdborcl)
(ORACLE_HOME = C:\app\ora\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\ora\product\12.1.0\dbhome_1\bin\oraclr12.dll")
)
)