cancel
Showing results for 
Search instead for 
Did you mean: 

sqlplus dump

Nobody's Hero
Valued Contributor

sqlplus dump

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
UNIX IS GOOD
8 REPLIES
harry d brown jr
Honored Contributor

Re: sqlplus dump

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

Live Free or Die
Andreas D. Skjervold
Honored Contributor

Re: sqlplus dump

Hi

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

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

Re: sqlplus dump

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
Life is a promise, fulfill it!
S.K. Chan
Honored Contributor

Re: sqlplus dump

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
Honored Contributor

Re: sqlplus dump

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
Live Free or Die
Nobody's Hero
Valued Contributor

Re: sqlplus dump

maxdsiz is 990 MB maxssiz is 83MG, loading 32bit Oracle 8.1.6.
UNIX IS GOOD
Alexander M. Ermes
Honored Contributor

Re: sqlplus dump

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Nobody's Hero
Valued Contributor

Re: sqlplus dump

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
UNIX IS GOOD