sqlplus/Linux - Segmentation Fault

From: Grace Tsai <gtsai_at_bnl.gov>
Date: Fri, 25 Jun 1999 14:51:11 -0400
Message-ID: <3773CF9F.25D9452A@bnl.gov>

We installed Oracle8 Server 8.0.5.0.0 in a Linux box, which has RedHat 5.2, glibc 2.0.7-79. After installation finished (use Installer) successfully, I enter "sqlplus" and got "Segmentation Fault", a core file was created. It seems the problem is from an Oracle subroutine which sqlplus uses, the subroutine is "saficxa". Here is how we found out the problem is caused by "saficxa".

1. Enter "gdb"

    in gdb prompt, enter "core-file core"

    enter "file (Our Oracle Home)/bin/sqlplus"

    enter "bt"
    We got "#0 0x8068e4b in saficxa()

                  #1 0x80569a9 in main()"

So at this point, we know the "saficxa" called by main is causing the sqlplus problem.

2. Enter "ldd (Our OracleHome)/bin/sqlplus"

    We got a list of files as follows:
    "libclntsh.so.1.0 => (OurOracleHome)/lib/libclntsh.so.1.0 (0x40000000)

     libsl.so.1 => /lib/libnsl.so.1 (0x40382000)
     libm.so.6 => /lib/libm.so.6 (0x4038a000)

    libdl.so.2 => /lib/libdl.so.2 (0x403a3000)     libc.so.6 => /lib/libc.so.6 (0x403a6000)     /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x2aaaa000)"

   Then we "nm" the lib files listed above one by one, e.g.,    "nm /lib/libnsl.so.1 | grep saficxa", none of them include "saficxa",

So at this point, we conclude that the "saficxa" causing the "Segmentation Fault" is an Oracle subroutine.

Can anybody help us to solve this problem? THanks.

Grace Tsai
Brookhaven National Lab Received on Fri Jun 25 1999 - 13:51:11 CDT