Cannot perform full database in Oracle9i under Linux

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 6 Dec 2002 14:23:45 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70303D14B@lnewton.leeds.lfs.co.uk>

The first thing I'd do is increase the size of my shared_pool because the bottom error on your error stack is an inability to allocate shared pool memory.

<extract>
Errors in file
/home/oracle/OraHome/admin/devdb1/bdump/devdb1_s001_10212.trc: ORA-07445: exception encountered: core dump [xsiofmgrMTSOpen()+35] [SIGSEGV]
[Address not mapped to object] [0x18] [] []

ORA-04031: unable to allocate 16364 bytes of shared memory ("large pool","unknown object","OLAP Alloc hea","xspgmgr const: OLAP PAGE POOL")
</extract>

Then I'd nip over to Metalink and see if there are any problems with ora-07445 and/or 'address not mapped to object' - there might be a known fault, with or without workarounds.

Try that and see what happens.

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: lamshing [mailto:lamshingNOSPAM_at_yahoo.com] Posted At: Friday, December 06, 2002 10:08 AM Posted To: server
Conversation: Cannot perform full database in Oracle9i under Linux Subject: Cannot perform full database in Oracle9i under Linux

Hi,

I have increased the /proc/sys/kernel/shmmax to 671088640 (640MB, half of physical memory) and the /proc/sys/kernel/sem values to

250 32000 100 256

I have a another Oracle9i server 9.0.1.0.0 on redhat linux 7.2 kernel 2.4.7-10 where we have no such problem.

Can anyone offer some help?

Thanks in advance

Shing Received on Fri Dec 06 2002 - 08:23:45 CST