sqlplus dump

[Nobody's Hero]

Installing Oracle 8.1.6 on an Nclass with 32GB of memory. Install seems to have went well. However when I run `sqlplus` I get a core dump.
Memory Fault (coredump)

core: core file from `sqlplus` received - SIGSEGV.

I increased maxssiz to 83570688, same problem occurrs. Any ideas?

Thanks,
Bob

[harry d brown jr]

Robert,

You might need to increase maxdsiz, not maxssiz. Also, is your N running 32bit or 64bit, and is oracle 32/64bit?

live free or die
harry

[Andreas D. Skjervold]

Hi

What about maxdsiz, min 256 M, and run relink all ($ORACLE_HOME/bin)

Andreas

[Helen French]

Hi,

Check whether u have installed the latest patches for the system. Check for the latest Oracle patches in metalink/support (oracle.com)

HTH,
Shiju

[S.K. Chan]

I've checked with one of my in house Oracle guru and apparently this might be a Oracle bug in sqlplus. There is a few occasion where sqlplus core dumps in a new install of 8.1.6. I strongly suggest you double check with Oracle before you do anything.

[harry d brown jr]

Robert,

Are the maxdsiz's set to at least this:

maxdsiz 0x40000000 (1,073,741,824)
maxdsiz_64bit 0x40000000

Also, what does your swap space look like?

And with that amount of memory, dbc_max_pct should be set to no more than 10% and dbc_min_pct to no more than 5%.

live free or die
harry

[Nobody's Hero]

maxdsiz is 990 MB maxssiz is 83MG, loading 32bit Oracle 8.1.6.

[Alexander M. Ermes]

Hi there.
Did you install all OS patches ?

Why did you not go for 64-bit Oracle ?

Did you relink all of Oracle software ?
Did you check Oracle Technet and Metalink
for documentation of install and upgrade procedures ?


Rgds
Alexander M. Ermes

[Nobody's Hero]

Thanks, everyone, not sure what fixed it. I did a relink and I created a new oraenv to be sure I am pointing in the right direction. Not sure what fixed it so I served 7's.

Thanks A lot,
Much Appreciated.

Bob Menefee