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