› Fóruns › Banco de dados Oracle › Erro conexão 9i estação não encontra o tnsnames.ora › Erro conexão 9i estação não encontra o tnsnames.ora
Ishii,
Segue abaixo conteúdo do arquivo trace gerado através do SQLNET.ORA .
— TRACE CONFIGURATION INFORMATION FOLLOWS —
New trace stream is “c:tracearq_trace.trc”
New trace level is 4
— TRACE 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
(2eca) niotns: niotns: setting up interrupt handler…
(2eca) niotns: Not trying to enable dead connection detection.
(2eca) niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))’)))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=z:max.exe)(HOST=CPU58970)(USER=airton))))
(2eca) nric2a: Getting local community information
(2eca) nriglp: Looking for local addresses setup by nrigla
(2eca) nriglp: No addresses in the preferred address list
(2eca) nric2a: TNSNAV.ORA is not present. No local communities entry.
(2eca) nrigla: Getting local address information
(2eca) nrigla: Address list being processed.
(2eca) nrigla: No community information so all addresses are local
(2eca) nridst: Resolving address to use to call destination or next hop
(2eca) nridst: Processing address list.
(2eca) nridst: No community entries so iterate over address list
(2eca) nric2a: This is a local community access
(2eca) nricall: Got routable address information.
(2eca) nricall: Making call with following address information: (DESCRIPTION=(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=Q:max.exe)(HOST=CPU58970)(USER=airton)))(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))’))).
(2eca) nricdt: Calling with outgoing connect data: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))’)))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=Q:max.exe)(HOST=CPU58970)(USER=airton)))).
(2eca) nscall: connecting…
(2eca) nsopen: opening transport…
(2eca) nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=0, nt[2]=0
(2eca) nsopen: unable to open transport
(2eca) nricdt: Call failed.
(2eca) nricdt: Call made to destination.
(2eca) nricdt: Processing address list so continuing.
(2eca) nric2a: Getting local community information
(2eca) nriglp: Looking for local addresses setup by nrigla
(2eca) nriglp: No addresses in the preferred address list
(2eca) nric2a: TNSNAV.ORA is not present. No local communities entry.
(2eca) nrigla: Getting local address information
(2eca) nrigla: Address list being processed.
(2eca) nrigla: Processed all addresses in address list. Failed to make contact.
(2eca) nricie: Result descriptor: 12203,12560,530,0.
(2eca) nricie: Result descriptor: 12203,12560,530,0 from Interchange:
(2eca) nricall: Exiting NRICALL with following termination result: -1.
(2eca) nioqper: error from nricall
(2eca) nioqper: nr err code: 12203
(2eca) nioqper: ns main err code: 12560
(2eca) nioqper: ns (2) err code: 0
(2eca) nioqper: nt main err code: 530
(2eca) nioqper: nt (2) err code: 0
(2eca) nioqper: nt OS err code: 0
(2eca) niqme: reporting nr (1) error: (12203) as rdbms err (12203)
(2eca) niotns: Couldn’t connect, returning 12203
nigtrm: Count in the NI global area is now 0
nigtrm: Count in the NL global area is now 0
Será que é possível ter uma idéia do problema? A conexão via PL/SQL Developer esta funcionando corretamente assim como os demais sistemas.
Obrigado.
Airton