Home » RDBMS Server » Server Administration » SQLPLUS coredump on HP-UX
SQLPLUS coredump on HP-UX [message #52940] Wed, 21 August 2002 05:27 Go to next message
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
Re: SQLPLUS coredump on HP-UX [message #52942 is a reply to message #52940] Wed, 21 August 2002 05:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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

Re: SQLPLUS coredump on HP-UX [message #52968 is a reply to message #52940] Wed, 21 August 2002 22:54 Go to previous messageGo to next message
Carlo Henrico
Messages: 2
Registered: August 2002
Junior Member
Thanks Mahesh, however, as mentioned in my posting the settings are all equal or more than these recommended, but I still get the problem.

Carlo
Re: SQLPLUS coredump on HP-UX [message #58652 is a reply to message #52942] Tue, 23 September 2003 21:44 Go to previous messageGo to next message
Linn Chen
Messages: 1
Registered: September 2003
Junior Member
Hi,Carlo.
I have met the same sqlplus coredump problem as yours.
Could you please tell me how you finally solved this problem?

Thanks.
Linn
Re: SQLPLUS coredump on HP-UX [message #194767 is a reply to message #52968] Mon, 25 September 2006 03:53 Go to previous message
rriaz
Messages: 2
Registered: April 2005
Location: India
Junior Member

Hi All,

I am also having the same problem. Please help me to solve this issue.

thanks,
riaz.
Previous Topic: ORA-1652 error
Next Topic: Default Temporary Tablespace
Goto Forum:
  


Current Time: Tue Dec 06 04:31:51 CST 2016

Total time taken to generate the page: 0.06180 seconds