请高手指教----急

aaahhh

按照文档是应该设成' TRUE'

gqzhang

大侠
您太牛了
我实在佩服

aaahhh

工作了么? 没工作不用着急佩服。。

gqzhang

？？？？？
我用的是WIN2000 SERVER
是要把它设成字符串 TRUE 吗？？？

aaahhh

对

aaahhh

你看Oracle里面其他的变量都是字符串的

gqzhang

把USE_SHARED_SOCKET设成 true 或者 false 都连接不上

gqzhang

以下是把USE_SHARED_SOCKET设成FALSE时的trace

gqzhang

[02-8月 -2003 07:32:57:671]
--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
[02-8月 -2003 07:32:57:671] New trace stream is C:\EDMS\ora805\network\trace\sqlnet_1856.trc
[02-8月 -2003 07:32:57:671] New trace level is 16
[02-8月 -2003 07:32:57:671] --- TRACE CONFIGURATION INFORMATION ENDS ---
[02-8月 -2003 07:32:57:671]
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
[02-8月 -2003 07:32:57:671] Attempted load of system pfile source C:\EDMS\ora805\network\admin\sqlnet.ora
[02-8月 -2003 07:32:57:671] Parameter source loaded successfully
[02-8月 -2003 07:32:57:671]
[02-8月 -2003 07:32:57:671] Attempted load of local pfile source C:\sqlnet.ora
[02-8月 -2003 07:32:57:671] Parameter source was not loaded
[02-8月 -2003 07:32:57:671]
[02-8月 -2003 07:32:57:671]  -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
[02-8月 -2003 07:32:57:671] Successful parameter table load
[02-8月 -2003 07:32:57:671]  -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
[02-8月 -2003 07:32:57:671]   trace_level_client = 16
[02-8月 -2003 07:32:57:671]   NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME, ONAMES)
[02-8月 -2003 07:32:57:671]   trace_file_client = sqlnet.trc
[02-8月 -2003 07:32:57:671]   SQLNET.AUTHENTICATION_SERVICES = (NTS)
[02-8月 -2003 07:32:57:671]   trace_directory_client = C:\EDMS\ora805\network\trace
[02-8月 -2003 07:32:57:671] --- PARAMETER SOURCE INFORMATION ENDS ---
[02-8月 -2003 07:32:57:671]
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
[02-8月 -2003 07:32:57:671] Log stream will be "C:\sqlnet.log"
[02-8月 -2003 07:32:57:671] Log stream validation not requested
[02-8月 -2003 07:32:57:671] --- LOG CONFIGURATION INFORMATION ENDS ---

