Home » RDBMS Server » Server Administration » Invalid Objects not compile after upgrade on 8.1.7.4 from 7.3.3 on Oracle Applications 10.7
Invalid Objects not compile after upgrade on 8.1.7.4 from 7.3.3 on Oracle Applications 10.7 [message #54946] Wed, 18 December 2002 00:59 Go to next message
Nadeem Raheem
Messages: 7
Registered: December 2002
Junior Member
We are upgrading Oracle Applications 10.7 to 11.5.7 on Sun SPARC after upgrading database objects are not compiling, we try using adadmin 'compile Apps Schema' and using utlrp.sql script as well but still they are not compile. Does anyone know how to compile these invalid objects?

Report message to a moderator

Re: Invalid Objects not compile after upgrade on 8.1.7.4 from 7.3.3 on Oracle Applications 10.7 [message #54951 is a reply to message #54946] Wed, 18 December 2002 11:40 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you are right.
utlrp.sql is the script to be run.
sometimes, it leaves objects as INVALID.
so, run again the utlrp.sql (logged in as sys) and spool the output to a log file.
check which particular objects are INVALID.
U can investigate further based on that.
some tables might be missing or something like that.!

Report message to a moderator

Previous Topic: Problem in starting oracle ora home81 agent and TNSlistener services
Next Topic: Codd's Rule
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:02:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.