Re: Ora-12560
From: Greg Gerritsen <Burg_at_shaw.ca>
Date: Mon, 09 Dec 2002 16:49:34 GMT
Message-ID: <3DF4C99E.1080000_at_shaw.ca>
> Are you sure this is the correct file? Look at the timestamp...
> Feb-2002.
> Anyway, some crucial info is missing here; the connecting to
> line should have more info, like client name, program, server name
> and protocol, SID, etc...
> Are you sure you set the sid to the same value as the service?
> You should have an OracleServiceXXXX, where XXXX stands for you SID.
> It may be up to 8 characters in length.
> use: set oracle_sid=XXXX, then do svrmgrl.
> And... make sure the serive is started; that can be cause of these
> weird errors, too.
>
> Grtz, Frank
>
Received on Mon Dec 09 2002 - 17:49:34 CET
Date: Mon, 09 Dec 2002 16:49:34 GMT
Message-ID: <3DF4C99E.1080000_at_shaw.ca>
Greg Gerritsen
Frank wrote:
> Greg Gerritsen wrote:
> <snipped very old info>
>
>> >> >> *********************************************************************** >> Fatal NI connect error 12160, connecting to: >> (LOCAL=NO) >> >> VERSION INFORMATION: >> TNS for 32-bit Windows: Version 8.1.6.0.0 - Production >> Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version >> 8.1.6.0.0 - Production >> Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version >> 8.1.6.0.0 - Production >> Time: 06-FEB-2002 10:04:53 >> Tracing not turned on. >> Tns error struct: >> nr err code: 0 >> ns main err code: -1 >> TNS-4294967Message -1 not found; product=NETWORK; facility=TNS >> >> ns secondary err code: 0 >> nt main err code: 0 >> nt secondary err code: 0 >> nt OS err code: 0 >>
> Are you sure this is the correct file? Look at the timestamp...
> Feb-2002.
> Anyway, some crucial info is missing here; the connecting to
> line should have more info, like client name, program, server name
> and protocol, SID, etc...
> Are you sure you set the sid to the same value as the service?
> You should have an OracleServiceXXXX, where XXXX stands for you SID.
> It may be up to 8 characters in length.
> use: set oracle_sid=XXXX, then do svrmgrl.
> And... make sure the serive is started; that can be cause of these
> weird errors, too.
>
> Grtz, Frank
>
Received on Mon Dec 09 2002 - 17:49:34 CET