Skip to main content

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;





Comments

Popular posts from this blog

Setting ORACLE_SID

The  Oracle System ID  ( S ID ) is used to uniquely identify a particular database on a system How to set ORACLE_SID: Windows: set ORACLE_SID=orcl Unix/ Linux: export ORACLE_SID=orcl SID is case sensitive in Unix / Linux environments. How to check the current ORACLE_SID: Windows: Go to the commnand prompt and type as C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set). C:\> set (To know all the parameters set) Unix/ Linux: echo $ORACLE_SID