Home » RDBMS Server » Server Administration » INVALID satus in dba_registry (oracle 11.2.0.3 on linux)
INVALID satus in dba_registry [message #586607] Sat, 08 June 2013 00:47 Go to next message
vivek_k47
Messages: 14
Registered: August 2012
Location: india
Junior Member
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.
  • Attachment: dba reg.jpg
    (Size: 45.74KB, Downloaded 29 times)
Re: INVALID satus in dba_registry [message #586608 is a reply to message #586607] Sat, 08 June 2013 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 57609
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/
No need to attach an image to post text, just copy and paste it inline
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

2/
Use "Col" statement to format the columns.
Use "Set pagesize 1000" to prevent from useless repeated headers

3/
Use WHERE clause to limit the output to the useful lines and don't pollute the post with useless information

4/
Do you use the INVALID components (but the last one)?
If not then deinstall them. You'll find the script in %ORACLE_HOME%\rdbsm\admin and the details on MOS.
If yes the deinstall and reinstall them.

5/
In the end, use utlrp.sql to recompile the invalid packages (last line).

Regards
Michel

[Edit: typo]

[Updated on: Sat, 08 June 2013 01:45]

Report message to a moderator

Re: INVALID satus in dba_registry [message #586609 is a reply to message #586608] Sat, 08 June 2013 01:40 Go to previous message
vivek_k47
Messages: 14
Registered: August 2012
Location: india
Junior Member
Thanks.Will keep that in mind.
Previous Topic: SGA SIZE (Increase shared pool)
Next Topic: Value of sga_target too small
Goto Forum:
  


Current Time: Fri Apr 18 08:48:56 CDT 2014

Total time taken to generate the page: 0.06437 seconds