OraFAQ Forum: Networking and Gateways » How does one set up a common SQL*Net connect string for all Real Application cluster database instan

Home » RDBMS Server » Networking and Gateways » How does one set up a common SQL*Net connect string for all Real Application cluster database instan

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How does one set up a common SQL*Net connect string for all Real Application cluster database instan [message #66040]

Fri, 19 October 2001 00:14

Prashant S
Messages: 3
Registered: October 2001

Junior Member

I want to connect Oracle9i client to a Real Application cluster database.But when I open Net configuration assistant or Net Manager on client to configure Net Services Names configuration, it asks me to enter the name of hosts where database resides ? There are 2 nodes in my RAC cluster.Which hostname should I give.Ideally speaking, my database belongs to both the nodes because it is a shared databse.
Can anyone please help?

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

Report message to a moderator

Re: How does one set up a common SQL*Net connect string for all Real Application cluster database in [message #66045 is a reply to message #66040]

Wed, 24 October 2001 00:50

K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore

Senior Member

SIR,

I THINK YOU CAN ENTER ANY HOST NAME.
TRY IT.

K.SREENIVASAN

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

Report message to a moderator

Re: How does one set up a common SQL*Net connect string for all Real Application cluster database in [message #66050 is a reply to message #66040]

Thu, 25 October 2001 07:26

prashant
Messages: 122
Registered: September 2000

Senior Member

Hi Sreenivasan,
Finally I got the things in place.I simply gave two addresses each having diffrent hostname in tnsnames.ora file and also included load_balance=on in the file.
This allows me to connect to the cluster database even if not all the instances of it are up.
Today I have posted another message related to Transparent Application Failover.Please try to reply to it.I see no reason why Oracle people are so poor at documentation.

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

Report message to a moderator

Previous Topic:	Re: Can't Install 8i Client on Pentium 4 , NT 4 machine??
Next Topic:	Re: Can't Install 8i Client on Pentium 4 , NT 4 machine??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 09:31:36 CDT 2025