Page 1 of 1
connect to RAC via TOraSession
Posted: Fri 22 Aug 2008 08:34
by tomos81
Hi all,
is there a solution to connect form TOraSession to Real Application cluster?
I am using version 6.25.1.13 for Delphi7
Posted: Fri 22 Aug 2008 11:08
by Plash
You should make an alias for RAC in the tnsnames.ora file and assign the alias name to the Server property of TOraSession.
Posted: Mon 25 Aug 2008 05:49
by tomos81
Plash wrote:You should make an alias for RAC in the tnsnames.ora file and assign the alias name to the Server property of TOraSession.
Hi, I can't connect...
in tnsnames.ora I have this record:
XXX_SERVICE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XXX_service)
)
)
In delphi -> TOraSession:
Direct mode is ON
Prefilled right username and password,
server: XXX1-vip:1521:XXX_SERVICE
login prompt: False
connect mode: cmNormal
but I can't connect...
where is the problem?
Posted: Tue 26 Aug 2008 11:21
by Plash
The Direct mode does not support RAC. In the Direct mode you can connect only to one server in RAC (if you specify the host, port and service name for that server). The tnsnames.ora file is not used in the Direct mode.
You should connect in OCI mode to use RAC.
Posted: Tue 26 Aug 2008 11:31
by tomos81
Plash wrote:The Direct mode does not support RAC. In the Direct mode you can connect only to one server in RAC (if you specify the host, port and service name for that server). The tnsnames.ora file is not used in the Direct mode.
You should connect in OCI mode to use RAC.
OK but how to connect to RAC which is in network with TOraSession?
Posted: Tue 26 Aug 2008 17:00
by tomos81
tomos81 wrote:Plash wrote:The Direct mode does not support RAC. In the Direct mode you can connect only to one server in RAC (if you specify the host, port and service name for that server). The tnsnames.ora file is not used in the Direct mode.
You should connect in OCI mode to use RAC.
OK but how to connect to RAC which is in network with TOraSession?
I solved that problem:
I downloaded Oracle instant client, set up enviroment variables for TNS_ADMIN (path to oci.dll from Oracle instant client) help is on
http://www.oracle.com/technology/tech/o ... ic-faq.htm
in TOraSession:
Direct is false
connection string is: username/password@alias
I have copied tnsnames.ora with my alias (alias from connection string) into oracle instant client directory.
it works fine, fast and stable...