Re: Oracle databases not starting

Sybrand, first thanks for your help.

As for the ORACLE_SID dos env var, I would assume any dos env vars that Oracle needs it would set up in the installation process?

I will try the trace stuff.

Apologies for the basic questions, I am not an Oracle DBA, but just installing it so that I can use the database with WebLogic J2EE.

Many thanks
PS I have also posted a clearer definition of the symptoms.

Sybrand Bakker wrote:

> 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 Sun May 06 2001 - 02:41:39 CDT