- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Sqlplus core dumb
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2010 02:21 AM
тАО12-22-2010 02:21 AM
Sqlplus core dumb
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2010 02:46 AM
тАО12-22-2010 02:46 AM
Re: Sqlplus core dumb
If you are dying in dld.so, not much you can do. Does any 64 bit program run at all?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2010 05:03 AM
тАО12-22-2010 05:03 AM
Re: Sqlplus core dumb
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2010 10:44 AM
тАО12-22-2010 10:44 AM
Re: Sqlplus core dumb
This has a specific error, not a core dump.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2010 11:22 PM
тАО12-22-2010 11:22 PM
Re: Sqlplus core dumb
->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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2010 06:24 AM
тАО12-23-2010 06:24 AM
Re: Sqlplus core dumb
but what you need , i can do.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2010 03:13 PM
тАО12-23-2010 03:13 PM
Re: Sqlplus core dumb
Again, can you get a stack trace with "bt"?
Any patches recently installed?