RAC 配置监听程序

原创

xiaoliuxian 2011-09-28 17:45:32 博主文章分类：Oracle ©著作权

©著作权归作者所有：来自51CTO博客作者xiaoliuxian的原创作品，请联系作者获取转载授权，否则将追究法律责任

[root@node1 admin]# cat listener.ora
# listener.ora.node1 Network Configuration File: /app/oracle/product/10.2.0/rac_db/network/admin/listener.ora.node1
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_NODE1 =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /app/oracle/product/10.2.0/rac_db)
      (PROGRAM = extproc)
    )
)

LISTENER_NODE1 =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.62.240)(PORT = 1521)(IP = FIRST))
    )
)

LISTENER_NODE2 =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.62.235)(PORT = 1521)(IP = FIRST))
    )
)

-------------------------------------------------------------------------------------------------------
[root@node1 admin]# cat tnsnames.ora
# tnsnames.ora Network Configuration File: /app/oracle/product/10.2.0/rac_db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORADB2 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORADB)
      (INSTANCE_NAME = ORADB2)
    )
)

ORADB1 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORADB)
      (INSTANCE_NAME = ORADB1)
    )
)

ORADB =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORADB)
    )
)

LISTENERS_ORADB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
)

------------------------------------------------------------------------------
查看监听状态
[oracle@node2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-SEP-2011 17:34:00

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_NODE2
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                28-SEP-2011 15:52:46
Uptime                    0 days 1 hr. 41 min. 13 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /app/oracle/product/10.2.0/rac_db/network/admin/listener.ora
Listener Log File         /app/oracle/product/10.2.0/rac_db/network/log/listener_node2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.62.236)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.62.235)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "ORADB" has 2 instance(s).
Instance "ORADB1", status READY, has 1 handler(s) for this service...
Instance "ORADB2", status READY, has 2 handler(s) for this service...
Service "ORADBXDB" has 2 instance(s).
Instance "ORADB1", status READY, has 1 handler(s) for this service...
Instance "ORADB2", status READY, has 1 handler(s) for this service...
Service "ORADB_XPT" has 2 instance(s).
Instance "ORADB1", status READY, has 1 handler(s) for this service...
Instance "ORADB2", status READY, has 2 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

-----------------------------------------------------------------------------------------------

连接测试:

conn sys/oracledb@oradb2 as sysdba

SQL> show parameter listener;
NAME         TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener        string
remote_listener        string LISTENERS_ORADB

SQL> show parameter service_name;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string ORADB