linux下Oracle安装之后重启监听失败。具体情况见下 、还往大家帮忙-问答-阿里云开发者社区-阿里云

开发者社区> 问答> 正文

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

2016-07-13 10:22:51 3234 0

我的操作是安装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
取消 提交回答
全部回答(0)
相关问答

1

回答

求教sock5客户端---linux安装与配置:配置报错 

2020-05-31 22:58:44 422浏览量 回答数 1

1

回答

求教sock5客户端---linux安装与配置-linux报错

2020-05-31 15:40:04 248浏览量 回答数 1

1

回答

Linux系统中,开启iptables对网络有哪些性能影响

2021-10-30 15:21:25 343浏览量 回答数 1

1

回答

Linux系统中,如何模拟线程切换过多引发的性能问题

2021-10-30 15:19:51 227浏览量 回答数 1

0

回答

Linux系统中,如何模拟过多的进程上下文切换引发的性能问题

2021-10-30 15:19:15 108浏览量 回答数 0

1

回答

Linux系统中,如何模拟过多僵尸进程对资源消耗的性能问题

2021-10-30 15:18:39 283浏览量 回答数 1

0

回答

Linux系统中,如何模拟过多进程竞争CPU导致的负载高的性能问题

2021-10-30 15:18:08 139浏览量 回答数 0

1

回答

Linux系统中,如何模拟网络吞吐过高的性能问题

2021-10-30 15:17:33 247浏览量 回答数 1

1

回答

Linux系统中,如何模拟磁盘读写过高的性能问题

2021-10-30 15:17:01 273浏览量 回答数 1

1

回答

Linux系统中,如何模拟内存使用率过高的性能问题

2021-10-30 15:16:35 233浏览量 回答数 1
+关注
杨冬芳
IT从业
1
文章
9167
问答
问答排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载