cancel
Showing results for 
Search instead for 
Did you mean: 

Error With ORACLE.

Mustafa Motiwala
Occasional Advisor

Error With ORACLE.

Hi,
I hope this isnt out of place for this question, but i am having trouble starting an oracle instance on R.H.L. 7.3. Every time i execute startup nomount pfile=xxx i get ORA-03113. Ram is 256 meg and swap is 512. any help will be appreciated.
Tx.
5 REPLIES
Kodjo Agbenu
Honored Contributor

Re: Error With ORACLE.

Hi,

If you are installing Oracle 8.1.x, you must consider relinking Oracle against glibc-2.1.3 (instead of 2.2.5 provided with RedHat 7.3).

This can be done automagically by using the patch provided on the Oracle Linux download site.

Good luck.

Kodjo
Learn and explain...
Mustafa Motiwala
Occasional Advisor

Re: Error With ORACLE.

Hi,
Been there, done that, installation went smoothly, now it just wont start. Without the glibc downgrade, the installation doesnt start.
U.SivaKumar_2
Honored Contributor

Re: Error With ORACLE.

Hi,

Oracle's solution:

Problem Description:
====================

You are attempting to startup the database via Server Manager
and ORA-3113 "end-of-file on communication channel" is reported.
The following errors are reported in the alert log:

Rolling back half complete log switch of thread 1.
Instance terminating with error 19502.
Instance terminated by LGWR.

Problem Explanation:
====================
During the log switch, Oracle is attempting to write to a file that
needs to grow. When there is insufficient disk space to write
to the alert log, the log switch cannot be recorded and fails.

Solution: VERIFY HARD DISK HAS FREE SPACE.

Solution Description:
=====================

Check the space on the hard disk drive(s) where Oracle is installed and
where the database files are located. Free up space as necessary.

Solution Explanation:
=====================

During the log switch, Oracle is attempting to write to a file that
needs to grow. In this testcase, there was not enough room to write
to the alert log, so the log switch could not be recorded and failed.
This caused the instance to crash and the instance could not startup
because it needed to switch the redo log.

regards,
U.SivaKumar
Innovations are made when conventions are broken
Alexander M. Ermes
Honored Contributor

Re: Error With ORACLE.

Hi there.
Just a question. Did you check the kernel parameters for the semaphore and shared memory values ? This could also be a reason for that error message. Look at the Install and Upgrade Guide in Oracle Technet.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Mustafa Motiwala
Occasional Advisor

Re: Error With ORACLE.

Guys, I KNOW i have enough hard disk space, with over 2G to spare. As for the shared memory & semaphores, i have been told that the red hat defaults are enough for a small database, when i start my instance, not i am doing startup nomount, this is the initial command, next would be the create database statement, but the problem is the instance just never starts. Plus, i just notices something else, after this, my svrmgrl hangs. if i kill it and launch another svrmgrl, it just allows me to execute one command, after that the next command i execute svrmgrl hangs. so then i have to reboot and everything is ok. i have attached the alert log if it helps.