Home » RDBMS Server » Networking and Gateways » tnsping success, sqlplus get ORA-12560 ,here is trace file
tnsping success, sqlplus get ORA-12560 ,here is trace file [message #66815] Wed, 22 January 2003 02:52 Go to next message
linqunhui
Messages: 4
Registered: January 2003
Junior Member
There are 2 IP address:
My Oracel server IP is : 10.18.58.88/132.107.64.74

I ask my network administrator for Oracle server IP,
He said "If you work at computer 132.107.64.74, the server ip address is:132.107.71.225, CAN not use 132.107.71.225;

If you work at computer 10.18.49.83, the server ip address is:10.18.58.88."

When I at computer 10.18.49.83,everything is correct.
When I at computer 132.107.64.74,I can ftp,ping,tnsping
Oracle Server 132.107.71.225,but I can not
sqlplus scott/tiger@pcdm

It report error: ORA-12560

PLEASE help me!

Here is trace file:

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is D:@tracecli.trc
New trace level is 4
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source E:OracleOra81networkadminsqlnet.ora
Parameter source loaded successfully

Attempted load of local pfile source D:@tracesqlnet.ora
Parameter source was not loaded

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_LEVEL_SERVER = USER
TRACE_LEVEL_CLIENT = USER
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES = (NTS)
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "D:@tracesqlnet.log"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbni: Unable to get data from navigation file tnsnav.ora
nncpmlf_make_local_addrfile: construction of local names file failed
nncpmsf_make_sys_addrfile: system names file is E:OracleOra81networkadmintnsnames.ora
niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=132.107.71.225)(PORT=1521)))(CONNECT_DATA=(SID=pcdm)(CID=(PROGRAM=E:OracleOra81binSQLPLUS.EXE)(HOST=FULLTEXT)(USER=Administrator))))
nscall: connecting...
nttbnd2addr: port resolved to 1521
nttbnd2addr: using host IP address: 132.107.71.225
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 160.
nsopen: transport is open
nsnainit: inf->nsinfflg[[0]]: 0x21 inf->nsinfflg[[1]]: 0x21
nsopen: global context check-in (to slot 0) complete
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: got NSPTRD packet
nscall: redirected
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 0) complete
nscall: connecting...
nttbnd2addr: port resolved to 3746
nttbnd2addr: using host IP address: 10.18.58.88
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 176.
ntt2err: soc 176 error - operation=1, ntresnt[[0]]=538, ntresnt[[1]]=65, ntresnt[[2]]=0
nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[[0]]=538, nt[[1]]=65, nt[[2]]=0; ora[[0]]=0, ora[[1]]=0, ora[[2]]=0
nsopen: unable to open transport
nioqper: error from nscall
nioqper: nr err code: 0
nioqper: ns main err code: 12560
nioqper: ns (2) err code: 0
nioqper: nt main err code: 538
nioqper: nt (2) err code: 65
nioqper: nt OS err code: 0
niqme: reporting NS-12560 error as ORA-12560
niomapnserror: returning error 12560
niotns: Couldn't connect, returning 12560
nigtrm: Count in the NI global area is now 0
nigtrm: Count in the NL global area is now 0
Re: tnsping success, sqlplus get ORA-12560 ,here is trace file [message #66817 is a reply to message #66815] Wed, 22 January 2003 10:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
first remove /comment out these 2 lines in ur sqlnet.ora
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES = (NTS)

and try again.
if sucess remove all the tracing entries (unless it is wanted).
else
post the exact error message
we'll look into other options.
Re: tnsping success, sqlplus get ORA-12560 ,here is trace file [message #66819 is a reply to message #66817] Wed, 22 January 2003 17:55 Go to previous messageGo to next message
linqunhui
Messages: 4
Registered: January 2003
Junior Member
Thank you your reply!
Thank you your reply!
Thank you your reply!

My network administrator said: " The Address is NAT change."

Now my sqlnet.ora is:
======================

# SQLNET.ORA Network Configuration File: D:OracleOra81NETWORKADMINsqlnet.ora
# Generated by Oracle configuration tools.

# SQLNET.AUTHENTICATION_SERVICES= (NTS)

# NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

TRACE_LEVEL_CLIENT = SUPPORT

TRACE_LEVEL_SERVER = SUPPORT

My input command is:
====================
tnsping pcdm correct
sqlplus scott/tiger@pcdm
ORA-12560:....

Now my trace file is:
=====================
--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is C:oracleora81networkADMINcli.trc
New trace level is 16
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source c:oracleora81networkadminsqlnet.ora
Parameter source loaded successfully

Attempted load of local pfile source C:oracleora81networkADMINsqlnet.ora
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_LEVEL_SERVER = SUPPORT
TRACE_LEVEL_CLIENT = SUPPORT
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "C:oracleora81networkADMINsqlnet.log"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nigini: entry
nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbi: entry
nrigbni: entry
nrigbni: Unable to get data from navigation file tnsnav.ora
nrigbni: exit
nrigbi: exit
nigini: exit
niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
nnfgiinit: entry
nnftboot: entry
nnftboot: exit
nnfoboot: entry
nnfoboot: exit
nnfoboot: entry
nnfoboot: exit
nnfhboot: entry
nnfhboot: exit
nnfnboot: entry
nnfnboot: exit
nnfnboot: entry
nnfnboot: exit
nnflcls: entry
nnflcls: exit
nncpmlf_make_local_addrfile: local names file is C:oracleora81networkADMINtnsnames.ora
nncpmsf_make_sys_addrfile: system names file is c:oracleora81networkadmintnsnames.ora
nncpcin_maybe_init: first request sent to name server will have ID 222
nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is [[root]]
nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
nnfgsrsp: Parmeter names.directory_path not found, setting path to compiled in default
nnfgspd: entry
nnfgspd: setting element DCE
nnfgspd: setting element CDS
nnfgspd: setting element TNSNAMES
nnfgspd: setting element ONAMES
nnfgspd: setting element ONRS
nnfgspd: setting element HOSTNAME
nnfgspd: setting element NOVELL
nnfgspd: setting element NDS
nnfgspd: setting element LDAP
nnfgspd: Path set
nnfgspd: exit
nnfgrne: Going though read path adapters
nnfgrne: Switching to DCE adapter
nnfgrne: Original name: pcdm
nnfgrne: Name did not qualify, skipping to next adapter
nnfgrne: Switching to CDS adapter
nnfgrne: Original name: pcdm
nnfgrne: Name did not qualify, skipping to next adapter
nnfgrne: Switching to TNSNAMES adapter
nnfgrne: Original name: pcdm
nnftqnm: entry
nnfcagmd: entry
nnfcagmd: Attempting to find metadata for type a.smd
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nnfotran: Checking local tnsnames.ora file
nncpldf_load_addrfile: initial load of names file C:oracleora81networkADMINtnsnames.ora
nncpldf_load_addrfile: success
nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 132.107.71.225)(PORT = 1521))) (CONNECT_DATA = (SID = pcdm))) for name pcdm
nnfcraa: entry
nnfgrne: Name successfully queried
nnfgrne: Obtaining answer records for pcdm
nnftans: entry
nnfcran: entry
nnfcran: 64 rrs requested, 1 remaining, 1 total
nnfcran: exit
nnfgrne: exit
nlolgserv: entry
nnfggav: entry
nnfggav: exit
nnfgfrm: entry
nnfgfrm: exit
nlolgserv: exit
nlolgobj: exit
nlolfmem: entry
nlolfmem: exit
nnfgdei: entry
nnfndei: entry
nnfndei: exit
nnfndei: entry
nnfndei: exit
nnfldei: entry
nnflcls: entry
nnflcls: exit
nnfldei: exit
nngsdei_deinit_streams: deinit
nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored
nsbfrfl: entry
nsbfrfl: normal exit
nnfgdei: exit
niotns: entry
niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=132.107.71.225)(PORT=1521)))(CONNECT_DATA=(SID=pcdm)(CID=(PROGRAM=c:oracleora81binSQLPLUS.EXE)(HOST=CSACER123)(USER=cs))))
nscall: entry
nsmal: entry
nsmal: 140 bytes at 0x19a0568
nsmal: normal exit
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nsc2addr: entry
nttbnd2addr: entry
nttbnd2addr: port resolved to 1521
nttbnd2addr: using host IP address: 132.107.71.225
nttbnd2addr: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 428 bytes at 0x1994908
nsmal: normal exit
nsopenmplx: entry
nsmal: entry
nsmal: 1712 bytes at 0x19a2830
nsmal: normal exit
nsopenmplx: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: No PROTOCOL.ORA file is found
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: creating a socket.
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 200.
nttcni: exit
nttcon: NT layer TCP/IP connection has been established.
nttcon: exit
nsopen: transport is open
nsnainit: entry
nsnainit: call
nsnadct: entry
nsnadct: normal exit
nsnasvnainfo: entry
nsnasvnainfo: normal exit
nainit: entry
nagblini: entry
nau_gin: entry
nau_gparams: entry
nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter file
nam_gbp: Parameter not found
nau_gparams: Using default value "FALSE"
nau_gslf: entry
nam_gic: entry
nam_gic: Counting # of items in "sqlnet.authentication_services" parameter
nam_gic: Parameter not found
nam_gic: Found 0 items
nam_gic: exit
nau_gslf: Using default value "all available adapters"
nauss_set_state: entry
nauss_set_state: exit
nau_gslf: exit
nau_gparams: exit
nau_gin: exit
nagblini: exit
na_saveprot: entry
na_saveprot: exit
nacomin: entry
nas_init: entry
nas_init: exit
nau_ini: entry
naugcp_get_connect_parameters: entry
nauss_set_state: entry
nauss_set_state: exit
naugcp_get_connect_parameters: exit
nau_gettab: entry
nau_tadv: entry
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: The following authentication adapter dll does not exist: orangss8.dll
nau_fad: exit
nau_fad: entry
nau_fad: The following authentication adapter dll does not exist: oranidx8.dll
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: The following authentication adapter dll does not exist: oranoss8.dll
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_tadv: Found at least one invalid entry
nau_tadv: exit
nau_gettab: using authentication adapter table "dynamic table"
nau_gettab: dynamic table contains the following services:
nau_gettab: KERBEROS5
nau_gettab: SECURID
nau_gettab: NDS
nau_gettab: NTS
nau_gettab: RADIUS
nau_gettab: exit
nau_sini: entry
nau_sini: exit
nau_ini: connection type: "standard"
nau_ini: exit
naeeinit: entry
nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file
nam_gbp: Parameter not found
nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_CLIENT" from parameter file
nam_gnsp: Parameter not found
naequad: Using default value "ACCEPTED"
nam_gic: entry
nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_CLIENT" parameter
nam_gic: Parameter not found
nam_gic: exit
naesno: Using default value "all available algorithms"
naeshow: entry
naeshow: These are the encryption algorithms that the client will accept:
naeshow: Choice 0: no algorithm; encryption inactive
naeshow: Choice 1: 'RC4_40' (ID 1)
naeshow: Choice 2: 'RC4_56' (ID 8)
naeshow: Choice 3: 'DES' (ID 2)
naeshow: Choice 4: 'DES40' (ID 3)
naeshow: exit
naeeinit: exit
naecinit: entry
nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_CLIENT" from parameter file
nam_gnsp: Parameter not found
naequad: Using default value "ACCEPTED"
nam_gic: entry
nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT" parameter
nam_gic: Parameter not found
nam_gic: exit
naesno: Using default value "all available algorithms"
naeshow: entry
naeshow: These are the checksumming algorithms that the client will accept:
naeshow: Choice 0: no algorithm; checksumming inactive
naeshow: Choice 1: 'MD5' (ID 1)
naeshow: exit
naecinit: exit
nainit: exit
nagetctxinfo: entry
nagetctxinfo: exit
nsnainit: NS Connection version: 310
nsnainit: inf->nsinfflg[[0]]: 0x41 inf->nsinfflg[[1]]: 0x41
nsnainit: "or" info flags: 0x41 Translations follow:
native service(s) is (are) wanted

