cancel
Showing results for 
Search instead for 
Did you mean: 

Sqlplus core dumb

 
remonsamir
Occasional Contributor

Sqlplus core dumb

$ sqlplus
Bus error(coredump)

$ gdb sqlplus core
HP gdb 5.9 for HP Itanium (32 or 64 bit) and target HP-UX 11.2x.
Copyright 1986 - 2001 Free Software Foundation, Inc.
Hewlett-Packard Wildebeest 5.9 (based on GDB) is covered by the
GNU General Public License. Type "show copying" to see the conditions to
change it and/or distribute copies. Type "show warranty" for warranty/support.
..
Core was generated by `sqlplus'.
Program terminated with signal 10, Bus error.
BUS_ADRALN - Invalid address alignment. Please refer to the following link that helps in handling unaligned data: http://docs.hp.com/en/7730/newhelp0610/pragmas.htm#pragma-pack-ex3

warning: Load module /u01/app/oracle/product/DB/11g/lib/libsqlplus.so has been stripped.
Debugging information is not available.

#0 0xc000000000055ae0:1 in memset+0x311 () from /usr/lib/hpux64/dld.so


please I need Help
remo
6 REPLIES

Re: Sqlplus core dumb

Can you get a stack trace with "bt"?
If you are dying in dld.so, not much you can do. Does any 64 bit program run at all?
Hein van den Heuvel
Honored Contributor

Re: Sqlplus core dumb

sqlplus, assuming you are refering to the Oracle interactive SQL tool, is supposed to work and is know to work for simple stuff, like activating it. Period.

If it does not work, there there is something major wrong with the configuration.
Wrong flavor of code, 32 versus 64 bitnes, messed up environment.

So just go back to the basics...

- Fresh install? Did it ever work? What changed?
- Which OS versions & Platform
- Which DB version and target platform?
- Are the two compatible according to Oracle.
- Does it fail for all users?
- What Oracle environment is targeted for a failing use?
# env | grep -i ora
# env | grep -i library

Hope this helps some,
Hein

Re: Sqlplus core dumb

>Hein: 32 versus 64 bitness

This has a specific error, not a core dump.
remonsamir
Occasional Contributor

Re: Sqlplus core dumb

- Fresh install? Did it ever work? What changed?
->no not fresh installation

- Which OS versions & Platform
->HP-UX rx-92 B.11.31 U ia64

- Which DB version and target platform?
data base version 11.1

- Are the two compatible according to Oracle.
yes
- Does it fail for all users?
yes

- What Oracle environment is targeted for a failing use?

umask 022
export TEMP=/tmp
export TMPDIR=/tmp
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/DB/11g
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
#export NLS_LANG=AMERICAN_AMERICA.AR8ISO8859P6
export PATH=$PATH:$ORACLE_HOME/bin
#export NLS_DATE_FORMAT="MM/DD/RRRR"
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
#export AIXTHREAD_SCOPE=S
set -o vi
export ORACLE_SID=FCR21
#echo "Done"
stty erase ^?


$ env | grep -i ora
PATH=/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/gvsd/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sas/bin:/opt/graphics/common/bin:/opt/atok/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/sec_mgmt/bastille/bin:/opt/caliper/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/resmon/bin:/opt/firefox:/opt/gnome/bin:/usr/contrib/kwdb/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/prm/bin:/opt/sfm/bin:/opt/swm/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/sentinel/bin:/opt/swa/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/langtools/bin:/opt/gwlm/bin:.:/u01/app/oracle/product/DB/11g/bin
ORACLE_BASE=/u01/app/oracle
LOGNAME=oracle
LIBPATH=/u01/app/oracle/product/DB/11g/lib:/u01/app/oracle/product/DB/11g/rdbms/lib
ORACLE_SID=FCR21
ORA_NLS33=/u01/app/oracle/product/DB/11g/ocommon/nls/admin/data
HOME=/home/oracle
LD_LIBRARY_PATH=/u01/app/oracle/product/DB/11g/lib:/u01/app/oracle/product/DB/11g/rdbms/lib
ORACLE_HOME=/u01/app/oracle/product/DB/11g
PWD=/home/oracle

$ env | grep -i library
LD_LIBRARY_PATH=/u01/app/oracle/product/DB/11g/lib:/u01/app/oracle/product/DB/11g/rdbms/lib

But i think this can help you to identifies the Error

$ gdb sqlplus core
HP gdb 5.9 for HP Itanium (32 or 64 bit) and target HP-UX 11.2x.
Copyright 1986 - 2001 Free Software Foundation, Inc.
Hewlett-Packard Wildebeest 5.9 (based on GDB) is covered by the
GNU General Public License. Type "show copying" to see the conditions to
change it and/or distribute copies. Type "show warranty" for warranty/support.
..
Core was generated by `sqlplus'.
Program terminated with signal 10, Bus error.
BUS_ADRALN - Invalid address alignment. Please refer to the following link that helps in handling unaligned data: http://docs.hp.com/en/7730/newhelp0610/pragmas.htm#pragma-pack-ex3

warning: Load module /u01/app/oracle/product/DB/11g/lib/libsqlplus.so has been stripped.
Debugging information is not available.

#0 0xc000000000055ae0:1 in memset+0x311 () from /usr/lib/hpux64/dld.so
remo
remonsamir
Occasional Contributor

Re: Sqlplus core dumb

@Hein van den thanks for fast replay
but what you need , i can do.
remo

Re: Sqlplus core dumb

>but what you need, I can do.

Again, can you get a stack trace with "bt"?
Any patches recently installed?