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>


Oh I am sure that the oracle_sid and the database sid I set are the same. One of the first things I thought about.

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

Original text of this message