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

<<  December 2018  >>
MoTuWeThFrSaSu
262728293012
3456789
10111213141516
17181920212223
24252627282930
31123456

View posts in large calendar

TextBox