tnsnames

[smacattack]

can anybody give me an example of a tnsnames entry for a link to another oracle database on another server.
I am going from a aix server oracle database to a win2000 oracle database if this has any relevance.

I can ping the I.P address from the aix server but my entry in tns names seems rubbish.
tnsping shows unable to resolve tns name.

Any ideas of whats missing.
??
HELp PLease

 

[bi]

have you tried running netasst on the AIX system? That's a pretty foolproof way to get the entry right in tnsnames.

Also, have you posted this question in the Oracle forum?

 

[smacattack]

Yes i have created the entry via netasst but still cannot get the connect to work via tnsping or my objective is to connect to another database.
?????

 

[alexhu]

Show us your tnsnames.ora

Alex

 

[nwardez]

Hi,

Did you check port number on which Oracle (on Win2000 server) is listening to ? Probably stupid, but is listener service started on Win2000 ? Can you connect to your database on Win2000 (in IPC or "remotely" with it's own tnsname) ? May also need to check sqlnet.ora file on Aix (often got troubles with it, try to remove it).

For example:

1) On your Aix box, tnsnames.ora file should looks like this:
MY_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = Win2000_HOST)(Port = 1521))
)
(CONNECT_DATA =
(SID = Win2000_SID)
)
)

and sqlnet.ora:
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

2) On Win2000 server, listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Win2000_HOST)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = Path_Tracle_Bin)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Win2000_SID)
(ORACLE_HOME = Path_Tracle_Bin)
(SID_NAME = Win2000_SID)
)
)

And then you should be able to connect with sqlplus user/password@MY_DB

 

[smacattack]

I have noticed that the global_dbnanme is set on the listener on the win2k box
This is abc.domain.gov.uk.
Should his reflect on the tnsnames file on the aix server somehow or should the database link be created any different?

At present its set up as shown above!