请教一下,新安装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 ~]$
看这位博主也遇到了同样的问题,但不知道是否已经解决;环境: 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 ~]$
解决方案 »
- 关于 is table of的问题
- oracle 10g 的 组合分区 range-list 如何高效呢?
- 教我学oracle
- 请教如何用语句终止ORACLE里两类“一个用户的连接”?
- oracle9i 中怎样创建用户名和密码?又怎样导入文件?
- 使用ODBC连接Oracle库数据问题,请指教!
- 请教:关于sql语句进行三表连接查询的问题
- 存储过程的问题???高手GG们帮忙看看!!! 哦哦哦:)
- 过多的analyze是否会象过多的索引一样影响数据库的性能?
- 求救!触发器问题!!!!
- por*c编程连接oracle数据库成功,但为什么SELECT总是查询不到?急!谢谢!
- 几个.txt文件中的数据导入到一个oracle数据表中的方法
chmod 6751 $ORACLE_HOME/bin/oracle
谢谢, 这个我已经设置了权限的;
[oracle@mes bin]$ ll oracle
-rwsr-s--x. 1 oracle oinstall 0 Jul 7 2014 oracle
内容如下: 有一个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
上面这个WARNING已经解决:
在配置文件: /oracle/app/oracle/product/12.1.2/db_1/network/admin/listener.ora
中添加了如下一行, 然后重启监听(lsnrctl reload)
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
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
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).