Page 1 of 1

Login Error in Direct Mode to RAC Server

Posted: Thu 24 Jan 2019 07:30
by Moehre
Hi, I am using UniDac 7.3.10 / Delphi XE10 Seattle and trying to user direct mode to an oracle 10g RAC database. In my tnsnames.ora file this entry is used for oci access:

(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.50.95)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.50.96)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wawioltp_prim)
)

What is the correct way to connect to the RAC server using direct mode?

When setting the server property to 10.1.50.95,10.1.50.96:1521:wawi1 (the sid) I sometimes (?) can connect to the database but more often I get an error "wrong username/password", although I am using the correct username/password

Many thanks in advance
Moehre

Re: Login Error in Direct Mode to RAC Server

Posted: Thu 24 Jan 2019 12:59
by MaximG
To enable Oracle RAC, such connection string, as follows can be used in the Direct Mode :

Code: Select all

OraSession.ConnectString :='Direct=True;Server=10.1.50.95:1521:wawioltp_prim,10.1.50.96:1521:wawioltp_prim;User ID=UserName;Password=UserPassword';
You can also use TNS alias description when working in the Direct Mode. For this, assign a necessary value to the Server property :

Code: Select all

OraSession.Server := '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.50.95)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.50.96)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = wawioltp_prim))';

Re: Login Error in Direct Mode to RAC Server

Posted: Fri 01 Feb 2019 08:26
by Moehre
Thank u very much for your assistance!
Using the TNSNAMES.ORA entry in SERVER property did the trick ;)

Greetings
Detlev

Re: Login Error in Direct Mode to RAC Server

Posted: Mon 04 Feb 2019 09:04
by MaximG
Please don't hesitate to contact us with questions concerning our product usage.