Tuesday, April 13, 2021

ORA-03113: end-of-file on communication channel

 When you were trying to start the Oracle database, you had the following on your screen.

SQL> STARTUP

ORACLE instance started.


Total System Global Area 6442450944 bytes

Fixed Size                  2938792 bytes

Variable Size            1224738904 bytes

Database Buffers         5200936960 bytes

Redo Buffers               13836288 bytes

ORA-03113: end-of-file on communication channel

Process ID: 13761

Session ID: 237 Serial number: 2961


To fix this problem, first check if it was due to no free memory available for the database. Run the command free -g as the root user.

[root@testMachine]# free -g

              total        used        free      shared  buff/cache   available

Mem:              3           0           2           0           0           2

Swap:             3           3           0


If it is necessary, remove some of the old log files in the directory of  $ORACLE_BASE/diag.

Reboot the linux machine to release the memory occupied by processes.

Restart the database.

-----------------------------------------------------------------------------------------------------------------


If you have ever asked the questions below, you will benefit from reading this book.
What is the meaning of life?
Why do I have to suffer?
How can I have the life I like to have?
How can I be the person I want to be?
How can I have good and harmonious relations with others?

What is the true meaning of spiritual practice?  Check it out here. 

No comments:

Post a Comment