[02-8月 -2003 07:32:57:671] nigini: entry
[02-8月 -2003 07:32:57:671] nigini: Count in NI global area now: 1
[02-8月 -2003 07:32:57:671] nigini: Count in NI global area now: 1
[02-8月 -2003 07:32:57:671] nrigbi: entry
[02-8月 -2003 07:32:57:671] nrigbni: entry
[02-8月 -2003 07:32:57:671] nrigbni: Unable to get data from navigation file tnsnav.ora
[02-8月 -2003 07:32:57:671] nrigbni: exit
[02-8月 -2003 07:32:57:671] nrigbi: exit
[02-8月 -2003 07:32:57:671] nigini: exit
[02-8月 -2003 07:32:57:671] niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
[02-8月 -2003 07:32:57:671] nnfgiinit: entry
[02-8月 -2003 07:32:57:671] nnftboot: entry
[02-8月 -2003 07:32:57:671] nnftboot: exit
[02-8月 -2003 07:32:57:671] nnfoboot: entry
[02-8月 -2003 07:32:57:671] nnfoboot: exit
[02-8月 -2003 07:32:57:671] nnfoboot: entry
[02-8月 -2003 07:32:57:671] nnfoboot: exit
[02-8月 -2003 07:32:57:671] nnfhboot: entry
[02-8月 -2003 07:32:57:671] nnfhboot: exit
[02-8月 -2003 07:32:57:671] nnflcls: entry
[02-8月 -2003 07:32:57:671] nnflcls: exit
[02-8月 -2003 07:32:57:671] nncpcin_maybe_init: first request sent to name server will have ID 0
[02-8月 -2003 07:32:57:671] nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
[02-8月 -2003 07:32:57:671] nncpcin_maybe_init: max request retries per name server is 1
[02-8月 -2003 07:32:57:671] nngsini_init_streams: initializing stream subsystem, cache size is 10
[02-8月 -2003 07:32:57:671] nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
[02-8月 -2003 07:32:57:671] nncpcin_maybe_init: default name server domain is [root]
[02-8月 -2003 07:32:57:671] nnfun2a: entry
[02-8月 -2003 07:32:57:671] nlolgobj: entry
[02-8月 -2003 07:32:57:671] nnfgrne: entry
[02-8月 -2003 07:32:57:671] nnfgrne: Installing read path
[02-8月 -2003 07:32:57:671] nnfgsrsp: entry
[02-8月 -2003 07:32:57:671] nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
[02-8月 -2003 07:32:57:671] nnfgsrdp: entry
[02-8月 -2003 07:32:57:671] nnfgsrdp: Setting path:
[02-8月 -2003 07:32:57:671] nnfgsrdp: checking element TNSNAMES
[02-8月 -2003 07:32:57:671] nnfgsrdp: checking element HOSTNAME
[02-8月 -2003 07:32:57:671] nnfgsrdp: checking element ONAMES
[02-8月 -2003 07:32:57:671] nnfgsrdp: Path set
[02-8月 -2003 07:32:57:671] nnfgrne: Going though read path adapters
[02-8月 -2003 07:32:57:671] nnfgrne: Switching to TNSNAMES adapter
[02-8月 -2003 07:32:57:671] nnfgrne: Original name: pdmbf
[02-8月 -2003 07:32:57:671] nnftinit: entry
[02-8月 -2003 07:32:57:671] nnftinit: Tnsnames refresh interval is 0
[02-8月 -2003 07:32:57:671] nlpaxini: entry
[02-8月 -2003 07:32:57:671] nlpaxini: exit
[02-8月 -2003 07:32:57:671] nnftmlf_make_local_addrfile: entry
[02-8月 -2003 07:32:57:671] nnftmlf_make_local_addrfile: construction of local names file failed
[02-8月 -2003 07:32:57:671] nnftmlf_make_local_addrfile: exit
[02-8月 -2003 07:32:57:671] nlpaxini: entry
[02-8月 -2003 07:32:57:671] nlpaxini: exit
[02-8月 -2003 07:32:57:671] nnftmlf_make_system_addrfile: entry
[02-8月 -2003 07:32:57:671] nnftmlf_make_system_addrfile: system names file is C:\EDMS\ora805\network\admin\tnsnames.ora
[02-8月 -2003 07:32:57:671] nnftmlf_make_system_addrfile: exit
[02-8月 -2003 07:32:57:671] nnftinit: exit
[02-8月 -2003 07:32:57:671] nnftqnm: entry
[02-8月 -2003 07:32:57:671] nnfcagmd: entry
[02-8月 -2003 07:32:57:671] nnfcagmd: Attempting to find metadata for type a.smd
[02-8月 -2003 07:32:57:671] nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
[02-8月 -2003 07:32:57:671] nnfcagmd: exit
[02-8月 -2003 07:32:57:671] nnfttran: entry
[02-8月 -2003 07:32:57:687] --- C:\EDMS\ora805\network\admin\tnsnames.ora TABLE HAS THE FOLLOWING CONTENTS ---
[02-8月 -2003 07:32:57:687] PDMBF = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 218.104.29.227)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PDMBF)))
[02-8月 -2003 07:32:57:687] --- END C:\EDMS\ora805\network\admin\tnsnames.ora TABLE ---
[02-8月 -2003 07:32:57:687] nnfttran: exit
[02-8月 -2003 07:32:57:687] nnfttran: entry
[02-8月 -2003 07:32:57:687] nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 218.104.29.227)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PDMBF))) for name pdmbf
[02-8月 -2003 07:32:57:687] nnfcraa: entry
[02-8月 -2003 07:32:57:687] nnfgrne: Name successfully queried
[02-8月 -2003 07:32:57:687] nnfgrne: Obtaining answer records for pdmbf
[02-8月 -2003 07:32:57:687] nnftans: entry
[02-8月 -2003 07:32:57:687] nnfcran: entry
[02-8月 -2003 07:32:57:687] nnfcran: 64 rrs requested, 1 remaining, 1 total
[02-8月 -2003 07:32:57:687] nnfcran: exit
[02-8月 -2003 07:32:57:687] nnfgrne: exit
[02-8月 -2003 07:32:57:687] nlolgserv: entry
[02-8月 -2003 07:32:57:687] nnfggav: entry
[02-8月 -2003 07:32:57:687] nnfggav: exit
[02-8月 -2003 07:32:57:687] nnfgfrm: entry
[02-8月 -2003 07:32:57:687] nnfgfrm: exit
[02-8月 -2003 07:32:57:687] nlolgserv: exit
[02-8月 -2003 07:32:57:687] nlolgobj: exit
[02-8月 -2003 07:32:57:687] nlolfmem: entry
[02-8月 -2003 07:32:57:687] nlolfmem: exit
[02-8月 -2003 07:32:57:687] nigtrm: Count in the NI global area is now 0
[02-8月 -2003 07:32:57:687] nrigbd: entry
[02-8月 -2003 07:32:57:687] nrigbd: exit
[02-8月 -2003 07:32:57:687] nigtrm: Count in the NL global area is now 0

