From: Geordie Henderson <u2d2@removethis.ugrad.cs.ubc.ca>
Subject: Re: PO 8 i  INSTALL PROBLEM
Date: 2000/06/06
Message-ID: <393CC799.F1E441C7@removethis.ugrad.cs.ubc.ca>#1/1
Content-Transfer-Encoding: 7bit
References: <vE0%4.6954$ep.148368@news.siol.net>
X-Accept-Language: en,fr
Content-Type: text/plain; charset=x-user-defined
X-Complaints-To: abuse@interchange.ubc.ca
X-Trace: nntp.itservices.ubc.ca 960284295 5326 24.113.228.6 (6 Jun 2000 09:38:15 GMT)
Organization: On a good day, maybe
Mime-Version: 1.0
Reply-To: u2d2@removethis.ugrad.cs.ubc.ca
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools


I've been down that road and it's pretty frustrating so let me see if I can
help.  ORA-1034 usually means that your database *instance* is not started.  The
database instance is the set of processes that need to be running in order to
use databases.

What you need to do is connect to the the server manager and start the
instance.  You can only do this, however, when you connect to the instance
manager as sysdba or maybe sysoper.  Most official Oracle documentation that
I've read neglects to mention this last fact about how you have to connect AS
SYSDBA but it's vital!  On Solaris this is done using the database user account
and typing the following commands:

>svrmgrl   

// this gets you to the SVRMGRL> prompt
// now type

SVRMGRL> connect as SYSDBA

// enter the username and password for which you are prompted (use the SYS user)

SVRMGRL> startup OPEN insert-your-SID-here

This starts the instance.  Once the instance is up you should be able to use all
of the database tools.  I don't know how this parallel operation is accomplished
in Windows but I imagine there is a similar set of commands available from the
DOS prompt in \orant\bin or perhaps some distracting GUI that abstracts what's
really going on away from the user.
  
Geordie 


Aleksander wrote:
> 
> Please help,
> I downloaded a PO 8 i and installed on my pc with win 98, 128mb ram.
> Installation goes fine, but when I start a database, I get a message :
>     ORA - 01034 ORACLE NOT AVAILABLE
> 
> What ever I do, I can't start ORACLE!
> What must I do ?
> Aleksander


