RAC connection

gianfrancog · Post by **gianfrancog** » Fri 27 Mar 2009 06:19

Hello

I would know how to build the connection string to connect to an Oracle database configured with RAC.

I proposed my customer to connect directly to the database, non through the Oracle clients (so using the 'Direct' option), but they prefere to connect entering the 'logical' database name and the 'logical" user name specified in the TNSNAMES file.

Could you help me?

Thanks in advance
G. Giugliano

Plash · Post by **Plash** » Fri 27 Mar 2009 07:41

The Direct mode does not support RAC. You can connect only to one server in RAC.

gianfrancog · Post by **gianfrancog** » Fri 27 Mar 2009 07:44

Hello

Thank for you reply. I supposed to be not able to connect with the 'Direct' option because the oracle client must access to the proper informations in the TNSNAMES file. I would understand how to build the connection string specifying the database name, user name and password

Thanks in advance

G. Giugliano

Plash · Post by **Plash** » Fri 27 Mar 2009 08:50

The connection string for RAC does not differ from the connection string for a single server:

username/password@tns_alias