TNS:protocol adapter error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: TNS:protocol adapter error

  1. #1
    Join Date
    Feb 2003
    Posts
    14

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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

  4. #4
    Join Date
    Mar 2002
    Posts
    25
    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.

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  6. #6
    Join Date
    Feb 2003
    Posts
    14
    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
  •  


Click Here to Expand Forum to Full Width