oracle 11G RAC scan监听器配置静态注册,解决无法访问oem
oracle 11G Rac,静态监听配置只需要在 listener.ora文件中增加 SID_LIST——部分,在配置11G RAC时候,经常remote_listener还是按照10 RAC方式配置,
导致11G OEM无法访问,这个时候需要配置scan 监听静态注册。
1、配置静态监听
/oracle/grid/network/admin/listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by
Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
SID_LIST_LISTENER_SCAN1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/db/product/db1)
(PROGRAM = extproc)
)
(SID_DESC=
(GLOBAL_DBNAME=gzdb)
(ORACLE_HOME=/oracle/db/product/db1)
(SID_NAME=gzdb1)
)
(SID_DESC=
(GLOBAL_DBNAME=gzdb)
(ORACLE_HOME=/oracle/db/product/db1)
(SID_NAME=gzdb2)
)
)
2、查看scan监听状态,实例1和实例2都已经注册到SCAN监听
# su - grid
DB1-> lsnrctl status LISTENER_SCAN1
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 25-AUG-2015 09:12:46
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 24-AUG-2015 10:19:11
Uptime 0 days 22 hr. 53 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/grid/network/admin/listener.ora
Listener Log File /oracle/crs/diag/tnslsnr/DB1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.96.4.55)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "gzdb" has 2 instance(s).
Instance "gzdb1", status UNKNOWN, has 1 handler(s) for this service...
Instance "gzdb2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
DB1->
3、通过IE访问OEM
oracle 11G Rac,静态监听配置只需要在 listener.ora文件中增加 SID_LIST——部分,在配置11G RAC时候,经常remote_listener还是按照10 RAC方式配置,
导致11G OEM无法访问,这个时候需要配置scan 监听静态注册。
1、配置静态监听
/oracle/grid/network/admin/listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by
Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
SID_LIST_LISTENER_SCAN1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/db/product/db1)
(PROGRAM = extproc)
)
(SID_DESC=
(GLOBAL_DBNAME=gzdb)
(ORACLE_HOME=/oracle/db/product/db1)
(SID_NAME=gzdb1)
)
(SID_DESC=
(GLOBAL_DBNAME=gzdb)
(ORACLE_HOME=/oracle/db/product/db1)
(SID_NAME=gzdb2)
)
)
2、查看scan监听状态,实例1和实例2都已经注册到SCAN监听
# su - grid
DB1-> lsnrctl status LISTENER_SCAN1
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 25-AUG-2015 09:12:46
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date 24-AUG-2015 10:19:11
Uptime 0 days 22 hr. 53 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/grid/network/admin/listener.ora
Listener Log File /oracle/crs/diag/tnslsnr/DB1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.96.4.55)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "gzdb" has 2 instance(s).
Instance "gzdb1", status UNKNOWN, has 1 handler(s) for this service...
Instance "gzdb2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
DB1->
3、通过IE访问OEM
![](/attachment/201508/25/27571661_1440465584Gz5n.jpg)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27571661/viewspace-1781747/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27571661/viewspace-1781747/