tnsnames.ora

I Installed Oracle8i on windows 2000. I installed only the client. And used Net8 Assistant to configure this with the server on other machine which runs NT 4.0. It got successful. But,I don't see tnsnames.ora file on the client machine.So,where did it write and what can I do now ?

Thanks.

RS

tnsnames.ora should be in oracle_home\network\admin\

directory on the client machine.

- Rajeev

No it is not there.Only SAMPLE folder is there.

RS

When you say "It got successful" did you mean that you were able to connect from the client machine to the server database ?

If yes then tnsnames.ora should be in the folder I mentioned. Could you do a file search for tnsnames.ora on the client machine ? (Run the windows search command)

- Rajeev

Try:
Find file/folder --> tnsnames.ora on the PC

No,the file is not there. Got successful means, In Net8 Assistant window there is a test button,Once I entered the service name, protocol etc I tested that way.


Thanks

If the connection test was successful, then you can connect to the db.

Halo,

I am not able to connect to the database using SQL*Plus. Giving an error ORA-12154: TNS:could not resolve service name.

Thanks.

Test it manually:

From DOS prompt from drive you installed Oracle software type
sqlplus system/manager@.... where .... is a connect string you input for you Net wizzard or a database alias, for example domain for you database is like seed.dbasupport.com so you type
sqlplus system/[email protected]

If you don't know your domain, you can get it from $ORACLE_HOME/network/admin/tnsnames.ora from the server. It will look something like this:

seed.dbasupport.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 166.55.555.55)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = seed)
)
)

But most likely you won't be able to connect.
In this case, just copy tnsnames.ora from the server to oracle_home\network\admin on your client PC. Also make sure your oracle service is started on client PC (Control Panel -> Services)
Then try manual connection from DOS prompt or from SQL Worksheet.

Once the connection test is successful, did u save the file.
the most possible reason would be the file is not saved successfully.

Try the net8 assist again, and save the file, if not already done.