Re: Newbie issue!

"Yousaf" <noway_at_hose.com> wrote in message news:1066686581.968785_at_ananke.eclipse.net.uk...
> Dear all,
>
> I am an Oracle newbie and I have the following issue:
>
> I have installed Oracle 9i R2 on my Red Hat box. But when I run startup
from
> SQL plus I get this:
>
> SQL> startup
> 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
>
> Someone told me that this error occurs when system can't find the control
> file. So I was told to run the CREATE CONTROLFILE which failed too,
because
> there are no data files in the /dbs directory!
>
> I did the following:
>
> SQL> CREATE CONTROLFILE DATABASE "DEFAULT" NORESETLOGS NOARCHIVELOG
> 2 MAXLOGFILES 32
> 3 MAXLOGMEMBERS 2
> 4 MAXDATAFILES 32
> 5 MAXINSTANCES 1
> 6 MAXLOGHISTORY 449
> 7 LOGFILE
> 8 GROUP 1 '/bakup/ora9/product/9.2/dbs/t_log1.f' SIZE 500K,
> 9 GROUP 1 '/bakup/ora9/product/9.2/dbs/t_log2.f' SIZE 500K
> 10 DATAFILE
> 11 '/bakup/ora9/product/9.2/dbs/lkDEFAULT';
> CREATE CONTROLFILE DATABASE "DEFAULT" NORESETLOGS NOARCHIVELOG
> *
> ERROR at line 1:
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01565: error in identifying file

'/bakup/ora9/product/9.2/dbs/lkDEFAULT'
> ORA-27047: unable to read the header block of file
> Linux Error: 92: Protocol not available
> Additional information: 1
>
>
> SQL>
>
>
> Above I have tried lkDEFAULT, ofcourse that is not a datafile but in
> desperation I tried that. How come there is not a single datafile in /dbs
> directory? How do I create one? I have found out from the previous posts
> that without specifying the datafiles in the script I would get the
> datafile not found error. But in my case there are no datafiles to specify
> in the script at all!
>
> Could anyone help me please?
> Regards
> --
> Yousaf
> Linux version 2.4.20-8
> gcc version 3.2.2
> Red Hat 9

ok simple question, did you actually create a database to start with? I am guessing not as you dont seem to have a clue

load up dbca and let it create one for you Received on Mon Oct 20 2003 - 17:32:20 CDT