ORA-12547: TNS:lost contact

[jieguo4]

请教一下，新安装Oracle， 不能访问问题， 安装 参考 《http://www.jianshu.com/p/36a78274a00e》进行的。
看这位博主也遇到了同样的问题，但不知道是否已经解决；

环境： centos7 + oracle 12c


命令操作显示如下：

[oracle@mes ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 04-JAN-2017 04:28:41

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mes.dfec.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 04-JAN-2017 04:28:28
Uptime 0 days 0 hr. 0 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/12.1.2/db_1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/mes/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mes.dfec.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully


[oracle@mes ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 4 04:28:57 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

ERROR:
ORA-12547: TNS:lost contact

Enter user-name:
ERROR:
ORA-12547: TNS:lost contact

Enter user-name:
ERROR:
ORA-12547: TNS:lost contact

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@mes ~]$

[js14982]

看看文件夹$ORACLE_HOME/bin/oracle文件权限是否有问题 如果权限不对 chmod 6751 $ORACLE_HOME/bin/oracle

[jieguo4]

引用 1 楼 js14982 的回复:

看看文件夹$ORACLE_HOME/bin/oracle文件权限是否有问题 如果权限不对 chmod 6751 $ORACLE_HOME/bin/oracle

谢谢， 这个我已经设置了权限的； [oracle@mes bin]$ ll oracle -rwsr-s--x. 1 oracle oinstall 0 Jul 7 2014 oracle

[鄙人王麻子]

为了验证你的问题，我特意从头做了一下，感觉这个文档有些不太好，现在还没开始装，稍后装完看看我会不会存在这个问题。

[jieguo1]

引用 6 楼 jieguo4 的回复:

/oracle/app/oracle/diag/tnslsnr/mes/listener/trace/listener.log 内容如下： 有一个WARNING... Fri Feb 03 21:58:33 2017 System parameter file is /oracle/app/oracle/product/12.1.2/db_1/network/admin/listener.ora Log messages written to /oracle/app/oracle/diag/tnslsnr/mes/listener/alert/log.xml Trace information written to /oracle/app/oracle/diag/tnslsnr/mes/listener/trace/ora_2789_140201565447680.trc Trace level is currently 0 Started with pid=2789 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mes)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE WARNING: Subscription for node down event still pending 03-FEB-2017 21:58:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mes.dfec.com)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375680)) * status * 0

上面这个WARNING已经解决： 在配置文件： /oracle/app/oracle/product/12.1.2/db_1/network/admin/listener.ora 中添加了如下一行， 然后重启监听（lsnrctl reload） SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

[jieguo4]

尝试 relink all, 报出如下错误： Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 2959 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-02-03_11-52-32PM. Please wait ...Please find the log file at /oracle/app/oracle/product/12.1.2/db_1/install/relinkActions2017-02-03_11-52-33-PM.log oracle.xml.parser.v2.XMLParseException: Start of root element expected. at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:323) at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:414) at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:355) at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:257) at oracle.sysman.oix.oixs.OixsSAXXmlParser.readXML(OixsSAXXmlParser.java:128) at oracle.sysman.oii.oiis.OiisMakeDepsReader.loadFromFile(OiisMakeDepsReader.java:219) at oracle.sysman.oii.oiis.OiisMakeDeps.doOperation(OiisMakeDeps.java:764) at oracle.sysman.oii.oiis.OiisMakeDeps.main(OiisMakeDeps.java:809) java.io.IOException: class oracle.xml.parser.v2.XMLParseException:Start of root element expected. at oracle.sysman.oix.oixs.OixsSAXXmlParser.readXML(OixsSAXXmlParser.java:150) at oracle.sysman.oii.oiis.OiisMakeDepsReader.loadFromFile(OiisMakeDepsReader.java:219) at oracle.sysman.oii.oiis.OiisMakeDeps.doOperation(OiisMakeDeps.java:764) at oracle.sysman.oii.oiis.OiisMakeDeps.main(OiisMakeDeps.java:809) ~ ~ ~ ~ ~ "/oracle/app/oracle/product/12.1.2/db_1/install/relink.log" 18L, 1435C

[jieguo4]

引用 3 楼 xiaohanshou 的回复:

为了验证你的问题，我特意从头做了一下，感觉这个文档有些不太好，现在还没开始装，稍后装完看看我会不会存在这个问题。

大哥，有出现我说的那个情况不？

[jieguo4]

大家好，我看网上说， $ORACLE_HOME/bin/oracle 大小不能为0， 我查了一下，这个文件大小是 0 . 按那个教程，我只是做到了配置监听， 用lsnrctl start LISTENER 可以启动监听， telnet 127.0.0.1 1521也能连接上。

[jieguo4]

/oracle/app/oracle/diag/tnslsnr/mes/listener/trace/listener.log 内容如下： 有一个WARNING... Fri Feb 03 21:58:33 2017 System parameter file is /oracle/app/oracle/product/12.1.2/db_1/network/admin/listener.ora Log messages written to /oracle/app/oracle/diag/tnslsnr/mes/listener/alert/log.xml Trace information written to /oracle/app/oracle/diag/tnslsnr/mes/listener/trace/ora_2789_140201565447680.trc Trace level is currently 0 Started with pid=2789 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mes)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE WARNING: Subscription for node down event still pending 03-FEB-2017 21:58:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mes.dfec.com)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375680)) * status * 0

[wobushixuyuan]

怎么解决的呢？我今天也出现这个报错了，sqlplus连接错误

[xfeeling]

oracle 12c 安装完 ‘‘sqlplus / as sysdba ’’报错，TNS:lost contact，多方查找，终于解决。 1. 我的问题原因是 $ORACLE_HOME/bin/oracle size is 0 2. 网上说需要relink all,relink all指令又报错，报错如下 [oracle@bin]$ ./relink all ./relink: line 168: 43197 Segmentation fault (core dumped) $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/install/modmakedeps.pl $ORACLE_HOME $ORACLE_HOME/inventory/make/makeorder.xml > $CURR_MAKEORDER （开始被） 3. 修改relink 文件每168行，将$ORACLE_HOME/perl/bin/perl改为perl 4. 然后relink all，结束后会给出操作结果日志，查看日志，有报错`INFO: /usr/bin/ld: cannot find -ljavavm12` 5. It is possible to work around this by copying the libjavavm12.a library located in $ORACLE_HOME/javavm/jdk/jdk7/lib to $ORACLE_HOME/lib directory and [retrying](https://www.virtualbox.org/ticket/14427).