RAC的时候listener的问题，希望知道的能指点一下！

vmwaregxs3.2.0+oracle+9.4.0+linuxas3u4 切换的时候总是有点问题。后来看了一下侦听 的状态发现总是有一个unknow的侦听，不知道是什么原因造成的，希望大家指点一下！

listener.ora的内容如下：



LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST =rac1)(PORT = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME =/opt/oracle/product/9.2.0)

(SID_NAME = orcl1)

)

)



listener的log如下：

CODE:[Copy to clipboard]TNSLSNR for Linux: Version 9.2.0.4.0 - Production on 30-JAN-2007 22:15:59



Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.



System parameter file is /opt/oracle/product/9.2.0/network/admin/listener.ora

Log messages written to /opt/oracle/product/9.2.0/network/log/listener.log

Trace information written to /opt/oracle/product/9.2.0/network/trace/listener.trc

Trace level is currently 0



Started with pid=1652

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521)))



TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

30-JAN-2007 22:16:00 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093120)) * status * 0

30-JAN-2007 22:16:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093120)) * status * 0

30-JAN-2007 22:16:50 * service_register * orcl1 * 0

30-JAN-2007 22:17:05 * service_update * orcl1 * 0

30-JAN-2007 22:17:08 * service_register * orcl2 * 0

30-JAN-2007 22:17:31 * service_update * orcl2 * 0

30-JAN-2007 22:18:11 * service_update * orcl2 * 0

30-JAN-2007 22:18:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac1)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093120)) * status * 0

30-JAN-2007 22:18:50 * service_update * orcl1 * 0

30-JAN-2007 22:19:11 * service_update * orcl2 * 0

30-JAN-2007 22:19:11 * service_update * orcl2 * 0

CODE:[Copy to clipboard]Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date 30-JAN-2007 22:16:00

Uptime 0 days 0 hr. 2 min. 23 sec

Trace Level off

Security OFF

SNMP OFF

Listener Parameter File /opt/oracle/product/9.2.0/network/admin/listener.ora

Listener Log File /opt/oracle/product/9.2.0/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521)))

Services Summary...

Service "orcl" has 3 instance(s).

Instance "orcl1", status UNKNOWN, has 1 handler(s) for this service...

Instance "orcl1", status READY, has 1 handler(s) for this service...

Instance "orcl2", status READY, has 1 handler(s) for this service...

The command completed successfully

把两个节点上的listener.ora删除，用lsnrctl start启动一个默认的监听试一下。



切换的时候遇到了什么问题？客户机用的tnsnames内容是什么，可不可以帖出来看看？

QUOTE:原帖由 blue_stone 于 2007-1-31 08:38 发表

把两个节点上的listener.ora删除，用lsnrctl start启动一个默认的监听试一下。



切换的时候遇到了什么问题？客户机用的tnsnames内容是什么，可不可以帖出来看看？ 谢谢版主出面。

下面是问题：

CODE:[Copy to clipboard]现在有两个结点,rac1和rac2,当plsql连接rac1,如果这个时候当掉 rac1,那么连接可以自动切换到rac2,查询后的到以下结果.

INSTANCE_NAME HOST_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER

orcl2 vmwareRAC2

SESSION BASIC NO

SESSION BASIC YES

如果这个时候在启动rac1,在当掉rac2,那么连接就不能从rac2上自动切换到rac1上了!并报远程对象或者主机不存在的错误，然后plsql就logout了!

问题:

rac是只能在失败的结点间切换一次还是多次了?如果是多次的话，那么要排查失败的原因主要是哪几个方面呢?谢谢大家指点一下了!删掉节点上的listener.ora后的默认侦听如下：

CODE:[Copy to clipboard][oracle@rac1 admin]$ lsnrctl status



LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 31-JAN-2007 13:17:22



Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.



Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date 31-JAN-2007 13:12:33

Uptime 0 days 0 hr. 4 min. 49 sec

Trace Level off

Security OFF

SNMP OFF

Listener Log File /opt/oracle/product/9.2.0/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521)))

