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

First, the question: Why did you want to run my.sql? any particular reason?

In your script:  

 CREATE database mydb
 (
 ...
 )

This will try to create an database (which I am assuming you already has). It might screw up what we had. I would suggest you to restore your backup copy. Also always test all the scripts on your dev system before applying to the production system.

Guang

defection_at_163.net (fee pack) wrote in message news:<4e732814.0208221843.3afd92b0_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
>
> _at_/opt/oracle/rdbms/admin/catalog.sql
>
>
> connect sys/change_on_install_at_orcl as sysdba
>
>
> CREATE database mydb
> (
> ...
> )
>
> _at_/opt/oracle/rdbms/admin/catproc.sql
>
> ***my.sql***
Received on Fri Aug 23 2002 - 20:09:50 CEST