Tweet
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>
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>