This content has been marked as final. Show 3 replies
Hi,1 person found this helpful
Try to disable parallelism in the ultrp script.
In the utlrp.sql you see a line like.
If is is more than 0 then the recompilation will happen in parallel. I remember there are some problems when compiling objects in parallel using utlrp.
Hi All ,
This issue is resolved.. I checked on Metalink for a similar solution , it was mentioned to do the following steps :
Did these steps and i ran it again.. its working fine now.. All sys objects have been compiled successfully.
shutdown immediate startup upgrade shutdown immediate startup
Also , i came across this :
Number of Sessions Exceeded During Database Creation While Executing SYS.UTL_RECOMP [ID 749359.1]
I would have tried to increase the number of sessions to a very high value if the above solution had not worked.
Hi SaravananDBA ,
Thanks for your suggestions... luckily i tried the method i described above and it worked.. Incase it would not have , i would have used your suggestions..
Thanks for super quick reply.