Re: Help:AIX/Oracle 8.1.5 "database cannot be mounted"

It's much more likely to be the case that another Instance is running under a different name (ie, a different ORACLE_SID), and that Instance has been directed to use a certain set of control files by an inappropriate init.ora.

If control files were missing, or couldn't be found, you would get an 'unable to identify control file' error message.

The error message, however, is 'unable to mount in exclusive mode', and that simply means another Instance has already mounted that particular control file.

The cure is to find out what other Instances are running, and to select from v$controlfile from each of them to see which one already has a handle on the controlfiles which are now attempting to be used. Then the fix will be to make sure that ORACLE_SID is set correctly for all known Instances.

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"Uwe Schneider" <uwe_at_richard-schneider.de> wrote in message
news:3BC9C544.298A4016_at_richard-schneider.de...


> Alvaro Fuentes wrote:

> >

> > Fellow Oracle'rs:

> >

> > I migrated from a 8.0.5 database to 8.1.5 in an AIX 4.3.3.0 server.

> >

> > The installation of new components, migration and the

> > configuration of Net8 (listener) came as a "Successful".

> >

> > The instance starts OK, but at the end of the ./dbstart, comes with

".......


> > ORA-01102: database cannot be mounted in EXCLUSIVE mode......

> > svgmgr> spool off; "

> >

> > If I do:

> >

> > sql> ALTER DATABASE myinstancename MOUNT

> >

> > will come with the same error-message (ORA-01102).

> >

> > Any pointers about how to track down this problem, any config/init files

to


> > look, or an alternate procedure to mount the database will be greatly

> > appreciated.

> >

>


> Try to start the instance by hand:

>


> $ svrmgrl

> SVRMGRL> connect internal

> SVRMGRL> startup

>


> This will (hopefully) report why the database cannot be mounted.

> Probably one or more of the control files aren't found. Or data files

> are in the wrong locations.

>


> Uwe

>


> --

> Uwe Schneider       | Telefon +49 7244 / 609504

> Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de

> DE-76356 Weingarten | http://www.richard-schneider.de/uwe

> Linux - OS al dente!