我本机上安装了oracle和plsql后,在cmd上可以连接数据库,我在net configuration assistant上的本地网络服务名配置上面测试是通过的。
使用plsql登录的时候一直报ora-12170,网上查找了资料试了很多种还是解决不了,
我tnsping ip地址,ping ip,都是可以的,下图是我lsnrctl status后的,
我的tnsnames.ora是:
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.14)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)