shared memory on Solaris 2.7/2.6 for oracle 8.0.5/8.0.4

[zen1823]

HELLO
Where can I find a comprehensive guide about shared memory on Solaris 2.7/2.6 for oracle 8.0.5/8.0.4

I am trying to install the Ardent DataStage 4.0.3 on a Solaris 2.6 for Oracle 7.x & 8.x.

I keep receiving the message cannot continue install because of shared memory conflicts, yet I have no other apps running on this box, I have 1 Gig of memory and
the following kernel values are as such:

Solaris 2.6 FIRST INSTALL,ATTEMPT KERNEL PARMS

MSGMAX 8192
MSGMNB 16384
SHMSEG 15
MSGSEG N/A
SHMMAX 2097152
SEMMNS 111
SEMMSL 111
SEMMNI 20

The DataStage 3.6.3 install works fine, but the 4.0.3,
keeps dying on the shared memory issues and inturn cannot
initialize the Universe Database Setup Program.

Thanks in advance

 

[cgswong]

I don't have any knowledge of DataStage, but have you read the install/readme for the product? Perhaps it can tell you whats wrong. The error indicates you probably don't have enough shared memory.

If you need info on the memory parameters for Oracle you can get it by reading the installation or maintenance manuals available on Oracle MetaLink.

Also, if Oracle is the only thing running and you have 1GB why is your SHMMAX so low? I would increase this to about 512MB and increase SEMMNI to 100. The default values for all Oracle parameters are below:

set shmsys:shminfo_shmmax=4292967295 * over 4GB
set shmsys:shminfo_shmmin=1 * min shared mem segm
set shmsys:shminfo_shmmni=100 * min shared mem ids
set shmsys:shminfo_shmseg=10 * max shared mem seg
set semsys:seminfo_semmni=100 * max semaphore ids
set semsys:seminfo_semmsl=100 * max semaphores in set
set semsys:seminfo_semmns=200 * max sys semaphores
set semsys:seminfo_semopm=100 * max oper per semop
set semsys:seminfo_semvmx=32767 * semaphore max value

SEMMNS=sum of processes parameter for each Oracle db, adding the largest one twice, then an additional 10 for each db.
SEMMSL=10 + largest processes parameter of any Oracle db on system.

The total allowable shared memory is SHMMAX * SHMSEG

Look at the readme for DataStage to see how much shared memory it needs and set the appropriate values for the above, or try increasing SHMMAX first.

Hope this helps.

- Stuart