This discussion is archived
0 Replies Latest reply: Apr 19, 2013 1:28 AM by 655031 RSS

Instantclient 11_2 on win7 gets ORA-12560

655031 Newbie
Currently Being Moderated
Hi All

I've got:

Server: Linux with Oracle 11g
Client: Window 7 with instant client driver 11 + ODBC

Server functions fine. I can connect from client with sqlplus but not from an ODBC application. I get ORA-12560: TNS: protocol adapter error

I've got TNS_ADMIN variable set to point to the directory where instantclient driver is.

sqlnet contains:
TCP.CONNECT_TIMEOUT=5
names.directory_lookup = (TNSNAMES,ONAMES)
DIAG_ADR_ENABLED = OFF
TRACE_LEVEL_CLIENT = SUPPORT
TRACE_DIRECTORY_CLIENT = C:\Users\adk\Desktop\instantclient_11_2
tnsnames.ora contains:
EVORAX =
    (DESCRIPTION =
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = devpacs)(PORT = 1521))
        ) (CONNECT_DATA =
            (SID = EVORAX) (SERVER = DEDICATED)
        )
    )
I run some traces and it seems sqlnet.ora is read tnsnames.ora is never opened, looked for...

Last comes the trace file. Any ideas what is wrong?

Thank you

trace file:
(3448) [19-APR-2013 10:01:22:453] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
(3448) [19-APR-2013 10:01:22:453] New trace stream is C:\Users\adk\Desktop\instantclient_11_2\cli_3448.trc
(3448) [19-APR-2013 10:01:22:453] New trace level is 16
(3448) [19-APR-2013 10:01:22:453] --- TRACE CONFIGURATION INFORMATION ENDS ---
(3448) [19-APR-2013 10:01:22:453] --- PARAMETER SOURCE INFORMATION FOLLOWS ---
(3448) [19-APR-2013 10:01:22:453] Attempted load of system pfile source C:\Users\adk\Desktop\instantclient_11_2\sqlnet.ora
(3448) [19-APR-2013 10:01:22:453] Parameter source loaded successfully
(3448) [19-APR-2013 10:01:22:453]
(3448) [19-APR-2013 10:01:22:453] Attempted load of local pfile source C:\Program Files (x86)\EasyVizWS\bin\sqlnet.ora
(3448) [19-APR-2013 10:01:22:453] Parameter source was not loaded
(3448) [19-APR-2013 10:01:22:453]
(3448) [19-APR-2013 10:01:22:453]  -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
(3448) [19-APR-2013 10:01:22:453] Successful parameter table load
(3448) [19-APR-2013 10:01:22:453]  -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
(3448) [19-APR-2013 10:01:22:453]   DIAG_ADR_ENABLED = OFF
(3448) [19-APR-2013 10:01:22:453]   TRACE_LEVEL_CLIENT = SUPPORT
(3448) [19-APR-2013 10:01:22:453]   names.directory_lookup = (TNSNAMES,ONAMES)
(3448) [19-APR-2013 10:01:22:453]   TCP.CONNECT_TIMEOUT = 5
(3448) [19-APR-2013 10:01:22:453]   TRACE_DIRECTORY_CLIENT = C:\Users\adk\Desktop\instantclient_11_2
(3448) [19-APR-2013 10:01:22:453] --- PARAMETER SOURCE INFORMATION ENDS ---
(3448) [19-APR-2013 10:01:22:453] --- LOG CONFIGURATION INFORMATION FOLLOWS ---
(3448) [19-APR-2013 10:01:22:453] Log stream will be "C:\Program Files (x86)\EasyVizWS\bin\sqlnet.log"
(3448) [19-APR-2013 10:01:22:453] Log stream validation not requested
(3448) [19-APR-2013 10:01:22:453] --- LOG CONFIGURATION INFORMATION ENDS ---

