我本机上安装了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)
)
)
