Re: ORA-01092

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Thu, 9 Jan 2003 11:46:06 +0100
Message-ID: <v1qkpmmfrd287@corp.supernews.com>

This is bug 1787295. From Metalink:

<quote>
The bug is fixed in 9.0.2.

Workaround:

---

Disable Resource Manager Plan functionality by removing the line RESOURCE_MANAGER_PLAN = ...
in init.ora.

</quote>

hth,
Peter

"Shravana Kumar" <kumar.shravana_at_blr.spcnl.co.in> schreef in bericht news:3E1C98C2.79F97A33_at_blr.spcnl.co.in...
> The alert log says the following.
>
> ORA-07452: specified resource manager plan does not exist in the data
> dictionaryThu Jan 9 03:29:40 2003
> Error 7452 happened during db open, shutting down database
> USER: terminating instance due to error 7452
> Instance terminated by USER, pid = 11353
>
>
> Best Regards,
> ShravanaKumar.
>
> Shravana Kumar wrote:
>
> > Hi All,
> >
> > we are using oracle 9i on solaris 8.
> >
> > I get the following error when starting up the oracle instance.
> >
> > SQL> startup
> > ORACLE instance started.
> >
> > Total System Global Area 126804664 bytes
> > Fixed Size 434872 bytes
> > Variable Size 104857600 bytes
> > Database Buffers 20971520 bytes
> > Redo Buffers 540672 bytes
> > Database mounted.
> > ORA-01092: ORACLE instance terminated. Disconnection forced
> >
> > Any ideas on resolving this problem....?
> >
> > Best Regards,
> > ShravanaKumar.
>
Received on Thu Jan 09 2003 - 04:46:06 CST