Linux_x86_64下oracle1204的RAC环境应用用户反映程序连接数据库需要多次才能连接上

显示全部楼层 · 2008-2-13 12:43:03

本帖最后由 teanawu66 于 2012-10-17 12:49 编辑
本环境是刚搭建完毕的两节点RAC环境，Linux_x86_64下oracle1204环境下应用用户反映程序连接数据库需要多次才能连接上
请碰到过类似问题的帮忙分析下原因

OS：
[root@vapaasdb1 ~]# uname -a
Linux vapaasdb1 2.6.18-308.el5 #1 SMP Fri Jan 27 17:17:51 EST 2012 x86_64 x86_64 x86_64 GNU/Linux
[root@vapaasdb1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.8 (Tikanga)
DB:
两节点的RAC的数据库；节点1为vapaasdb1,节点2为vapaasdb2
数据库版本
[oracle@vapaasdb1 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Oct 17 12:30:02 2012
Copyright (c) 1982, 2007, Oracle.All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select version from v$instance;
VERSION
-----------------
10.2.0.4.0
本环境是刚搭建完毕的两节点RAC环境，应用用户反映，程序连接数据库时需要连接3、4次才能连上数据库
现跟踪两个节点上的监听信息
.附件《listener.rar》中10.1_1.log和10.3_1.log分别是节点1 vapaasdb1和节点2 vapaasdb2上跟踪单线程程序启动时listener的跟踪信息
.附件《listener.rar》中10.1_2.log和10.3_2.log分别是节点1 vapaasdb1和节点2 vapaasdb2上跟踪多线程程序启动时listener的跟踪信息

千问 · 2008-2-13 12:43:03

顶一个

千问 · 2008-2-13 12:43:03

if you install RAC ，maybe you can try the followway
alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.30)(PORT = 1521))' sid='inthrac1';
alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.31)(PORT = 1521))' sid='inthrac2';
alter system set local_listener='LISTENERS_ORCL' sid='*';

千问 · 2008-2-13 12:43:03

I met what you described，this is oracle bug ，but oracle didnt accept it

千问 · 2008-2-13 12:43:03

这个好像和静态注册和动态注册有关系

千问 · 2008-2-13 12:43:03

做等答案！

千问 · 2008-2-13 12:43:03

在节点1的tnsnames.ora的配置了local_listener,节点2也配置了local_listener
[oracle@vapaasdb1 admin]$ cat tnsnames.ora
LISTENERS_PAASDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vapaasdb1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vapaasdb2-vip)(PORT = 1521))
)
LOCAL_LISTENER_PAASDB1 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vapaasdb1-vip)(PORT = 1521))
)