Re: Oracle databases not starting

From: James Mu <jamesmu_ca_at_yahoo.ca>
Date: Fri, 4 May 2001 17:23:18 +0800
Message-ID: <f6FI6.15538$nC6.1821337@news20.bellglobal.com>

First, you should tell me which version and which platform that you install oracle database. This error often occurs due to the following causes:

1) The protocol adapters might not be installed.
2) The listener/db has not been started
3) Net8 configurations files has not been set properly.
4) Oracle is not installed properly.

James
by the way, do you properly setup the parameter ORALCE_SID?

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 Fri May 04 2001 - 04:23:18 CDT