The solution is:
to obtain patch 646305 from Oracle Support or, as a temporary action,
to set ssm-threshold=0 contrasting with value of 8388608 indicated in
Installation guide. The second was helpful.
Many thanks to:
"George W. Baltz" <gwb_at_umd5.umd.edu>,
Henri Sundelin <hs_at_spock.fscrew.fi>,
Paul W Grant <PGRANT_at_uk.oracle.com>.
Responses follow:
--------------------------------------------------------------------
Date: Tue, 29 Sep 1998 10:38:04 -0400
From: "George W. Baltz" <gwb_at_umd5.umd.edu>
To: "Rustam T. Usmanov" <rustam_at_ruslan.ru>
Cc: gwb_at_liver.csc.umd.edu
Subject: Re: Unable to protect memory installing ORACLE 8.0.4 on AS 1000
under DU4.0d
You need a patch level for Oracle 8.0.4 -> 8.0.4.2.1. It's available from
Oracle support. I found it somewhere on their web support site, but don't
remember the URL.
--------------------------------------------------------------------
Date: Tue, 29 Sep 1998 17:47:04 +0300
From: Henri Sundelin <hs_at_spock.fscrew.fi>
To: "Rustam T. Usmanov" <rustam_at_ruslan.ru>
Subject: Re: Unable to protect memory installing ORACLE 8.0.4 on AS 1000
under DU4.0d
I also got that some time ago..
I remember that some oracle documentation has wrong shm values -
here is what is in my sysconfigtab:
ipc:
shm-max=139095040
shm-mni=128
shm-seg=32
ssm-threshold=0
--------------------------------------------------------------------
Date: 29 Sep 98 15:59:00 +0100
From: "PGRANT.UK.ORACLE.COM" <PGRANT_at_uk.oracle.com>
To: rustam_at_ruslan.ru
Subject: Re: Unable to protect memory installing ORACLE 8.0.4 on AS 1000
under DU4.0d
There is a patch and you should contact your local Oracle Support. Ask
for patch 646305!
To help you out for the moment you could use ssm_threshold=0
This effects a change of memory management and can be done without a
reboot.
However easiest way to do it is to add it to the sysconfigtab. Anything
above
8M set in this option will cause this error.
ssm_threshold=0
This is a problem caused by the os and is a changed that happened
somewhere
between 4.0B and 4.0D. This patch may already be include in the full
patchset
for 8.0.4.1, 8.0.4.2 and 8.0.4.3 but can't confirm at moment.
--------------------------------------------------------------------
Original message:
Dear all,
I have a problem installing Oracle 8.0.4 on AlphaServer 1000 with 256M of
physical memory under DU4.0d. Installation of the Oracle Enterprise
(RDBMS) (MTS with creation of DB objects) failed at the stage of DB
creation with the following message in
$ORACLE_HOME/admin/$ORACLE_SID/create/crdb$ORACLE_SID.lst:
Connected.
ORA-27122: unable to protect memory
Digital Unix Error: 22: Invalid argument
Additional information: 18
create database "orat"
*
ORA-01034: ORACLE not available
Disconnected.
It means that mprotect() call failed with EINVAL error. But what next,
except the call to the Oracle Worldwide Support?
At the same time I successfully managed to install the same product on
AlphaServer 400 with 128M under DU4.0d. I use Oracle's recommended SHM
parameters in both cases.
I would be grateful if anyone could help me to resolve this problem.
Thanks in advance,
Rustam
--
Rustam Usmanov, senior researcher <rustam_at_unilib.neva.ru>
Open Library Systems Center, St.Petersburg State Technical University
Address: 29, Politekhnitcheskaya str., St.Petersburg, 195251, Russia
Tel/fax: +7(812)-552-7654 <http://www.unilib.neva.ru/olsc/>
Received on Tue Sep 29 1998 - 18:37:38 NZST