Skip to Main Content
Forums

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!

ORA-13516:AWR Operation failed:Catproc not valid

847140Jun 27 2013 — edited Aug 15 2013

HI

I got the below error while installing Oracle 11.2.0.2.0 in linux server (2.6.18-262.el5)

ORA-13516:AWR Operation failed:Catproc not valid

ORA-06512: at 'SYS.DBMS_SWRF_INTERNAL",line 206

ORA-06512: at 'SYS.DBMS_SWRF_INTERNAL",line 239

ORA-06512: at line 1

can u please help me to fix this issue.

Thanking you

Comments

SH_INT
Answer

You need to look in the tPOVPartition table (which is the FDM table that stores all the location related information). There is a field in this table which tells you the numer of the tDataSeg table used by each location

Marked as Answer by user17 · Sep 27 2020
1 person found this helpful
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 12 2013
Added on Jun 27 2013
#general-database-discussions, #not
14 comments
7,056 views