nsnainit: "or" info flags: 0x41 Translations follow:
native service(s) is (are) wanted
"and" info flags: 0x41 Translations follow:
native service(s) is (are) wanted

nsnainit: normal exit
nsoptions: entry
nsoptions: lcl[[0]]=0x0, lcl[[1]]=0x100000, gbl[[0]]=0x0, gbl[[1]]=0x0, cha=0x0
nsoptions: lcl[[0]]=0x1fefff, lcl[[1]]=0x100000, gbl[[0]]=0xf83f, gbl[[1]]=0x0
nsoptions: normal exit
nsopen: global context check-in (to slot 0) complete
nsopen: lcl[[0]]=0x1fefff, lcl[[1]]=0x100000, gbl[[0]]=0xf83f, gbl[[1]]=0x0, tdu=32767, sdu=2048
nsdo: entry
nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=7, flg=0x4201, mvd=0
nsbal: entry
nsbgetfl: entry
nsbgetfl: normal exit
nsmal: entry
nsmal: 44 bytes at 0x198ff18
nsmal: normal exit
nsbal: normal exit
nsbal: entry
nsbgetfl: entry
nsbgetfl: normal exit
nsmal: entry
nsmal: 44 bytes at 0x19948a0
nsmal: normal exit
nsbal: normal exit
nsepcIniCFI: entry
nlidg8: entry
nlidg8: exit
nsepcIniCFI: normal exit
nsdo: nsctxrnk=0
nsdo: normal exit
nsopen: normal exit
nsdo: entry
nsdo: cid=0, opcode=67, *bl=167, *what=8, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=14, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2023
nscon: entry
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nspsend: entry
nspsend: plen=225, type=1
nttwr: entry
nttwr: socket 200 had bytes written=225
nttwr: exit
nspsend: 225 bytes to transport
nspsend: packet dump
nspsend: 00 E1 00 00 01 00 00 00 &#124........
nspsend: 01 36 01 2C 00 00 08 00 &#124.6.,....
nspsend: 7F FF A3 0A 00 00 01 00 &#124........
nspsend: 00 A7 00 3A 00 00 02 00 &#124...:....
nspsend: 41 41 00 00 00 00 00 00 &#124AA......
nspsend: 00 00 00 00 01 D4 00 00 &#124........
nspsend: 00 05 00 00 00 00 00 00 &#124........
nspsend: 00 00 28 44 45 53 43 52 &#124..(DESCR
nspsend: 49 50 54 49 4F 4E 3D 28 &#124IPTION=(
nspsend: 41 44 44 52 45 53 53 3D &#124ADDRESS=
nspsend: 28 50 52 4F 54 4F 43 4F &#124(PROTOCO
nspsend: 4C 3D 54 43 50 29 28 48 &#124L=TCP)(H
nspsend: 4F 53 54 3D 31 33 32 2E &#124OST=132.
nspsend: 31 30 37 2E 37 31 2E 32 &#124107;.71.2
nspsend: 32 35 29 28 50 4F 52 54 )(PORT
nspsend: 3D 31 35 32 31 29 29 28 &#124=1521))(
nspsend: 43 4F 4E 4E 45 43 54 5F &#124CONNECT_
nspsend: 44 41 54 41 3D 28 53 49 &#124DATA=(SI
nspsend: 44 3D 70 63 64 6D 29 28 &#124D=pcdm)(
nspsend: 43 49 44 3D 28 50 52 4F &#124CID=(PRO
nspsend: 47 52 41 4D 3D 63 3A 5C &#124GRAM=c:
nspsend: 6F 72 61 63 6C 65 5C 6F &#124oracleo
nspsend: 72 61 38 31 5C 62 69 6E &#124ra81bin
nspsend: 5C 53 51 4C 50 4C 55 53 &#124SQLPLUS
nspsend: 2E 45 58 45 29 28 48 4F &#124.EXE)(HO
nspsend: 53 54 3D 43 53 41 43 45 &#124ST=CSACE
nspsend: 52 31 32 33 29 28 55 53 &#124R123)(US
nspsend: 45 52 3D 63 73 29 29 29 &#124ER=cs)))
nspsend: 29 00 00 00 00 00 00 00 &#124).......
nspsend: normal exit
nscon: exit (0)
nsdo: nsctxrnk=0
nsdo: normal exit
nsdo: entry
nsdo: cid=0, opcode=68, *bl=512, *what=9, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=2, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2023
nscon: entry
nscon: recving a packet
nsprecv: entry
nsbal: entry
nsbgetfl: entry
nsbgetfl: normal exit
nsmal: entry
nsmal: 44 bytes at 0x19a00f0
nsmal: normal exit
nsbal: normal exit
nsprecv: reading from transport...
nttrd: entry
nttrd: socket 200 had bytes read=63
nttrd: exit
nsprecv: 63 bytes from transport
nsprecv: tlen=63, plen=63, type=5
nsprecv: packet dump
nsprecv: 00 3F 00 00 05 00 00 00 &#124.?......
nsprecv: 00 35 28 41 44 44 52 45 &#124.5(ADDRE
nsprecv: 53 53 3D 28 50 52 4F 54 &#124SS=(PROT
nsprecv: 4F 43 4F 4C 3D 74 63 70 &#124OCOL=tcp
nsprecv: 29 28 48 4F 53 54 3D 31 &#124)(HOST=1
nsprecv: 30 2E 31 38 2E 35 38 2E &#1240;.18.58.
nsprecv: 38 38 29 28 50 4F 52 54 g)(PORT
nsprecv: 3D 33 39 31 35 29 29 00 &#124=3915)).
nsprecv: normal exit
nscon: got NSPTRD packet
nscon: got 53 bytes connect data
nscon: exit (0)
nsdo: nsctxrnk=0
nsdo: normal exit
nscall: redirected
nsclose: entry
nstimarmed: entry
nstimarmed: no timer allocated
nstimarmed: normal exit
nsdo: entry
nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x440, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=3, flg=0x4201, mvd=0
nsbfr: entry
nsbaddfl: entry
nsbaddfl: normal exit
nsbfr: normal exit
nsbfr: entry
nsbaddfl: entry
nsbaddfl: normal exit
nsbfr: normal exit
nsdo: nsctxrnk=0
nsdo: normal exit
nsclose: closing transport
nttdisc: entry
nttdisc: Closed socket 200
nttdisc: exit
nsclose: global context check-out (from slot 0) complete
nsnadisc: entry
nadisc: entry
nacomtm: entry
nacompd: entry
nacompd: exit
nacompd: entry
nacompd: exit
nacomtm: exit
nas_dis: entry
nas_dis: exit
nau_dis: entry
nau_fad: exit
nau_dis: exit
naeetrm: entry
naeetrm: exit
naectrm: entry
naectrm: exit
nagbltrm: entry
nau_gtm: entry
nau_gtm: exit
nagbltrm: exit
nadisc: exit
nsnadisc: normal exit
nsbfr: entry
nsbaddfl: entry
nsbaddfl: normal exit
nsbfr: normal exit
nsmfr: entry
nsmfr: 1712 bytes at 0x19a2830
nsmfr: normal exit
nsmfr: entry
nsmfr: 428 bytes at 0x1994908
nsmfr: normal exit
nsclose: normal exit
nscall: connecting...
nsc2addr: entry
nttbnd2addr: entry
nttbnd2addr: port resolved to 3915
nttbnd2addr: using host IP address: 10.18.58.88
nttbnd2addr: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 428 bytes at 0x1994908
nsmal: normal exit
nsopenmplx: entry
nsmal: entry
nsmal: 1712 bytes at 0x19a2830
nsmal: normal exit
nsopenmplx: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: creating a socket.
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 224.
ntt2err: entry
ntt2err: soc 224 error - operation=1, ntresnt[[0]]=538, ntresnt[[1]]=65, ntresnt[[2]]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[[0]]=538, nt[[1]]=65, nt[[2]]=0; ora[[0]]=0, ora[[1]]=0, ora[[2]]=0
nsopen: unable to open transport
nsbfr: entry
nsbfr: normal exit
nsmfr: entry
nsmfr: 1712 bytes at 0x19a2830
nsmfr: normal exit
nsmfr: entry
nsmfr: 428 bytes at 0x1994908
nsmfr: normal exit
nsopen: error exit
nsmfr: entry
nsmfr: 167 bytes at 0x1994f48
nsmfr: normal exit
nsmfr: entry
nsmfr: 140 bytes at 0x19a0568
nsmfr: normal exit
nladtrm: entry
nladtrm: exit
nscall: error exit
nioqper: error from nscall
nioqper: nr err code: 0
nioqper: ns main err code: 12560
nioqper: ns (2) err code: 0
nioqper: nt main err code: 538
nioqper: nt (2) err code: 65
nioqper: nt OS err code: 0
niomapnserror: entry
niqme: entry
niqme: reporting NS-12560 error as ORA-12560
niqme: exit
niomapnserror: returning error 12560
niomapnserror: exit
niotns: Couldn't connect, returning 12560
niotns: exit
nsbfrfl: entry
nsbrfr: entry
nsbrfr: nsbfs at 0x19a00f0, data at 0x199c048.
nsbrfr: normal exit
nsbrfr: entry
nsbrfr: nsbfs at 0x19948a0, data at 0x199c870.
nsbrfr: normal exit
nsbrfr: entry
nsbrfr: nsbfs at 0x198ff18, data at 0x199d098.
nsbrfr: normal exit
nsbfrfl: normal exit
nigtrm: Count in the NI global area is now 0
nnfgdei: entry
nrigbd: entry
nrigbd: exit
nigtrm: Count in the NL global area is now 0
It's a network setup problem [message #66820 is a reply to message #66817] Wed, 22 January 2003 19:14 Go to previous messageGo to next message
linqunhui
Messages: 4
Registered: January 2003
Junior Member
Thank Mahesh Rajendran.
Thank you very much.

I found the reason:

My network administrator use Sniffer to catch tcp/ip package.The communication procedure is:

132.107.64.74 <-------> 132.107.71.225 <--NAT--->10.18.58.88


1.The Oracle client 132.107.64.74
sends a package to Oracle Server(132.107.71.225)

2.The Router use NAT to change the package header
target IP address from 132.107.71.225 to 10.18.58.88

3.The True Oracle Server(10.18.58.88) received this package.

4.The True Oracle Server(10.18.58.88) reply this package.
It send a package:
the package include 2 part.
one is package header,the other is package data.

In package header,target ip is oracle client 132.107.64.74
In package data,there is a IP address and port.
The IP is a true Oracle Server IP(10.18.58.88)

5.After the oracle client receives this package.
It send a new package to new IP address: 10.18.58.88

6.Because it can not reach this new IP. 10.18.58.88

7.The Oracle client try to use the getway address
:132.107.64.126

8.also can not reach 10.18.58.88

9.The client try again

10.The client try again

11.The client try again

until timeout,It report error: ORA-12560
The network administrator said It's a ORACLE setup problem [message #66821 is a reply to message #66817] Wed, 22 January 2003 19:28 Go to previous messageGo to next message
linqunhui
Messages: 4
Registered: January 2003
Junior Member
I don't know how to resolve this ORA-12560 error.

Please help me!

Thank you very much!
Re: The network administrator said It's a ORACLE setup problem [message #323582 is a reply to message #66821] Wed, 28 May 2008 22:43 Go to previous message
rolleaway
Messages: 1
Registered: May 2008
Junior Member
how to resolve it at last?
thank you!
Previous Topic: Calling MSSQL Stored procedure
Next Topic: Licensing fee for Transparent gateway for MS SQL SERVER
Goto Forum:
  


Current Time: Tue Dec 06 02:44:15 CST 2016

Total time taken to generate the page: 0.08953 seconds