Re: Oracle databases not starting

That would usually mean
(as described in the net8 administrators manual, chapter 'Troubleshooting') add to sqlnet.ora

trace_level_client = 16
trace_unique_client = true
trace_directory_client = <any sensible directory>

and you will get a cli<nn>.trc in aforementioned directory.

However, may be you should check first whether you have either the ORACLE_SID dos env var, or the hkey\local_machine\software\oracle\oracle_sid string var in your registry.

This is a common source of 12560.

Hth,

Sybrand Bakker, Oracle DBA

"Phil McAvity" <Phil_at_at8ball.demon.co.uk> wrote in message news:3AEFBD8D.6A2BD52_at_at8ball.demon.co.uk...
> I have also found this: -
>
> ORA-12560: TNS:protocol adapter error
> Cause: The listener was unable to start a process connecting the user to
> the database server.
>
> Actions:
> Turn on tracing and re-execute the operation.
> Evaluate the contents of the trace file to diagnose the problem.
>
> Some help this is again. What trace file?
>
>
> Phil McAvity wrote:
>
> > All,
> >
> > I had a complete working Oracle installation but noticed a problem when
> > trying to run toad or sqlplus. When I checked the services it showed my
> > database service as in the 'starting' state. I left it for a long time
> > but the state didn't change.
> >
> > I have deinstalled and reinstalled Oracle and even sadly removed the my
> > two databases in an effort to get things working.
> >
> > Having reinstalled Oracle, I get the following when trying to use
> > sqlplus
> >
> > D:\>sqlplus
> >
> > SQL*Plus: Release 8.1.6.0.0 - Production on Wed May 2 08:08:35 2001
> >
> > (c) Copyright 1999 Oracle Corporation. All rights reserved.
> >
> > Enter user-name: system
> > Enter password: password
> > ERROR:
> > ORA-12560: TNS:protocol adapter error
> >
> > Enter user-name:
> >
> > I have no idea what a TNS: protocol adapter error is.
> >
> > Can someone please help. It am keen to be able to resolve these type of
> > problems on my own - could someone recommend a book or series of books?
>
Received on Wed May 02 2001 - 04:08:31 CDT