Oracle10g客户端,Server端tnsnames.ora及监听设置

tolywang

不知道能不能将节点3的端口改掉 (改为非1521)  来实现AP与Report分开

bluemoon0083

不是吧，个人感觉应该不是动态注册instance造成的
本来你的pmon要向3个listener注册发送信息，然后取消掉了，现在只要跟本地listener通信就行了，按理来说应该是减轻pmon的负担了

当然有可能是取消掉了，但是pmon还是不断尝试向远程listener通信，而又一直被拒绝，然后pmon又继续尝试，这样是有可能引起问题
如果真是这样的话应该就是bug了，重启可能就行了，但至少LZ你可以看下3个节点listener log的日志，里面这些信息都会纪录的

tolywang

原帖由 bluemoon0083 于 2009-12-18 11:08 发表
不是吧，个人感觉应该不是动态注册instance造成的
本来你的pmon要向3个listener注册发送信息，然后取消掉了，现在只要跟本地listener通信就行了，按理来说应该是减轻pmon的负担了

当然有可能是取消掉了，但是pmon还是不断尝试向远程listener通信，而又一直被拒绝，然后pmon又继续尝试，这样是有可能引起问题
如果真是这样的话应该就是bug了，重启可能就行了，但至少LZ你可以看下3个节点listener log的日志，里面这些信息都会纪录的

节点1上的 listener_mxrac01.log ，貌似还是会去找 1， 2， 3 。  


发现另外一个问题， tail  -f  观察居然每个几秒钟产生一行记录，要看看开发怎么写的程序连接 。





