链接oracle数据库 提示no listener

oracle安装在虚拟机上的,且服务中的listener和数据库都开着呢,就是连不上,并且虚拟机关闭了 本地竟然还能ping通。服务器中的C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN下的两个文件中的host也都写的是虚拟机上的ip。更诡异的是如图图片说明求大神指导 感谢

1个回答

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
JDBC连接oracle 出问题:Listener refused the connection!

我现在在做一个小项目,环境是MYECLIPS6+TOMCAT5+ORACLE10g 当我在页面浏览时,总出现间接性的数据库连接错误,郁闷了很久。。 下面是MYECLIPSE中报的错误: java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: 192.168.133.250:1521:oracle at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:279) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318) at oracle.jdbc.driver.PhysicalConnection. <init>(PhysicalConnection.java:343) at oracle.jdbc.driver.T4CConnection. <init>(T4CConnection.java:147) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.zjsoft.zjsj.util.Database.getConnection(Database.java:59) at org.zjsoft.zjsj.util.Database.getPreparedStatement(Database.java:79) at org.zjsoft.zjsj.dao.impl.DepartmentDAOImpl.getDepartmentByID(DepartmentDAOImpl.java:41) at org.zjsoft.zjsj.dao.impl.ApplyTypeDAOImpl.setData(ApplyTypeDAOImpl.java:104) at org.zjsoft.zjsj.dao.impl.ApplyTypeDAOImpl.getApplyTypeByID(ApplyTypeDAOImpl.java:25) at org.zjsoft.zjsj.dao.impl.ApplyDAOImpl.setDataList(ApplyDAOImpl.java:151) at org.zjsoft.zjsj.dao.impl.ApplyDAOImpl.listApplyByStatus(ApplyDAOImpl.java:36) at org.zjsoft.zjsj.servlet.accepter.AcceptStatusServlet.doPost(AcceptStatusServlet.java:42) at org.zjsoft.zjsj.servlet.accepter.AcceptStatusServlet.doGet(AcceptStatusServlet.java:24) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.zjsoft.zjsj.filter.EncodingFilter.doFilter(EncodingFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Unknown Source) 下面是我浏览器上显示的错误: java.lang.NullPointerException org.zjsoft.zjsj.util.Database.getPreparedStatement(Database.java:81) org.zjsoft.zjsj.dao.impl.DepartmentDAOImpl.getDepartmentByID(DepartmentDAOImpl.java:41) org.zjsoft.zjsj.dao.impl.ApplyTypeDAOImpl.setData(ApplyTypeDAOImpl.java:104) org.zjsoft.zjsj.dao.impl.ApplyTypeDAOImpl.getApplyTypeByID(ApplyTypeDAOImpl.java:25) org.zjsoft.zjsj.dao.impl.ApplyDAOImpl.setDataList(ApplyDAOImpl.java:151) org.zjsoft.zjsj.dao.impl.ApplyDAOImpl.listApplyByStatus(ApplyDAOImpl.java:36) org.zjsoft.zjsj.servlet.accepter.AcceptStatusServlet.doPost(AcceptStatusServlet.java:42) org.zjsoft.zjsj.servlet.accepter.AcceptStatusServlet.doGet(AcceptStatusServlet.java:24) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.zjsoft.zjsj.filter.EncodingFilter.doFilter(EncodingFilter.java:25) org.zjsoft.zjsj.util.Database.getPreparedStatement(Database.java:81)代码如下: private Connection getConnection() { Connection connection = null; try { Class.forName(DBDRIVER); // 加载数据库驱动类 } catch (ClassNotFoundException e) { e.printStackTrace(); } try { connection = DriverManager.getConnection(DBURL, USER, PASSWORD); } catch (SQLException e) { e.printStackTrace(); } return connection; } [b]问题补充:[/b] 项目都做了这么久了 不可能再改数据库了 修改连接试了下 连接数已经改为300了 但还是出现那个错误啊

ERROR: ORA-12541: TNS:no listener

使用pl/sql连接远程Linux上的oracle出现ERROR: ORA-12541: TNS:no listener 本人用的是win系统,想使用pl/sql连接远程oracle,配置文件都配了,实在是没有办法了,求大神救救我

将Oracle数据库连接到Xampp

<div class="post-text" itemprop="text"> <p>I also have a normal oracle 11.2.0 client installed (PATH and ORACLE_HOME are set correctly). I remove <code>;</code> on my <code>extension</code> on file <code>php.ini</code>. Now, I tried to connect, so i create a file with this code:</p> <pre><code>&lt;html&gt; &lt;head&gt;&lt;title&gt;Oracle demo&lt;/title&gt;&lt;/head&gt; &lt;body&gt; &lt;?php $conn=oci_connect("myuser","mypass","localhost/orc1"); If (!$conn) echo 'Failed to connect to Oracle'; else echo 'Succesfully connected with Oracle DB'; oci_close($conn); ?&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>That file is in folder "test" in "htdocs". When i put that url: <a href="http://localhost/test/scriptdemo.php" rel="nofollow">http://localhost/test/scriptdemo.php</a> shows me that error:</p> <pre><code>Warning: oci_connect(): ORA-12541: TNS:no listener in C:\xampp\htdocs\test\scriptdemo.php on line 5 Failed to connect to Oracle </code></pre> <p>I have the same password and username that i use in Oracle. Thank's</p> </div>

急!!!!!!Oracle11g数据库又连不上了!

昨天还好好的,今天打开Oracle sql developer连接就看到下面的错误: 执行请求的操作时遇到错误: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 供应商代码 12505 网上大多说是监听的问题 但重启之后还是没变化

重启服务器之后,oracle11g监听无效

辛苦了一天,把oracle11g在centos7下配置好了,测试监听配置,也能远程连接了。结果重启之后,监听启动不了了。 启动监听器: $ lsnrctl start Starting /data/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /data/oracle/diag/tnslsnr/chkj/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.110)(PORT=1521))) TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist Linux Error: 99: Cannot assign requested address Listener failed to start. See the error message(s) above... 我就晕了,又去 $ sqlplus /nolog SQL> alter system register; SP2-0640: Not connected SQL> startup ORA-01031: insufficient privileges 又去重启了监听,查看了监听 [oracle@chkj ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 24-NOV-2016 10:01:48 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.110)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused 求大神指点 我的配置文件如下: listener.ora Network Configuration File: /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = orcl11g) (ORACLE_HOME = /data/oracle/product/11.2.0/db_1) (GLOBAL_DBNAME = ORCLCHKJ) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.110)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /data/oracle tnsnames.ora Network Configuration File: /data/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.110)(PORT = 1521)) ORCLCHKJ= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.110)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclchkj) ) )

linux下Oracle安装之后重启监听失败。具体情况见下 、还往大家帮忙

