topic Re: Sqlplus core dumb in Operating System - HP-UX

Sqlplus core dumb

remonsamir — Wed, 22 Dec 2010 10:21:42 GMT

$ 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

Re: Sqlplus core dumb

Dennis Handly — Wed, 22 Dec 2010 10:46:07 GMT

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?

Re: Sqlplus core dumb

Hein van den Heuvel — Wed, 22 Dec 2010 13:03:30 GMT

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

Dennis Handly — Wed, 22 Dec 2010 18:44:23 GMT

>Hein: 32 versus 64 bitness

This has a specific error, not a core dump.

Re: Sqlplus core dumb

remonsamir — Thu, 23 Dec 2010 07:22:00 GMT

- 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

Re: Sqlplus core dumb

remonsamir — Thu, 23 Dec 2010 14:24:07 GMT

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

Re: Sqlplus core dumb

Dennis Handly — Thu, 23 Dec 2010 23:13:19 GMT

>but what you need, I can do.

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