17-DEC-2009 20:40:48 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=(PROGRAM=C:\Program
Files\DFMS\MesL10.exe)(HOST=A2-L01CKTS04)(USER=SFC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.72.113)(PORT=2796)) * establish * mxdell * 0
17-DEC-2009 20:40:51 * service_update * mxdell3 * 0
17-DEC-2009 20:40:57 * service_update * mxdell2 * 0
17-DEC-2009 20:40:57 * service_update * mxdell3 * 0
17-DEC-2009 20:41:00 * service_update * mxdell2 * 0
17-DEC-2009 20:41:06 * service_update * mxdell3 * 0
17-DEC-2009 20:41:09 * service_update * mxdell2 * 0
17-DEC-2009 20:41:10 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=(PROGRAM=C:\Program
Files\DFMS\MesL10.exe)(HOST=A2-L01CKTS04)(USER=SFC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.72.113)(PORT=2802)) * establish * mxdell * 0
17-DEC-2009 20:41:12 * service_update * mxdell2 * 0
17-DEC-2009 20:41:18 * service_update * mxdell2 * 0
17-DEC-2009 20:41:20 * service_update * mxdell3 * 0
17-DEC-2009 20:41:21 * service_update * mxdell1 * 0
17-DEC-2009 20:41:21 * service_update * mxdell1 * 0
17-DEC-2009 20:41:21 * service_update * mxdell2 * 0
17-DEC-2009 20:41:21 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mxdell)(INSTANCE_NAME=mxdell1)(CID=(PROGRAM=D:\Program Files\Quest
Software\Toad for Oracle\toad.exe)(HOST=PCE-TSG-036)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.161.32.120)(PORT=3743)) *
establish * mxdell * 0
17-DEC-2009 20:41:24 * service_update * mxdell1 * 0
17-DEC-2009 20:41:24 * service_update * mxdell1 * 0
17-DEC-2009 20:41:24 * service_update * mxdell2 * 0
17-DEC-2009 20:41:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mxdell)(INSTANCE_NAME=mxdell1)(CID=(PROGRAM=D:\Program Files\Quest
Software\Toad for Oracle\toad.exe)(HOST=PCE-TSG-036)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.161.32.120)(PORT=3744)) *
establish * mxdell * 0
17-DEC-2009 20:41:32 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=
(PROGRAM=C:\AutoPrint\autoprint.exe)(HOST=A3-DCHOTELS05)(USER=SFC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.81.47)(PORT=2527)) * establish *
mxdell * 0
17-DEC-2009 20:41:32 * service_update * mxdell3 * 0
17-DEC-2009 20:41:33 * service_update * mxdell1 * 0
17-DEC-2009 20:41:33 * service_update * mxdell1 * 0
17-DEC-2009 20:41:35 * service_update * mxdell3 * 0
17-DEC-2009 20:41:35 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=(PROGRAM=C:\Program
Files\DFMS\MesL10.exe)(HOST=A2-L01RPRS01)(USER=sfc))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.72.71)(PORT=1176)) * establish * mxdell * 0
17-DEC-2009 20:41:36 * service_update * mxdell1 * 0
17-DEC-2009 20:41:36 * service_update * mxdell1 * 0
17-DEC-2009 20:41:38 * service_update * mxdell3 * 0
17-DEC-2009 20:41:56 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=mxdell)) * (ADDRESS=(PROTOCOL=tcp)
(HOST=10.18.235.151)(PORT=55161)) * establish * mxdell * 0
17-DEC-2009 20:41:56 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=mxdell)) * (ADDRESS=(PROTOCOL=tcp)
(HOST=10.18.235.151)(PORT=55163)) * establish * mxdell * 0
17-DEC-2009 20:41:56 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=mxdell)) * (ADDRESS=(PROTOCOL=tcp)
(HOST=10.18.235.151)(PORT=55166)) * establish * mxdell * 0
17-DEC-2009 20:41:56 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=mxdell)) * (ADDRESS=(PROTOCOL=tcp)
(HOST=10.18.235.151)(PORT=55165)) * establish * mxdell * 0
17-DEC-2009 20:41:57 * service_update * mxdell1 * 0
17-DEC-2009 20:41:57 * service_update * mxdell1 * 0
17-DEC-2009 20:41:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=mxdell)) * (ADDRESS=(PROTOCOL=tcp)
(HOST=10.18.235.151)(PORT=55172)) * establish * mxdell * 0
17-DEC-2009 20:41:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mxrac01)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_MXRAC01)
(VERSION=169870336)) * status * 0
17-DEC-2009 20:41:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=mxdell)) * (ADDRESS=(PROTOCOL=tcp)
(HOST=10.18.235.151)(PORT=55173)) * establish * mxdell * 0
17-DEC-2009 20:42:00 * service_update * mxdell1 * 0
17-DEC-2009 20:42:00 * service_update * mxdell1 * 0
17-DEC-2009 20:42:00 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=
(PROGRAM=C:\AutoPrint\autoprint.exe)(HOST=A3-DCHOTELS07)(USER=SFC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.81.179)(PORT=4751)) * establish *
mxdell * 0
17-DEC-2009 20:42:03 * service_update * mxdell2 * 0
17-DEC-2009 20:42:09 * service_update * mxdell2 * 0
17-DEC-2009 20:42:18 * service_update * mxdell2 * 0
17-DEC-2009 20:42:20 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=(PROGRAM=E:\DFMS Backgroud
JOB\PO_Cancel_MI03_TO_DC\PoCancelMI03toDC.exe)(HOST=MXPSV-DFMS-APP3)(USER=lh.bpa))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.67.152)(PORT=2023))
* establish * mxdell * 0
17-DEC-2009 20:42:24 * service_update * mxdell2 * 0
17-DEC-2009 20:42:32 * (CONNECT_DATA=(SID=mxdell1)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.8.110)
(PORT=3940)) * establish * mxdell1 * 0
17-DEC-2009 20:42:37 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=(PROGRAM=c:\windows\system32
\inetsrv\w3wp.exe)(HOST=MXPSV-DFMS-APP)(USER=NETWORK?SERVICE))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.67.142)(PORT=1144)) * establish * mxdell
* 0
17-DEC-2009 20:42:39 * service_update * mxdell2 * 0
17-DEC-2009 20:42:50 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=
(PROGRAM=C:\AutoPrint\autoprint.exe)(HOST=A3-DCHOTELS07)(USER=SFC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.81.179)(PORT=4760)) * establish *
mxdell * 0
17-DEC-2009 20:42:51 * service_update * mxdell2 * 0
17-DEC-2009 20:42:56 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=
(PROGRAM=C:\AutoPrint\autoprint.exe)(HOST=A3-DCHOTELS05)(USER=SFC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.81.47)(PORT=2540)) * establish *
mxdell * 0
17-DEC-2009 20:43:00 * service_update * mxdell2 * 0
17-DEC-2009 20:43:02 * service_update * mxdell3 * 0
17-DEC-2009 20:43:06 * service_update * mxdell2 * 0
17-DEC-2009 20:43:08 * service_update * mxdell3 * 0
17-DEC-2009 20:43:09 * service_update * mxdell2 * 0
17-DEC-2009 20:43:21 * service_update * mxdell1 * 0
17-DEC-2009 20:43:21 * service_update * mxdell1 * 0
17-DEC-2009 20:43:21 * service_update * mxdell2 * 0
17-DEC-2009 20:43:24 * service_update * mxdell1 * 0
17-DEC-2009 20:43:24 * service_update * mxdell1 * 0
17-DEC-2009 20:43:24 * service_update * mxdell2 * 0
17-DEC-2009 20:43:32 * service_update * mxdell3 * 0
17-DEC-2009 20:43:33 * service_update * mxdell1 * 0
17-DEC-2009 20:43:33 * service_update * mxdell1 * 0
17-DEC-2009 20:43:33 * service_update * mxdell2 * 0
17-DEC-2009 20:43:35 * service_update * mxdell3 * 0
17-DEC-2009 20:43:38 * service_update * mxdell3 * 0
17-DEC-2009 20:44:00 * (CONNECT_DATA=(SERVICE_NAME=mxdell)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(CID=
(PROGRAM=C:\AutoPrint\autoprint.exe)(HOST=A3-DCHOTELS07)(USER=SFC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.13.81.179)(PORT=4772)) * establish *
mxdell * 0
17-DEC-2009 20:44:02 * service_update * mxdell3 * 0
17-DEC-2009 20:44:08 * service_update * mxdell3 * 0

oradbHome

还是建立多个TAF的服务吧. 在你那个帖子写了.你看看.

tolywang

仅仅在节点3上做了如下的更改 ：

alter  system set remote_listener='' scope=both  sid='mxdell3' ;  

然后节点1，2 上的lsnrctl status 中看不到3 实例的踪影 。测试发现连接1，2的客户端配置不能连接到节点3 了， 当然
还需要多次测试 。

microsoft_fly

please:
more /u01/product/oracle/network/admin/listener.ora