Pular para o conteúdo

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

#98178
airoosp
Participante

    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