Re: Rebuild an instance

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. Received on Fri Nov 17 2006 - 18:50:03 CST