oracle12cPDB里建立的用户登录不上去,显示IO错误:Unknownhostspecified
- 作者: 为什么忘不了那个她
- 来源: 51数据库
- 2021-09-02
连接失败, 错误报告:
user = store
url = jdbc:oracle:thin:@orclpdb
错误消息 = io 错误: unknown host specified
碰到这个问题的童靴们,正解如下:
首先在 oracle enterprise manager database express 12c中查看容器名是

然后在 $home$\product\12.2.0\dbhome_1\network\admin\tnsnames.ora中增加
orclpdb =
(description =
(address = (protocol = tcp)(host = localhost)(port = 1521))
(connect_data =
(server = dedicated)
(service_name = orclpdb)
)
)
这样,在登录的时候写@orclpdb就可以解析为本地host了,之前出现登录不了也就是无法解析到本地localhost
推荐阅读
