OCP Blog
Super DBA
Problem During Installation Patch Set 10.2.0.4, PL/SQL: ORA-00904: "OTHER_XML": invalid identifier
by Vazha Mantua Sunday, September 18, 2011 2:49 PM

Good Day All,

 

 

 

After applying Patch Set 10.2.0.4 on Oracle RDBMS we discover that one of component was not updated correctly.Please see below:

 

Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:19:27
Oracle XDK VALID 10.2.0.4.0 00:00:00
Oracle Workspace Manager VALID 10.2.0.4.3 00:01:22
Oracle Expression Filter VALID 10.2.0.4.0 00:00:16

 

In Installation Log file we found error PL/SQL: ORA-00904: "OTHER_XML": invalid identifier, while compiling package dbms_sqlpa.

In this post we will provide us how can you fix this problem.It’s very simple:

SQL>sqlplus / as sysdba
SQL>drop table plan_table;
SQL>@?/rdbms/admin/utlxplan
SQL>@?/rdbms/admin/prvtspao.plb
SQL>@?/rdbms/admin/utlrp.sql

Tags: ,

Comments (4) -

1/7/2012 5:00:57 PM #

Orya Jan

Thank you so very muchf!

Orya Jan United States

1/14/2012 2:27:03 PM #

Villas for Rent in Italy

Great source of information and this is master piece of article thank you so very much for sharing such a nice post.

Villas for Rent in Italy United States

3/30/2012 11:06:53 AM #

network installation new york

This post is exact reflection of how I would express my views on the same. Thank for this absolutely amazing and explanatory posts.

network installation new york United States

4/4/2012 6:00:17 PM #

paul mitchell hair products

A very insightful post that brings out the crux of the topic beautifully. Thanks a lot for the post.

paul mitchell hair products United Kingdom

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar

TextBox