Re: ORA-01092

It appears you ran out of space in your SYSTEM tablespace. Resize it or add an extra datafile. Then you can safely rerun catalo.sql and catproc.sql.

Peter

"Shravana Kumar" <kumar.shravana_at_blr.spcnl.co.in> schreef in bericht news:3E1CC204.4FBCE0A6_at_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 Thu Jan 09 2003 - 07:30:09 CST