请教一下,新安装Oracle, 不能访问问题, 安装 参考 《http://www.jianshu.com/p/36a78274a00e》进行的。 
看这位博主也遇到了同样的问题,但不知道是否已经解决;环境: centos7 + oracle 12c
命令操作显示如下:[oracle@mes ~]$ lsnrctl statusLSNRCTL for Linux: Version 12.1.0.2.0 - Production on 04-JAN-2017 04:28:41Copyright (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 sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 4 04:28:57 2017Copyright (c) 1982, 2014, Oracle.  All rights reserved.ERROR:
ORA-12547: TNS:lost contactEnter user-name: 
ERROR:
ORA-12547: TNS:lost contactEnter user-name: 
ERROR:
ORA-12547: TNS:lost contactSP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@mes ~]$

解决方案 »

  1.   

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

  2.   


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

  3.   

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

  4.   

    /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 0Started 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
      

  5.   


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

  6.   

    尝试 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
      

  7.   

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

  8.   

    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).