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: ,

Filter by APML

Calendar

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

View posts in large calendar

TextBox