This discussion is archived
1 2 Previous Next 22 Replies Latest reply: Dec 8, 2012 11:04 PM by anappsdba RSS

Invalid objects in APPS schema after import. autoconfig failing.

anappsdba Newbie
Currently Being Moderated
Hello everyone !

The env is as follows:

os - RHEL 5 - 64-bit
database - 11.1.0.7
apps - r12.1.3

The distribution of invalid objects is as given below:

OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
DMSYS VIEW 1
TNE_APPS PACKAGE BODY 1
DMSYS PACKAGE 1
SYSTEM PACKAGE BODY 2
APPS PROCEDURE 2
OWAPUB PACKAGE BODY 3
DEV SYNONYM 13
APPS PACKAGE 13
APPS VIEW 13
DMSYS PACKAGE BODY 17
APPS TRIGGER 19
ODM JAVA CLASS 264
PUBLIC SYNONYM 265
APPS JAVA CLASS 578
APPS PACKAGE BODY 936

Just want to know what could be the reason they have become invalid. We had lost our databas instance due to redolog corruption, opened the db with allowresetlogs_corruption, took full export and did full import into new db. Now these objects are from the new db.

Regards.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points