TNS 12203 & TNS 12560 - Any ideas... please help!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: TNS 12203 & TNS 12560 - Any ideas... please help!!!

  1. #1

    Question

    Hi Gang,

    here is a copy of the error message in my SQLNET.LOG file. My application was working perfectly when I left on a vacation, I come back and there is a connection problem and this is the error message I get! Nobody has touched my server (or so they claim...) in the mean time. What could be the possible reason for this error and what should I check.

    I've already checked the Listener process, the tnsnames.ora file, the service and connections through SQL*Plus & Toad. All of the above seems fine. I've also checked the permissions for the Oracle_home and all subdirectories. The Oracle sid has no special characters. I can't think of any valid reason. Somebody please help!

    Also in my TNSNAMES.ORA the PROTOCOL is TCP and what I see in the log file is PROTOCOL=BEQ. Can somebody please throw some light on this!!!

    This is on Windows NT Server 4.0 (Terminal Server Edition) & Oracle 8.0.6.0.0

    Fatal NI connect error 12203, connecting to:
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESC RIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program Files\Jouve\AirGTI Task Manager Suite\Airgtitm.exe)(HOST=JOUVE2)(USER=WilsonPl))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.0.6.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.6.0.0 - Production
    Time: 12-AUG-02 11:43:05
    Tracing not turned on.
    Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination
    ns main err code: 12560
    TNS-12560: TNS:protocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 0
    nt OS err code: 0

    Thanks in advance,
    -Shyami

    [Edited by Shyamis on 09-03-2002 at 12:01 PM]
    ------------------------------------------
    Shyami.S.Seelan, OCP 8i, 9i DBA
    Dublin, Ireland.
    http://www.geocities.com/shyamiseelan/OCP
    ------------------------------------------

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I'd re-check your tnsnames.ora file on both the client and the server.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Thanks Jeff, the problem was with the application. It randomly picks up which default database it wants to point to!

    Thanks again,
    -Shyami
    ------------------------------------------
    Shyami.S.Seelan, OCP 8i, 9i DBA
    Dublin, Ireland.
    http://www.geocities.com/shyamiseelan/OCP
    ------------------------------------------

  4. #4
    Join Date
    Oct 2002
    Posts
    391
    earlier on "............It randomly picks up which default database it wants to point to!"

    Oracle LDA error #12203 has occurred in orlon():
    ORA-12203: TNS:unable to connect to destination


    i had this error too... but from my tnsnames.ora, there is only one entry.....

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