SYS.DBMS_SQL

[Naeem]

Hello,
I have problems in exporting a user.
I have following
errorEXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_SQL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 20
ORA-06512: at line 1

I tried to compile the packages, it gives me compilation errors.
I have been asked to execute the following scripts
1. catproc.sql
2.catalog.sql

My DB is production database, is it safe to execute these scripts.
I am not able to dump the base.
Please help me it is urgent.
Naeem

[sambavan]

What is your oracle version and the OS?

Sam

[Zaggy]

$ORACLE_HOME/rdbms/admin/utlrp.sql recompiles all invalid objects and requires standard and DBMS_standard to be valid. This may be a perfect or temp fix, depending on the underlying problem.

[Naeem]

Oracle version is 8.1.7 and the os is Sun solaris.
I am trying with utlrp.sql
Thanks
Naeem

[moff]

Hi,

I think the script mentioned will recompile all the packages. However the error your getting looks like a corruption or the package has not been installed properly.

out of interest...who asked you to re-run the catalog and catproc scripts?

I have run these scripts on a heavily used development/test database with no adverse effects. Do you have (can you take) a full backup before running the scripts?

Cheers

Moff

[Naeem]

Hi Moff,
It is somebody from a consulting company.
They told me that the packages are not properly installed and I have to rerun these packages.
Naeem

[Zamial]

catalog.sql I believe just recreates the data dictionary tables

catproc.sql create some of the necessary procedures installed when installing oracle.

i'm sure its safe to run em again. I never have though.

[moff]

Hi,

I think my previous post was a little unclear in what I was trying to say.

To clarify things....

'The script mentioned will recompile all packages' - I mean the utlrp.sql script.

'I have run these scripts....' I mean the catproc and catalog scipts.

As mentioned before I have run these scripts (catalog and catproc) on a developement/test database with no problems.

Cheers

Moff

[Naeem]

Thanks all of you,
I had executed the catproc.sql it reinstalled all the packages and certain Library.
Thanks for your help
Naeem