O8i install solution to ORA-3113 problems on RH 7

From: James Damiano <jadam_at_nhes.state.nh.us>
Date: Thu, 30 Aug 2001 09:49:37 -0700
Message-ID: <F001.0037D4B7.20010830090350@fatcity.com>

I thought I'd pass on the solution to a problem we just experienced trying to install Oracle 8.1.7 on to a box running Linux Kernel 2.2.16 (Red Hat 7.0):

The install of Oracle8i (8.1.7) Standard Edition on this Intel box went very well except when it attempted to create the sample database. Since then, I have tried to create a small database with SID=orcl myself. Here is what happened:

I successfully startup "SVRMGR" and "connect internal". However, when I issue the "startup nomount pfile=..../orcl/pfile/initorcl_0.ora", I get the error message "ORA-03113: end-of-file on communication channel". After doing this, I will get this same "ORA-03113" every time I try to start "SVRMGR". If I reboot the machine, I can alleviate getting the error message, that is until I try to "startup nomount..." in which case the same cycle repeats. By the way, I can successfully connect to databases running on remote servers.

The Final solution to this problem was the following:

RDBMS 817 rquires glibc 2.1.3 to install correctly. That means RedHat 7 will not work with glibc-2.2-12. This problem does not exist with RedHat 7.1 and all Suse certified versions.

The problem is that Oracle 8.1.x needs glibc 2.1.3. It will link without error with glibc 2.2, but when you try to run dbassist or create a database from scratch, there are problems (dbassist hangs, "End of file on communication channel", etc.)

To get Oracle 8.1.6 or 8.1.7 working on systems with glibc 2.2.

Install the compat-glibc RPM for 2.1.3.x
cd to the directory where compat-glibc installed the files
Copy the following files to $ORACLE_HOME/lib: libc-2.1.3.so libpthread.so libdl.so ld-linux.so.2 Sometimes, these are symbolic links, so you'll need to copy the target of the symbolic link and rename it to the link name when you copy it to $ORACLE_HOME/lib.

For example, if ls -l shows:

        ld-linux.so.2 -> ld-2.1.3.so
        libc-2.1.3.so
        libdl.so -> libdl.so.2
        libpthread.so -> libpthread.so.0
Then:
        cp ld-2.1.3.so $ORACLE_HOME/lib/ld-linux.so.2
        cp libc-2.1.3.so $ORACLE_HOME/lib
        cp libdl.so.2 $ORACLE_HOME/lib/libdl.so
        cp libpthread.so.0 $ORACLE_HOME/lib/libpthread.so

4. Create a file in $ORACLE_HOME/lib called libc.so with the following contents (as a single line):

GROUP ( <OH>/lib/libc-2.1.3.so <OH>/lib/ld-linux.so.2 <CL>/libc_nonshared.a )

Substitute the value of $ORACLE_HOME for <OH> and the location of the compat-glibc directory for <CL>.

For example, my $ORACLE_HOME is:

/u01/app/oracle/product/8.1.7
and my compat-glibc directory is:

/usr/i386-glibc21-linux/lib

so the GROUP line looks like this for me:

        GROUP (/u01/app/oracle/product/8.1.7/lib/libc-2.1.3.so

/u01/app/oracle/product/8.1.7/lib/ld-linux.so.2
/usr/i386-glibc21-linux/lib/libc_nonshared.a)
(This is all one line.)

5. cd $ORACLE_HOME/bin

6. Run the following command from the UNIX prompt:

relink all

All of the Oracle software, including the assitants, will work fine after this and will work with RedHat 7.0 and kernel 2.2.16 kernel, as well as the 2.4.0 and 2.4.1-pre11 kernels.

Jim Damiano

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Damiano
  INET: jadam_at_nhes.state.nh.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Aug 30 2001 - 11:49:37 CDT