一、ora-12170:tns:连接超时
问题场景（主机ip自动获取，没手动设置；导致主机ip自动修改）解决办法
将主机ip修改回原来的主机ip地址
二、ERROR-ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务
问题场景(主机ip自动获取，没手动设置；导致主机ip自动修改,即使修改回原本主机ip后，连接oracle数据库依然报错ora-12514错误)解决办法
参考文章
找到oracle安装位置下的C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora文件，具体路径根据个人安装oracle路径为准
修改listener.ora文件
添加
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = [具体实例名])
)
)
修改前
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = [具体主机IP地址])(PORT = 1521))
)
)
修改后
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = [具体主机IP地址])(PORT = 1521))
)
)
