Re: ORA-01092

From: Shravana Kumar <kumar.shravana_at_blr.spcnl.co.in>
Date: Thu, 09 Jan 2003 05:57:48 +0530
Message-ID: <3E1CC204.4FBCE0A6@blr.spcnl.co.in>

hi ,
thanks a lot. this problem is now solved. But, I have another problem like this..

I have created the database successfully and created the user and indx tablespaces as described in the document.

If i run the scripts to build data dictionary views, I get lot of errors.

    connext sys/password as sysdba
    SQL> @/export/home/oracle/products/9.0.1/rdbms/admin/catalog.sql     SQL> @/export/home/oracle/products/9.0.1/rdbms/admin/catproc.sql

The errors are as follows.
QL> @/export/home/oracle/products/9.0.1/rdbms/admin/catproc.sql from sys.x$kqfvi

         *
ERROR at line 15:
ORA-00604: error occurred at recursive SQL level 1 ORA-01654: unable to extend index SYS.I_COL1 by 25 in tablespace SYSTEM

from sys.obj$ o, sys.error$ e

         *
ERROR at line 10:
ORA-00604: error occurred at recursive SQL level 1 ORA-01654: unable to extend index SYS.I_COL1 by 25 in tablespace SYSTEM

comment on table USER_ERRORS is

                 *

ERROR at line 1:
ORA-00942: table or view does not exist

would be able to help me out here..? thanks a lot.

Best Regards,
ShravanaKumar.

Peter van Rijn wrote:

> 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 Wed Jan 08 2003 - 18:27:48 CST