Hi,
I found database down.When i checked in alert log i found some errors.
ORA-1092 : opitsk aborting process
Fri Jul 11 11:27:41 2014
Error occured while spawning process m001; error = 2097
Fri Jul 11 11:27:41 2014
ORA-1092 : opiodr aborting process unknown ospid (13452_47006397374928)
Fri Jul 11 11:27:41 2014
ORA-1092 : opiodr aborting process unknown ospid (22359_46998378852816)
Fri Jul 11 11:27:41 2014
ORA-1092 : opiodr aborting process unknown ospid (22281_47883182965200)
Fri Jul 11 11:27:41 2014
ORA-1092 : opitsk aborting process
Fri Jul 11 11:27:41 2014
ORA-1092 : opiodr aborting process unknown ospid (24813_47427205538256)
Fri Jul 11 11:27:41 2014
ORA-1092 : opiodr aborting process unknown ospid (1109_47358283338192)
Fri Jul 11 11:27:41 2014
ORA-1092 : opiodr aborting process unknown ospid (24715_47645794148816)
Fri Jul 11 11:27:41 2014
ORA-1092 : opiodr aborting process unknown ospid (30327_47942272070096)
Fri Jul 11 11:27:41 2014
ORA-1092 : opitsk aborting process
Fri Jul 11 11:27:41 2014
ORA-1092 : opitsk aborting process
Fri Jul 11 11:27:41 2014
ORA-1092 : opitsk aborting process
Fri Jul 11 11:27:41 2014
ORA-1092 : opitsk aborting process
Fri Jul 11 11:27:41 2014
ORA-1092 : opiodr aborting process unknown ospid (3848_46986342765008)
Fri Jul 11 11:27:41 2014
ORA-1092 : opiodr aborting process unknown ospid (32496_46941510586832)
Note : -Database was down for 3 hours and running fine now.
Also in the related trace file i found the following error.
ORA-02097: parameter cannot be modified because specified value is invalid
Could you tell me what is root cause of this error and how to avoid it in future?
Regards,
Srini
[Updated on: Fri, 11 July 2014 11:31]
Report message to a moderator