Skip to Content
avatar image
Former Member

Invalid Objects in oracle upgrade 12.1.0.2

Dear All,

We have executed the @pre_upgrade_checks.sql before upgrading the database from 11.2.0.4.to 12.1.0.2. We have found around 80 invalid objects. Output of the pre_upgrade_checks.sql is as below

**********************************************************************

Invalid Objects

**********************************************************************

WARNING: ----> INVALID_OBJECTS

WARNING: ----> Invalid Objects in a schema (not SAP, not SYS)

.... USER SYSTEM has 54 INVALID object(s).

.... USER NELITO has 25 INVALID object(s).

.... USER TCLFI has 1 INVALID object(s).

Number of invalid objects based on SYS.DBA_OBJECTS

Number of invalid objects (SYS): 0

Number of invalid objects (SAP): 0

Number of invalid objects (all): 80

Number of invalid objects (SYS)    : 26( from SYS.registry$sys_inv_objs)

Number of invalid objects (non-SYS): 0( from SYS.registry$nonsys_inv_objs)

Note: a value of -1 indicates that the respective table does not exist.

We have also run the /oracle/cfgtoollogs/<SID>/preupgrade/preupgrade_fixups.sql and $ORACLE_HOME/rdbms/admin/utlrp.sql. But the number of invalid objects remained same. 

We also tried to compile objects manually with below command

SQL> ALTER VIEW NELITO.VW_OVERHEAD_MTHLY COMPILE;

Warning: View altered with compilation errors.

SQL>show error

no error

Please help on above issue.

Regards

Bhargav Bhatt

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 29, 2016 at 12:23 PM

    Hello

    The DB should be dedicated to SAP usage... and obviously here you have 3rd party applications using it (user / schema for NETLITO & TCLFI)

    Focus on the system objects, and warn you customer about this unsupported usage of the DB.

    I hope they are note using an ASFU license for Oracle, because in that scenario hosting 3rd party application in the Oracle DB is a license violation.

    Best regards

    581312 - Oracle database: Licensing restrictions

    If you use other software (for reporting, for example, or external tools to create automatic SAP system copies), then the following actions at the database level - among others - are not allowed:

    • Creating database users
    Add comment
    10|10000 characters needed characters exceeded