Oracle client with Oracle Names Server configuration

[Overdoos]

Hello,

here in my department we have an Oracle Names Server to connect our clients to all databases we run here and it works fine.
Unfortunately, I had to reinstall my client recently and I don't know how to connect it to the Names Server so that it would look into the lists of that server to connect me. The guy who configured the names server and the client connections is on holiday for several weeks and hadn't got round to providing backup knowledge in our department.

Do any of you have expirience with connecting Oracle clients (9i) with Oracle 8i databases using Oracle Names Server? And if you do, would you be so kind as to talk me through this, because I cannot seem to find the stuff I need on the internet.

Extra Info:
* The 'Oracle Net Manager' found my Oracle Names Server (oracle-dns:1575) and shows it as P-ONS
* If i configure my tnsnames.ora, I can connect to all databases but now that the Names Server shows up in the list, no databases seems to be listening.
* The error when trying to connect is the well known ORA-12154

thank you for your time...

 

[avjoshi]

You will need to modify sqlnet.ora to use Oracle Names. This file is located in the same directory as the tnsnames.ora.

Add NAMES.PREFERRED_SERVERS to point to your Names server.
Set NAMES.DIRECTORY_PATH to (ONAMES).

These entries in your case may look like this (modify it where required)

NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = P-ONS)(PORT = 1575))
)
NAMES.DIRECTORY_PATH= (ONAMES)

The best thing to do would be to copy the sqlnet.ora file from your colleagues



Anand