Announcement

Collapse
No announcement yet.

Problems with OTM 5.5 CU5-RU3

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problems with OTM 5.5 CU5-RU3

    We have some problems with installing RU3 for CU5.
    We want to have the possiblity to use the features in Metalink patch 7376912 (multiple row selection). This is included from RU1 and we have installed RU3. It worked to install in our first test region but in the other it fails.
    We get the following error:

    SQL> @recompile_invalid_objects;
    APP_SERVER ORA-00054: resource busy and acquire with NOWAIT specified
    ORA-06512: at "GLOGOWNER.CHECKC", line
    19
    ORA-02264: name already used by an existing constraint
    EXTERNAL_SYSTEM ORA-00054: resource busy and acquire with NOWAIT specified
    ORA-06512: at "GLOGOWNER.CHECKC",
    line 19
    ORA-02264: name already used by an existing constraint
    CONTACT ORA-00054: resource busy and acquire with NOWAIT specified
    ORA-06512: at "GLOGOWNER.CHECKC", line
    19
    ORA-02264: name already used by an existing constraint
    Error adding check constraint on I_TRANSMISSION.RUN_NEW_DOMAIN
    I_TRANSMISSION ORA-00054: resource busy and acquire with NOWAIT specified
    patch7130600
    patch7293994
    ORA-00054: resource busy and acquire with NOWAIT specified Index: IX_TRSMSN_COMMTD_GID Table: I_TRANSMISSION
    ORA-00054: resource busy and acquire with NOWAIT specified Index: IND_ITRANSMISSION_STATUS Table:
    I_TRANSMISSION
    ORA-00054: resource busy and acquire with NOWAIT specified Index: IX_TRSMSN_EXTSYS_GID Table: I_TRANSMISSION
    ORA-00054: resource busy and acquire with NOWAIT specified Index: IND_ITRANM_CREATE_DATE Table:
    I_TRANSMISSION
    ORA-00054: resource busy and acquire with NOWAIT specified Index: IX_IT_APP_MACHINE_GID Table:
    I_TRANSMISSION
    ORA-00054: resource busy and acquire with NOWAIT specified Index: IX_IT_APP_SERVER_GID Table: I_TRANSMISSION
    ORA-00054: resource busy and acquire with NOWAIT specified Index: IX_IT_CONTACT_GID Table: I_TRANSMISSION
    ORA-00054: resource busy and acquire with NOWAIT specified Index: IX_IT_EXT_SYS_COM_METHOD_GID Table:
    I_TRANSMISSION
    ORA-24344: success with compilation error
    ORA-24344: success with compilation error

    List of first 50 Invalid objects after recompile.
    ================================================
    VPD PACKAGE BODY
    PKG_PURGE PACKAGE BODY
    Errors for PACKAGE BODY PKG_PURGE:
    1339/4 PL/SQL: SQL Statement ignored
    1339/43 PL/SQL: ORA-00942: table or view does not exist
    1910/29 PL/SQL: ORA-00942: table or view does not exist
    1910/5 PL/SQL: SQL Statement ignored
    1913/5 PL/SQL: SQL Statement ignored
    1913/61 PL/SQL: ORA-00942: table or view does not exist
    1921/8 PLS-00364: loop index variable 'JOB_PARAM_REC' use is invalid
    1938/7 PLS-00364: loop index variable 'SO_JOB_REC' use is invalid
    1950/15 PLS-00364: loop index variable 'SO_JOB_REC' use is invalid

    Errors for PACKAGE BODY VPD:
    1007/2 PL/SQL: SQL Statement ignored
    1007/32 PL/SQL: ORA-00942: table or view does not exist
    1018/36 PLS-00364: loop index variable 'CREC' use is invalid
    969/2 PL/SQL: SQL Statement ignored
    969/32 PL/SQL: ORA-00942: table or view does not exist
    981/34 PLS-00364: loop index variable 'CREC' use is invalid


    Invalid objects before Recompile....
    14
    Invalid objects after Recompile....
    2


    Some objects have compiled successfully.

    Please re-run recompile_invalid_objects to compile the rest of invalid objects.
    SQL> @recompile_invalid_objects;
    ORA-24344: success with compilation error
    ORA-24344: success with compilation error

    List of first 50 Invalid objects after recompile.
    ================================================
    VPD PACKAGE BODY
    PKG_PURGE PACKAGE BODY
    Errors for PACKAGE BODY PKG_PURGE:
    1339/4 PL/SQL: SQL Statement ignored
    1339/43 PL/SQL: ORA-00942: table or view does not exist
    1910/29 PL/SQL: ORA-00942: table or view does not exist
    1910/5 PL/SQL: SQL Statement ignored
    1913/5 PL/SQL: SQL Statement ignored
    1913/61 PL/SQL: ORA-00942: table or view does not exist
    1921/8 PLS-00364: loop index variable 'JOB_PARAM_REC' use is invalid
    1938/7 PLS-00364: loop index variable 'SO_JOB_REC' use is invalid
    1950/15 PLS-00364: loop index variable 'SO_JOB_REC' use is invalid

    Errors for PACKAGE BODY VPD:
    1007/2 PL/SQL: SQL Statement ignored
    1007/32 PL/SQL: ORA-00942: table or view does not exist
    1018/36 PLS-00364: loop index variable 'CREC' use is invalid
    969/2 PL/SQL: SQL Statement ignored
    969/32 PL/SQL: ORA-00942: table or view does not exist
    981/34 PLS-00364: loop index variable 'CREC' use is invalid


    Invalid objects before Recompile....
    2
    Invalid objects after Recompile....
    2


    The number of invalid objects is still the same after recompile.

    Please analyze the existing invalid objects.
    SQL>
Working...
X