1 2 Previous Next 22 Replies Latest reply: Dec 9, 2012 1:04 AM by V. A. Nagpure RSS

    Invalid objects in APPS schema after import. autoconfig failing.

    V. A. Nagpure
      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