Home » RDBMS Server » Server Administration » INVALID Objects (10g, 2, Windows2003 Server)
INVALID Objects [message #446065] Fri, 05 March 2010 06:20 Go to next message
oracleraj
Messages: 13
Registered: November 2009
Junior Member
SQL> select OBJECT_NAME, OBJECT_TYPE, STATUS from user_objects where status = 'INVALID';

OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------- ------------------- -------
GET_MAX_CHECKPOINT FUNCTION INVALID
DBA_LOGMNR_LOG VIEW INVALID
DBA_LOGMNR_SESSION VIEW INVALID
DBMS_LOGMNR_INTERNAL PACKAGE BODY INVALID
LOGMNR_KRVRDLUID3 PROCEDURE INVALID
LOGMNR_KRVRDREPDICT3 PROCEDURE INVALID
DBMS_LOGMNR_FFVTOLOGMNRT PROCEDURE INVALID
LOGMNR_KRVRDA_TEST_APPLY PROCEDURE INVALID
DBMS_LOGMNR_OCTOLOGMNRT PROCEDURE INVALID
DBA_LOGMNR_PURGED_LOG VIEW INVALID
LOGMNR_DICT_CACHE PACKAGE BODY INVALID

OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------- ------------------- -------
DBMS_LOGMNR_SESSION PACKAGE BODY INVALID
LOGSTDBY_LOG VIEW INVALID
DBA_LOGSTDBY_PROGRESS VIEW INVALID
DBA_LOGSTDBY_LOG VIEW INVALID
DBMS_LOGSTDBY PACKAGE BODY INVALID
DBMS_INTERNAL_LOGSTDBY PACKAGE BODY INVALID
DBA_CAPTURE VIEW INVALID
ALL_CAPTURE VIEW INVALID
ALL_CAPTURE_PARAMETERS VIEW INVALID
ALL_CAPTURE_EXTRA_ATTRIBUTES VIEW INVALID
DBA_REGISTERED_ARCHIVED_LOG VIEW INVALID

OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------- ------------------- -------
_ALL_STREAMS_PROCESSES VIEW INVALID
ALL_STREAMS_GLOBAL_RULES VIEW INVALID
ALL_STREAMS_SCHEMA_RULES VIEW INVALID
ALL_STREAMS_TABLE_RULES VIEW INVALID
ALL_STREAMS_MESSAGE_RULES VIEW INVALID
ALL_STREAMS_RULES VIEW INVALID
DBMS_LOGMNR_LOGREP_DICT PACKAGE BODY INVALID
DBMS_STREAMS_ADM_UTL PACKAGE BODY INVALID
DBMS_STREAMS_ADM PACKAGE BODY INVALID
DBMS_CAPTURE_ADM_INTERNAL PACKAGE BODY INVALID
DBMS_CAPTURE_PROCESS PACKAGE BODY INVALID

OBJECT_NAME OBJECT_TYPE STATUS
-------------------------------------------------- ------------------- -------
DBMS_LOGREP_UTIL PACKAGE BODY INVALID

34 rows selected.

How can I make them VALID Objects, I have tried to recompile them but but failed....
Re: INVALID Objects [message #446068 is a reply to message #446065] Fri, 05 March 2010 06:25 Go to previous messageGo to next message
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
Member
Hi,
Can you please post what kind of error you are getting when you try to compile these objects.
The reason of the error might be because the base object of invalid object's might not be correct or might not exists.
You can run $ORACLE_HOME/rdbms/admin/utlrp.sql file to compile the invalid objects of the database and then compare the count of invalid objects.

Regards
Lalit
Re: INVALID Objects [message #446074 is a reply to message #446065] Fri, 05 March 2010 06:31 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
first of all why they are in that invalid state?

What/How you tried?

Its a FAQ.Search Before Posting.

sriram Smile
Re: INVALID Objects [message #446086 is a reply to message #446074] Fri, 05 March 2010 07:10 Go to previous messageGo to next message
oracleraj
Messages: 13
Registered: November 2009
Junior Member
When I do full DB export I get below errors in my log file... the export terminates sussesfully with warnings....message in log file... some one told me because of Invalid objects in DB.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2625
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.system_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGMNR_LOGREP_DICT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGMNR_LOGREP_DICT"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2625
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.system_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGMNR_LOGREP_DICT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGMNR_LOGREP_DICT"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_exp
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2700
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table DEF$_AQCALL 0 rows exported
Re: INVALID Objects [message #446107 is a reply to message #446086] Fri, 05 March 2010 08:34 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

I guess some grants missing. Check Metalink Document 417601.1

-Babu
Re: INVALID Objects [message #446146 is a reply to message #446107] Fri, 05 March 2010 13:28 Go to previous message
John Watson
Messages: 6580
Registered: January 2010
Location: Global Village
Senior Member
I would guess that at some point you upgraded from 9i to 10g. There are many bugs logged in Metalink regarding the upgrade of Streams, and all your invalid objects are related to Streams.
If you aren't using Streams, the errors don't matter - just ignore them.

[Updated on: Fri, 05 March 2010 14:58]

Report message to a moderator

Previous Topic: Drop table issue
Next Topic: Increasing tablespace size
Goto Forum:
  


Current Time: Fri Dec 09 06:13:02 CST 2016

Total time taken to generate the page: 0.15171 seconds