TNS:protocol adapter error
When I try to log in to server it is giving me TNS-12560[TNSrotocol adapter error] and TNS-12628 error.
From client I am able to log in.
SQLNET log looks like this. What can be the problem?
Fatal NI connect error 12638, connecting to:
TNS for 32-bit Windows: Version 18.104.22.168.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 22.214.171.124.0 - Production
Time: 26-FEB-2003 15:29:16
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12638
TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
have you set the oracle_sid?
i think on the server you will connect locally.
And locally connect ( direct ) requires the correct setting of ORACLE_SID
When you connect to oracle from the server do not user the host string,just login with username/password...
Please let me know if this worked.
I am having this problem also, even when I set the sid first, even when I am trying to logon on the machine. A workaround that I have used and it works is
username/password@sid or username@sid/password
It is cumbersome, but it does work.
My TNS listener file looks correct - I compare it to other DB's that I have on other servers that are working correctly. I have 8.1.6 patched to 126.96.36.199.8 on W2000 Server sp3.
Is the OS user authenticated on the domain the server belongs to, if not you many need to change the following in your sqlnet.ora
sqlnet.authentication_services = (NTS)
sqlnet.authentication_services = (NONE)
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
I set the SID too.
And then try to login with out giving host string - same error.
Even it is not allowing me to log in as internal through svrmgr.
In my case sqlnet.authentication_services = (NTS).
I donít think Chaning it to NONE will help.
what to do?
Click Here to Expand Forum to Full Width