Upgrade from 8i to 9i Rel 2

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Thu, 23 Dec 2004 08:24:31 -0400
Message-id: <1A4AC4BAB9C50A42854582B69B08C0340624C4E3@MSGMARBIO05>

The 9i Migration Manual tells us to ensure we don't have a user or role named OUTLN in our database before we upgrade.

I did that.

Then, after running u0801070.sql, I noticed there were half a dozen data dictionary objects that were invalid because... The OUTLN user didn't exist and hadn't been re-created.

I found a Metalink note that included the code in the 8.0.5 upgrade script to recreate the OUTLN user, after that we only had three invalid objects in our SYS schema.

We're wondering now whether we should just NOT drop the OUTLN user before we upgrade our databases, since it isn't re-created by the upgrade script.

So far Oracle's only response has been: "run the RDA", they didn't even tell me whether they had seen this before or not.

Has anyone seen this before? (about OUTLN I mean)

I'll run the RDA on our test server... Sigh If they want us to run the RDA every time, where is there more than one field to fill out when we submit a TAR. Patrice.

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

Received on Thu Dec 23 2004 - 06:22:06 CST