Services Summary...

Service "orcl" has 2 instance(s).

Instance "orcl1", status READY, has 1 handler(s) for this service...

Instance "orcl2", status READY, has 1 handler(s) for this service...

The command completed successfully客户段的tnsnames.ora的内容如下：

CODE:[Copy to clipboard]ractest =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.10)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.11)(PORT = 1521))

(LOAD_BALANCE = on)

(FAILOVER = on)

)

(CONNECT_DATA =

(SERVICE_NAME =orcl)

(FAILOVER_MODE =

(TYPE = session)

(METHOD = basic)

)

)

)切换失败的时候oracm的cm.log的内容如下见最后几行：

CODE:[Copy to clipboard][oracle@rac2 log]$ cat cm.log

oracm, version[ 9.2.0.2.0.47 ] started {Wed Jan 31 13:10:22 2007 }

KernelModuleName is hangcheck-timer {Wed Jan 31 13:10:22 2007 }

OemNodeConfig(): Network Address of node0: 10.10.10.1 (port 9998)

{Wed Jan 31 13:10:22 2007 }

OemNodeConfig(): Network Address of node1: 10.10.10.2 (port 9998)

{Wed Jan 31 13:10:22 2007 }

>WARNING: OemInit2: Opened file(/var/opt/oracle/oradata/orcl/RacQuorumDisk 8), tid = main:16384 file = oem.c, line = 491 {Wed Jan 31 13:10:22 2007 }

InitializeCM: ModuleName = hangcheck-timer {Wed Jan 31 13:10:22 2007 }

InitializeCM: Kernel module hangcheck-timer is already loaded {Wed Jan 31 13:10:22 2007 }

Debug Hang : ClusterListener (PID=1463) Registered withwatchdog daemon. {Wed Jan 31 13:10:22 2007 }

Debug Hang : CmConnectListener (PID=1464):Registered with watchdog daemon. {Wed Jan 31 13:10:22 2007 }

Debug Hang :StartNMMon (PID=1458) Registered with watchdog daemon. {Wed Jan 31 13:10:22 2007 }

CreateLocalEndpoint(): Network Address: 10.10.10.2

{Wed Jan 31 13:10:22 2007 }

Debug Hang : DiskPingThread (PID=135159169): Registered with {Wed Jan 31 13:10:22 2007 }

Debug Hang :PollingThread (PID=135159169): Registered with {Wed Jan 31 13:10:22 2007 }

Debug Hang :SendingThread (PID=135159169): Registered with {Wed Jan 31 13:10:22 2007 }

NMEVENT_SUSPEND [00][00][00][00][00][00][00][02] {Wed Jan 31 13:10:27 2007 }

HandleUpdate(): SYNC(0) from node(1) completed {Wed Jan 31 13:10:30 2007 }

HandleUpdate(): NODE(1) IS ACTIVE MEMBER OF CLUSTER, INCARNATION(1) {Wed Jan 31 13:10:30 2007 }

NMEVENT_RECONFIG [00][00][00][00][00][00][00][02] {Wed Jan 31 13:10:30 2007 }

Successful reconfiguration, 1 active node(s) node 1 is the master, my node num is 1 (reconfig 1) {Wed Jan 31 13:10:30 2007 }

