Re: ORA-04045: catalog.sql and catproc.sql damaged my db.

do u mean i can recover my db by following these steps? step

1.ALTER SYSTEM SET _SYSTEM_TRIG_ENABLED='FALSE'
2.run catalog.sql, catproc.sql
3.ALTER SYSTEM SET _SYSTEM_TRIG_ENABLED='true'

by the way, i am using 9i, do i need catalog.sql and catproc.sql?

i'm sorry for my mistake. the create statement in my.sql should like this:

CREATE tablespace myTBS -- but not CREATE database myDB.... (
...
)

any idea for my script?
does the following sequence make sense:

1.run catalog.sql
2.create tablespace
3.run catproc.sql

***my.sql***

connect sys/change_on_install_at_orcl as sysdba

@/opt/oracle/rdbms/admin/catalog.sql

connect sys/change_on_install_at_orcl as sysdba

CREATE tablespace myTBS
(
...
)

@/opt/oracle/rdbms/admin/catproc.sql

***my.sql***

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<ak2ljr$ral$1_at_babylon.agtel.net>...
> You should set _system_trig_enabled = false
> (ALTER SYSTEM SET _SYSTEM_TRIG_ENABLED='FALSE')
> as SYSDBA, then run catalog.sql, catproc.sql and then
> re-enable system triggers by setting _system_trig_enabled=true.
> This parameter should always be set to false before almost any
> object owned by SYS is modified (including Java VM) in 8i and
> later, otherwise you will see errors similar to those you got
> due to system triggers kicking in when they shouldn't. Since
> you're on 9i, you can change this parameter dynamically through
> alter system, on 8i you would have to set it in init.ora and bounce
> the instance, update catalog, reset and bounce again (I love new
> 9i dynamic reconfiguration feature!) Entering restricted session
> while you update catalog wouldn't hurt either.
>
> --
> Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
> All opinions are mine and do not necessarily go in line with those of my employer.
>
>
> "fee pack" <defection_at_163.net> wrote in message
> news:4e732814.0208220048.489d18d6_at_posting.google.com...
> > after running the file my.sql (see below), i encounter some error:
> > when i try to edit the table data, the following error displayed:
> >
> > ORA-04045 ... SYS.DBMS_OUTPUT
> > ORA-06508 ...
> > ORA-06512 ...
> > ORA-06508 ...
> > ORA-06512 ...
> >
> >
> > then i go to the package SYS.DBMS_OUTPUT, the status is "invalid", i
> > try to recompile it, the following error displayed:
> >
> > ORA-04045 ORA-04045: errors during recompilation/revalidation of
> > SYS.CDC_ALTER_CTABLE_BEFORE
> > ORA-06508 ...
> > ORA-06512 ...
> > ORA-06508 ...
> > ORA-06512 ...
> >
> > when i try to compile SYS.CDC_ALTER_CTABLE_BEFORE, the error message
> > displayed:
> > ORA-00604 ...
> > ORA-04045 ...LBACSYS.LBAC_EVENTS
> > ORA-06512 ...
> > ORA-06508 ...
> > ORA-06512 ...
> >
> > when i try to compile LBACSYS.LBAC_EVENTS, the error message
> > displayed:
> > ORA-04045 ORA-04045: errors during recompilation/revalidation of
> > SYS.CDC_ALTER_CTABLE_BEFORE
> > ORA-06508 ...
> > ORA-06512 ...
> > ORA-06508 ...
> > ORA-06512 ...
> >
> >
> > it seems SYS.CDC_ALTER_CTABLE_BEFORE call LBACSYS.LBAC_EVENTS, and
> > latter also call the former --- that is a circle!
> >
> >
> > my db works well before running the file my.sql. it seems the
> > execution of catalog.sql and catproc.sql cause the error. i am using
> > 9i, and the document histories show that the catalog.sql and
> > catproc.sql are last updated in Apr,2001.
> >
> >
> > my questions are:
> > 1.with 9i db, do i need to run the two files?
> > 2.how can i recover my db?(i don't have backup, can i use redoXX.log?)
> >
> >
> > ***my.sql***
> >
> > connect sys/change_on_install_at_orcl as sysdba
> >
> > @/opt/oracle/rdbms/admin/catalog.sql
> >
> >
> > connect sys/change_on_install_at_orcl as sysdba
> >
> >
> > CREATE database mydb
> > (
> > ...
> > )
> >
> > @/opt/oracle/rdbms/admin/catproc.sql
> >
> > ***my.sql***
Received on Thu Aug 22 2002 - 22:11:51 CDT