Re: Missing ora_control1 ???

Hi,

Oracle could not able to read your control file and failed to mount the database.

Please provide the following information.

Do you have backup of your files or first time creation ? Produciton database or test database ?

sqlplus /nolog
connect /as sysdba
startup nomount pfile=<your pfile location> show parameter control

ls -lrt <Value listed out above under value column>

Pick up the contents available in value column and check whether the file is available or not in OS, If available, please check the file permission.

CASE 1 : If Database was already created and running.

         You have to restore the control file from backup.

CASE 2: If database created newly then you can recreate the controlfile.

         But you have to do it with EXTREME CARE. To recreate the control file

         you must know the datafiles and redolog files location and size.

Please post the message, if you need further help on this.

NOTE : PLEASE DONT DO ANYTHING WITH ASSUMPTION WHICH WILL CAUSE LOSS OF DATA. Rgds
Dhana

<tgagne_at_wide-open-west.com> wrote in message news:<tLednQr7WPuj_RPdRVn-sA_at_wideopenwest.com>...
> Douglas Hawthorne wrote:
>
> ><snip>
> >
> >Tom,
> >
> >Have you checked out the documentation at
> >http://www.dizwell.com/html/9i_-_red_hat_9.html for how to install Oracle 9i
> >on RH9 ?
> >
> >It would appear that you have not created the database as yet. You may also
> >wish to review the instructions in Chapter 2 of the "Oracle 9i Database
> >Administrator's Guide" with emphasis on the dbca utility to automate much of
> >the process as possible.
> >
> >
> >
>
> I thought I had but apparently not well enough. I thought I'd even
> grepped the document. I've installed it four times (I think) already so
> perhaps there's some debris lying around in directories that's
> messing-up subsequent installs. I'll try again tonight.
Received on Thu Apr 29 2004 - 12:03:22 CEST