analyze on each object to check is the are corrupted

SQL>Connect / as sysdba

SQL>oradebug setmypid
SQL>oradebug unlimit
SQL>@$ORACLE_HOME/rdbms/admin/utlvalid.sql

-- By running utlvalid.sql (if not exist, a table named invalid_row will be created and that is needed to run
-- Analyze on partition table as below syntax show.
-- You might get ora-955 if the invalid table already exist, ignore it and continue with the Analyze command.

For Index:

SQL>Analyze Index <Owner>.<Index_name> Validate Structure Online;

For Parition/Subpartition Index:

SQL> analyze Index <Owner>.<Index_name> partition (<partition_name>) validate structure online;
SQL> analyze Index <Owner>.<Index_name> subpartition (<subpartition_name>) validate structure online;


For Cluster:

SQL>Analyze Cluster <Owner>.<Cluster_name> validate structure cascade;

For non-partition table

SQL>Analyze Table <OWNER>.<TABLE_NAME> Validate Structure Cascade Online;

SQL>Analyze Table <OWNER>.<TABLE_NAME> Validate Structure Online;



For Partition table
SQL> Analyze table <OWNER>.<TABLE_NAME> partition (<partition_name>) validate structure cascade Online into invalid_rows;

SQL> Analyze table <OWNER>.<TABLE_NAME> validate structure cascade Online into invalid_rows;




SQL> oradebug tracefile_name
This last command will tell the name of the trace and its location.
Please send us the trace.


Upload following trace file

/oracle/pc52c/diag/rdbms/pc52c/pc52c/trace/pc52c_ora_5561.trc: