请高手指教----急

aaahhh

上面listener.log怎么说Oracle server pc 的ip 是 61.181.115.1 ?  这个pc不是配制的ip 是
192.168.0.100 么?

(ADDRESS=(PROTOCOL=tcp)(HOST=61.181.115.1)(PORT=1770))

gqzhang

对，没错

不好意思，我在客户端sqlnet.ora 里设trace，没有输出，我是这样设置的

names.trace_level = 16
names.trace_file = sqlnet.trc
names.trace_directory = /oracle/network/trace

gqzhang

61.181.115.1 是外网IP,
数据库装在192.168.0.66上，且设为DMZ
如果在内网用192.168.0.20去连接，能够成功且61.181.115.1 的相应位置为192.168.0.20

aaahhh

你没设oracle names, 不要用names.
而是
trace_level_client=16                
trace_file_client=               
trace_directory_client=

aaahhh

我对这些不是很熟， 不过上面不是说外网ip是218。104。。么

gqzhang

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

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

gqzhang

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

[02-8月 -2003 06:43:07:156] nigini: entry
[02-8月 -2003 06:43:07:156] nigini: Count in NI global area now: 1
[02-8月 -2003 06:43:07:156] nigini: Count in NI global area now: 1
[02-8月 -2003 06:43:07:156] nrigbi: entry
[02-8月 -2003 06:43:07:156] nrigbni: entry
[02-8月 -2003 06:43:07:156] nrigbni: Unable to get data from navigation file tnsnav.ora
[02-8月 -2003 06:43:07:156] nrigbni: exit
[02-8月 -2003 06:43:07:156] nrigbi: exit
[02-8月 -2003 06:43:07:156] nigini: exit
[02-8月 -2003 06:43:07:156] niqname: Hst is already an NVstring.
[02-8月 -2003 06:43:07:156] niqname: Inserting CID.
[02-8月 -2003 06:43:07:156] niotns: entry
[02-8月 -2003 06:43:07:156] niotns: niotns: setting up interrupt handler...
[02-8月 -2003 06:43:07:156] niotns: Not trying to enable dead connection detection.
[02-8月 -2003 06:43:07:156] 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 06:43:07:156] nscall: entry
[02-8月 -2003 06:43:07:156] nsmal: entry
[02-8月 -2003 06:43:07:156] nsmal: 164 bytes at 0x12c7180
[02-8月 -2003 06:43:07:156] nsmal: normal exit
[02-8月 -2003 06:43:07:156] nscall: connecting...
[02-8月 -2003 06:43:07:156] nladini: entry
[02-8月 -2003 06:43:07:156] nladini: exit
[02-8月 -2003 06:43:07:156] nladget: entry
[02-8月 -2003 06:43:07:156] nladget: exit
[02-8月 -2003 06:43:07:156] nsc2addr: entry
[02-8月 -2003 06:43:07:156] nttbnd2addr: entry
[02-8月 -2003 06:43:07:156] nttgetport: entry
[02-8月 -2003 06:43:07:156] nttgetport: port resolved to 1521
[02-8月 -2003 06:43:07:156] nttgetport: exit
[02-8月 -2003 06:43:07:156] nttbnd2addr: using host IP address: 218.104.29.227
[02-8月 -2003 06:43:07:156] nttbnd2addr: exit
[02-8月 -2003 06:43:07:156] nsc2addr: normal exit
[02-8月 -2003 06:43:07:156] nsopen: entry
[02-8月 -2003 06:43:07:156] nsmal: entry
[02-8月 -2003 06:43:07:156] nsmal: 492 bytes at 0x12c76f0
[02-8月 -2003 06:43:07:156] nsmal: normal exit
[02-8月 -2003 06:43:07:156] nsopenmplx: entry
[02-8月 -2003 06:43:07:156] nsmal: entry
[02-8月 -2003 06:43:07:156] nsmal: 2348 bytes at 0x12ca898
[02-8月 -2003 06:43:07:156] nsmal: normal exit
[02-8月 -2003 06:43:07:156] nsopenmplx: normal exit
[02-8月 -2003 06:43:07:156] nsopen: opening transport...
[02-8月 -2003 06:43:07:156] nttcon: entry
[02-8月 -2003 06:43:07:156] nttcon: toc = 1
[02-8月 -2003 06:43:07:156] nttcnp: entry
[02-8月 -2003 06:43:07:156] ntvlin: entry
[02-8月 -2003 06:43:07:156] ntvllt: entry
[02-8月 -2003 06:43:07:156] ntvllt: tcp.validnode_checking not turned on
[02-8月 -2003 06:43:07:156] ntvllt: exit
[02-8月 -2003 06:43:07:156] ntvlin: exit
[02-8月 -2003 06:43:07:156] nttcnp: Validnode Table IN use; err 0x0
[02-8月 -2003 06:43:07:156] nttcnp: creating a socket.
[02-8月 -2003 06:43:07:171] nttcnp: exit
[02-8月 -2003 06:43:07:171] nttcni: entry
[02-8月 -2003 06:43:07:171] nttcni: trying to connect to socket 220.
[02-8月 -2003 06:43:30:140] ntt2err: entry
[02-8月 -2003 06:43:30:140] ntt2err: soc 220 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
[02-8月 -2003 06:43:30:140] ntt2err: exit
[02-8月 -2003 06:43:30:140] nttcni: exit
[02-8月 -2003 06:43:30:140] nttcon: exit
[02-8月 -2003 06:43:30:140] nserror: entry
[02-8月 -2003 06:43:30:140] 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 06:43:30:140] nsopen: unable to open transport
[02-8月 -2003 06:43:30:140] nsbfr: entry
[02-8月 -2003 06:43:30:140] nsbfr: normal exit
[02-8月 -2003 06:43:30:140] nsbfr: entry
[02-8月 -2003 06:43:30:140] nsbfr: normal exit
[02-8月 -2003 06:43:30:140] nsmfr: entry
[02-8月 -2003 06:43:30:140] nsmfr: 2348 bytes at 0x12ca898
[02-8月 -2003 06:43:30:140] nsmfr: normal exit
[02-8月 -2003 06:43:30:140] nsmfr: entry
[02-8月 -2003 06:43:30:140] nsmfr: 492 bytes at 0x12c76f0
[02-8月 -2003 06:43:30:140] nsmfr: normal exit
[02-8月 -2003 06:43:30:140] nsopen: error exit
[02-8月 -2003 06:43:30:140] nsclose: entry
[02-8月 -2003 06:43:30:140] nsclose: normal exit
[02-8月 -2003 06:43:30:140] nladget: entry
[02-8月 -2003 06:43:30:140] nladget: exit
[02-8月 -2003 06:43:30:140] nsmfr: entry
[02-8月 -2003 06:43:30:140] nsmfr: 164 bytes at 0x12c7180
[02-8月 -2003 06:43:30:140] nsmfr: normal exit
[02-8月 -2003 06:43:30:140] nladtrm: entry
[02-8月 -2003 06:43:30:140] nladtrm: exit
[02-8月 -2003 06:43:30:140] nscall: error exit
[02-8月 -2003 06:43:30:140] nioqper:  error from nscall
[02-8月 -2003 06:43:30:140] nioqper:    nr err code: 0
[02-8月 -2003 06:43:30:140] nioqper:    ns main err code: 12535
[02-8月 -2003 06:43:30:140] nioqper:    ns (2)  err code: 12560
[02-8月 -2003 06:43:30:140] nioqper:    nt main err code: 505
[02-8月 -2003 06:43:30:140] nioqper:    nt (2)  err code: 60
[02-8月 -2003 06:43:30:140] nioqper:    nt OS   err code: 0
[02-8月 -2003 06:43:30:140] niomapnserror: entry
[02-8月 -2003 06:43:30:140] niqme: entry
[02-8月 -2003 06:43:30:140] niqme: reporting NS-12535 error as ORA-12535
[02-8月 -2003 06:43:30:140] niqme: exit
[02-8月 -2003 06:43:30:140] niomapnserror: returning error 12535
[02-8月 -2003 06:43:30:140] niomapnserror: exit
[02-8月 -2003 06:43:30:140] niotns: Couldn't connect, returning 12535
[02-8月 -2003 06:43:30:140] niotns: exit
[02-8月 -2003 06:43:30:140] nsbfrfl: entry
[02-8月 -2003 06:43:30:140] nsbfrfl: normal exit
[02-8月 -2003 06:43:30:140] nigtrm: Count in the NI global area is now 0
[02-8月 -2003 06:43:30:140] nrigbd: entry
[02-8月 -2003 06:43:30:140] nrigbd: exit
[02-8月 -2003 06:43:30:140] nigtrm: Count in the NL global area is now 0

aaahhh

倒酶， 这个  USE_SHARED_SOCKET=TRUE 还有个bug, 这个错误
ntt2err: soc 220 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
就是导致这个bug 1566794。

你在外网有没有个pc 有8.1.7.4或者9i的client ?

如果没有， 把USE_SHARED_SOCKET=TRUE 改成false， 再把trace里新内容贴出来

gqzhang

大侠
我在设置USE_SHARED_SOCKET的时候是用的双字节，设置为0X000000001

还是要把USE_SHARED_SOCKET设置成字符串TRUE??

gqzhang

我在外网有8.5.0的client