Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Kerry_1
Contributor

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

Dear All
I've installed Oracle9iAS on my HP-UX11i.Then I began to install needed patches from 9ias_patch CDROM. During the installation of 9.0.1.3 patch set and AQ one-off patch on Infrastructure Machine, according to the corresponding guide I attempted to start Infastructure Data Base using the following commands:
$sqlplus
Enter user-name: / as sysdba
Connect to an idle instance.
SQL>startup
Oracle instance started
Total System Global Area 571396368 bytes
Fixed size 438544 bytes
Variable Size 419430400 bytes
Database Buffers 150994944 bytes
RedoBuffers 532480 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
SQL>
What is the cause of my mistake?
Thanks
Kerry
3 REPLIES
T G Manikandan
Honored Contributor

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


1.what is the value of shared memory shmmax parameter.

2.Are the files owned by oracle user.
check the permission of all the database files whether the ownership is oracle?


Look out for messages in the alert_log file of the database.
This can find out the cause.
Revert back


Thanks
Cheryl Griffin
Honored Contributor

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

See Oracle's site for an explanation http://www.oracle-error.com/ora-03113.htm

Other sites such as the following
http://www.orafaq.com/msgboard/replication/messages/121.htm

Suggest
"Please increase shared pool area to the maximum in $ORACLE_HOME/dbs/initdw.ora"

Cheryl
"Downtime is a Crime."
uri_1
Advisor

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

Increase semmni or decrease the number of concurent oracle users in the init.ora file.