otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire


Share Oracle Enchancements, Issues and Bugs This forum is for sharing Oracle Enhancements, Issues and Bugs with other members of the OTM SIG Community to gain greater visibility and help push towards a timely resolution.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old March 16th, 2009, 15:04
Junior Member
 
Join Date: Jun 2008
Location: Stockholm, Sweden
Posts: 3
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 2 Times in 2 Posts
Rep Power: 0
Lucas ICA is on a distinguished road
Send a message via MSN to Lucas ICA
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>
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to Lucas ICA For This Useful Post:
chrisplough (May 18th, 2009)
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
JDBC Problems after applying OTM 5.5 CU5 Joe Patton Patches 0 March 30th, 2009 20:10
otmapp55 are having problems starting nkrantz Installation and Upgrades 22 July 24th, 2008 16:00
OTM 5.5 performance problems? Check STATISTICS_LEVEL in database. HughesInNC Database Administration 6 March 6th, 2008 13:25



All times are GMT. The time now is 00:53.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40