Debug Hang :ClientProcListener (PID=1580):Registered with watchdog daemon. {Wed Jan 31 13:10:38 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:163849 file = unixinc.c, line = 767 {Wed Jan 31 13:10:38 2007 }

Debug Hang :ClientProcListener (PID=1580) UnRegistered with watchdog daemon. {Wed Jan 31 13:10:38 2007 }

Debug Hang :ClientProcListener (PID=1581):Registered with watchdog daemon. {Wed Jan 31 13:10:38 2007 }

Debug Hang :ClientProcListener (PID=1589):Registered with watchdog daemon. {Wed Jan 31 13:10:38 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:196618 file = unixinc.c, line = 767 {Wed Jan 31 13:10:38 2007 }

Debug Hang :ClientProcListener (PID=1589) UnRegistered with watchdog daemon. {Wed Jan 31 13:10:38 2007 }

Debug Hang :ClientProcListener (PID=1590):Registered with watchdog daemon. {Wed Jan 31 13:10:38 2007 }

Debug Hang :ClientProcListener (PID=1631):Registered with watchdog daemon. {Wed Jan 31 13:10:39 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:229387 file = unixinc.c, line = 767 {Wed Jan 31 13:10:39 2007 }

Debug Hang :ClientProcListener (PID=1631) UnRegistered with watchdog daemon. {Wed Jan 31 13:10:39 2007 }

Debug Hang :ClientProcListener (PID=1632):Registered with watchdog daemon. {Wed Jan 31 13:10:39 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:180233 file = unixinc.c, line = 767 {Wed Jan 31 13:10:40 2007 }

Debug Hang :ClientProcListener (PID=1581) UnRegistered with watchdog daemon. {Wed Jan 31 13:10:40 2007 }

NMEVENT_SUSPEND [00][00][00][00][00][00][00][02] {Wed Jan 31 13:11:30 2007 }

HandleUpdate(): SYNC(1) from node(1) completed {Wed Jan 31 13:11:32 2007 }

HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER, INCARNATION(2) {Wed Jan 31 13:11:32 2007 }

HandleUpdate(): NODE(1) IS ACTIVE MEMBER OF CLUSTER, INCARNATION(1) {Wed Jan 31 13:11:32 2007 }

NMEVENT_RECONFIG [00][00][00][00][00][00][00][03] {Wed Jan 31 13:11:33 2007 }

Debug Hang : CMNodeListener(PID=1658) Registered with watchdog daemon. {Wed Jan 31 13:11:33 2007 }

Successful reconfiguration, 2 active node(s) node 1 is the master, my node num is 1 (reconfig 2) {Wed Jan 31 13:11:33 2007 }

Debug Hang :ClientProcListener (PID=1697):Registered with watchdog daemon. {Wed Jan 31 13:16:55 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:311305 file = unixinc.c, line = 767 {Wed Jan 31 13:16:55 2007 }

Debug Hang :ClientProcListener (PID=1697) UnRegistered with watchdog daemon. {Wed Jan 31 13:16:55 2007 }

Debug Hang :ClientProcListener (PID=1698):Registered with watchdog daemon. {Wed Jan 31 13:16:55 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:327689 file = unixinc.c, line = 767 {Wed Jan 31 13:16:55 2007 }

Debug Hang :ClientProcListener (PID=1698) UnRegistered with watchdog daemon. {Wed Jan 31 13:16:55 2007 }

Debug Hang :ClientProcListener (PID=1699):Registered with watchdog daemon. {Wed Jan 31 13:16:55 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:344073 file = unixinc.c, line = 767 {Wed Jan 31 13:16:55 2007 }

Debug Hang :ClientProcListener (PID=1699) UnRegistered with watchdog daemon. {Wed Jan 31 13:16:55 2007 }

Debug Hang :ClientProcListener (PID=1700):Registered with watchdog daemon. {Wed Jan 31 13:16:55 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:360457 file = unixinc.c, line = 767 {Wed Jan 31 13:16:55 2007 }

Debug Hang :ClientProcListener (PID=1700) UnRegistered with watchdog daemon. {Wed Jan 31 13:16:55 2007 }

Debug Hang :ClientProcListener (PID=1706):Registered with watchdog daemon. {Wed Jan 31 13:17:01 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:376841 file = unixinc.c, line = 767 {Wed Jan 31 13:17:01 2007 }

Debug Hang :ClientProcListener (PID=1706) UnRegistered with watchdog daemon. {Wed Jan 31 13:17:01 2007 }

Debug Hang :ClientProcListener (PID=1707):Registered with watchdog daemon. {Wed Jan 31 13:17:01 2007 }

Debug Hang :ClientProcListener (PID=1728):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:409612 file = unixinc.c, line = 767 {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1728) UnRegistered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1729):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1730):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1731):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:458767 file = unixinc.c, line = 767 {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1731) UnRegistered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1732):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1733):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:491536 file = unixinc.c, line = 767 {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1733) UnRegistered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1734):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1735):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:524305 file = unixinc.c, line = 767 {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1735) UnRegistered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1736):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1737):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:442382 file = unixinc.c, line = 767 {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1730) UnRegistered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1738):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:557074 file = unixinc.c, line = 767 {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1737) UnRegistered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1739):Registered with watchdog daemon. {Wed Jan 31 13:17:06 2007 }