我的操作是安装oracle之后、尝试连接 [oracle@linux64 ~]$ sqlplus / as sysdba Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> SQL> SQL> set linesize 2000; SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO --------------- ---------------- ---------------------------------------------------------------- ----------------- ------------ ------------ --- ---------- ------- ------------------------------ ---------- --- ----------------- ------------------ --------- --- 1 trade linux64 11.2.0.1.0 05-SEP-15 OPEN NO 1 STOPPED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO 通过这个查询 应该说明我库应该是配置了,监听也起来了、我想试着重启一下监听。就先查看了下监听的状态、然后stop监听、再start 监听就起不来了 ORACLE安装完成后直接查看监听状态 [oracle@linux64 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:02 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 18:58:31 Uptime 0 days 0 hr. 28 min. 31 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) Services Summary... Service "trade" has 1 instance(s). Instance "trade", status READY, has 1 handler(s) for this service... Service "tradeXDB" has 1 instance(s). Instance "trade", status READY, has 1 handler(s) for this service... The command completed successfully 关闭监听 [oracle@linux64 ~]$ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:35 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) The command completed successfully 再次打开监听 [oracle@linux64 ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:40 Copyright (c) 1991, 2009, Oracle. All rights reserved. Starting /home/oracle/oracle/product/11R2/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /home/oracle/oracle/product/11R2/network/admin/listener.ora Log messages written to /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 19:27:40 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) The listener supports no services The command completed successfully ----再次查看监听状态 [oracle@linux64 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:44 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 19:27:40 Uptime 0 days 0 hr. 0 min. 4 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) The listener supports no services The command completed successfully [oracle@linux64 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:47 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 19:27:40 Uptime 0 days 0 hr. 0 min. 7 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) The listener supports no services The command completed successfully

oracle 11g win10报 ora-12541 TNS:无监听程序

个人笔记本:windows 10 64位 数据库32位:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for 32-bit Windows: Version 11.2.0.1.0 - Production 装完数据库后用 pl/sql连接,始终报 12541 无监听程序,网上也找个各个办法 1、重新配置监听 和网络服务名,到测试的那一步依旧无监听程序 2、ORACLE_HOME,ORACLE_SID等环境变量也配置了。 用sqlplus登陆一点问题也没有。以下两个服务都正常启动 OracleOraDb11g_home1TNSListener OracleServiceORCL 山穷水尽,求各位指点。(toad也试了,涛声依旧)

plsql连接本地oracle服务器连不上

如图,我在自己笔记本上安装了oracle 11g和plsql,但是连不上,是什么原因呢![图片说明](https://img-ask.csdn.net/upload/201512/16/1450224480_849952.png)

oracle12c无法用plsql连接

win下装12c,使用sqlplus连接时没有问题 ![图片说明](https://img-ask.csdn.net/upload/201710/05/1507184227_654387.png) 用plsql连接时报错 ![图片说明](https://img-ask.csdn.net/upload/201710/05/1507184275_525314.png) listener.ora中配置 ![图片说明](https://img-ask.csdn.net/upload/201710/05/1507184315_614686.png) tnsnames.ora中配置 ![图片说明](https://img-ask.csdn.net/upload/201710/05/1507184340_429686.png) 不知道是哪出了错

oracle 监听问题 --sqlplus可以登录,其他程序不可以连接

![图片说明](https://img-ask.csdn.net/upload/201903/25/1553486650_212575.png) ??????????????? ip什么的根本不管,直接就能登录本地oracle 在其他程序连接oracle报错: oracle 错误代码:ora-12541 ![图片说明](https://img-ask.csdn.net/upload/201903/25/1553486662_295736.png) 请问这种情况怎么解决? 以下是 listener.ora代码 为了解决这个问题,重新配置了一个监听 所以有两个监听程序,但是依旧不好使! ``` # listener.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. LISTENER2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = KX8G3P6HOZLYPJ9)(PORT = 1512)) ) ) ADR_BASE_LISTENER2 = E:\app\Administrator LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = KX8G3P6HOZLYPJ9)(PORT = 1521)) ) ) ADR_BASE_LISTENER = E:\app\Administrator SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = ORCL) ``` 以下是tnsnames.ora代码, 前两天还能用,今天一连接就开始报错!! ``` # tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = KX8G3P6HOZLYPJ9)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) ``` ============补================== 以下是lsnrctl stat 执行结果 ![图片说明](https://img-ask.csdn.net/upload/201903/26/1553587194_177214.png) 以下是tnsping orcl执行结果 ![图片说明](https://img-ask.csdn.net/upload/201903/26/1553587202_93004.png)

oracle11g配置监听(centos7下)

按照一般流程配置完成了,我先在1号终端启动监听lsnrctl start,再打开另一个终端,sqlplus /nolog打开服务器,再输入 conn sys@orcl001 as sysdba,想连接,但是出现提示: TNS:listener does not currently know of service requested in connect descriptor(侦听器目前不知道连接中请求的服务描述符)!! 于是我又 alter system register;(实例注册),又提示 Not connected(没有连接)!! 我又到1号终端,查看监听状态,提示The listener supports no services(侦听器不支持服务)!!!,我又重启监听和服务器,还是不行,还是以上提示!!!! 求大神~!帮助~!! 一下是配置文件: listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC= (GLOBAL_DBNAME =ORCL) (ORACLE_HOME =:/data/oracle/product/11.2.0/db_1) (SID_NAME = ORCL) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) tnsnames.ora ORCL001 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl11g)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) )

virtualbox上安装oracle11g主机连接不上

虚拟机上安装的是11g的客户端,网卡选择的是host-only.主机能ping通虚拟机ip,虚拟机防火墙也关闭了,listener文件的host地址也改过了,在主机上执行sqlplus命令连接不上,一直提示no listener?怎么解决

安装完成Oracle之后,无法登录,不知道该如何配置,求助大佬