gqzhang

[02-8月 -2003 07:32:57:687]
--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
[02-8月 -2003 07:32:57:687] New trace stream is C:\EDMS\ora805\network\trace\sqlnet_1856_1.trc
[02-8月 -2003 07:32:57:687] New trace level is 16
[02-8月 -2003 07:32:57:687] --- TRACE CONFIGURATION INFORMATION ENDS ---
[02-8月 -2003 07:32:57:687]
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
[02-8月 -2003 07:32:57:687] Attempted load of system pfile source C:\EDMS\ora805\network\admin\sqlnet.ora
[02-8月 -2003 07:32:57:687] Parameter source loaded successfully
[02-8月 -2003 07:32:57:687]
[02-8月 -2003 07:32:57:687] Attempted load of local pfile source C:\sqlnet.ora
[02-8月 -2003 07:32:57:687] Parameter source was not loaded
[02-8月 -2003 07:32:57:687]
[02-8月 -2003 07:32:57:687]  -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
[02-8月 -2003 07:32:57:687] Successful parameter table load
[02-8月 -2003 07:32:57:687]  -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
[02-8月 -2003 07:32:57:687]   trace_level_client = 16
[02-8月 -2003 07:32:57:687]   NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME, ONAMES)
[02-8月 -2003 07:32:57:687]   trace_file_client = sqlnet.trc
[02-8月 -2003 07:32:57:687]   SQLNET.AUTHENTICATION_SERVICES = (NTS)
[02-8月 -2003 07:32:57:687]   trace_directory_client = C:\EDMS\ora805\network\trace
[02-8月 -2003 07:32:57:687] --- PARAMETER SOURCE INFORMATION ENDS ---
[02-8月 -2003 07:32:57:687]
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
[02-8月 -2003 07:32:57:687] Log stream will be "C:\sqlnet.log"
[02-8月 -2003 07:32:57:687] Log stream validation not requested
[02-8月 -2003 07:32:57:687] --- LOG CONFIGURATION INFORMATION ENDS ---