Debug Hang :ClientProcListener (PID=1742):Registered with watchdog daemon. {Wed Jan 31 13:17:10 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:606227 file = unixinc.c, line = 767 {Wed Jan 31 13:17:10 2007 }

Debug Hang :ClientProcListener (PID=1742) UnRegistered with watchdog daemon. {Wed Jan 31 13:17:10 2007 }

Debug Hang :ClientProcListener (PID=1743):Registered with watchdog daemon. {Wed Jan 31 13:17:10 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:622611 file = unixinc.c, line = 767 {Wed Jan 31 13:22:48 2007 }

>ERROR: WriteEventPort: write failed with error 32., tid = ClientProcListener:622611 file = unixinc.c, line = 915 {Wed Jan 31 13:22:48 2007 }

Debug Hang :ClientProcListener (PID=1743) UnRegistered with watchdog daemon. {Wed Jan 31 13:22:48 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:589842 file = unixinc.c, line = 767 {Wed Jan 31 13:22:48 2007 }

Debug Hang :ClientProcListener (PID=1739) UnRegistered with watchdog daemon. {Wed Jan 31 13:22:48 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:540689 file = unixinc.c, line = 767 {Wed Jan 31 13:22:48 2007 }

Debug Hang :ClientProcListener (PID=1736) UnRegistered with watchdog daemon. {Wed Jan 31 13:22:48 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:507920 file = unixinc.c, line = 767 {Wed Jan 31 13:22:48 2007 }

Debug Hang :ClientProcListener (PID=1734) UnRegistered with watchdog daemon. {Wed Jan 31 13:22:48 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:475151 file = unixinc.c, line = 767 {Wed Jan 31 13:22:48 2007 }

Debug Hang :ClientProcListener (PID=1732) UnRegistered with watchdog daemon. {Wed Jan 31 13:22:48 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:573454 file = unixinc.c, line = 767 {Wed Jan 31 13:22:48 2007 }

Debug Hang :ClientProcListener (PID=1738) UnRegistered with watchdog daemon. {Wed Jan 31 13:22:48 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:393225 file = unixinc.c, line = 767 {Wed Jan 31 13:22:48 2007 }

>ERROR: WriteEventPort: write failed with error 32., tid = ClientProcListener:393225 file = unixinc.c, line = 915 {Wed Jan 31 13:22:48 2007 }

Debug Hang :ClientProcListener (PID=1707) UnRegistered with watchdog daemon. {Wed Jan 31 13:22:48 2007 }

>WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:425996 file = unixinc.c, line = 767 {Wed Jan 31 13:22:48 2007 }

>ERROR: WriteEventPort: write failed with error 32., tid = ClientProcListener:425996 file = unixinc.c, line = 915 {Wed Jan 31 13:22:48 2007 }

>ERROR: WriteEventPort: write failed with error 32., tid = ClientProcListener:425996 file = unixinc.c, line = 915 {Wed Jan 31 13:22:48 2007 }

Debug Hang :ClientProcListener (PID=1729) UnRegistered with watchdog daemon. {Wed Jan 31 13:22:48 2007 }这个是listener.ora 的log

CODE:[Copy to clipboard]TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

31-JAN-2007 13:18:55 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSIO

N=153093120)) * status * 0

31-JAN-2007 13:19:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSIO

N=153093120)) * status * 0

31-JAN-2007 13:19:02 * service_register * orcl1 * 0

31-JAN-2007 13:19:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSIO

N=153093120)) * status * 0

31-JAN-2007 13:19:04 * service_register * orcl2 * 0

31-JAN-2007 13:19:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSIO

N=153093120)) * status * 0

