General
cancel
Showing results for 
Search instead for 
Did you mean: 

Could not connect to Oracle database using AquaData

samik23
Occasional Visitor

Could not connect to Oracle database using AquaData

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.
2 REPLIES
Hein van den Heuvel
Honored Contributor

Re: Could not connect to Oracle database using AquaData

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
Occasional Visitor

Re: Could not connect to Oracle database using AquaData

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