topic Oracle8i dbassist coredumps when saving script in Operating System - HP-UX

Oracle8i dbassist coredumps when saving script

Andreas D. Skjervold — Mon, 13 Aug 2001 10:17:56 GMT

Hi
Anyone experienced anything like this:

When running Oracle8i (64bit)'s dbassist java program; when selecting to save information to shell script, the program coredumps with the following error:

SIGSEGV 11* segmentation violation
stackbase=7CD6B000, stackpointer=7CD6CDE8, pc=C184D70C
dbassist[107]: 1984 Abort(coredump)

(truncated; full listing in enclosed file)

rgds Andreas

Re: Oracle8i dbassist coredumps when saving script

Andreas D. Skjervold — Mon, 13 Aug 2001 10:22:11 GMT

A little to quick:

This is on a HP-UX 11.0 64bit, running Oracle8.1.7.0.0 (64bit)
Patches:
GR+HWCR June 2001
+PHCO_23963

/stand/system:
* Tunable parameters
STRMSGSZ 65535
max_thread_proc 256
maxdsiz 256000000
maxdsiz_64bit 1073741824
maxssiz 83886080
maxssiz_64bit 83886080
maxswapchunks 1024
maxtsiz_64bit 67108864
maxuprc 100
maxusers 250
ncallout 2064
nkthread 2048
nstrpty 60
semmni 70
semmns 1600
shmmax 0X40000000
shmmni 800

Andreas

Re: Oracle8i dbassist coredumps when saving script

Ravi_8 — Mon, 13 Aug 2001 10:55:49 GMT

Hi, Andreas
is the value of nproc is 4096?

Re: Oracle8i dbassist coredumps when saving script

Andreas D. Skjervold — Mon, 13 Aug 2001 11:59:53 GMT

nproc is 276!

Re: Oracle8i dbassist coredumps when saving script

Ravi_8 — Mon, 13 Aug 2001 12:23:25 GMT

Hi,
the nproc value should be 4096 and according to this value, some of the kernel parameters values will also change, look into orcale 8.1.7 installation doc. by looking at the values you have provided it looks that swap is 1GB and RAM is 512 MB which is enough for oracle 8.1.7.

Re: Oracle8i dbassist coredumps when saving script

Andreas D. Skjervold — Mon, 13 Aug 2001 12:28:55 GMT

Hi
Think I have the parameters OK as I have several database up and running without problems. And the dbassist tool works fine if I let it do the database creation right away instead of generating a script.
But you know the script is nice to have, (especially if the creatinon fail and you have to start over, and also in recovery procedures)

Tried to crank up th nproc value to 4096, but the error remains.

ANdreas

Re: Oracle8i dbassist coredumps when saving script

Andreas D. Skjervold — Tue, 14 Aug 2001 06:44:05 GMT

Hi
Set LANG=C.iso88591 and problem solved.

This must be related to my X-software (PC-Xware)

Andreas