31-JAN-2007 13:19:06 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSIO

N=153093120)) * status * 0

31-JAN-2007 13:19:40 * (CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=session)(METHOD=basic))(CID=(PROGRAM=C:\Program Files\P

LSQL Developer\plsqldev.exe)(HOST=69D949A4C5514E8)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.21)(PORT=1111))

* establish * orcl * 0

31-JAN-2007 13:19:47 * (CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=session)(METHOD=basic))(CID=(PROGRAM=C:\Program Files\P

LSQL Developer\plsqldev.exe)(HOST=69D949A4C5514E8)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.21)(PORT=1112))

* establish * orcl * 0

31-JAN-2007 13:19:52 * (CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=session)(METHOD=basic))(CID=(PROGRAM=C:\Program Files\P

LSQL Developer\plsqldev.exe)(HOST=69D949A4C5514E8)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.21)(PORT=1114))

* establish * orcl * 0

31-JAN-2007 13:21:50 * service_died * orcl1 * 12537

31-JAN-2007 13:21:56 * (CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=session)(METHOD=basic))(CID=(PROGRAM=C:\Program Files\P

LSQL Developer\plsqldev.exe)(HOST=69D949A4C5514E8)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.21)(PORT=1119))

* establish * orcl * 0

31-JAN-2007 13:22:04 * (CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=session)(METHOD=basic))(CID=(PROGRAM=C:\Program Files\P

LSQL Developer\plsqldev.exe)(HOST=69D949A4C5514E8)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.21)(PORT=1121))

* establish * orcl * 0

31-JAN-2007 13:22:25 * service_register * orcl1 * 0

31-JAN-2007 13:22:37 * service_update * orcl1 * 0

31-JAN-2007 13:22:48 * service_died * orcl2 * 12537

31-JAN-2007 13:22:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSIO

N=153093120)) * status * 0

31-JAN-2007 13:22:55 * (CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=session)(METHOD=basic))(CID=(PROGRAM=C:\Program Files\P

LSQL Developer\plsqldev.exe)(HOST=69D949A4C5514E8)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.21)(PORT=1122))

* establish * orcl * 0

31-JAN-2007 13:22:58 * (CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=session)(METHOD=basic))(CID=(PROGRAM=C:\Program Files\P

LSQL Developer\plsqldev.exe)(HOST=69D949A4C5514E8)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.21)(PORT=1124))

* establish * orcl * 0

31-JAN-2007 13:32:39 * service_update * orcl1 * 0

CODE:[Copy to clipboard]SQL> select THREAD#,STATUS,ENABLED from gv$thread;

THREAD# STATUS ENABLED ;

THREAD# STATUS ENABLED

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

1 OPEN PUBLIC

2 OPEN PUBLIC

1 OPEN PUBLIC

2 OPEN PUBLIC

CODE:[Copy to clipboard]SQL> select INSTANCE_NUMBER,INSTANCE_NUMBER,STATUS,HOST_NAME from gv$instance;



INSTANCE_NUMBER INSTANCE_NUMBER STATUS

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

HOST_NAME

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

2 2 OPEN

rac2



1 1 OPEN

rac1[ 本帖最后由 moumoulrc 于 2007-1-31 13:57 编辑 ]

TAF !!!????

QUOTE:原帖由 oldunix 于 2007-1-31 14:05 发表

TAF !!!???? rac1上的TAF

CODE:[Copy to clipboard]orcl=

(description=

(load_balance=on)

(failover=on)

(address_list=

(address=(protocol=tcp)(host=rac1)(port=1521))

(address=(protocol=tcp)(host=rac2)(port=1521)))

(connect_data=

(service_name=orcl)))

orcl1=

(description=

(address=(protocol=tcp)(host=rac1)(port=1521))

(connect_data=

(service_name=orcl)

(instance_name=orcl1)))

orcl2=

(description=

(address=(protocol=tcp)(host=rac2)(port=1521))

(connect_data=

(service_name=orcl)

(instance_name=orcl2)))cm.log里面有一个错误，不知道是什么原因产生的

