This forum is currently locked. You can't register or post questions at this time. (read more)

dba_registry shows invalid enries

All posts relating to Oracle database administration.

Moderator: Tim...

vivek_k47
Member
Posts: 27
Joined: Sun Aug 05, 2012 11:45 am

dba_registry shows invalid enries

Postby vivek_k47 » Sat Jun 08, 2013 5:30 am

Hi,
When i run the command:
select comp_name,version,status from dba_registry;
some of the items show the status as INVALID.(Oracle database packages and types,oracle rules manager,oracle workspace manager,oracle expression filter,oracle multimedia)

What is the reason for this and how can i set them to VALID.
Thanks.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: dba_registry shows invalid enries

Postby Tim... » Sat Jun 08, 2013 7:32 am

Hi.

This can happen during upgrades and patches. Especially if you have not followed the full path.

1) Make sure everything in your installation is valid. You can do this using the "$ORACLE_HOME/rdbms/admin/utlrp.sql" script. It is discussed here:

http://www.oracle-base.com/articles/mis ... bjects.php

Check for invalid objects.

http://www.oracle-base.com/dba/script.p ... bjects.sql

If anything is invalid, investigate and fix it. For example, if it is a procedure, do:

Code: Select all

ALTER PROCEDURE my_proc COMPILE;
SHOW ERRORS


This will tell you why it fails to compile, so you can investigate and fix the issues.

2) Once everything is compiled, and working as normal, you can force the registry to say a different value, as discussed here:

https://forums.oracle.com/forums/thread ... dID=896665

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests

cron