| Net configuration files [message #200243] |
Sun, 29 October 2006 23:35  |
khushi2006
Messages: 13
Registered: October 2006
|
Junior Member |
|
|
I have oracle server 9.2 installed on my machine. I have moved the tnsnames.ora, sqlnet.ora and listener.ora to c:\.
But when i connect to my database, it connects without giving any error message. I guess i need to set the tns_admin variable first and then only it should connect!!! Sqlnet.ora contains the following:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Please clarify.Khushi
|
|
|
|
|
|
|
|
|
|
| Re: Net configuration files [message #200248 is a reply to message #200243] |
Mon, 30 October 2006 00:32  |
khushi2006
Messages: 13
Registered: October 2006
|
Junior Member |
|
|
It is still connecting.Also, i did the following:-
1)Using Net Manger, i created alias "Test1" to connect to same database.tnsname.ora is still in c:\. It created successfully but no entry was created in the tnsname.ora file.
2)i used the connect string scott/tiger@test1 to check wich gave the following error:
ORA-12154: TNS:could not resolve service name
3) Then i manually made an entry in tnsnames.ora in c:\ and rechecked, it worked.
For scott/tiger@<db_name> it is working .
[Updated on: Mon, 30 October 2006 00:33] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