[02-8月 -2003 07:32:57:687] nigini: entry
[02-8月 -2003 07:32:57:687] nigini: Count in NI global area now: 1
[02-8月 -2003 07:32:57:687] nigini: Count in NI global area now: 1
[02-8月 -2003 07:32:57:687] nrigbi: entry
[02-8月 -2003 07:32:57:687] nrigbni: entry
[02-8月 -2003 07:32:57:687] nrigbni: Unable to get data from navigation file tnsnav.ora
[02-8月 -2003 07:32:57:687] nrigbni: exit
[02-8月 -2003 07:32:57:687] nrigbi: exit
[02-8月 -2003 07:32:57:687] nigini: exit
[02-8月 -2003 07:32:57:687] niqname: Hst is already an NVstring.
[02-8月 -2003 07:32:57:687] niqname: Inserting CID.
[02-8月 -2003 07:32:57:687] niotns: entry
[02-8月 -2003 07:32:57:687] niotns: niotns: setting up interrupt handler...
[02-8月 -2003 07:32:57:687] niotns: Not trying to enable dead connection detection.
[02-8月 -2003 07:32:57:687] niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=218.104.29.227)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PDMBF)(CID=(PROGRAM=C:\EDMS\ora805\bin\sqlplus.exe)(HOST=LIUFENG)(USER=polysoft))))
[02-8月 -2003 07:32:57:687] nscall: entry
[02-8月 -2003 07:32:57:687] nsmal: entry
[02-8月 -2003 07:32:57:687] nsmal: 164 bytes at 0x12c71a0
[02-8月 -2003 07:32:57:687] nsmal: normal exit
[02-8月 -2003 07:32:57:687] nscall: connecting...
[02-8月 -2003 07:32:57:687] nladini: entry
[02-8月 -2003 07:32:57:687] nladini: exit
[02-8月 -2003 07:32:57:687] nladget: entry
[02-8月 -2003 07:32:57:687] nladget: exit
[02-8月 -2003 07:32:57:687] nsc2addr: entry
[02-8月 -2003 07:32:57:687] nttbnd2addr: entry
[02-8月 -2003 07:32:57:687] nttgetport: entry
[02-8月 -2003 07:32:57:687] nttgetport: port resolved to 1521
[02-8月 -2003 07:32:57:687] nttgetport: exit
[02-8月 -2003 07:32:57:687] nttbnd2addr: using host IP address: 218.104.29.227
[02-8月 -2003 07:32:57:687] nttbnd2addr: exit
[02-8月 -2003 07:32:57:687] nsc2addr: normal exit
[02-8月 -2003 07:32:57:687] nsopen: entry
[02-8月 -2003 07:32:57:687] nsmal: entry
[02-8月 -2003 07:32:57:687] nsmal: 492 bytes at 0x12c7710
[02-8月 -2003 07:32:57:687] nsmal: normal exit
[02-8月 -2003 07:32:57:687] nsopenmplx: entry
[02-8月 -2003 07:32:57:687] nsmal: entry
[02-8月 -2003 07:32:57:687] nsmal: 2348 bytes at 0x12ca898
[02-8月 -2003 07:32:57:687] nsmal: normal exit
[02-8月 -2003 07:32:57:687] nsopenmplx: normal exit
[02-8月 -2003 07:32:57:687] nsopen: opening transport...
[02-8月 -2003 07:32:57:687] nttcon: entry
[02-8月 -2003 07:32:57:687] nttcon: toc = 1
[02-8月 -2003 07:32:57:687] nttcnp: entry
[02-8月 -2003 07:32:57:687] ntvlin: entry
[02-8月 -2003 07:32:57:687] ntvllt: entry
[02-8月 -2003 07:32:57:703] ntvllt: tcp.validnode_checking not turned on
[02-8月 -2003 07:32:57:703] ntvllt: exit
[02-8月 -2003 07:32:57:703] ntvlin: exit
[02-8月 -2003 07:32:57:703] nttcnp: Validnode Table IN use; err 0x0
[02-8月 -2003 07:32:57:703] nttcnp: creating a socket.
[02-8月 -2003 07:32:57:703] nttcnp: exit
[02-8月 -2003 07:32:57:703] nttcni: entry
[02-8月 -2003 07:32:57:703] nttcni: trying to connect to socket 220.
[02-8月 -2003 07:33:20:671] ntt2err: entry
[02-8月 -2003 07:33:20:671] ntt2err: soc 220 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
[02-8月 -2003 07:33:20:671] ntt2err: exit
[02-8月 -2003 07:33:20:671] nttcni: exit
[02-8月 -2003 07:33:20:671] nttcon: exit
[02-8月 -2003 07:33:20:671] nserror: entry
[02-8月 -2003 07:33:20:671] nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[02-8月 -2003 07:33:20:671] nsopen: unable to open transport
[02-8月 -2003 07:33:20:671] nsbfr: entry
[02-8月 -2003 07:33:20:671] nsbfr: normal exit
[02-8月 -2003 07:33:20:671] nsbfr: entry
[02-8月 -2003 07:33:20:671] nsbfr: normal exit
[02-8月 -2003 07:33:20:671] nsmfr: entry
[02-8月 -2003 07:33:20:671] nsmfr: 2348 bytes at 0x12ca898
[02-8月 -2003 07:33:20:671] nsmfr: normal exit
[02-8月 -2003 07:33:20:671] nsmfr: entry
[02-8月 -2003 07:33:20:671] nsmfr: 492 bytes at 0x12c7710
[02-8月 -2003 07:33:20:671] nsmfr: normal exit
[02-8月 -2003 07:33:20:671] nsopen: error exit
[02-8月 -2003 07:33:20:671] nsclose: entry
[02-8月 -2003 07:33:20:671] nsclose: normal exit
[02-8月 -2003 07:33:20:671] nladget: entry
[02-8月 -2003 07:33:20:671] nladget: exit
[02-8月 -2003 07:33:20:671] nsmfr: entry
[02-8月 -2003 07:33:20:671] nsmfr: 164 bytes at 0x12c71a0
[02-8月 -2003 07:33:20:671] nsmfr: normal exit
[02-8月 -2003 07:33:20:671] nladtrm: entry
[02-8月 -2003 07:33:20:671] nladtrm: exit
[02-8月 -2003 07:33:20:671] nscall: error exit
[02-8月 -2003 07:33:20:671] nioqper:  error from nscall
[02-8月 -2003 07:33:20:671] nioqper:    nr err code: 0
[02-8月 -2003 07:33:20:671] nioqper:    ns main err code: 12535
[02-8月 -2003 07:33:20:671] nioqper:    ns (2)  err code: 12560
[02-8月 -2003 07:33:20:671] nioqper:    nt main err code: 505
[02-8月 -2003 07:33:20:671] nioqper:    nt (2)  err code: 60
[02-8月 -2003 07:33:20:671] nioqper:    nt OS   err code: 0
[02-8月 -2003 07:33:20:671] niomapnserror: entry
[02-8月 -2003 07:33:20:671] niqme: entry
[02-8月 -2003 07:33:20:671] niqme: reporting NS-12535 error as ORA-12535
[02-8月 -2003 07:33:20:671] niqme: exit
[02-8月 -2003 07:33:20:671] niomapnserror: returning error 12535
[02-8月 -2003 07:33:20:671] niomapnserror: exit
[02-8月 -2003 07:33:20:671] niotns: Couldn't connect, returning 12535
[02-8月 -2003 07:33:20:671] niotns: exit
[02-8月 -2003 07:33:20:671] nsbfrfl: entry
[02-8月 -2003 07:33:20:671] nsbfrfl: normal exit
[02-8月 -2003 07:33:20:671] nigtrm: Count in the NI global area is now 0
[02-8月 -2003 07:33:20:671] nrigbd: entry
[02-8月 -2003 07:33:20:671] nrigbd: exit
[02-8月 -2003 07:33:20:671] nigtrm: Count in the NL global area is now 0