Page 1 of 1

RAC connection

Posted: Fri 27 Mar 2009 06:19
by gianfrancog
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

Posted: Fri 27 Mar 2009 07:41
by Plash
The Direct mode does not support RAC. You can connect only to one server in RAC.

Posted: Fri 27 Mar 2009 07:44
by gianfrancog
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

Posted: Fri 27 Mar 2009 08:50
by Plash
The connection string for RAC does not differ from the connection string for a single server:

username/password@tns_alias