Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

AWR report problem after cluster node switch.

809288Oct 31 2010 — edited Oct 31 2010

Hello all. I have some strange problem, can any one advice what to do....
I have OracleDB (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 on Solaris x86_64), we have two server nodes and one shared storage attached to them, db is running on node1 and if it dies db will be switched to node2, classic cluster.
Some time ago we tested this switching, so i shut downed db and switch it to node2, and startup it there (oracle_homes are identical), every thing was ok, soo i switched it back to node1. But now i can't run awrrpt.sql or awrinfo.sql, it gives error like this:

Using the report name awrinfo.txt
No errors.
create or replace package body AWRINFO_UTIL as
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
No errors.
ERROR:
ORA-03114: not connected to ORACLE
And in alert log:
ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [509] [] [] []

I tried to drop AWR with catnoawr.sql and recreate it with catawrtb.sql, everything seems to be fine, but still can't run awrrpt.sql or awrinfo.sql, same error.

Any one familiar with such problem ?

Thanks for advice.