(3448) [19-APR-2013 10:01:22:453] nlstdipi: entry
(3448) [19-APR-2013 10:01:22:453] nlstdipi: exit
(3448) [19-APR-2013 10:01:22:453] nigini: entry
(3448) [19-APR-2013 10:01:22:453] nigini: Count in the NL global area is now 1
(3448) [19-APR-2013 10:01:22:453] nigini: Count in NI gbl area now: 1
(3448) [19-APR-2013 10:01:22:453] nrigbi: entry
(3448) [19-APR-2013 10:01:22:453] nrigbni: entry
(3448) [19-APR-2013 10:01:22:453] nrigbni: Unable to get data from navigation file tnsnav.ora
(3448) [19-APR-2013 10:01:22:453] nrigbni: exit
(3448) [19-APR-2013 10:01:22:453] nrigbi: exit
(3448) [19-APR-2013 10:01:22:453] nigini: exit
(3448) [19-APR-2013 10:01:22:453] nigini: entry
(3448) [19-APR-2013 10:01:22:453] nigini: Count in the NL global area is now 2
(3448) [19-APR-2013 10:01:22:453] nigini: Count in NI gbl area now: 2
(3448) [19-APR-2013 10:01:22:453] nigini: exit
(3448) [19-APR-2013 10:01:22:453] niqname: Hst is already an NVstring.
(3448) [19-APR-2013 10:01:22:453] niqname: Inserting CID.
(3448) [19-APR-2013 10:01:22:453] nigtrm: Count in the NI global area is now 1
(3448) [19-APR-2013 10:01:22:453] nigtrm: Count in the NL global area is now 1
(3448) [19-APR-2013 10:01:22:453] nigini: entry
(3448) [19-APR-2013 10:01:22:453] nigini: Count in the NL global area is now 2
(3448) [19-APR-2013 10:01:22:453] nigini: Count in NI gbl area now: 2
(3448) [19-APR-2013 10:01:22:453] nigini: exit
(3448) [19-APR-2013 10:01:22:453] niqname: Hst is already an NVstring.
(3448) [19-APR-2013 10:01:22:453] niqname: Inserting CID.
(3448) [19-APR-2013 10:01:22:453] nigtrm: Count in the NI global area is now 1
(3448) [19-APR-2013 10:01:22:453] nigtrm: Count in the NL global area is now 1
(3448) [19-APR-2013 10:01:22:453] nigini: entry
(3448) [19-APR-2013 10:01:22:453] nigini: Count in the NL global area is now 2
(3448) [19-APR-2013 10:01:22:453] nigini: Count in NI gbl area now: 2
(3448) [19-APR-2013 10:01:22:453] nigini: exit
(3448) [19-APR-2013 10:01:22:453] niqname: Hst is already an NVstring.
(3448) [19-APR-2013 10:01:22:453] niqname: Inserting CID.
(3448) [19-APR-2013 10:01:22:453] niotns: entry
(3448) [19-APR-2013 10:01:22:453] snsbitini_ts: entry
(3448) [19-APR-2013 10:01:22:453] snsbitini_ts: normal exit
(3448) [19-APR-2013 10:01:22:453] snsbitini_ts: entry
(3448) [19-APR-2013 10:01:22:453] snsbitini_ts: normal exit
(3448) [19-APR-2013 10:01:22:453] niotns: Not trying to enable dead connection detection.
(3448) [19-APR-2013 10:01:22:453] niotns: Calling address: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleEVORAX)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=EVORAX)(CID=(PROGRAM=C:\Program?Files??x86?\EasyVizWS\bin\evsm.exe)(HOST=ADK-WIN7)(USER=adk))))
(3448) [19-APR-2013 10:01:22:453] nsgettrans_bystring: entry
(3448) [19-APR-2013 10:01:22:453] nlpcaini: entry
(3448) [19-APR-2013 10:01:22:453] nlpcaini: prg = oracle
(3448) [19-APR-2013 10:01:22:453] nlpcaini: arg[0] = oracleEVORAX
(3448) [19-APR-2013 10:01:22:453] nlpcaini: arg[1] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
(3448) [19-APR-2013 10:01:22:453] nlpcaini: env[0] = ALLUSERSPROFILE=C:\ProgramData
(3448) [19-APR-2013 10:01:22:453] nlpcaini: exit
(3448) [19-APR-2013 10:01:22:453] ntgettrans: entry
(3448) [19-APR-2013 10:01:22:453] ntgettrans: exit
(3448) [19-APR-2013 10:01:22:453] nsgettrans_bystring: exit
(3448) [19-APR-2013 10:01:22:453] nscall: entry
(3448) [19-APR-2013 10:01:22:453] nsmal: entry
(3448) [19-APR-2013 10:01:22:453] nsmal: 216 bytes at 0xfa8ee00
(3448) [19-APR-2013 10:01:22:453] nsmal: normal exit
(3448) [19-APR-2013 10:01:22:453] nscall: connecting...
(3448) [19-APR-2013 10:01:22:453] nlad_expand_hst: Result: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleEVORAX)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=EVORAX)(CID=(PROGRAM=C:\Program?Files??x86?\EasyVizWS\bin\evsm.exe)(HOST=ADK-WIN7)(USER=adk))))
(3448) [19-APR-2013 10:01:22:453] nladini: entry
(3448) [19-APR-2013 10:01:22:453] nladini: exit
(3448) [19-APR-2013 10:01:22:453] nladget: entry
(3448) [19-APR-2013 10:01:22:453] nladget: exit
(3448) [19-APR-2013 10:01:22:453] nsmal: entry
(3448) [19-APR-2013 10:01:22:453] nsmal: 246 bytes at 0xfa8fd70
(3448) [19-APR-2013 10:01:22:453] nsmal: normal exit
(3448) [19-APR-2013 10:01:22:453] nsc2addr: entry
(3448) [19-APR-2013 10:01:22:453] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleEVORAX)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=EVORAX)(CID=(PROGRAM=C:\Program?Files??x86?\EasyVizWS\bin\evsm.exe)(HOST=ADK-WIN7)(USER=adk))))
(3448) [19-APR-2013 10:01:22:468] nlpcaini: entry
(3448) [19-APR-2013 10:01:22:468] nlpcaini: prg = oracle
(3448) [19-APR-2013 10:01:22:468] nlpcaini: arg[0] = oracleEVORAX
(3448) [19-APR-2013 10:01:22:468] nlpcaini: arg[1] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
(3448) [19-APR-2013 10:01:22:468] nlpcaini: env[0] = ALLUSERSPROFILE=C:\ProgramData
(3448) [19-APR-2013 10:01:22:468] nlpcaini: exit
(3448) [19-APR-2013 10:01:22:468] nsc2addr: normal exit
(3448) [19-APR-2013 10:01:22:468] nsopen: entry
(3448) [19-APR-2013 10:01:22:468] nsmal: entry
(3448) [19-APR-2013 10:01:22:468] nsmal: 996 bytes at 0xfa91b00
(3448) [19-APR-2013 10:01:22:468] nsmal: normal exit
(3448) [19-APR-2013 10:01:22:468] nsopenmplx: entry
(3448) [19-APR-2013 10:01:22:468] nsmal: entry
(3448) [19-APR-2013 10:01:22:468] nsmal: 2120 bytes at 0xfa91ef0
(3448) [19-APR-2013 10:01:22:468] nsmal: normal exit
(3448) [19-APR-2013 10:01:22:468] snsbitini_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbitini_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] nsiorini: entry
(3448) [19-APR-2013 10:01:22:468] nsbal: entry
(3448) [19-APR-2013 10:01:22:468] nsbgetfl: entry
(3448) [19-APR-2013 10:01:22:468] nsbgetfl: normal exit
(3448) [19-APR-2013 10:01:22:468] nsmal: entry
(3448) [19-APR-2013 10:01:22:468] nsmal: 84 bytes at 0xfa8f000
(3448) [19-APR-2013 10:01:22:468] nsmal: normal exit
(3448) [19-APR-2013 10:01:22:468] nsbal: normal exit
(3448) [19-APR-2013 10:01:22:468] nsiorini: exit (0)
(3448) [19-APR-2013 10:01:22:468] nscpxget: entry
(3448) [19-APR-2013 10:01:22:468] snsbitts_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbitts_ts: acquired the bit
(3448) [19-APR-2013 10:01:22:468] snsbitts_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] snsbitcl_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbitcl_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] nscpxget: normal exit
(3448) [19-APR-2013 10:01:22:468] nsopenalloc_nsntx: nlhthput on mplx_ht_nsgbu:ctx=fa91b00, nsntx=fa91ef0
(3448) [19-APR-2013 10:01:22:468] nsopenmplx: normal exit
(3448) [19-APR-2013 10:01:22:468] nsopen: opening transport...
(3448) [19-APR-2013 10:01:22:468] ntpcon: entry
(3448) [19-APR-2013 10:01:22:468] ntpcon: toc = 1
(3448) [19-APR-2013 10:01:22:468] sntpcall: entry
(3448) [19-APR-2013 10:01:22:468] snlpcss: entry
(3448) [19-APR-2013 10:01:22:468] snlpcss: Failed to load ORASPAWN.DLL, err = 126
(3448) [19-APR-2013 10:01:22:468] sntpcall: exit
(3448) [19-APR-2013 10:01:22:468] ntpcon: exit
(3448) [19-APR-2013 10:01:22:468] nserror: entry
(3448) [19-APR-2013 10:01:22:468] nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=126, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
(3448) [19-APR-2013 10:01:22:468] nsopen: unable to open transport
(3448) [19-APR-2013 10:01:22:468] nstoClearTimeout: entry
(3448) [19-APR-2013 10:01:22:468] nstoClearTimeout: ATO disabled for ctx=0x0FA91B00
(3448) [19-APR-2013 10:01:22:468] nstoClearTimeout: STO disabled for ctx=0x0FA91B00
(3448) [19-APR-2013 10:01:22:468] nstoClearTimeout: RTO disabled for ctx=0x0FA91B00
(3448) [19-APR-2013 10:01:22:468] nstoClearTimeout: PITO disabled for ctx=0x0FA91B00
(3448) [19-APR-2013 10:01:22:468] nstoUpdateActive: entry
(3448) [19-APR-2013 10:01:22:468] nstoUpdateActive: Active timeout is -1 (see nstotyp)
(3448) [19-APR-2013 10:01:22:468] snsbitts_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbitts_ts: acquired the bit
(3448) [19-APR-2013 10:01:22:468] snsbitts_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] snsbitcl_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbitcl_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] nsiocancel: entry
(3448) [19-APR-2013 10:01:22:468] nsiofrrg: entry
(3448) [19-APR-2013 10:01:22:468] nsiofrrg: cur = fa9283c
(3448) [19-APR-2013 10:01:22:468] nsbfr: entry
(3448) [19-APR-2013 10:01:22:468] nsbaddfl: entry
(3448) [19-APR-2013 10:01:22:468] nsbaddfl: normal exit
(3448) [19-APR-2013 10:01:22:468] nsbfr: normal exit
(3448) [19-APR-2013 10:01:22:468] nsiofrrg: exit
(3448) [19-APR-2013 10:01:22:468] nsiocancel: exit
(3448) [19-APR-2013 10:01:22:468] nsvntx_dei: entry
(3448) [19-APR-2013 10:01:22:468] nsvntx_dei: exit
(3448) [19-APR-2013 10:01:22:468] nsopenfree_nsntx: nlhthdel from mplx_ht_nsgbu, ctx=fa91b00 nsntx=fa91ef0
(3448) [19-APR-2013 10:01:22:468] nsiocancel: entry
(3448) [19-APR-2013 10:01:22:468] nsiofrrg: entry
(3448) [19-APR-2013 10:01:22:468] nsiofrrg: exit
(3448) [19-APR-2013 10:01:22:468] nsiocancel: exit
(3448) [19-APR-2013 10:01:22:468] snsbittrm_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbittrm_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] snsbitts_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbitts_ts: acquired the bit
(3448) [19-APR-2013 10:01:22:468] snsbitts_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] snsbitcl_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbitcl_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] nsmfr: entry
(3448) [19-APR-2013 10:01:22:468] nsmfr: 2120 bytes at 0xfa91ef0
(3448) [19-APR-2013 10:01:22:468] nsmfr: normal exit
(3448) [19-APR-2013 10:01:22:468] nsmfr: entry
(3448) [19-APR-2013 10:01:22:468] nsmfr: 996 bytes at 0xfa91b00
(3448) [19-APR-2013 10:01:22:468] nsmfr: normal exit
(3448) [19-APR-2013 10:01:22:468] nsopen: error exit
(3448) [19-APR-2013 10:01:22:468] nsclose: entry
(3448) [19-APR-2013 10:01:22:468] nsclose: normal exit
(3448) [19-APR-2013 10:01:22:468] nladget: entry
(3448) [19-APR-2013 10:01:22:468] nladget: exit
(3448) [19-APR-2013 10:01:22:468] nsmfr: entry
(3448) [19-APR-2013 10:01:22:468] nsmfr: 246 bytes at 0xfa8fd70
(3448) [19-APR-2013 10:01:22:468] nsmfr: normal exit
(3448) [19-APR-2013 10:01:22:468] nsmfr: entry
(3448) [19-APR-2013 10:01:22:468] nsmfr: 216 bytes at 0xfa8ee00
(3448) [19-APR-2013 10:01:22:468] nsmfr: normal exit
(3448) [19-APR-2013 10:01:22:468] nladtrm: entry
(3448) [19-APR-2013 10:01:22:468] nladtrm: exit
(3448) [19-APR-2013 10:01:22:468] nscall: error exit
(3448) [19-APR-2013 10:01:22:468] nioqper:  error from nscall
(3448) [19-APR-2013 10:01:22:468] nioqper:    ns main err code: 12560
(3448) [19-APR-2013 10:01:22:468] nioqper:    ns (2)  err code: 0
(3448) [19-APR-2013 10:01:22:468] nioqper:    nt main err code: 530
(3448) [19-APR-2013 10:01:22:468] nioqper:    nt (2)  err code: 126
(3448) [19-APR-2013 10:01:22:468] nioqper:    nt OS   err code: 0
(3448) [19-APR-2013 10:01:22:468] niomapnserror: entry
(3448) [19-APR-2013 10:01:22:468] niqme: entry
(3448) [19-APR-2013 10:01:22:468] niqme: reporting NS-12560 error as ORA-12560
(3448) [19-APR-2013 10:01:22:468] niqme: exit
(3448) [19-APR-2013 10:01:22:468] niomapnserror: exit
(3448) [19-APR-2013 10:01:22:468] niotns: Couldn't connect, returning 12560
(3448) [19-APR-2013 10:01:22:468] niotns: exit
(3448) [19-APR-2013 10:01:22:468] snsbittrm_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbittrm_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] snsbittrm_ts: entry
(3448) [19-APR-2013 10:01:22:468] snsbittrm_ts: normal exit
(3448) [19-APR-2013 10:01:22:468] nsbfrfl: entry
(3448) [19-APR-2013 10:01:22:468] nsbrfr: entry
(3448) [19-APR-2013 10:01:22:468] nsbrfr: nsbfs at 0xfa8f000, data at 0xfa92880.
(3448) [19-APR-2013 10:01:22:468] nsbrfr: normal exit
(3448) [19-APR-2013 10:01:22:468] nsbfrfl: normal exit
(3448) [19-APR-2013 10:01:22:468] nigtrm: Count in the NI global area is now 1
(3448) [19-APR-2013 10:01:22:468] nigtrm: Count in the NL global area is now 1

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points