48227, 00000, "Invalid Relation File - [%s] [%s] [%s] [%s]"

From: Chris <romanisgod_at_gmail.com>
Date: Mon, 31 Aug 2009 06:01:29 -0700 (PDT)
Message-ID: <c7ce8037-05c1-46b2-bebb-b4ff162326e7_at_z34g2000vbl.googlegroups.com>

Here is the solution for anyone out there, took me time and $$$ to finally find a fix to this problem. Let information be free!

Oracle v 9g/ 10g/ 11g:


--Recreate the AMS relations

To recreate the AMS relations in the ADR repository, please take a backup of the cur
rent directory /home/oracle/oracle/diag and then remove it:

rm -rf /home/oracle/oracle/diag

It can be done with the database OPEN.

Once the directory is removed, connect to sqlplus and the directory will be recreated automatically:

sqlplus '/ as sysdba'


This will recreate the Directory which is reported to be corrupt Received on Mon Aug 31 2009 - 08:01:29 CDT

Original text of this message