OraFAQ Forum: Server Administration » SQLPLUS coredump on HP-UX

Home » RDBMS Server » Server Administration » SQLPLUS coredump on HP-UX

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLPLUS coredump on HP-UX [message #52940]

Wed, 21 August 2002 05:27

Carlo Henrico
Messages: 2
Registered: August 2002

Junior Member

I have just installed Oracle 9.2.0.1 on HP-UX 11.0 64 bit. After having numerous problems, I decided to read the manual... :)

Patches (seem) up to date
Kernel Parameters are fix'd
Environment variables are fix'd (especially the lib/lib32 difference) and the NLS parameters are set.

However, whenever I try to run sqlplus, I get a Memory fault(coredump):
core: ELF-64 core file - PA-RISC 2.0 from 'sqlplus' - received SIGSEGV

If I run "adb sqlplus core"
$c
afixdpt+4A4 from afixdpt
afixdpt(
cannot unwind -- no unwind entry. (1)

Running :
$ gdb sqlplus core
Detected 64-bit executable.
Invoking /opt/langtools/bin/gdb64.
HP gdb 2.1
Copyright 1986 - 1999 Free Software Foundation, Inc.
Hewlett-Packard Wildebeest 2.1 (based on GDB 5.0-hpwdb-20000630)
Wildebeest is free software, covered by the GNU General Public License, and
you are welcome to change it and/or distribute copies of it under certain
conditions. Type "show copying" to see the conditions. There is
absolutely no warranty for Wildebeest. Type "show warranty" for details.
Wildebeest was built for PA-RISC 2.0 (wide), HP-UX 11.00.
..(no debugging symbols found)...
Core was generated by `sqlplus'.
Program terminated with signal 11, Segmentation fault.
(no debugging symbols found)...
warning: The shared libraries were not privately mapped; setting a
breakpoint in a shared library will not work until you rerun the program.

warning: section .data not found in /oracle/app/product/920/lib/libwtc9.sl
(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...
(no debugging symbols found)...(no debugging symbols found)...(no debugging symbols found)...#0 0x2193b4 in ?? ()
(gdb) bt
#0 0x2193b4 in ?? ()
#1 0xc0000000001e26d4 in gethrtime () from /usr/lib/pa20_64/libc.2

Running:
$ chatr sqlplus
sqlplus:
64-bit ELF executable
shared library dynamic path search:
LD_LIBRARY_PATH enabled first
SHLIB_PATH enabled second
embedded path enabled third /oracle/app/product/920/sqlplus/lib/:/oracle/app/product/920/lib/:/usr/lib/pa20_64:/opt/langtools/lib/pa20_64:
shared library list:
libwtc9.sl
libcl.2
librt.2
libpthread.1
libnss_dns.1
libdl.1
libm.2
libc.2
shared library binding:
deferred
global hash table disabled
shared library mapped private disabled
shared library segment merging disabled
shared vtable support disabled
segments:
index type address flags size
6 text 4000000000000000 z---c D (default)
7 data 8000000100000000 ---m- D (default)
executable from stack: D (default)
kernel assisted branch prediction enabled
lazy swap allocation for dynamic segments disabled

and lastly:
$ ldd sqlplus
libwtc9.sl => /oracle/app/product/920/lib/libwtc9.sl
libcl.2 => /usr/lib/pa20_64/libcl.2
librt.2 => /usr/lib/pa20_64/librt.2
libpthread.1 => /usr/lib/pa20_64/libpthread.1
libnss_dns.1 => /usr/lib/pa20_64/libnss_dns.1
libdl.1 => /usr/lib/pa20_64/libdl.1
libm.2 => /usr/lib/pa20_64/libm.2
libc.2 => /usr/lib/pa20_64/libc.2
libdl.1 => /usr/lib/pa20_64/libdl.1
libdl.1 => /usr/lib/pa20_64/libdl.1
libdl.1 => /usr/lib/pa20_64/libdl.1

Any ideas PLEASE!!!

Carlo

Report message to a moderator

Re: SQLPLUS coredump on HP-UX [message #52942 is a reply to message #52940]

Wed, 21 August 2002 05:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try these settings.
         shmmax=1073741824 or 0X40000000
         shmmni=100
         shmseg=10
         semmns=1000
         semmni=100
and i would recomend Set atleast SHMMAX >=MAXDSIZ

Report message to a moderator