Thursday, June 9, 2011

Jboss Error - .....Couldn’t clean volatile data: ORA-00376: file 4 cannot be read at this time

Database just suddenly crash and when you try to login to sqlplus to shutdown immediate and then you get the following error:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], []
, [], [], [], [], []


If so, then startup the database. The startup is normal without giving any error but when you startup the jboss it will give an error like below


org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception:  org.quartz.JobPersistenceException: Couldn’t clean volatile data: ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: ‘u01\app\oracle\oradata\ORADB\USERS01.DBF’
[See nested exception: java.sql.SQLException: ORA-00376: file 4 cannot be read at this time
 ORA-01110: data file 4: ‘u01\app\oracle\oradata\ORADB\USERS01.DBF’


Solution


    SQL> recover datafile ‘u01\app\oracle\oradata\ORADB\USERS01.DBF’
    Media recovery complete.
    SQL> alter database datafile ‘u01\app\oracle\oradata\ORADB\USERS01.DBF‘ online;





No comments:

Post a Comment