MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Mac OS X Limits for Oracle

with 2 comments

A couple months ago, I tried to install Oracle Database 10g, Release 2 for Mac OS X on Intel x86-64 on a MacBook running generic Snow Leopard. It didn’t work because you must have the Mac OS X Server. Somebody asked me to post more of what I found when I tried to hack the installation. Oracle’s documentation Oracle™ Database Installation Guide 10g Release 2 (10.2) for Apple Mac OS X (Intel), B25286-01 clearly states that the installation requires Mac OS X Server edition. By the way, this is one of the best installation guides I’ve seen from Oracle because it is very complete.

You can determine which version of Mac OS X you’re running with the following:

# sw_vers

It won’t work when you’re on a generic Snow Leopard release, like this:

ProductName:	Mac OS X
ProductVersion:	10.6.2
BuildVersion:	10C540

The first place you’ll get stopped cold is during the installation. You can specify the kern.sysv.shmmni value in the sysctl.conf file at the required 4096 but it won’t allow reconfiguration from the default value of 32. The inability to override this value stops the Oracle installer. You can see the default value of the shared memory parameters by running this command in a terminal session:

# /usr/sbin/sysctl -a | grep \\.shm

You should see the following:

kern.sysv.shmmax: 4194304
kern.sysv.shmmin: 1
kern.sysv.shmmni: 32
kern.sysv.shmseg: 8
kern.sysv.shmall: 1024

I haven’t tested it on the Mac OS X Server edition yet. I’ve a hunch that it’ll work like a charm. When I do get to that, I’ll update the post. Here’s the Apple support note on kern.sysv.shmmni for the Server version.

Written by maclochlainn

February 15th, 2010 at 12:43 pm

Posted in Mac,Mac OS X,Oracle

2 Responses to 'Mac OS X Limits for Oracle'

Subscribe to comments with RSS or TrackBack to 'Mac OS X Limits for Oracle'.

  1. i got these values. so what i do next

    kern.sysv.shmmax: 2197815296
    kern.sysv.shmmin: 1
    kern.sysv.shmmni: 4096
    kern.sysv.shmseg: 8
    kern.sysv.shmall: 2097152
    my snow leopard is–

    ProductName: Mac OS X
    ProductVersion: 10.6.3
    BuildVersion: 10D2162

    mangesh

    5 Sep 10 at 1:47 am

  2. You’ll find the instructions in the Oracle Database Installation Guide, 10g Release 2 (10.2) for Apple Mac OS X (Intel). You may need to adjust some items for the higher point release of the Mac OS X.

    maclochlainn

    7 Sep 10 at 11:09 am

Leave a Reply