-
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:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.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
Sahil Patel
-
Hi,
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
Orca
-
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.
regards
anandkl
anandkl
-
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 8.1.6.3.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)
to
sqlnet.authentication_services = (NONE)
Jim
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?
sahil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|