Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

mdsys objects invalid after 11g2 upgrade from 10.2

edited Sep 11, 2013 9:05AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered


We are using datapump export/import to upgrade an oracle 10.2.0.1.0 32 bit db of character set WE8ISO8859P1 on windows to oracle 11.2.0.1 64 bit db of character set al32utf8
all the data we need is in one schema (pvm)

I created the oracle 11g db 
I created the needed tablespaces, roles, and schema in the 11g db.
I then performed a datapump import of the pvm schema only.
Went smooth.
I recompile invalid objects and all compiles clean.

I then run catupgrd.sql (because I think I need to do this when converting from 32 bit to 64 bit word size, but correct me if I am mistaken please).  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center