Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle8i dbassist coredumps when saving script

Andreas D. Skjervold
Honored Contributor

Oracle8i dbassist coredumps when saving script

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
6 REPLIES
Andreas D. Skjervold
Honored Contributor

Re: Oracle8i dbassist coredumps when saving script

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Ravi_8
Honored Contributor

Re: Oracle8i dbassist coredumps when saving script

Hi, Andreas
is the value of nproc is 4096?
never give up
Andreas D. Skjervold
Honored Contributor

Re: Oracle8i dbassist coredumps when saving script

nproc is 276!
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Ravi_8
Honored Contributor

Re: Oracle8i dbassist coredumps when saving script

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.
never give up
Andreas D. Skjervold
Honored Contributor

Re: Oracle8i dbassist coredumps when saving script

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Andreas D. Skjervold
Honored Contributor

Re: Oracle8i dbassist coredumps when saving script

Hi
Set LANG=C.iso88591 and problem solved.

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

Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!