Login Error in Direct Mode to RAC Server
Posted: Thu 24 Jan 2019 07:30
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
(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