Re: Clients connecting to non-vip address
Date: Thu, 10 Jan 2008 06:30:07 -0800
> I have noticed that client applications running on BEA WebLogic Server
> as well as Sun Application Server are allowed to create connection
> pools to the non-vip address on the Oracle 10g RAC. The jdbc url both
> application servers use is:
> In the listeners.ora file:
> LISTENER_MYDB =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = mydb-vip)(PORT = 1521)(IP =
> (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.200)(PORT = 1521)
> (IP = FIRST))
> However, even though I ONLY specify the vip address in my jdbc url, I
> see established connections from the application server to the non-vip
> address (xxx.xx.xx.200). Since I see the same phenomena from two
> different COTS application servers, I am thinking I need to tweak my
> Oracle RAC configuration. I tried commenting out the non-vip address
> in the listeners.ora, and I wasn't able to connect to the db at all.
> Is anyone out there versed in manual Oracle RAC configuration that
> will prevent clients from connecting to the non-vip address. Seems the
> Oracle connection process is spawning connections to the non-vip
> address upon client requests. The /etc/hosts and dns on all machines
> are resolving properly. Any help is greatly appreciated. Thank you.
Please don't double post your questions (and two different emails addresses?).
BEA, unfortunately, has a long history of not truly understanding RAC which is a shame. The solution is to prevent connections except via the VIPs. Edit TNSNAMES.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Jan 10 2008 - 08:30:07 CST