Re: Rebuild an instance

Charles Hooper wrote:
> bobrivers.br_at_gmail.com wrote:
> > Hi,
> >
> > No, oracle stills runnig. In fact I'm able to use other databases.
> >
> > I don't know if I'm using the names accordingly. My oracle has two
> > instances (or databases) running on it. I deleted the files (that ones
> > inside oradata) of one of them.
>
> If I recall correctly, an export (exp) does not export objects owned by
> SYS. You may be missing the DBMS_RULE_ADM package, and possibly a
> couple other packages that live in the SYS schema.
>
> The error: "CREATE ROLE "GLOBAL_AQ_USER_ROLE" IDENTIFIED GLOBALLY "
> _AQ_ indicates that this is related to advanced queuing.
>
> It appears to be blowing up when trying to access the specific
> functions of the DBMS_RULE_ADM package:
> SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE
> SYS.DBMS_RULE_ADM.CREATE_EVALUATI­ON_CONTEXT_OBJ, 'SYS',TRUE);"
>
> http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_rule_a.htm
> The above link describes the DBMS_RULE_ADM package, as it applies to
> Oracle 10.2.
>
> Joel Garry likely knows the name of the SQL script that must be run to
> install the DBMS_RULE_ADM package (sorry, I am not sitting in front of
> a 9i database server). What scripts did you run on the new database
> instance when you created it? Did you see any messages related to
> package STANDARD?
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.

The script that you are looking for is (at least with 10g R2): $ORA_HOME$/RDBMS/ADMIN/dbmsread.sql

This script is called automatically by the catproc.sql, which is one of the first scripts run when a new database instance is created. What you may want to do is either create a new DB catalog by rerunning a couple scripts, or start over with a new database instance.

The scripts that you will need to run in SQLPlus (at least for 10g R2 - maybe someone else can verify for 9i):
catalog.sql
catblock.sql
catproc.sql
catoctk.sql

If that does not help, create a new database instance using Oracle DBCA, and then try an import. You may need to execute oradim -delete -sid first to reuse the old database SID name.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Sat Nov 18 2006 - 07:30:57 CST