Could not connect to Oracle database using AquaData

[samik23]

I have this entry in the tnsnames.ora file:
TEST=
(DESCRIPTION =

(ADDRESS_LIST =

(LOAD_BALANCE=YES)

(FAILOVER=ON)

(ADDRESS = (PROTOCOL = TCP)(HOST = IP1)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = IP2)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = IP3)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = dmprd)

(FAILOVER_MODE =

(TYPE = session)

(METHOD = basic)

)

)

)
What is the SID corrsponding to this entry? The database server is a remote machine. Is there a way I can get the Service ID from it by using lsnrctl? There is no listener.ora file in my machine.

[Hein van den Heuvel]

Hmmm,

This is all documented in gory detail in for example:
"Oracle9i Net Services Administrator's Guide
Release 2 (9.2)
Part Number A96580-02"
Chapter 2
"Database Service and Database Instance Identification"

Online manual (first one google found)
http://www.utexas.edu/its/unix/reference/oracledocs/v92/B10501_01/network.920/a96580/concepts.htm#NETAG002

For the client application code the 'TEST' is all it needs to know. On the server that is expected to be served by service 'dmprd' which is likely mapped onto DB_NAME=dmprd,
but could have been changed.

From the client you don't get to look into listener.ora.

fwiw,
Hein.

[samik23]

Thanks a lot Hein.
I had a look into the material you pointed out. That was great.