tnsping的问题

baikejia

加了server=dedicated还是不行

baikejia

test=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )

global_name=test.world
db_domain=''

test=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.world)
    )
  )

test.world=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )

test.world=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.world)
    )
  )

都不行

lojian

关注中！

baikejia

我就奇怪，要tnsping不通应该所有网段都不通啊
怎么会和网段有关？

blandy

网段之间是否有防火墙?

如果有的话,应该就是防火墙的问题

qrsy

tnsnames.ora 配置如下就可以

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = test)
      (SERVER = DEDICATED)
    )
  )

mugen

it doesnot work

zjxs

客户端sqlnet.ora中添加tnsping.trace_level和tnsping.trace_directory参数来跟踪一下。

baikejia

nnfttran: exit
nnfttran: entry
nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = test))) for name test
nnfcraa: entry
nnfgrne: Name successfully queried
nnfgrne: Obtaining answer records for swapp
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
nnfun2awanm: Getting the path of sqlnet.ora
nnfun2awanm: Getting the adapter name
nnfun2awanm: exit
nscall: entry
nsmal: entry
nsmal: 164 bytes at 0xb380c0
nsmal: normal exit
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nsc2addr: entry
nttbnd2addr: entry
nttgetport: entry
nttgetport: port resolved to 1521
nttgetport: exit
nttbnd2addr: using host IP address: 10.17.41.201
nttbnd2addr: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 492 bytes at 0xb812a0
nsmal: normal exit
nsopenmplx: entry
nsmal: entry
nsmal: 2348 bytes at 0xb81498
nsmal: normal exit
nsopenmplx: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: tcp.validnode_checking not turned on
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 1920.
ntt2err: entry
ntt2err: soc 1920 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nsbfr: entry
nsbfr: normal exit
nsbfr: entry
nsbfr: normal exit
nsmfr: entry
nsmfr: 2348 bytes at 0xb81498
nsmfr: normal exit
nsmfr: entry
nsmfr: 492 bytes at 0xb812a0
nsmfr: normal exit
nsopen: error exit
nscall: error exit
nscall: entry
nscall: connecting...
nsclose: entry
nsclose: normal exit
nladget: entry
nladget: exit
nsmfr: entry
nsmfr: 164 bytes at 0xb380c0
nsmfr: normal exit
nladtrm: entry
nladtrm: exit
nscall: error exit

mugen

楼上的，我看不太懂上面的信息