CODE:[Copy to clipboard]>ERROR: WriteEventPort: write failed with error 32., tid = ClientProcListener:425996 file = unixinc.c, line = 915 {Wed Jan 31 13:22:48 2007 }

>ERROR: WriteEventPort: write failed with error 32., tid = ClientProcListener:425996 file = unixinc.c, line = 915 {Wed Jan 31 13:22:48 2007 }

Debug Hang :ClientProcListener (PID=1729) UnRegistered with watchdog daemon. {Wed Jan 31 13:22:48 2007 }[ 本帖最后由 moumoulrc 于 2007-1-31 14:19 编辑 ]

1 删除listener.ora文件后，问题依旧，说明这个问题和listener配置无关。

2 在client的/etc/hosts文件中增加ip hostname的对应列表，使用sqlplus进行测试，看是否可以成功切换。

3 oracle rac中和网络相关的地方有1. 初始化参数中的local_listener和remote_listeners，2 listener.ora 3. server的tnsnames.ora， 4. client的tnsnames.ora , 5 server和client的hosts文件

QUOTE:原帖由 blue_stone 于 2007-1-31 14:22 发表

1 删除listener.ora文件后，问题依旧，说明这个问题和listener配置无关。

2 在client的/etc/hosts文件中增加ip hostname的对应列表，使用sqlplus进行测试，看是否可以成功切换。

3 oracle rac中和网络相关的地方 ... init.ora

CODE:[Copy to clipboard]*.log_buffer=3072000

*.compatible='9.2.0.0.0'

*.control_files='/var/opt/oracle/oradata/orcl/control01.ctl','/var/opt/oracle/oradata/orcl/control02.ctl'

*.core_dump_dest='/opt/oracle/admin/orcl/cdump'

*.user_dump_dest='/opt/oracle/admin/orcl/udump'

*.background_dump_dest='/opt/oracle/admin/orcl/bdump'

*.db_block_size=8192

*.db_cache_size=102400000

*.db_file_multiblock_read_count=128

*.db_name='orcl'

*.fast_start_mttr_target=300

*.hash_join_enabled=TRUE

*.job_queue_processes=2

*.large_pool_size=3145728

*.pga_aggregate_target=21200000

*.processes=300

*.remote_login_passwordfile='exclusive'

*.sga_max_size=1280000000

*.shared_pool_size=70000000

*.timed_statistics=TRUE

*.undo_management='AUTO'

*.undo_retention=10800

*.session_cached_cursors=200

*.cluster_database = TRUE

*.cluster_database_instances = 2

orcl1.instance_name='orcl1'

orcl2.instance_name='orcl2'

orcl1.instance_number=1

orcl2.instance_number=2

*.service_names='orcl'

orcl1.thread=1

orcl2.thread=2

orcl1.local_listener='(address=(protocol=tcp)(host=rac1)(port=1521))'

orcl1.remote_listener='(address=(protocol=tcp)(host=rac2)(port=1521))'

orcl2.local_listener='(address=(protocol=tcp)(host=rac2)(port=1521))'

orcl2.remote_listener='(address=(protocol=tcp)(host=rac1)(port=1521))'

orcl1.undo_tablespace=undotbs1

orcl2.undo_tablespace=undotbs2

主机名添加到client的hosts文件后用sqlplus测试，还会提示你说的错误么？

QUOTE:原帖由 blue_stone 于 2007-2-1 08:50 发表

主机名添加到client的hosts文件后用sqlplus测试，还会提示你说的错误么？ 我的client用的是windows。你的意思是说把rac1，rac2的主机名和ip写到客户机的hosts里面吗？？？用直接在客户机的tnsnames.ora里面写节点的IP不可以吗？？谢谢指点了啊！

QUOTE:原帖由 blue_stone 于 2007-2-1 08:50 发表

主机名添加到client的hosts文件后用sqlplus测试，还会提示你说的错误么？ 谢谢版主了，正如版主所言！