前言：
今天大家对“oracle监听协议ipc”大致比较关心，你们都需要分析一些“oracle监听协议ipc”的相关文章。那么小编在网络上汇集了一些关于“oracle监听协议ipc””的相关知识，希望我们能喜欢，兄弟们一起来学习一下吧！由于测试环境机房搬迁，所以所有服务器都得备份停机。当机房搬迁完成后需要启动数据库服务，测试下是否可用。当数据库启动没问题后，需要启动监听，但是查看监听状态时，发现监听没有监听任何实例。
问题描述：
查看监听状态：
[oracle@LremDbF admin]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 04-JAN-2014 03:27:01
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LremDbF)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 04-JAN-2014 03:26:56
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/12c/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/diag/tnslsnr/LremDbF/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LremDbF)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
注意标红文字，提示没有任何实例监听。
处理过程：查看监听文件listener.ora内容是否填写正确。
发现监听文件没有任何修改，跟停机前一致。
使用强制监听
[oracle@LremDbF admin]$ sqlplus / as sysdba
SQL> alter system register;
System altered.
SQL> exit
查看监听状态
[oracle@LremDbF admin]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 04-JAN-2014 03:27:41
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LremDbF)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 04-JAN-2014 03:26:56
Uptime 0 days 0 hr. 0 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/12c/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/diag/tnslsnr/LremDbF/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LremDbF)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=LremDbF)(PORT=5500))(Security=(my_wallet_directory=/home/oracle/app/oracle/admin/lrem/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "lrem" has 1 instance(s).
Instance "lrem", status READY, has 1 handler(s) for this service...
Service "lremXDB" has 1 instance(s).
Instance "lrem", status READY, has 1 handler(s) for this service...
The command completed successfully
这时已经有监听实例了。
说明监听已经正常启动，状态正常。
标签： #oracle监听协议ipc
