Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SYS objects invalid just after installation

misterimranSep 3 2015 — edited Sep 3 2015

Dear All,

I hae installed Oracle 11g (11.2.0.4) on Windows Server 2012 Standard. Just after installation I can see that the objects are valid, objects i checked are trigger, procedure, functio & packages.

But as soon as i compile the objects, many of them beome INVALID. I was compiling using TOAD. After that if i try to compile using utlrp.sql, the result is the same.

DBMS_SCHEDULER that is oftenly used in our application, is also INVALID.

Any idea what this is happening and what is the solution. I will be very thankful to you.

Regards, Imran

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2015
Added on Sep 3 2015
11 comments
7,205 views