unable to start database

[Former Member]

Hello ,

I am unable to start my database

what could the issue ?

Please provide solution

Regards

Clement

SQL> startup

ORACLE instance started.

Total System Global Area 4710117376 bytes

Fixed Size 2189072 bytes

Variable Size 2365589744 bytes

Database Buffers         2332033024 bytes

Redo Buffers 10305536 bytes

Database mounted.

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

Process ID: 20524

Session ID: 125 Serial number: 5

[Former Member · Accepted solution]

Hallo,

please check alert.log for any other errors appearing at the same time.

Also check the permissions on the oracle file systems (oraarch, sapdata).

Regards,

Thomas.

[Former Member · Accepted solution]

Thomas my man you  saved my life again .Thanks a lot pal .Cheers mate

[Former Member]

Proble could be any of following kindly attach alert.log file

• Server machine crashed
• Your server process was killed at O/S level
• Network problems
• Oracle internal errors / aborts on the server
• Client incorrectly handling multiple connections
• etc.. etc.. etc.. - a lot of possible causes !!

[Former Member]

Hi,

Could you check if any of your filesystem is full, especially /oracle/<SID>/oraarch.

-Renu

[Former Member]

The filesystem is not full as per below

bizdev:bidadm 26> bdf .

Filesystem          kbytes    used   avail %used Mounted on

/dev/oraarchvg/lvol1

                   20971520   71784 19593510    0% /oracle/BID/oraarch

[Former Member]

Could you check the alert log. /oracle/<SID>/saptrace/background

-Renu

[former_member189725]

Check the trace file as well for the process with ID 20524

Also check the timestamp of the trace file.

Regards

Ratnajit