topic Re: sqlplus dump in Operating System - HP-UX

sqlplus dump

Nobody's Hero — Mon, 04 Mar 2002 14:38:38 GMT

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

Re: sqlplus dump

harry d brown jr — Mon, 04 Mar 2002 14:42:47 GMT

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

Re: sqlplus dump

Andreas D. Skjervold — Mon, 04 Mar 2002 14:44:38 GMT

Hi

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

Andreas

Re: sqlplus dump

Helen French — Mon, 04 Mar 2002 14:45:46 GMT

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

Re: sqlplus dump

S.K. Chan — Mon, 04 Mar 2002 14:49:21 GMT

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.

Re: sqlplus dump

harry d brown jr — Mon, 04 Mar 2002 14:50:06 GMT

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

Re: sqlplus dump

Nobody's Hero — Mon, 04 Mar 2002 14:54:57 GMT

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

Re: sqlplus dump

Alexander M. Ermes — Mon, 04 Mar 2002 15:23:28 GMT

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

Re: sqlplus dump

Nobody's Hero — Mon, 04 Mar 2002 15:26:43 GMT

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