- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - HP-UX
- >
- System Administration
- >
- Re: Sqlplus core dumb
-
- Forums
-
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Middle East
- HPE Blog, Russia
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
-
Blogs
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Blog, Latin America
- HPE Blog, Middle East
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
-
Information
- Community
- Welcome
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Tips and Tricks
- Resources
- Announcements
- Email us
- Feedback
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Blogs
-
Information
-
English
- 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
- Email to a Friend
- 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
- Email to a Friend
- 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
- Email to a Friend
- 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
- Email to a Friend
- 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
- Email to a Friend
- 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
- Email to a Friend
- 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
- Email to a Friend
- 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?
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2021 Hewlett Packard Enterprise Development LP