简述一下local_listener与remote_listener这两个参数的含义(针对rac 环境)
在安装 完RAC以后,oracle 会自动修改local_listener和remote_listener这两个参数,同时把两个节点的3要素添加到$ORACLE_HOME/network/admin下的tnsnames.ora文件中:
1.查看listeners_devdb服务名配置
[oracle@rac21admin]$ more tnsnames.ora
LISTENERS_DEVDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
)
2.show parameter local_listener and remote_listener
[oracle@rac1 admin]$ sqlplus /nolog
SQL> connsys/oracle@devdb1 as sysdba
Connected.
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.230.68)(PORT = 1521))
remote_listener string LISTENERS_DEVDB
SQL> connsys/oracle@devdb2 as sysdba
Connected.
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.230.69)(PORT = 1521))
remote_listener string LISTENERS_DEVDB
3.查看listener状态
节点1
[oracle@rac1 admin]$lsnrctl status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC1
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 28-APR-2009 10:36:56
Uptime 0 days 8 hr. 1 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener_rac1.log
Listening Endpoints S
local_listener与remote_listener详述
最新推荐文章于 2024-08-19 09:00:00 发布
本文详细介绍了在Oracle RAC环境下,local_listener和remote_listener参数的作用。安装完RAC后,这两个参数会被自动修改,并在tnsnames.ora文件中添加节点信息。local_listener参数指定本地监听器地址,而remote_listener则指向服务名,用于在不同节点间进行连接。通过查看listener状态,可以观察到每个实例如何处理连接请求。当实例关闭时,已建立的连接不会中断,新的连接请求将被重定向到可用实例。
摘要由CSDN通过智能技术生成