Re: Oracle10g on LinuxxFedora 2) - SQLPLUS Problem

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Mon, 16 Oct 2006 13:23:44 GMT
Message-Id: <pan.2006.10.16.13.23.39.272683@verizon.net>

On Fri, 13 Oct 2006 20:03:19 -0700, PowerLifter1450 wrote:

> I seemed to have installed Oracle 10g R! on Linux Fedor Core 2
> successfully. However, whn I siwtch directories to $cd ORACLE_HOME/bin
> and type $sqlplus I just get another $prompt, no SQL> promt (and no
> error message). A starter database was not installed, if that maters.
> Any clues about why this is happening would be much appreicated. Thanks!

Something is wrong with your sqlplus executable. Try: "file sqlplus", "ldd sqlplus" and "nm sqlplus". The output of those commands should look like this:
$ file sqlplus
sqlplus: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), for GNU/Linux 2.2.5, not stripped$ $ ldd sqlplus

        linux-gate.so.1 =>  (0x0068b000)
        libsqlplus.so => /oracle/product/10g/lib/libsqlplus.so (0x00b18000)
        libclntsh.so.10.1 => /oracle/product/10g/lib/libclntsh.so.10.1 (0x00f27000)
        libnnz10.so => /oracle/product/10g/lib/libnnz10.so (0x0016d000)
        libdl.so.2 => /lib/libdl.so.2 (0x00804000)
        libm.so.6 => /lib/libm.so.6 (0x007dd000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x00906000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x050e7000)
        libc.so.6 => /lib/libc.so.6 (0x006b2000)
        /lib/ld-linux.so.2 (0x0068c000)

$ nm sqlplus
         U afidrv

080486e4 t __bad_processor_detected
08049b54 A __bss_start
080485fc t call_gmon_start
08049b5c b completed.4577

080499fc d __CTOR_END__
080499f8 d __CTOR_LIST__
08049b48 D __data_start
08049b48 W data_start
08048950 t __do_global_ctors_aux
08048620 t __do_global_dtors_aux
08049b4c D __dso_handle
08049a04 d __DTOR_END__
08049a00 d __DTOR_LIST__
08049a0c A _DYNAMIC

08049b54 A _edata
08049b60 A _end

         U exit@@GLIBC_2.0

08048978 T _fini
080499f8 A __fini_array_end
080499f8 A __fini_array_start
08048994 R _fp_hw
         U fprintf@@GLIBC_2.0

08048654 t frame_dummy
080489f4 r __FRAME_END__
08049b1c d _GLOBAL_OFFSET_TABLE_
......

If you don't have an output like that, there is a problem with your sqlplus executable. If so, you can try the following: cd $ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install

-- 
http://www.mladen-gogala.com

Received on Mon Oct 16 2006 - 08:23:44 CDT