安装完成Oracle之后,无法登录,不知道该如何配置,求助大佬 附上安装图 ``` Oracle Database 11g Express Edition Configuration ------------------------------------------------- This will configure on-boot properties of Oracle Database 11g Express Edition. The following questions will determine whether the database should be starting upon system boot, the ports it will use, and the passwords that will be used for database accounts. Press <Enter> to accept the defaults. Ctrl-C will abort. Specify the HTTP port that will be used for Oracle Application Express [8080]:7070 /etc/init.d/oracle-xe: line 362: netstat: command not found Specify a port that will be used for the database listener [1521]: /etc/init.d/oracle-xe: line 405: netstat: command not found Specify a password to be used for database accounts. Note that the same password will be used for SYS and SYSTEM. Oracle recommends the use of different passwords for each database account. This can be done after initial configuration: Confirm the password: Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:y /bin/sed: can't read /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora: No such file or directory /bin/sed: can't read /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora: No such file or directory /bin/chown: invalid user: 'oracle:dba' sed: can't read /u01/app/oracle/product/11.2.0/xe/config/scripts/postDBCreation.sql: No such file or directory /bin/chown: invalid user: 'oracle:dba' /bin/sed: can't read /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora: No such file or directory /bin/sed: can't read /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora: No such file or directory /bin/chown: invalid user: 'oracle:dba' /bin/chown: invalid user: 'oracle:dba' Starting Oracle Net Listener...Done Configuring database...Done /bin/chmod: cannot access '/u01/app/oracle/oradata': No such file or directory /bin/chmod: cannot access '/u01/app/oracle/diag': No such file or directory /bin/chown: invalid user: 'oracle:dba' Starting Oracle Database 11g Express Edition instance...Done Installation completed successfully. root@jingsongchan:/home/jingsongchan# sudo service oracle-xe start Job for oracle-xe.service failed because the control process exited with error code. See "systemctl status oracle-xe.service" and "journalctl -xe" for details. root@jingsongchan:/home/jingsongchan# systemctl status oracle-xe.service ● oracle-xe.service - SYSV: This is a program that is responsible for taking car Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAI 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Expre 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listene 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exit 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result ' 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking car Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAI 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Expre 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listene 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exit 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result ' 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking car Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAI 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Expre 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listene 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exit 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result ' 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking car Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAI 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Expre 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listene 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exit 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result ' 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking care Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILU 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'ex 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program t ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edi 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener usin 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, co 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-c 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=e 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code' 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is r ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition insta 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is respons ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/orac 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited statu 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/pro 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for ta ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END)...skipping... ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/produc 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for takin ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/ 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking c ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking ca ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11. 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking car ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2. 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care o ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care o ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/x 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/b 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/ 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/t 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tn 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tns 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnsl 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnsls 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsn 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr a 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Or 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Orac 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle E 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Ex 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Exp 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Exp 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ lines 1-16/16 (END) ● oracle-xe.service - SYSV: This is a program that is responsible for taking care of Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: failed (Result: exit-code) since Thu 2019-09-05 18:43:04 CST; 22s ago Docs: man:systemd-sysv-generator(8) Process: 3861 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=1/FAILURE) 9月 05 18:43:04 jingsongchan su[3872]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3872]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Starting Oracle Database 11g Express Edition instance. 9月 05 18:43:04 jingsongchan su[3878]: No passwd entry for user 'oracle' 9月 05 18:43:04 jingsongchan su[3878]: FAILED su for oracle by root 9月 05 18:43:04 jingsongchan su[3878]: - ??? root:oracle 9月 05 18:43:04 jingsongchan oracle-xe[3861]: Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Exp 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Control process exited, code=exited status=1 9月 05 18:43:04 jingsongchan systemd[1]: oracle-xe.service: Failed with result 'exit-code'. 9月 05 18:43:04 jingsongchan systemd[1]: Failed to start SYSV: This is a program that is responsible for taking care of. ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ```

plsqldev连接linux中的oracle显示ORA12541:无监听程序。

