Re: pb starting Oracle 9i on Linux

Beserko <beserkobob_at_yahoo.ca> wrote in message news:<pan.2002.12.31.03.16.54.158865.2834_at_yahoo.ca>...
> When I installed Oracle, I haven't created a database.
> Should I create a database before or after setting those
> "control files" ? What I found in the manual is pretty vague.

Depends which manual. I think there is a wizard in the installer. To do it manually, search for the CREATE DATABASE command in the SQL reference manual. You might get a book that explains how to create a database, to do it right is quite involved, at least the first few times. There may also be a linux/oracle faq floating about. http://oracle9i.freeshell.org/ found in a quick altavista search...

>
> Thanks,
>
> B.
>
> On Mon, 30 Dec 2002 11:03:21 -0500, Rauf Sarwar wrote:
>
> > Beserko <beserkobob_at_yahoo.ca> wrote in message
> > news:<pan.2002.12.30.06.21.41.788552.4447_at_yahoo.ca>...
> >> Hi,
> >>
> >> I recently installed Oracle 9i on Linux. Everything went fine, but,
> >> when I tried to start the database this message showed up :
> >>
> >>
> >> [oracle_at_Rodan oracle]$ sqlplus /nolog
> >>
> >> SQL*Plus: Release 9.2.0.1.0 - Production on Lu Dec 30 01:16:16 2002
> >>
> >> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> >>
> >> SQL> connect / as sysdba
> >> Connected to an idle instance.
> >> SQL> startup pfile=/opt/oracle/product/9.2.0/dbs/init.ora ORACLE
> >> instance started.
> >>
> >> Total System Global Area 42741800 bytes Fixed Size 450600 bytes
> >> Variable Size 41943040 bytes Database Buffers
> >> 204800 bytes Redo Buffers 143360 bytes
> >> ORA-00205: error in identifying controlfile, check alert log for more
> >> info
> >>
> >>
> >> SQL>
> >>
> >> What's the problem ? I searched on the net, but I haven't found
> >> anything useful.
> >>
> >> Thanks,
> >>
> >> B.
> >
> >
> > Check that the proper control filename is referenced in the
> > CONTROL_FILES initialization parameter in the init.ora file and try
> > again.
> >
> > Regards
> > /Rauf Sarwar

jg

--
@home is bogus.
'You think you're a leader? Well, now. If you go marching down the
street, and no one is following you, you aren't a leader. You're just
taking a stroll.' - some Pastor