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

Hi There,

I admit to being a bit confused by all this.

Why precisely did you run the catalog.sql and catproc.sql scripts ? They're usually run after the database is created. If the database was working fine, why did you rerun them ?

Also the sequence at the end of your post seems a little weird. You first run catalog.sql, then create the database , then run catproc.sql.

Am I missing something here ?

Richard
"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 - 04:18:28 CDT