Re: Newbie - Starting up Oracle in Linux

Bill Bell <billb_at_ti.com> wrote in message news:<3C2B2D83.4030406_at_ti.com>...
> Need help starting up server.
>
> I am using Oracle8i for Linux Starter Kit book. I am trying to get familiar
> with Oracle.
>
> After several attempt I just finished installing Oracle 8.1.7 on Mandrake 8.1.
> Sqlplus was running and I was able to do some queries. I shut down the
> computer and I started it up again and Oracle did not start up. The book says
> the way to start it up is to log in to sqlplus as
>
> sys/oracle as sysdba
>
> and issue the command
>
> STARTUP OPEN
>
> The syntax 'sys/oracle as sysdba' does not appear to be correct.
>
> What is the proper procedure to startup the server? Thanks...

What you have is correct, but you need to add your pfile to the open command.

Your pfile can be found in /data01/oraInventory/admin/fccsdbb/pfile

Change 'data01' and 'fccsdbb' to match *your* installation.

When you call open, call it as:
open pfile = '/data01/oraInventory/admin/fccsdbb/pfile'

A better way altogether is from the commandline enter:

svrmgrl
connect internal
[startup]/[shutdown]
exit

You will need to have set you shell environment variables (for the login of the user) that the book talks about eariler in the chapter.

Happy computing.

//ed Received on Fri Jan 18 2002 - 12:22:35 CST