Sometimes you can get ” ORA-00471: DBWR process terminated with error ” error.
Details of error are as follows.
ORA-00471: DBWR process terminated with error
Cause: The database writer process died
Action: Warm start instance
To solve the problem, please execute the following steps:
Reduce the database db_files parameter to reduce file descriptors usage (requires a database restart)
Increase the number of file descriptors value specific to your UNIX kernel ( File descriptor limit is per process.)
set kernel.shmmax to 4G
The latest solution is startup or restart instance again.
Do you want to learn Oracle Database for Beginners, then read the following articles.
1,741 views last month, 1 views today