在本论坛看了很多的帖子都没解决。 ![图片说明](https://img-ask.csdn.net/upload/201903/25/1553522279_534884.png) 本人oracle装在Linux虚拟机中,数据库能够正常启动 ,用sqlplus /as sysdba也能连接。就是PlSQL连接不上。 ![图片说明](https://img-ask.csdn.net/upload/201903/25/1553522539_999187.png) 监听启动也是正常。 ![图片说明](https://img-ask.csdn.net/upload/201903/25/1553522764_374631.png) listener.ora和tnsnames.ora文件中的IP都是虚拟机IP。 ![图片说明](https://img-ask.csdn.net/upload/201903/25/1553522972_482853.png) ![图片说明](https://img-ask.csdn.net/upload/201903/25/1553523114_430137.png) 请教各位大神!

本地oracle每次登录都报错(ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exit)

本地oracle数据库每次登录都会报错(ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exit 每次使用oracle数据库时,服务启动了,每次都报错(ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exit) 每次想要成功连接数据库,都要如下这样做,才能连接oracle数据库 ![图片说明](https://img-ask.csdn.net/upload/201905/29/1559109795_489782.png) ![图片说明](https://img-ask.csdn.net/upload/201905/29/1559109804_668698.png) ![图片说明](https://img-ask.csdn.net/upload/201905/29/1559109816_614784.png) ![图片说明](https://img-ask.csdn.net/upload/201905/29/1559109829_333291.png) 不知道谁有什么彻底的方法解决这个问题?不吝赐教

Oracle 报错问题,时好时坏

报错信息如下: ``` Caused by: y: oracle.net.ns.NetException:ion: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found ``` 不确定是不是session的问题

从excel导入1000多条数据到oracle数据库时,java内存溢出,tomcat报错

tomcat错误日志如下: # # An unexpected error has been detected by HotSpot Virtual Machine: # # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x7c930a19, pid=1168, tid=1936 # # Java VM: Java HotSpot(TM) Client VM (1.5.0_16-b02 mixed mode) # Problematic frame: # C [ntdll.dll+0x10a19] # --------------- T H R E A D --------------- Current thread (0x0082d500): JavaThread "Finalizer" daemon [_thread_in_native, id=1936] siginfo: ExceptionCode=0xc0000005, reading address 0x0030002d Registers: EAX=0x0011a358, EBX=0x00080000, ECX=0x0030002d, EDX=0x00350045 ESP=0x0ac8f77c, EBP=0x0ac8f788, ESI=0x0011a350, EDI=0x0011a2e0 EIP=0x7c930a19, EFLAGS=0x00010246 Top of Stack: (sp=0x0ac8f77c) 0x0ac8f77c: 00080000 0011a2f0 00000000 0ac8f85c 0x0ac8f78c: 7c93084c 00143898 0030002d 0ac8f840 0x0ac8f79c: 00000000 00000880 0011a2f8 00000000 0x0ac8f7ac: 00000000 0082ec44 0ac8f7f0 00143898 0x0ac8f7bc: 0782de50 0782de50 0014f1f0 00000008 0x0ac8f7cc: 000801b8 769a2580 00000030 00000028 0x0ac8f7dc: 0011f1c8 0ac8f800 770f4a64 76ab5034 0x0ac8f7ec: 0011f1c8 00000008 00000020 00000003 Instructions: (pc=0x7c930a19) 0x7c930a09: 85 92 00 00 00 8b 4e 0c 8d 46 08 8b 10 89 4d 0c 0x7c930a19: 8b 09 3b 4a 04 89 55 14 0f 85 ea 0f 00 00 3b c8 Stack: [0x0ac50000,0x0ac90000), sp=0x0ac8f77c, free space=253k Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) C [ntdll.dll+0x10a19] C [ntdll.dll+0x1084c] C [ole32.dll+0x12024] C [OLEAUT32.dll+0x2d424] C [OLEAUT32.dll+0x2c12c] C [OLEAUT32.dll+0x4f10] C [OLEAUT32.dll+0x4ea9] C [OLEAUT32.dll+0x4958] C [jacob.dll+0x15dc] j com.jacob.com.Variant.finalize()V+8 v ~StubRoutines::call_stub V [jvm.dll+0x875fa] V [jvm.dll+0xdfe2c] V [jvm.dll+0x874cb] V [jvm.dll+0x8ca8e] C [java.dll+0x2006] j java.lang.ref.Finalizer.runFinalizer()V+45 j java.lang.ref.Finalizer.access$100(Ljava/lang/ref/Finalizer;)V+1 j java.lang.ref.Finalizer$FinalizerThread.run()V+11 v ~StubRoutines::call_stub V [jvm.dll+0x875fa] V [jvm.dll+0xdfe2c] V [jvm.dll+0x874cb] V [jvm.dll+0x87228] V [jvm.dll+0xa2093] V [jvm.dll+0x111379] V [jvm.dll+0x111347] C [MSVCRT.dll+0x2a3b0] C [kernel32.dll+0xb699] Java frames: (J=compiled Java code, j=interpreted, Vv=VM code) j com.jacob.com.Variant.release()V+0 j com.jacob.com.Variant.finalize()V+8 v ~StubRoutines::call_stub j java.lang.ref.Finalizer.invokeFinalizeMethod(Ljava/lang/Object;)V+0 j java.lang.ref.Finalizer.runFinalizer()V+45 j java.lang.ref.Finalizer.access$100(Ljava/lang/ref/Finalizer;)V+1 j java.lang.ref.Finalizer$FinalizerThread.run()V+11 v ~StubRoutines::call_stub --------------- P R O C E S S --------------- Java Threads: ( => current thread ) 0x0c9823a0 JavaThread "Thread-28" daemon [_thread_blocked, id=2680] 0x0c913490 JavaThread "File Reaper" daemon [_thread_blocked, id=4368] 0x0c8fe390 JavaThread "AWT-Windows" daemon [_thread_in_native, id=2568] 0x0c8fc440 JavaThread "Java2D Disposer" daemon [_thread_blocked, id=1932] 0x0bf80470 JavaThread "http-8080-19" daemon [_thread_blocked, id=4280] 0x0bf4ee70 JavaThread "http-8080-18" daemon [_thread_blocked, id=4276] 0x0bf798b0 JavaThread "http-8080-17" daemon [_thread_blocked, id=4272] 0x0bf78470 JavaThread "http-8080-16" daemon [_thread_blocked, id=4268] 0x0bf773d0 JavaThread "http-8080-15" daemon [_thread_blocked, id=4264] 0x0bf77690 JavaThread "http-8080-14" daemon [_thread_blocked, id=4260] 0x0bf76e70 JavaThread "http-8080-13" daemon [_thread_blocked, id=4256] 0x0bf74020 JavaThread "http-8080-12" daemon [_thread_blocked, id=4248] 0x0bf69320 JavaThread "http-8080-11" daemon [_thread_blocked, id=1108] 0x0bf45100 JavaThread "http-8080-10" daemon [_thread_blocked, id=3744] 0x0bf56a70 JavaThread "http-8080-9" daemon [_thread_blocked, id=1836] 0x0bf55670 JavaThread "http-8080-8" daemon [_thread_blocked, id=4012] 0x0bf543a0 JavaThread "http-8080-7" daemon [_thread_blocked, id=456] 0x0bf52150 JavaThread "http-8080-6" daemon [_thread_blocked, id=616] 0x0bf523c0 JavaThread "http-8080-5" daemon [_thread_blocked, id=2848] 0x0bf52ca0 JavaThread "http-8080-4" daemon [_thread_blocked, id=1456] 0x0bf51e70 JavaThread "http-8080-3" daemon [_thread_blocked, id=3000] 0x0bf4f990 JavaThread "http-8080-2" daemon [_thread_blocked, id=888] 0x0becc770 JavaThread "http-8080-1" daemon [_thread_blocked, id=2136] 0x0bf02e70 JavaThread "TP-Monitor" daemon [_thread_blocked, id=3776] 0x0bf00470 JavaThread "TP-Processor4" daemon [_thread_in_native, id=3696] 0x0bef9ce0 JavaThread "TP-Processor3" daemon [_thread_blocked, id=2376] 0x0bef6980 JavaThread "TP-Processor2" daemon [_thread_blocked, id=2864] 0x0bef75d0 JavaThread "TP-Processor1" daemon [_thread_blocked, id=564] 0x008a7bd0 JavaThread "http-8080-Acceptor-0" daemon [_thread_in_native, id=924] 0x0089a170 JavaThread "ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon [_thread_in_native, id=3272] 0x008b75d0 JavaThread "Thread-1" daemon [_thread_blocked, id=1160] 0x008890a0 JavaThread "GC Daemon" daemon [_thread_blocked, id=2688] 0x00844cd0 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=2444] 0x00842550 JavaThread "CompilerThread0" daemon [_thread_blocked, id=3820] 0x00840e20 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=3968] 0x008370f0 JavaThread "JDWP Command Reader" daemon [_thread_in_native, id=4052] 0x00836370 JavaThread "JDWP Event Helper Thread" daemon [_thread_blocked, id=2576] 0x00835cb0 JavaThread "JDWP Transport Listener: dt_socket" daemon [_thread_in_vm, id=1448] =>0x0082d500 JavaThread "Finalizer" daemon [_thread_in_native, id=1936] 0x0082c250 JavaThread "Reference Handler" daemon [_thread_blocked, id=2400] 0x00823120 JavaThread "main" [_thread_in_native, id=416] Other Threads: 0x0082b530 VMThread [id=2092] 0x00845360 WatcherThread [id=2060] VM state:not at safepoint (normal execution) VM Mutex/Monitor currently owned by a thread: None Heap def new generation total 3264K, used 73K [0x02bd0000, 0x02f50000, 0x030b0000) eden space 2944K, 2% used [0x02bd0000, 0x02be25c0, 0x02eb0000) from space 320K, 0% used [0x02eb0000, 0x02eb0000, 0x02f00000) to space 320K, 0% used [0x02f00000, 0x02f00000, 0x02f50000) tenured generation total 42212K, used 19496K [0x030b0000, 0x059e9000, 0x06bd0000) the space 42212K, 46% used [0x030b0000, 0x043ba330, 0x043ba400, 0x059e9000) compacting perm gen total 36608K, used 36359K [0x06bd0000, 0x08f90000, 0x0abd0000) the space 36608K, 99% used [0x06bd0000, 0x08f51dd8, 0x08f51e00, 0x08f90000) No shared spaces configured. Dynamic libraries: 0x00400000 - 0x0040d000 C:\java\jre1.5.0_16\bin\javaw.exe 0x7c920000 - 0x7c9b6000 C:\WINDOWS\system32\ntdll.dll 0x7c800000 - 0x7c91d000 C:\WINDOWS\system32\kernel32.dll 0x77da0000 - 0x77e49000 C:\WINDOWS\system32\ADVAPI32.dll 0x77e50000 - 0x77ee2000 C:\WINDOWS\system32\RPCRT4.dll 0x77fc0000 - 0x77fd1000 C:\WINDOWS\system32\Secur32.dll 0x77d10000 - 0x77d9f000 C:\WINDOWS\system32\USER32.dll 0x77ef0000 - 0x77f38000 C:\WINDOWS\system32\GDI32.dll 0x77be0000 - 0x77c38000 C:\WINDOWS\system32\MSVCRT.dll 0x76300000 - 0x7631d000 C:\WINDOWS\system32\IMM32.DLL 0x62c20000 - 0x62c29000 C:\WINDOWS\system32\LPK.DLL 0x73fa0000 - 0x7400b000 C:\WINDOWS\system32\USP10.dll 0x6d640000 - 0x6d7de000 C:\java\jre1.5.0_16\bin\client\jvm.dll 0x76b10000 - 0x76b3a000 C:\WINDOWS\system32\WINMM.dll 0x6d290000 - 0x6d298000 C:\java\jre1.5.0_16\bin\hpi.dll 0x76bc0000 - 0x76bcb000 C:\WINDOWS\system32\PSAPI.DLL 0x6d390000 - 0x6d3c5000 C:\java\jre1.5.0_16\bin\jdwp.dll 0x6d610000 - 0x6d61c000 C:\java\jre1.5.0_16\bin\verify.dll 0x6d310000 - 0x6d32d000 C:\java\jre1.5.0_16\bin\java.dll 0x6d630000 - 0x6d63f000 C:\java\jre1.5.0_16\bin\zip.dll 0x6d220000 - 0x6d227000 C:\java\jre1.5.0_16\bin\dt_socket.dll 0x71a20000 - 0x71a37000 C:\WINDOWS\system32\WS2_32.dll 0x71a10000 - 0x71a18000 C:\WINDOWS\system32\WS2HELP.dll 0x719c0000 - 0x719fe000 C:\WINDOWS\System32\mswsock.dll 0x76ef0000 - 0x76f17000 C:\WINDOWS\system32\DNSAPI.dll 0x76f80000 - 0x76f88000 C:\WINDOWS\System32\winrnr.dll 0x76f30000 - 0x76f5c000 C:\WINDOWS\system32\WLDAP32.dll 0x64000000 - 0x64025000 C:\Program Files\Bonjour\mdnsNSP.dll 0x76d30000 - 0x76d48000 C:\WINDOWS\system32\Iphlpapi.dll 0x76f90000 - 0x76f96000 C:\WINDOWS\system32\rasadhlp.dll 0x60fd0000 - 0x61025000 C:\WINDOWS\system32\hnetcfg.dll 0x71a00000 - 0x71a08000 C:\WINDOWS\System32\wshtcpip.dll 0x6d4c0000 - 0x6d4c8000 C:\java\jre1.5.0_16\bin\management.dll 0x6d190000 - 0x6d1bf000 C:\java\jre1.5.0_16\bin\cmm.dll 0x6d3d0000 - 0x6d3ef000 C:\java\jre1.5.0_16\bin\jpeg.dll 0x6d4d0000 - 0x6d4e3000 C:\java\jre1.5.0_16\bin\net.dll 0x6d000000 - 0x6d16d000 C:\java\jre1.5.0_16\bin\awt.dll 0x72f70000 - 0x72f96000 C:\WINDOWS\system32\WINSPOOL.DRV 0x76990000 - 0x76acc000 C:\WINDOWS\system32\ole32.dll 0x5adc0000 - 0x5adf7000 C:\WINDOWS\system32\uxtheme.dll 0x736d0000 - 0x73719000 C:\WINDOWS\system32\ddraw.dll 0x73b30000 - 0x73b36000 C:\WINDOWS\system32\DCIMAN32.dll 0x6d240000 - 0x6d290000 C:\java\jre1.5.0_16\bin\fontmanager.dll 0x74680000 - 0x746cb000 C:\WINDOWS\system32\MSCTF.dll 0x73640000 - 0x7366e000 C:\WINDOWS\system32\msctfime.ime 0x6d4f0000 - 0x6d4f9000 C:\java\jre1.5.0_16\bin\nio.dll 0x0ffd0000 - 0x0fff8000 C:\WINDOWS\system32\rsaenh.dll 0x759d0000 - 0x75a7e000 C:\WINDOWS\system32\USERENV.dll 0x5fdd0000 - 0x5fe24000 C:\WINDOWS\system32\netapi32.dll 0x10000000 - 0x10018000 C:\java\jre1.5.0_16\bin\jacob.dll 0x770f0000 - 0x7717c000 C:\WINDOWS\system32\OLEAUT32.dll 0x76fa0000 - 0x7701f000 C:\WINDOWS\system32\CLBCATQ.DLL 0x77020000 - 0x770ba000 C:\WINDOWS\system32\COMRes.dll 0x77bd0000 - 0x77bd8000 C:\WINDOWS\system32\VERSION.dll 0x0cce0000 - 0x0cfa6000 C:\WINDOWS\system32\msi.dll 0x20000000 - 0x20549000 C:\WINDOWS\system32\xpsp2res.dll 0x0d070000 - 0x0d475000 D:\dll\PrnSheetDll.dll 0x5d170000 - 0x5d207000 C:\WINDOWS\system32\comctl32.dll 0x7d590000 - 0x7dd83000 C:\WINDOWS\system32\shell32.dll 0x77f40000 - 0x77fb6000 C:\WINDOWS\system32\SHLWAPI.dll 0x76320000 - 0x76367000 C:\WINDOWS\system32\comdlg32.dll 0x77180000 - 0x77282000 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2180_x-ww_a84f1ff9\comctl32.dll 0x5efe0000 - 0x5eff7000 C:\WINDOWS\system32\olepro32.dll 0x75e00000 - 0x75eae000 C:\WINDOWS\system32\SXS.DLL 0x4dd10000 - 0x4dd93000 C:\Program Files\Common Files\System\ado\msado15.dll 0x75b50000 - 0x75b75000 C:\WINDOWS\system32\MSDART.DLL 0x1b5d0000 - 0x1b665000 C:\WINDOWS\system32\MSWSTR10.DLL 0x72d70000 - 0x72de7000 C:\Program Files\Common Files\System\Ole DB\oledb32.dll 0x74fa0000 - 0x74fb1000 C:\Program Files\Common Files\System\Ole DB\OLEDB32R.DLL 0x0d8e0000 - 0x0d94d000 D:\oracle\product\10.2.0\db_1\bin\OraOLEDB10.DLL 0x44100000 - 0x44120000 D:\oracle\product\10.2.0\db_1\bin\OraOLEDBgmr10.dll 0x61c20000 - 0x61e72000 D:\oracle\product\10.2.0\db_1\bin\oraclient10.dll 0x60870000 - 0x60953000 D:\oracle\product\10.2.0\db_1\bin\oracore10.dll 0x60a80000 - 0x60b44000 D:\oracle\product\10.2.0\db_1\bin\oranls10.dll 0x63690000 - 0x636a8000 D:\oracle\product\10.2.0\db_1\bin\oraunls10.dll 0x7c340000 - 0x7c396000 D:\oracle\product\10.2.0\db_1\bin\MSVCR71.dll 0x60eb0000 - 0x60eb7000 D:\oracle\product\10.2.0\db_1\bin\orauts.dll 0x636b0000 - 0x636b6000 D:\oracle\product\10.2.0\db_1\bin\oravsn10.dll 0x0d950000 - 0x0da42000 D:\oracle\product\10.2.0\db_1\bin\oracommon10.dll 0x60300000 - 0x60857000 D:\oracle\product\10.2.0\db_1\bin\orageneric10.dll 0x63430000 - 0x63457000 D:\oracle\product\10.2.0\db_1\bin\orasnls10.dll 0x0da50000 - 0x0dbb0000 D:\oracle\product\10.2.0\db_1\bin\oraxml10.dll 0x0dbb0000 - 0x0dbc1000 C:\WINDOWS\system32\MSVCIRT.dll 0x60960000 - 0x60a6d000 D:\oracle\product\10.2.0\db_1\bin\oran10.dll 0x62740000 - 0x6277d000 D:\oracle\product\10.2.0\db_1\bin\oranl10.dll 0x62790000 - 0x627a7000 D:\oracle\product\10.2.0\db_1\bin\oranldap10.dll 0x627f0000 - 0x628f9000 D:\oracle\product\10.2.0\db_1\bin\orannzsbb10.dll 0x62530000 - 0x62583000 D:\oracle\product\10.2.0\db_1\bin\oraldapclnt10.dll 0x62670000 - 0x6268b000 D:\oracle\product\10.2.0\db_1\bin\orancrypt10.dll 0x71a40000 - 0x71a4b000 C:\WINDOWS\system32\WSOCK32.dll 0x62920000 - 0x6296c000 D:\oracle\product\10.2.0\db_1\bin\oranro10.dll 0x626b0000 - 0x626b7000 D:\oracle\product\10.2.0\db_1\bin\oranhost10.dll 0x62660000 - 0x62666000 D:\oracle\product\10.2.0\db_1\bin\orancds10.dll 0x629c0000 - 0x629c8000 D:\oracle\product\10.2.0\db_1\bin\orantns10.dll 0x60b50000 - 0x60ea8000 D:\oracle\product\10.2.0\db_1\bin\orapls10.dll 0x0dbd0000 - 0x0dbd9000 D:\oracle\product\10.2.0\db_1\bin\oraslax10.dll 0x63080000 - 0x63284000 D:\oracle\product\10.2.0\db_1\bin\oraplp10.dll 0x61ed0000 - 0x61f5b000 D:\oracle\product\10.2.0\db_1\bin\orahasgen10.dll 0x62ab0000 - 0x62b1a000 D:\oracle\product\10.2.0\db_1\bin\oraocr10.dll 0x62b20000 - 0x62b60000 D:\oracle\product\10.2.0\db_1\bin\oraocrb10.dll 0x62980000 - 0x62990000 D:\oracle\product\10.2.0\db_1\bin\orantcp10.dll 0x0dbe0000 - 0x0dc7a000 D:\oracle\product\10.2.0\db_1\bin\orasql10.dll 0x44400000 - 0x44423000 D:\oracle\product\10.2.0\db_1\bin\OraOLEDBrst10.dll 0x44700000 - 0x44707000 D:\oracle\product\10.2.0\db_1\bin\OraOLEDButl10.dll 0x44300000 - 0x44306000 D:\oracle\product\10.2.0\db_1\bin\OraOLEDB10zhs.dll 0x44200000 - 0x44208000 D:\oracle\product\10.2.0\db_1\bin\OraOLEDBpus10.dll 0x75690000 - 0x757ca000 C:\WINDOWS\system32\comsvcs.dll 0x75050000 - 0x75063000 C:\WINDOWS\system32\MTXCLU.DLL 0x75090000 - 0x750a4000 C:\WINDOWS\system32\colbact.DLL 0x762a0000 - 0x762b1000 C:\WINDOWS\system32\CLUSAPI.DLL 0x75010000 - 0x75022000 C:\WINDOWS\system32\RESUTILS.DLL 0x71f00000 - 0x71f04000 C:\WINDOWS\system32\security.dll 0x77c40000 - 0x77c64000 C:\WINDOWS\system32\msv1_0.dll 0x76760000 - 0x7676c000 C:\WINDOWS\system32\cryptdll.dll 0x72df0000 - 0x72e41000 C:\Program Files\Common Files\System\msadc\msadce.dll 0x0e590000 - 0x0e595000 C:\Program Files\Common Files\System\msadc\msadcer.dll 0x0e5d0000 - 0x0e5d6000 C:\Program Files\Common Files\System\ado\msader15.dll VM Arguments: jvm_args: -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:1666 -Dcatalina.home=D:\tomcat-6.0.24 -Djava.endorsed.dirs=D:\tomcat-6.0.24\endorsed -Dcatalina.base=D:\tomcat-6.0.24 -Djava.io.tmpdir=D:\tomcat-6.0.24\temp -Dfile.encoding=UTF-8 java_command: org.apache.catalina.startup.Bootstrap start Launcher Type: SUN_STANDARD Environment Variables: JAVA_HOME=C:\java\jdk1.5.0_16 CLASSPATH=.;C:\java\jdk1.5.0_16\dt.jar; C:\java\jdk1.5.0_16\lib\tools.jar; ;C:\Program Files\Java\jre6\lib\ext\QTJava.zip PATH=C:/Program Files/Java/jre6/bin/client;C:/Program Files/Java/jre6/bin;D:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\ThinkPad Wireless LAN Adapter Software;C:\Program Files\Common Files\Thunder Network\KanKan\Codecs;C:\Program Files\Intel\WiFi\bin\;C:\java\JDK1.5.0\bin;C:\Program Files\TortoiseSVN\bin;C:\java\jdk1.5.0_16\bin;C:\java\jdk1.5.0_16\jre\bin;D:\tomcat-6.0.24\bin;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\StormII\Codec;C:\Program Files\StormII USERNAME=think OS=Windows_NT PROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 10, GenuineIntel --------------- S Y S T E M --------------- OS: Windows XP Build 2600 Service Pack 2 CPU:total 2 (cores per cpu 2, threads per core 1) family 6 model 7 stepping 10, cmov, cx8, fxsr, mmx, sse, sse2 Memory: 4k page, physical 1958696k(57748k free), swap 3897560k(1530344k free) vm_info: Java HotSpot(TM) Client VM (1.5.0_16-b02) for windows-x86, built on May 28 2008 01:04:49 by "java_re" with MS VC++ 6.0

docker根据helowin/oracle_11g镜像启动Oracle,第一次可以连接,重启docker后连不上oracle

启动后,都可以用navicat连上,进入容器,用SQLplus也能进去. 但是当重启docker后(docker stop/start 11gxe), 用navicat连接时提示: **ORA-12514: TNS:listener does not currently know of service requested in connect descriptor **

Oracle无法启动监听服务

在计算机服务里面启动Oracle监听服务,错误提示是: ![图片说明](https://img-ask.csdn.net/upload/201803/05/1520252867_790352.jpg) 本地计算机上的OracleOraDB12Home2TNSListener服务启动后停止,某些服务在未由其他服务或程序使用时即将自动停止。 网上很多答案都过,包括将host和监听文件listener.ora里的地址改成计算机的名称或者ip地址,注册表检查过imagepath文件的地址(是TNSLSNR文件所在的路径)也是没错的。也试过把监听文件删除再重新配置。 疑点:在把监听文件删除后再重新配置,出现提示端口1521被占用,使用netstat -aon|findstr查看端口1521并没有被占用,换了几个端口也是同样提示,不知道监听服务无法启动是否于此有关。 如何去解决?新手,刚下载,已经摸索了两天,虚心求教。

在中国程序员是青春饭吗?

今年,我也32了 ,为了不给大家误导,咨询了猎头、圈内好友,以及年过35岁的几位老程序员……舍了老脸去揭人家伤疤……希望能给大家以帮助,记得帮我点赞哦。 目录: 你以为的人生 一次又一次的伤害 猎头界的真相 如何应对互联网行业的「中年危机」 一、你以为的人生 刚入行时,拿着傲人的工资,想着好好干,以为我们的人生是这样的: 等真到了那一天,你会发现,你的人生很可能是这样的: ...

程序员请照顾好自己,周末病魔差点一套带走我。

程序员在一个周末的时间,得了重病,差点当场去世,还好及时挽救回来了。

Java基础知识面试题(2020最新版)

文章目录Java概述何为编程什么是Javajdk1.5之后的三大版本JVM、JRE和JDK的关系什么是跨平台性?原理是什么Java语言有哪些特点什么是字节码?采用字节码的最大好处是什么什么是Java程序的主类?应用程序和小程序的主类有何不同?Java应用程序与小程序之间有那些差别?Java和C++的区别Oracle JDK 和 OpenJDK 的对比基础语法数据类型Java有哪些数据类型switc...

和黑客斗争的 6 天!

互联网公司工作,很难避免不和黑客们打交道,我呆过的两家互联网公司,几乎每月每天每分钟都有黑客在公司网站上扫描。有的是寻找 Sql 注入的缺口,有的是寻找线上服务器可能存在的漏洞,大部分都...

Intellij IDEA 实用插件安利

1. 前言从2020 年 JVM 生态报告解读 可以看出Intellij IDEA 目前已经稳坐 Java IDE 头把交椅。而且统计得出付费用户已经超过了八成(国外统计)。IDEA 的...

搜狗输入法也在挑战国人的智商!

故事总是一个接着一个到来...上周写完《鲁大师已经彻底沦为一款垃圾流氓软件!》这篇文章之后,鲁大师的市场工作人员就找到了我,希望把这篇文章删除掉。经过一番沟通我先把这篇文章从公号中删除了...

总结了 150 余个神奇网站,你不来瞅瞅吗?

原博客再更新,可能就没了,之后将持续更新本篇博客。

副业收入是我做程序媛的3倍,工作外的B面人生是怎样的?

提到“程序员”,多数人脑海里首先想到的大约是:为人木讷、薪水超高、工作枯燥…… 然而,当离开工作岗位,撕去层层标签,脱下“程序员”这身外套,有的人生动又有趣,马上展现出了完全不同的A/B面人生! 不论是简单的爱好,还是正经的副业,他们都干得同样出色。偶尔,还能和程序员的特质结合,产生奇妙的“化学反应”。 @Charlotte:平日素颜示人,周末美妆博主 大家都以为程序媛也个个不修边幅,但我们也许...

MySQL数据库面试题(2020最新版)

文章目录数据库基础知识为什么要使用数据库什么是SQL?什么是MySQL?数据库三大范式是什么mysql有关权限的表都有哪几个MySQL的binlog有有几种录入格式?分别有什么区别?数据类型mysql有哪些数据类型引擎MySQL存储引擎MyISAM与InnoDB区别MyISAM索引与InnoDB索引的区别?InnoDB引擎的4大特性存储引擎选择索引什么是索引?索引有哪些优缺点?索引使用场景(重点)...

如果你是老板,你会不会踢了这样的员工?

有个好朋友ZS,是技术总监,昨天问我:“有一个老下属,跟了我很多年,做事勤勤恳恳,主动性也很好。但随着公司的发展,他的进步速度,跟不上团队的步伐了,有点...

我入职阿里后,才知道原来简历这么写

私下里,有不少读者问我:“二哥,如何才能写出一份专业的技术简历呢?我总感觉自己写的简历太烂了,所以投了无数份,都石沉大海了。”说实话,我自己好多年没有写过简历了,但我认识的一个同行,他在阿里,给我说了一些他当年写简历的方法论,我感觉太牛逼了,实在是忍不住,就分享了出来,希望能够帮助到你。 01、简历的本质 作为简历的撰写者,你必须要搞清楚一点,简历的本质是什么,它就是为了来销售你的价值主张的。往深...

魂迁光刻,梦绕芯片,中芯国际终获ASML大型光刻机

据羊城晚报报道,近日中芯国际从荷兰进口的一台大型光刻机,顺利通过深圳出口加工区场站两道闸口进入厂区,中芯国际发表公告称该光刻机并非此前盛传的EUV光刻机,主要用于企业复工复产后的生产线扩容。 我们知道EUV主要用于7nm及以下制程的芯片制造,光刻机作为集成电路制造中最关键的设备,对芯片制作工艺有着决定性的影响,被誉为“超精密制造技术皇冠上的明珠”,根据之前中芯国际的公报,目...

优雅的替换if-else语句

场景 日常开发,if-else语句写的不少吧??当逻辑分支非常多的时候,if-else套了一层又一层,虽然业务功能倒是实现了,但是看起来是真的很不优雅,尤其是对于我这种有强迫症的程序"猿",看到这么多if-else,脑袋瓜子就嗡嗡的,总想着解锁新姿势:干掉过多的if-else!!!本文将介绍三板斧手段: 优先判断条件,条件不满足的,逻辑及时中断返回; 采用策略模式+工厂模式; 结合注解,锦...

离职半年了,老东家又发 offer,回不回?

有小伙伴问松哥这个问题,他在上海某公司,在离职了几个月后,前公司的领导联系到他,希望他能够返聘回去,他很纠结要不要回去? 俗话说好马不吃回头草,但是这个小伙伴既然感到纠结了,我觉得至少说明了两个问题:1.曾经的公司还不错;2.现在的日子也不是很如意。否则应该就不会纠结了。 老实说,松哥之前也有过类似的经历,今天就来和小伙伴们聊聊回头草到底吃不吃。 首先一个基本观点,就是离职了也没必要和老东家弄的苦...

2020阿里全球数学大赛:3万名高手、4道题、2天2夜未交卷

阿里巴巴全球数学竞赛( Alibaba Global Mathematics Competition)由马云发起,由中国科学技术协会、阿里巴巴基金会、阿里巴巴达摩院共同举办。大赛不设报名门槛,全世界爱好数学的人都可参与,不论是否出身数学专业、是否投身数学研究。 2020年阿里巴巴达摩院邀请北京大学、剑桥大学、浙江大学等高校的顶尖数学教师组建了出题组。中科院院士、美国艺术与科学院院士、北京国际数学...

为什么你不想学习?只想玩?人是如何一步一步废掉的

不知道是不是只有我这样子,还是你们也有过类似的经历。 上学的时候总有很多光辉历史,学年名列前茅,或者单科目大佬,但是虽然慢慢地长大了,你开始懈怠了,开始废掉了。。。 什么?你说不知道具体的情况是怎么样的? 我来告诉你: 你常常潜意识里或者心理觉得,自己真正的生活或者奋斗还没有开始。总是幻想着自己还拥有大把时间,还有无限的可能,自己还能逆风翻盘,只不是自己还没开始罢了,自己以后肯定会变得特别厉害...

百度工程师,获利10万,判刑3年!

所有一夜暴富的方法都写在刑法中,但总有人心存侥幸。这些年互联网犯罪高发,一些工程师高技术犯罪更是引发关注。这两天,一个百度运维工程师的案例传遍朋友圈。1...

程序员为什么千万不要瞎努力?

本文作者用对比非常鲜明的两个开发团队的故事,讲解了敏捷开发之道 —— 如果你的团队缺乏统一标准的环境,那么即使勤劳努力,不仅会极其耗时而且成果甚微,使用...

为什么程序员做外包会被瞧不起?

二哥,有个事想询问下您的意见,您觉得应届生值得去外包吗?公司虽然挺大的,中xx,但待遇感觉挺低,马上要报到,挺纠结的。

当HR压你价,说你只值7K,你该怎么回答?

当HR压你价,说你只值7K时,你可以流畅地回答,记住,是流畅,不能犹豫。 礼貌地说:“7K是吗?了解了。嗯~其实我对贵司的面试官印象很好。只不过,现在我的手头上已经有一份11K的offer。来面试,主要也是自己对贵司挺有兴趣的,所以过来看看……”(未完) 这段话主要是陪HR互诈的同时,从公司兴趣,公司职员印象上,都给予对方正面的肯定,既能提升HR的好感度,又能让谈判气氛融洽,为后面的发挥留足空间。...

面试:第十六章:Java中级开发

HashMap底层实现原理,红黑树,B+树,B树的结构原理 Spring的AOP和IOC是什么?它们常见的使用场景有哪些?Spring事务,事务的属性,传播行为,数据库隔离级别 Spring和SpringMVC,MyBatis以及SpringBoot的注解分别有哪些?SpringMVC的工作原理,SpringBoot框架的优点,MyBatis框架的优点 SpringCould组件有哪些,他们...

面试阿里p7,被按在地上摩擦,鬼知道我经历了什么?

面试阿里p7被问到的问题(当时我只知道第一个):@Conditional是做什么的?@Conditional多个条件是什么逻辑关系?条件判断在什么时候执...

无代码时代来临,程序员如何保住饭碗?

编程语言层出不穷,从最初的机器语言到如今2500种以上的高级语言,程序员们大呼“学到头秃”。程序员一边面临编程语言不断推陈出新,一边面临由于许多代码已存在,程序员编写新应用程序时存在重复“搬砖”的现象。 无代码/低代码编程应运而生。无代码/低代码是一种创建应用的方法,它可以让开发者使用最少的编码知识来快速开发应用程序。开发者通过图形界面中,可视化建模来组装和配置应用程序。这样一来,开发者直...

面试了一个 31 岁程序员,让我有所触动,30岁以上的程序员该何去何从?

最近面试了一个31岁8年经验的程序猿,让我有点感慨,大龄程序猿该何去何从。

大三实习生,字节跳动面经分享,已拿Offer

说实话,自己的算法,我一个不会,太难了吧

程序员垃圾简历长什么样?

已经连续五年参加大厂校招、社招的技术面试工作,简历看的不下于万份 这篇文章会用实例告诉你,什么是差的程序员简历! 疫情快要结束了,各个公司也都开始春招了,作为即将红遍大江南北的新晋UP主,那当然要为小伙伴们做点事(手动狗头)。 就在公众号里公开征简历,义务帮大家看,并一一点评。《启舰:春招在即,义务帮大家看看简历吧》 一石激起千层浪,三天收到两百多封简历。 花光了两个星期的所有空闲时...

《Oracle Java SE编程自学与面试指南》最佳学习路线图2020年最新版(进大厂必备)

正确选择比瞎努力更重要!

字节跳动面试官竟然问了我JDBC?

轻松等回家通知

面试官:你连SSO都不懂,就别来面试了

大厂竟然要考我SSO,卧槽。

实时更新:计算机编程语言排行榜—TIOBE世界编程语言排行榜(2020年6月份最新版)

内容导航: 1、TIOBE排行榜 2、总榜(2020年6月份) 3、本月前三名 3.1、C 3.2、Java 3.3、Python 4、学习路线图 5、参考地址 1、TIOBE排行榜 TIOBE排行榜是根据全世界互联网上有经验的程序员、课程和第三方厂商的数量,并使用搜索引擎(如Google、Bing、Yahoo!)以及Wikipedia、Amazon、YouTube统计出排名数据。

立即提问
相关内容推荐