Oracle 12c 18c 19c JDBC方式连接PDB数据库

1.配置监听

这里假定CDB数据库名为ORCL，PDB在CDB下面名称为PDBORCL
listener.ora添加(#后面为注释，不要添加进去)

1. SID_LIST_LISTENER =

2. (SID_LIST =

3. (SID_DESC =

4. (GLOBAL_DBNAME = ORCL)

5. (SID_NAME = ORCL) #这里是SID名

6. )

7. (SID_DESC =

8. (GLOBAL_DBNAME = PDBORCL)#这里是PDB数据库名

9. (SID_NAME = ORCL) #这里是SID名

10. )

11. )

 tnsname.ora添加

1. PDBORCL=

2. (DESCRIPTION =

3. (ADDRESS_LIST =

4. (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT =1521))

5. )

6. (CONNECT_DATA =

7. (SERVICE_NAME = PDBORCL) #这里是PDB数据库名

8. )

9. )

 2.重启监听(需要管理员权限)

lsnrctl reload

 重启监听也可以用下面的代码：
停止监听

lsnrctl stop

 启动监听

lsnrctl start

 3.检查JDBC代码
注意:连接PDB时，1521端口号后面不是冒号:，而是斜线/
例如 

String url = "jdbc:oracle:thin:@//localhost:1521/pdborcl";  

 

转载于:https://www.cnblogs.com/gsls200808/p/4405499.html