Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-03113:end-of-file on communication channel (Oracle9iAS)

Kerry_1
Contributor

ORA-03113:end-of-file on communication channel (Oracle9iAS)

Dear All
Thanks a lot for your answers for my previous question about the error "ORA-03113:end-of-file on communication channel" during my attempt to start Infrastucture data base of Oracle9iAS. Some of you recommend me to increase the value of shmmax kernel parameter to the maximum and accordingly the shared_pool_size parameter in my $ORACLE_HOME/dbs/initdw.ora.
The RAM of my server is 1GB. So I set the value of shmmax to 268435456. And Universal Installer sets the value of shared_pool_size during creation of Infrastructure DB in $ORACLE_HOME/dbs/initdw.ora to 201326592.
So what are the values of shmmax and shared_pool_size should I set to avoid the ORA-03113?
Thanks
Kerry.
2 REPLIES
Printaporn_1
Esteemed Contributor

Re: ORA-03113:end-of-file on communication channel (Oracle9iAS)

Hi Kerry,

ORA-03113:end-of-file on communication channel
is general message that can cause by any problem that cause instance down.

Better get close to problem by check oracle alert log.
enjoy any little thing in my life

Re: ORA-03113:end-of-file on communication channel (Oracle9iAS)

Hi Kerry,
I had the same error and the instance would not mount. I fixed this by fixing the /etc/hosts file. Make sure the hostname and IP is in the systems /etc/hosts file. This might sound wierd but did work.

Thanks
Sushil Singh