根据周亮ORACLE DBA实战里的一个实验做的。
环境描述：两节点10G RAC环境，节点2宕机。此时客户端通过原节点2 VIP地址无法连接至
数据库。客户端较多修改不便需要在服务器上进行修改。
1.检查节点1监听状态、/etc/hosts 、IP信息 [oracle@rac1 admin]$ ifconfig
eth0 Link encap:Ethernet HWaddr 08:00:27:93:AD:F2
inet addr:192.168.57.219 Bcast:192.168.57.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:112453 errors:0 dropped:0 overruns:0 frame:0
TX packets:2496 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:68881461 (65.6 MiB) TX bytes:332010 (324.2 KiB)
eth0:1 Link encap:Ethernet HWaddr 08:00:27:93:AD:F2
inet addr:192.168.57.221 Bcast:192.168.57.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
eth0:2 Link encap:Ethernet HWaddr 08:00:27:93:AD:F2
inet addr:192.168.57.222 Bcast:192.168.57.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
eth1 Link encap:Ethernet HWaddr 08:00:27:33:81:45
inet addr:192.168.58.1 Bcast:192.168.58.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1750 errors:0 dropped:0 overruns:0 frame:0
TX packets:150571 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:150427 (146.9 KiB) TX bytes:130002468 (123.9 MiB)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:82328 errors:0 dropped:0 overruns:0 frame:0
TX packets:82328 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:13965995 (13.3 MiB) TX bytes:13965995 (13.3 MiB)
[oracle@rac1 admin]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.57.219 rac1.bys.com rac1
192.168.57.220 rac2.bys.com rac2
192.168.57.221 rac1-vip
192.168.57.222 rac2-vip
192.168.58.1 rac1-priv
192.168.58.2 rac2-priv
[oracle@rac1 admin]$ lsnrctl status LISTENER_RAC1
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-APR-2014 23:22:19
Copyright (c) 1991, 2005,
Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC1
Version TNSLSNR for
Linux: Version 10.2.0.1.0 - Production
Start Date 09-APR-2014 23:19:51
Uptime 0 days 0 hr. 2 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/dbhome_1/network/log/listener_rac1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.57.221)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.57.219)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "RAC" has 1 instance(s).
Instance "RAC1", status READY, has 2 handler(s) for this service...
Service "RAC_XPT" has 1 instance(s).
Instance "RAC1", status READY, has 2 handler(s) for this service...
Th |