Oracle RAC下添加静态注册监听器listener - 数据库编程

PTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.245)(PORT=1522)))
The listener supports no services
The command completed successfully

4,vi listener.ora 添加以下信息，主要要修改三个节点的信息（后来证实，本步骤可以省略，可能因为静态监听信息已在endpoints_listener.ora文件中了）

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = epmdb)
(ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1)
(SID_NAME = epmdb3)
)
)

5, 重启listener
[grid@dtydb5 admin]$ srvctl stop listener -l listener_epm
[grid@dtydb5 admin]$ srvctl start listener -l listener_epm

这时服务还是没有注册上来
[grid@dtydb5 admin]$ lsnrctl status listener_epm

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 13-SEP-2012 10:27:15

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_EPM)))
STATUS of the LISTENER
------------------------
Alias LISTENER_EPM
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 13-SEP-2012 10:26:35
Uptime 0 days 0 hr. 0 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/11.2.0/grid/network/admin/listener.ora
Listener Log File /oracle/11.2.0/grid/log/diag/tnslsnr/dtydb5/listener_epm/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_EPM)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.235)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.245)(PORT=1522)))
The listener supports no services
The command completed successfully

6,什么原因？应该是local_listener设置问题,还需要修改该参数

sys@EPMDB3(dtydb5)> show parameter local

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=10.4
.124.245)(PORT=1521))))

sys@EPMDB3(dtydb5)> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.245)(PORT=1522))))' scope=both sid='*';

系统已更改。
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.243)(PORT=1522))))' scope=both sid='epmdb1';
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.244)(PORT=1522))))' scope=both sid='epmdb2';
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.245)(PORT=1522))))' scope=both sid='epmdb3';

7，已成功注册
[grid@dtydb5 admin]$ lsnrctl status LISTENER_EPM

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 13-SEP-2012 10:40:47

Oracle RAC下添加静态注册监听器listener(二)