topic Re: Error With ORACLE. in Operating System - Linux

Error With ORACLE.

Mustafa Motiwala — Thu, 14 Nov 2002 07:18:46 GMT

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.

Re: Error With ORACLE.

Kodjo Agbenu — Thu, 14 Nov 2002 07:30:35 GMT

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

Re: Error With ORACLE.

Mustafa Motiwala — Thu, 14 Nov 2002 07:37:04 GMT

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

Re: Error With ORACLE.

U.SivaKumar_2 — Thu, 14 Nov 2002 08:27:39 GMT

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

Re: Error With ORACLE.

Alexander M. Ermes — Thu, 14 Nov 2002 13:28:20 GMT

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

Re: Error With ORACLE.

Mustafa Motiwala — Fri, 15 Nov 2002 08:17:27 GMT

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.