RE: URGENT!!! - Inadvertantly ran catalog.sql in an existing database

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 6 Sep 2006 16:54:15 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410508554B86@usahm236.amer.corp.eds.com>

Where you user SYS (sysdba) when you ran catalog? If not you should be able to drop the wrong user owned objects and then fix all public synonyms to point to the correct user, that is, SYS.

Anyway try this:

Drop any should be SYS owned objects owned by any other user shutdown immediate
startup restrict
connect / as sysdba
@catalog
@catproc
@utlrp

-- take a look
-- if OK unrestrict the db or shutdown and startup normal
-- Also note that any direct grants on SYS owned objects to users,

package owners, etc... will likely need to be re-issued right before you run utlrp

Note - I have seen special instructions for dealing with revalidation of STANDARD on metalink that you may want to search for if the above does not work. I think the special instructions were due to a bug that caused package STANDARD to go invalid.

HTH -- Mark D Powell --

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula Stankus Sent: Wednesday, September 06, 2006 4:37 PM To: oracle-l_at_freelists.org
Subject: Re: URGENT!!! - Inadvertantly ran catalog.sql in an existing database

Then I tried to just run standard.

It said it created the package.

Then I tried to run utlirp.sql

It hangs and comes back with messages standard not accessible.

Now my whole machine is hanging.

Is there anyway to cleanup the catalog without recoverying the entire database?

I read that it might be necessary to just have online a large rbs, create standard, run catalog.sql, run catproc.sql and utlirp.sql

Any advice is greatly appreciated. The good thing is this is test but it means contract $$ if we have to loose a day.

sigh....

Get your email and more, right on the new Yahoo.com <http://us.rd.yahoo.com/evt=42973/*http://www.yahoo.com/preview>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 06 2006 - 15:54:15 CDT