java 连接数据库报错 12514, 无法识别监听, 但是 PL 客户端可以连接
oracle 监听 添加 ip
同时修改 tnsnames.ora,listener.ora 将这两个文件中 HOST 后面的主机都修改为 127.0.0.1 然后重启 OracleServiceXE,OracleXETNSListener 服务
listener.ora 文件修改为
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (SID_NAME = PLSExtProc)
- (ORACLE_HOME = D:\Oracle11gXE\oracle\product\11.0.2\server)
- (PROGRAM = extproc)
- )
- (SID_DESC =
- (SID_NAME = CLRExtProc)
- (ORACLE_HOME = D:\Oracle11gXE\oracle\product\11.0.2\server)
- (PROGRAM = extproc)
- )
- (SID_DESC =
- (SID_NAME = XE)
- (ORACLE_HOME = D:\Oracle11gXE\oracle\product\11.0.2\server)
- )
- /* 黄色字体部分即为新加的数据库实例描述, 注意该实例那样加 (PROGRAM = extproc), 否则会报 "ORA-28547: TNS: 连接服务器失败, 可能是 Net8 管理错误."*/
- )
- LISTENER =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
- (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
- )
- )
- DEFAULT_SERVICE_LISTENER = (XE)
来源: http://www.bubuko.com/infodetail-3102057.html