Re: ORA-01102 error

From metalink:

Here is the definition for the ORA-01112:  01112, 00000, "media recovery not started"

 // *Cause: An attempt to continue media recovery is being made but media
 // recovery was not started.
 // *Action: None.

 There are a couple of things to look for:

1. Make sure the read/write permissions on the new database are correct.
2. Make sure you have correctly set your SID to point to the new database.
3. Look in the alert<SID>.log for additional errors.

The fact that you have just installed Oracle makes me wonder whether perhaps you were not logged on as Oracle when creating the directory structure or perhaps when creating or FTPing some files.

Daniel A. Morgan

Michael Ivanov wrote:

> I just have installed Oracle 8.1.6 on AIX 4.3.3. But when I shutdown
> database after installation procedure ("shutdown normal" in svrmgrl), I
> can not startup database again yet. I get ORA-01102 error (could not
> mount database in EXCLUSIVE mode) always. I have no other instances
> which use this database exactly.
> How can I check what instances use this database also ?
>
> $ svrmgrl
>
> Oracle Server Manager Release 3.1.6.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Release 8.1.6.0.0 - Production
> JServer Release 8.1.6.0.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup mount
> ORACLE instance started.
> Total System Global Area 109874916 bytes
> Fixed Size 69348 bytes
> Variable Size 76079104 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 172032 bytes
> ORA-01102: cannot mount database in EXCLUSIVE mode
>
> SVRMGR> alter database mount;
> alter database mount
> *
> ORA-01102: cannot mount database in EXCLUSIVE mode
>
> --
>
> Best regards.
>
> Michael Ivanov -
> E-mail: ivanovmj_at_niiefa.spb.su
> phone: +7 812 4627863
> fax: +7 812 4644629
Received on Mon Apr 23 2001 - 23:33:39 CDT