oracle can not startup,why?

[lesni_1]

[/app/oracle/product/8.1.6/bin$]./dbstart

SQL*Plus: Release 8.1.6.0.0 - Production on Sun Jul 25 18:09:34 2004

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area 164018904 bytes
Fixed Size 96984 bytes
Variable Size 78389248 bytes
Database Buffers 83886080 bytes
Redo Buffers 1646592 bytes
ORA-00205: error in identifying controlfile, check alert log for more info


SQL> Disconnected

Database "ccora" warm started.
8.1
/app/oracle/product/8.1.6
ccora
/app/oracle/product/8.1.6/dbs/initccora.ora

[lesni_1]

and when I shutdown:

[/app/oracle/product/8.1.6/bin$]./dbshut

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.0.0, 64 bit - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SVRMGR> Connected.
SVRMGR> ORA-01507: database not mounted
ORACLE instance shut down.
SVRMGR>
Server Manager complete.
Database "ccora" shut down.

[Victor Fridyev]

Hi,
First of all, check whether all volume groups are activated. Run:
vgdisplay
If everything is OK, check where control files were built and verify that the file system where control files are located is mounted.

HTH

[Jan Sladky]

hi,
if all is mounted, check whether control files exist, destination you can get from pfile or spfile

if you are using pfile

cat $ORACLE_HOME/dbs/initSID.ora

if you are using spfile

cat $ORACLE_HOME/dbs/spfileSID.ora

br Jan

[Hein van den Heuvel]

>> ORA-00205: error in identifying controlfile, check alert log for more info


Oracle means every word of that.


1) It has trouble reading the control file
2) Check the alert log.


2) Did you check the alert log?
Care to share the detailed message from there?

1) My approach to this kind of error is to 'play Oracle'. What does it have to do to start the DB. Well...
First it needs to know whcih DB, but translating ORACLE_SID. So check $ORACLE_SID. Is it what you expect?
Next it will open teh parameter file. In there it will find the control file pointer, and in the control file it will find the database files.
So... find the control file:

echo $ORACLE_HOME

ls $ORACLE_HOME/dbs/*$ORACLE_SID

grep control $ORACLE_HOME/dbs/*$ORACLE_SID

Now carefully look at the file specs returned.

Try an ls -l on those files.
Try cp to /dev/null for those files.

Try to explain any failure in the steps above and you will have found the core problem. Now try to fix that :-).

Hein.

[Jan Sladky]

sorry,
foir spfile use strings instead off cat

strings $ORACLE_HOME/dbs/spfileSID.ora

br Jan

[Indira Aramandla]

Hi Lesni,

When you try to start the oracle database, and it errors saying
ORA-00205: error in identifying controlfile, check alert log for more info,

means that the control files specified in the init.ora file are not foung in the location.

Check for the following. View the init.ora file and look for the controlfile entry. This will specify the name and location of the control file.

Then look in the directory to see if the control files exists.

The physical file location and name are same as the one specified in the init.ora file then try to start the database. Otherwise correct the location and names in the init.ora file save the file. I assuem that you are using oracel 8.1.6 release and so there will not be an spfile. This only exists for oracle release from 9i on wards.


I hope this helps

Indira A

[uadm26]

Thanks all,

I change the semmni to 600 (400) and semmns to 1200 (600) (semmni*2), and works well.