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

Thread: TNS-12560: TNS:protocol adapter error

  1. #1
    Join Date
    Jul 2004
    Posts
    2

    TNS-12560: TNS:protocol adapter error

    Please help,

    I have 8.1.7.4.1

    I run sqlplusw from server without any problems, but if I launch svrmgrl from cmd on server - error occurs:

    TNS-12560: TNSrotocol adapter error

    What can be wrong???

    all my oracle details see below:





    tnsnames.ora:

    STAT.EUR.NSROOT.NET =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = alacmesd002)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = stat)
    )
    )

    INST1_HTTP.EUR.NSROOT.NET =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = alacmesd002)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://admin)
    )
    )


    sqlnet.ora:

    NAMES.DEFAULT_DOMAIN = eur.nsroot.net

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)




    sqlnet.log

    ***********************************************************************
    Fatal NI connect error 12560, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclestat)(ARGS='(DESCRIPTION=(LOCAL=YES )(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=stat)(CID=(PROGRAM=C:\oracle\ora81\bin\svrmgrl.exe)( HOST=ALACMESD002)(USER=Administrator))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.4.0 - Production
    Time: 14-JUL-2004 01:46:04
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNSrotocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 2
    nt OS err code: 0

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    SET ORACLE_SID ???
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Jul 2004
    Posts
    2

    I have set ORACLE_SID=STAT

    sure, I have set ORACLE_SID=STAT
    but problem still persists

  4. #4
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    Why do tou need to run SVRMGRL? You can use SQLPLUS instead at 8i

  5. #5
    Join Date
    Jul 2004
    Location
    chennai, India
    Posts
    4
    Hi,

    Please check whether you have started the windows nt OS services for the appropriate ORACLE_SIDs.

    Rgds,
    K.S.Venkatesh

  6. #6
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Originally posted by ksvenkatesh
    Hi,

    Please check whether you have started the windows nt OS services for the appropriate ORACLE_SIDs.

    Rgds,
    K.S.Venkatesh
    oops... SQLPLUSW will connect without starting the services?
    Last edited by Thomasps; 07-14-2004 at 07:48 AM.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  7. #7
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    Re: TNS-12560: TNS:protocol adapter error

    Originally posted by Russtem
    Please help,

    I have 8.1.7.4.1

    I run sqlplusw from server without any problems, but if I launch svrmgrl from cmd on server - error occurs:

    TNS-12560: TNSrotocol adapter error

    What can be wrong???
    nt OS err code: 0
    This could be one of the reason why svrmgrl becomes obsolete in 9i
    and the use of sqlplus was advised.

    sqlplus /nolog
    SQL>connect sys/syspass as sysdba
    or
    equivalent

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