Re: Ora-12560

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 Thu Dec 05 2002 - 19:26:06 CET