How to install Oracle Database 10g on Mac OS X Snow Leopard « ray_apps

September 14, 2009

How to install Oracle Database 10g on Mac OS X Snow Leopard

Filed under: mac, oracle — Raimonds Simanovskis @ 12:25 am

Oracle Database 10g is not yet officially supported on new Mac OS X 10.6 Snow Leopard but thanks to comments at my previous tutorial I managed to do Oracle 10g installation on fresh Mac OS X Snow Leopard.

If you have upgraded from Leopard with Oracle 10g installation to Snow Leopard then most probably Oracle 10g should work fine and you should not do anything. These instructions are just for fresh installation of Snow Leopard.

And also please take in mind that Oracle 10g on Snow Leopard is not supported yet by Oracle and therefore please do not run critical production applications on it :)

So here are my updated Oracle 10g installation instructions for Snow Leopard.

Initial preparation

At first you need Xcode tools installed on your Mac OS X.

Then you need to create oracle user as well as increase default kernel parameters. Open Terminal and switch to root user:

sudo -i

Create oinstall group and oracle user (I used group and user number 600 to ensure that they do not collide with existing groups and users):

dscl . -create /groups/oinstall
dscl . -append /groups/oinstall gid 600
dscl . -append /groups/oinstall passwd "*"

dscl . -create /users/oracle
dscl . -append /users/oracle uid 600
dscl . -append /users/oracle gid 600
dscl . -append /users/oracle shell /bin/bash
dscl . -append /users/oracle home /Users/oracle
dscl . -append /users/oracle realname "Oracle software owner"
mkdir /Users/oracle
chown oracle:oinstall /Users/oracle

Change password for oracle user:

passwd oracle

Change default kernel parameters:

vi /etc/sysctl.conf

and enter values recommended by Oracle:

kern.sysv.semmsl=87381
kern.sysv.semmns=87381
kern.sysv.semmni=87381
kern.sysv.semmnu=87381
kern.sysv.semume=10
kern.sysv.shmall=2097152
kern.sysv.shmmax=2197815296
kern.sysv.shmmni=4096
kern.maxfiles=65536
kern.maxfilesperproc=65536
net.inet.ip.portrange.first=1024
net.inet.ip.portrange.last=65000
kern.corefile=core
kern.maxproc=2068
kern.maxprocperuid=2068

Oracle DB installation scripts have reference to Java version 1.4.2 which is not present on Snow Leopard. The easiest way to fix it is to create symbolic link to newer version of Java:

sudo ln -s /System/Library/Frameworks/JavaVM.framework/Versions/1.5.0 /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2

After this reboot your computer so that these new kernel parameters would be taken into effect.

After reboot you need to log in as new “Oracle software owner” user (as now Snow Leopard has stricter control for access to X11 display and therefore I couldn’t manage to start Oracle installation just from terminal).

Open Terminal application and set shell settings in .bash_profile

vi .bash_profile

and enter

export DISPLAY=:0.0
export ORACLE_BASE=$HOME
umask 022
ulimit -Hn 65536
ulimit -Sn 65536

As you see I prefer to install all Oracle related files under home directory of oracle user therefore I am setting ORACLE_BASE to home directory. And also include ulimit settings – I forgot to do this initially and got strange TNS service errors because of that.

Now execute this script so that these settings are applied to current shell:

. ./.bash_profile

Now download db.zip installation archive and place it somewhere and unzip it:

mkdir Install
cd Install
# download db.zip to this directory
unzip db.zip
cd db/Disk1

Now you are ready to start installation. In Snow Leopard you need to pass -J-d32 option to installation script to force to run Java in 32-bit mode as some native libraries are 32-bit:

./runInstaller -J-d32

Installation

In installation wizard I selected the following options:

Standard Edition – as I don’t need additional features of Enterprise Edition
Install Software Only – we will need to do some fixes before database creation

In the middle of installation you will get error message “Error in invoking target ‘all_no_orcl ipc_g ihsodbc32′ …” (message truncated). Please do not press anything and switch to Terminal application.

cd ~/oracle/product/10.2.0/db_1/rdbms/lib
vi ins_rdbms.mk

and in this file you need to search for line containing HSODBC_LINKLINE (in vi enter /HSODBC_LINKLINE) and comment out this line with putting # in front of it:

#	$(HSODBC_LINKLINE)

and save changed file.

In this way we disable failing compilation of library which is anyway not needed for our Oracle DB installation.

After that you can switch back to Oracle installation application and press Retry.

At the end of installation you will be instructed to run one shell script from root. To do that open new tab in Terminal and execute (substitute “username” with your login name):

su - username
sudo /Users/oracle/oracle/product/10.2.0/db_1/root.sh

Hopefully installation will complete successfully.

Creation of database

Switch back to Terminal tab with oracle user and add the following lines to .bash_profile of oracle user:

export ORACLE_HOME=/Users/oracle/oracle/product/10.2.0/db_1
export DYLD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_SID=orcl
PATH=$PATH:$ORACLE_HOME/bin

and execute it

. ~/.bash_profile

Now you need to modify $ORACLE_HOME/jdk/bin/java script and change “…java -Xbootclasspath…” to “…java -d32 -Xbootclasspath…”. This is necessary to force netca and dbca utilities to run in 32-bit mode.

Now you need to do the major installation hack :) Unfortunately the main oracle executable binary when compiled under Snow Leopard is giving core dumps when starting Oracle database and currently the only way how I managed to fix it is to replace this executable file with the one which was compiled previously under Leopard. So you need to download it in trust me that it is correct :)

cd $ORACLE_HOME/bin
curl -O http://rayapps.com/downloads/oracle_se.zip
unzip oracle_se.zip
chmod ug+s oracle
rm oracle_se.zip

(If you installed Oracle Enterprise Edition then please substitute oracle_se.zip with oracle_ee.zip)

Now you can run Network Configuration Assistant

netca

and select all default options to create listener and wait until you get confirmation message that listener is configured and started.

After that you can run Database Configuration Assistant

dbca

and select

Create a Database
General Purpose
Specify orcl as Global Database Name and SID (or set it to something different if you need)
Specify password for SYS and SYSTEM users
I selected also Sample Schemas
and in Character Sets I selected Use Unicode (AL32UTF8)

At the end of installation I tried to use Password Management to unlock additional schemas but it didn’t work – so you need to unlock other sample schemas if needed using sqlplus.

At the end of installation verify if you can connect to newly created database

sqlplus system@orcl

I hope that my fixes will help you as well and you will be able to connect to database.

If you want to unlock other sample users then do it from sqlplus, e.g.:

alter user hr account unlock identified by hr;

Further instructions are the same as for Leopard and there are no more changes.

Change listener to listen on localhost

As I need this Oracle database just as local development database on my computer then I want to change the listener so that it would listen just on localhost port 1521:

vi $ORACLE_HOME/network/admin/listener.ora

and change it to:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /Users/oracle/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = /Users/oracle/oracle/product/10.2.0/db_1)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

Then also change ORCL alias definition in $ORACLE_HOME/network/admin/tnsnames.ora to:

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

After this change restart listener and try to connect with sqlplus to verify that these changes are successful.

Automatic startup of Oracle database

If you want that Oracle database is started automatically when your computer is booted then you need to create the following startup script. Start terminal and switch to root.

At first edit /etc/oratab and change N to Y at the end of line for ORCL database – this will be used by dbstart utility to find which databases should be started automatically.

Then create startup script for Oracle database:

mkdir /Library/StartupItems/Oracle
cd /Library/StartupItems/Oracle
vi Oracle

and enter the following:

#!/bin/sh

# Suppress the annoying "$1: unbound variable" error when no option
# was given
if [ -z $1 ] ; then
  echo "Usage: $0 [start|stop|restart] "
  exit 1
fi

# source the common startup script
. /etc/rc.common

# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for the installation
ORACLE_HOME=/Users/oracle/oracle/product/10.2.0/db_1
DYLD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_HOME DYLD_LIBRARY_PATH

# change the value of ORACLE to the login name of the
# oracle owner at your site
ORACLE=oracle

PATH=$PATH:$ORACLE_HOME/bin

# Set shell limits for the Oracle Database
ulimit -Hu 2068
ulimit -Su 2068
ulimit -Hn 65536
ulimit -Sn 65536

StartService()
{
  ConsoleMessage "Starting Oracle Databases"
  su $ORACLE -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
}

StopService()
{
  ConsoleMessage "Stopping Oracle Databases"
  su $ORACLE -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"
}

RestartService()
{
  StopService
  StartService
}

RunService "$1"

and then make this script executable

chmod a+x Oracle

and in addition create properties file:

vi StartupParameters.plist

with the following contents:

{
  Description     = "Oracle Database Startup";
  Provides        = ("Oracle Database");
  Requires        = ("Disks");
  OrderPreference = "None";
}

Now you can verify that these scripts are working. Open new terminal and try

sudo /Library/StartupItems/Oracle/Oracle stop

to stop the database and

sudo /Library/StartupItems/Oracle/Oracle start

to start again the database. And later you can reboot your computer also to verify that Oracle database will be started automatically.

Hide oracle user from login window

After computer reboot you probably noticed that now you got oracle user in initial login window. To get rid of it execute this from terminal:

sudo defaults write /Library/Preferences/com.apple.loginwindow HiddenUsersList -array-add oracle

What next?

Now when you have Oracle database installed you would need some development tools that you could use to access the database. Here are some links:

Oracle SQL Developer – free Oracle GUI tool that supports Mac OS X as well
If you would like to use Ruby and Ruby on Rails then check out my tutorial how to setup Ruby and Oracle client on Snow Leopard

Please comment if you find any issues with Oracle Database 10g installation on Snow Leopard using this tutorial.

Comments (110)

110 Comments »

Thanks for this, I’ll post a link to this on my blog as well.

Comment by Christopher R. Murphy — September 14, 2009 @ 2:20 am | Reply
Thanks a lot, but I faced another problem. During the installation Java machine crashes in a random way with the following exception:

Invalid memory access of location fea4538c eip=002e8ea9

Comment by Boris — September 14, 2009 @ 10:46 am | Reply
Some details:

Process: java [702]
Path: /usr/bin/java
Identifier: com.apple.javajdk16.oracle.sysman.oii.oiic.OiicInstaller
Version: 13.0.0 (13.0.0)
Code Type: X86 (Native)
Parent Process: ??? [1]

Date/Time: 2009-09-14 13:02:43.465 +0400
OS Version: Mac OS X 10.6.1 (10B504)
Report Version: 6

Interval Since Last Report: 1529 sec
Crashes Since Last Report: 12
Per-App Interval Since Last Report: 553 sec
Per-App Crashes Since Last Report: 11
Anonymous UUID: AA030127-C3CA-450C-911F-45C5305B915B

Exception Type: EXC_BAD_ACCESS (SIGSEGV)
Exception Codes: KERN_INVALID_ADDRESS at 0×00000000fe9a37dc
Crashed Thread: 12 Java: CompilerThread0

Application Specific Information:

Java information:
Exception type: Bus Error (0xa) at pc=0×002e8ea9

Java VM: Java HotSpot(TM) Client VM (14.1-b02-90 mixed mode macosx-x86)

Current thread (0×0187f400): JavaThread “CompilerThread0″ daemon [_thread_in_native, id=-1329491968, stack(0xb0b19000,0xb0c19000)]
Stack: [0xb0b19000,0xb0c19000]

Current CompileTask:
C1:1621 oracle.sysman.oii.oiis.OiisFileEntry.toString()Ljava/lang/String; (241 bytes)

Java Threads: ( => current thread )
0×01955c00 JavaThread “Image Fetcher 0″ daemon [_thread_blocked, id=-1318727680, stack(0xb155d000,0xb165d000)]
0×01a9d800 JavaThread “Thread-8″ [_thread_blocked, id=-1316614144, stack(0xb1761000,0xb1861000)]
0×01980c00 JavaThread “Image Animator 3″ daemon [_thread_blocked, id=-1317670912, stack(0xb165f000,0xb175f000)]
0×0197e800 JavaThread “TaskScheduler timer” [_thread_blocked, id=-1324171264, stack(0xb102c000,0xb112c000)]
0×01989800 JavaThread “Thread-4″ daemon [_thread_blocked, id=-1319784448, stack(0xb145b000,0xb155b000)]
0×028c6800 JavaThread “CursorIdler” [_thread_blocked, id=-1320841216, stack(0xb1359000,0xb1459000)]
0×018d4400 JavaThread “AWT-EventQueue-0″ [_thread_blocked, id=-1323114496, stack(0xb112e000,0xb122e000)]
0×028ce400 JavaThread “Java2D Disposer” daemon [_thread_blocked, id=-1325228032, stack(0xb0f2a000,0xb102a000)]
0×028c9800 JavaThread “AWT-Shutdown” [_thread_blocked, id=-1326321664, stack(0xb0e1f000,0xb0f1f000)]
0×028c9000 JavaThread “AWT-AppKit” daemon [_thread_in_native, id=-1602661120, stack(0xbf800000,0xc0000000)]
0×01880400 JavaThread “Low Memory Detector” daemon [_thread_blocked, id=-1328435200, stack(0xb0c1b000,0xb0d1b000)]
=>0×0187f400 JavaThread “CompilerThread0″ daemon [_thread_in_native, id=-1329491968, stack(0xb0b19000,0xb0c19000)]
0×0187e800 JavaThread “Signal Dispatcher” daemon [_thread_blocked, id=-1330548736, stack(0xb0a17000,0xb0b17000)]
0×0187d800 JavaThread “Surrogate Locker Thread (CMS)” daemon [_thread_blocked, id=-1331605504, stack(0xb0915000,0xb0a15000)]
0×01872000 JavaThread “Finalizer” daemon [_thread_blocked, id=-1333727232, stack(0xb070f000,0xb080f000)]
0×01871400 JavaThread “Reference Handler” daemon [_thread_blocked, id=-1334784000, stack(0xb060d000,0xb070d000)]
0×01800c00 JavaThread “main” [_thread_in_Java, id=-1341124608, stack(0xb0001000,0xb0101000)]
Other Threads:
0×02801000 VMThread [stack: 0xb050b000,0xb060b000] [id=-1335840768]
0×01880c00 WatcherThread [stack: 0xb0d1d000,0xb0e1d000] [id=-1327378432]

VM state:not at safepoint (normal execution)
VM Mutex/Monitor currently owned by a thread: None

Heap
par new generation total 14336K, used 6778K [0×05010000, 0×06010000, 0×06010000)
eden space 12288K, 52% used [0×05010000, 0×056563d0, 0×05c10000)
from space 2048K, 17% used [0×05c10000, 0×05c687d8, 0×05e10000)
to space 2048K, 0% used [0×05e10000, 0×05e10000, 0×06010000)
concurrent mark-sweep generation total 49152K, used 18225K [0×06010000, 0×09010000, 0×0e610000)
concurrent-mark-sweep perm gen total 36816K, used 24569K [0×0e610000, 0×10a04000, 0×12610000)

Virtual Machine Arguments:
JVM Args: -Doracle.installer.library_loc=/tmp/OraInstall2009-09-14_12-57-48PM/oui/lib/mac_osx -Doracle.installer.oui_loc=/tmp/OraInstall2009-09-14_12-57-48PM/oui -Doracle.installer.bootstrap=TRUE -Doracle.installer.startup_location=/Users/oracle/Disk1/install -Doracle.installer.jre_loc=/System/Library/Frameworks/JavaVM.framework/Versions/1.5.0/Home/ -Doracle.installer.extjre=true -Doracle.installer.nlsEnabled=”TRUE” -Doracle.installer.prereqConfigLoc=/tmp/OraInstall2009-09-14_12-57-48PM/prereq -Doracle.installer.unixVersion=10.0.0 -Xmx150m
Java Command: oracle.sysman.oii.oiic.OiicInstaller -scratchPath /tmp/OraInstall2009-09-14_12-57-48PM -sourceLoc /Users/oracle/Disk1/install/../stage/products.xml -sourceType network -timestamp 2009-09-14_12-57-48PM -jreLoc /System/Library/Frameworks/JavaVM.framework/Versions/1.5.0/Home/
Launcher Type: SUN_STANDARD
Physical Memory: Page Size = 4k, Total = 3840M, Free = 1981M

…

Comment by Boris — September 14, 2009 @ 11:04 am | Reply
Hmm, didn’t see such errors on my iMac where are run installation very many times.
Did you specified -d32 flag in all places according to my instructions? And did you created soft link from Java 1.4.2 to 1.5.0? (Wondering why there are 1.5.0 and not 1.4.2 in file paths)

Comment by Raimonds Simanovskis — September 14, 2009 @ 12:58 pm | Reply
That’s because I changed path in runInstaller script. Creating soft link instead of it leads to the same result. =(
Yes, I start ./runInstaller -J-d32 as described.

Comment by Boris — September 14, 2009 @ 1:13 pm | Reply
Strange, but after I created soft link, installer doesn’t crash before message “Error in invoking target ‘all_no_orcl ipc_g ihsodbc32′ …” occurs. And while I try to fix this everything halts.

BTW, I don’t see -d32 among arguments in the report given. But installer says:

Command line argument array elements …
Arg:0:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home/bin/java:
Arg:1:-Doracle.installer.library_loc=/tmp/OraInstall2009-09-14_03-16-16PM/oui/lib/mac_osx:
…
Arg:10:-d32:

Comment by Boris — September 14, 2009 @ 1:38 pm | Reply
Well, the problem is that Snow Leopard has only Java 6 version, which only works in 64bit mode. Thanks Apple for their uncompromising decisions and marketing. So my 1.5.0 framework was pointing to 1.6.0 =)

I’ve found simple guide how to restore Java 5 here:
http://wiki.oneswarm.org/index.php/OS_X_10.6_Snow_Leopard

Comment by Boris — September 14, 2009 @ 4:24 pm | Reply
- That was the same on my test iMac (1.5.0 pointing to 1.6.0) where I tried the installation.
  So probably there is some other reason why your installation is failing. But it would be good to hear from you if restoring Java 1.5 installation will solve your issue :)
  
  Comment by Raimonds Simanovskis — September 14, 2009 @ 4:56 pm | Reply
  - Now with Java 5 crashes disappered and I’ve finally finished my installation. =)
    
    Comment by Boris — September 14, 2009 @ 5:11 pm
Hi,

In the /Library/StartupItems/Oracle script ..

What do you mean by this :

…
…
# change the value of ORACLE to the login name of the
# oracle owner at your site
ORACLE=oracle
…
…

Thanks.

Comment by mikeT — September 15, 2009 @ 4:12 pm | Reply
Hi,

I’m also having this error:

MGLTMacbookPro-2:~ mikeT$ sudo /Library/Startupitems/Oracle/Oracle start
Starting Oracle Databases
Processing Database instance “mac102g”: log file /Users/oracle/product/10.2.0/db_1/startup.log

MGLTMacbookPro-2:~ mikeT$ cat /Users/oracle/product/10.2.0/db_1/startup.log
cat: /Users/oracle/product/10.2.0/db_1/startup.log: Permission denied

MGLTMacbookPro-2:~ mikeT$ sudo /Library/Startupitems/Oracle/Oracle stop
Stopping Oracle Databases
Processing Database instance “mac102g”: log file /Users/oracle/product/10.2.0/db_1/shutdown.log

MGLTMacbookPro-2:~ mikeT$ cat /Users/oracle/product/10.2.0/db_1/shutdown.log
cat: /Users/oracle/product/10.2.0/db_1/shutdown.log: Permission denied

Comment by mikeT — September 15, 2009 @ 4:46 pm | Reply
Leave ORACLE=oracle if you created oracle user according to these instructions.

And you cannot access /Users/oracle/product/10.2.0/db_1/startup.log with your user, use sudo or “su – oracle” to view contents of log files.

Comment by Raimonds Simanovskis — September 15, 2009 @ 8:31 pm | Reply
Hey Raimonds,

Thanks for the guide, it works. 1 thing I realize is that it installs the standard edition even though I asked it to install the enterprise edition. I think the reason is because db.zip is for oracle standard edition only. We do need to use some enterprise features. Is there like a db.zip for enterprise edition?

Comment by Anthony Lai — September 15, 2009 @ 11:57 pm | Reply
- I got Enterprise edition working now, following what you said. I installed EE on Leopard (not Snow Leopard), and then later copy the oracle executable into Snow Leopard. Let me know if you are interested in that file for others to download and install Oracle EE.
  
  Comment by Anthony Lai — September 16, 2009 @ 2:31 am | Reply
Hello,

I was able to view the log, I can’t start / stop the database:

…
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> ERROR:
ORA-01031: insufficient privileges

SQL> ORA-01012: not logged on
SQL> Database instance “mac102g” shut down.

SQL*Plus: Release 10.2.0.4.0 – Production on Wed Sep 16 00:44:01 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> ERROR:
ORA-01031: insufficient privileges

SQL> ORA-01012: not logged on
SQL> Database instance “mac102g” shut down.
…

Starting the DB.

/Users/oracle/product/10.2.0/db_1/bin/dbstart: Starting up database “mac102g”
Wed Sep 16 00:19:57 EST 2009

_mdnsresponder: Warning: Version 10 listener is required for Oracle Database 10g
_mdnsresponder: Version Server: for Listener is NOT supported with Database version 10
_mdnsresponder: Restart Oracle Net Listener using an alternate ORACLE_HOME_LISTNER: lsnrctl start

SQL*Plus: Release 10.2.0.4.0 – Production on Wed Sep 16 00:19:58 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> ERROR:
ORA-01031: insufficient privileges

SQL> ORA-01031: insufficient privileges
SQL>
/Users/oracle/product/10.2.0/db_1/bin/dbstart: Database instance “mac102g” warm started.

Comment by mikeT — September 16, 2009 @ 1:21 pm | Reply
- I got the same issue. I couldn’t start oracle service after reboot .
  But I’ve found solution that works in my case – edit $ORACLE_HOME/bin/dbstart script and change this block:
  
  Connect / as sysdba
  startup
  quit
  EOF
  
  to:
  
  Connect sys/{password} as sysdba
  startup
  quit
  EOF
  
  where {password} is password of oracle system user. I know it’s very insecure solution but for me it’s OK. Anyway, I don’t know what causes such a problem and I’d like to know that.
  
  Comment by Boris — September 18, 2009 @ 4:34 pm | Reply
  - I was having the same problem and this fixed it. It’s probably possible to fix the permissions in Oracle, but I leave that for an Oracle guru to figure out. I, like Boris, am fine hard coding the passwords because I’m using this database in a situation that doesn’t demand security.
    
    Comment by Ken Heutmaker — September 19, 2009 @ 7:15 pm
- Regarding the version issue: It’s a red herring. I think you can safely ignore it. If you want to fix it, here are the instructions:
  
  There is an error in dbstart caused by the platform name. The script assumes that the platform name is is 1 word, but the platform name on a Mac is “MacOS X Server”. To fix this issue, you need to change the line in dbstart that starts with “export VER10LIST”. Find the -f5 on that line and change it to -f7.
  
  However, after this change, I still get the insufficient privileges error.
  
  Comment by Ken Heutmaker — September 19, 2009 @ 7:01 pm | Reply
- Regarding comment #12 about not being able to start/stop the database using dbstart and dbshut…
  
  The problem is with “connect / as sysdba” throwing an error:
  ORA-01031: insufficient privileges
  
  I found the ORA-01031 error was caused by the “oracle” user not being in the same OS group as the “oracle” executable so it could not authenticate. I installed the database using the dba group (not oinstall). However, the “oracle” executable we download from raysapps.com was created using the OS group oinstall. After adding the oinstall group to the oracle user then error with “connect / as sysdba” was resolved. The scripts dbshut and dbstart now work as expected without having to hardcode the password.
  
  Comment by RC — October 30, 2009 @ 2:38 am | Reply
  - I can confirm the problem went away by adding user “oracle” to the “oinstall” group:
    
    # dscl . -create /groups/oinstall
    # dscl . -append /groups/oinstall gid 600
    # dscl . -append /groups/oinstall passwd “*”
    # dscl . -append /groups/oinstall GroupMembership oracle
    
    Comment by Lars H — December 5, 2009 @ 7:35 pm
Hard to tel what exactly is wrong. Isn’t there some other Oracle installation which is conflicting with the new one? (This “Warning: Version 10 listener is required for Oracle Database 10g” message seems strange to me – it is shown by $ORACLE_HOME/bin/dbstart script)

Comment by Raimonds Simanovskis — September 17, 2009 @ 11:15 pm | Reply
Hi Raimonds – I only got one installation though.

Comment by mikeT — September 18, 2009 @ 1:07 pm | Reply
Hi,

How will I safely remove the Oracle 10g installation? I would want to reinstall it.

Thanks.

Comment by mikeT — September 18, 2009 @ 1:26 pm | Reply
Delete everything under /Users/oracle as well as delete /etc/oratab file. If you already created /Library/StartupItems/Oracle then delete it as well. And to be safe also reboot :)

When you try again then verify with oracle user that you do not have sqlplus in your PATH. As I wrote it seamed that you have some wrong version of it somewhere else.

Comment by Raimonds Simanovskis — September 18, 2009 @ 5:56 pm | Reply
Hi, Raimonds. I am unable to download the oracle_se.zip file. The process freezes when it reaches approx. 27 Mb (the file is supposed to be 34.7 Mb). I tried both curl and Safari, with no success. Do you know if there is something wrong with either the file and/or the link? Thanks

Comment by Aldo — September 18, 2009 @ 6:45 pm | Reply
Raymonds, please disregard my previous post. I changed to a different ISP and the download worked this time. However, at the moment I execute the netca command I get the following exception:

java.lang.NoSuchMethodError: oracle.net.nl.NLParamParser.setFilePermissions(I)V
at oracle.net.config.Config$ConfigStruct.setNlpa(Unknown Source)
at oracle.net.config.Config.(Unknown Source)
at oracle.net.ca.ConfigureLDAP.initConfig(Unknown Source)
at oracle.net.ca.InitialSetup.setupConfigObjects(Unknown Source)
at oracle.net.ca.InitialSetup.(Unknown Source)
at oracle.net.ca.NetCA.main(Unknown Source)

I have already patched the $ORACLE_HOME/jdk/bin/java script to add the -d32 switch. I have also changed the Java Preferences so 32 bits mode takes precedence over 64 bits mode. No luck. Any suggestions? Thanks!

Comment by Aldo — September 18, 2009 @ 7:57 pm | Reply
- Aldo,
  
  I had the same problem after following the instructions above.
  
  java.lang.NoSuchMethodError: oracle.net.nl.NLParamParser.setFilePermissions(I)V
  at oracle.net.config.Config$ConfigStruct.setNlpa(Unknown Source)
  .
  .
  .
  
  I turned on verbose mode in java and saw that the loaded jar (ojdbc14.jar) on my System caused the problem
  
  [Loaded oracle.net.nl.NLParamParser from file:/Library/Java/Extensions/ojdbc14.jar]
  
  java.lang.NoSuchMethodError: oracle.net.nl.NLParamParser.setFilePermissions(I)V
  at oracle.net.config.Config$ConfigStruct.setNlpa(Unknown Source)
  
  We had an older JDBC driver as part of our configuration (dating to 2005). I replaced the file (with same name ojdbc14.jar) with the one that was installed in my …/product/10.2.0/db_1/jdbc/lib/ and netca and dbca is now working.
  
  There seemed to be some new Java methods added to the later version of the ojdbc.14 jar file.
  
  Hope this helps you or other’s that may have stumbled onto this.
  
  Comment by Danny — November 17, 2009 @ 8:45 pm | Reply
Hi,

I was able to install it successfully.
How will be able to access the dbconsole?

Thanks.

Comment by mikeT — September 20, 2009 @ 12:40 pm | Reply
Hey, Thanks for the post. I would like to know, how to do the following step
Now you need to modify $ORACLE_HOME/jdk/bin/java script and change “…java -Xbootclasspath…” to “…java -d32 -Xbootclasspath…”

Comment by John — September 20, 2009 @ 9:06 pm | Reply
Hi,

I’m getting this error when trying to start dbconsole:

MGLTMacbookPro-2:bin oracle$ . emctl start dbconsole:

-bash: OS: command not found
-bash: OS: command not found
-bash: OS: command not found
-bash: OS: command not found
OC4J Configuration issue. /Users/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_192.168.2.2_yes not found.
MGLTMacbookPro-2:db_1 oracle$ emctl status dbconsole
/Users/oracle/product/10.2.0/db_1/bin/emctl: line 236: OS: command not found
/Users/oracle/product/10.2.0/db_1/bin/emctl: line 242: OS: command not found
/Users/oracle/product/10.2.0/db_1/bin/emctl: line 248: OS: command not found
/Users/oracle/product/10.2.0/db_1/bin/emctl: line 256: OS: command not found
OC4J Configuration issue. /Users/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_192.168.2.2_yes not found.

Any help?

Comment by mikeT — September 21, 2009 @ 12:12 pm | Reply
Had a look at emctl file and found out that in these lines there is fragment Mac OS X without quotes around it and therefore OS is interpreted as shell command :) It seems that this file is autogenerated but unfortunately not adapted for Mac OS X.

And if you will take a look in Oracle 10g release notes for Mac OS X then you will find that Oracle Enterprise Manager Database Control is in the list of unsupported products :(

Comment by Raimonds Simanovskis — September 21, 2009 @ 7:38 pm | Reply
I’m able to install, configure and start up Oracle. My problem is I cannot get pass the isqlplus or isqlplus/dba authentication screan on my web browser. No matter what I do, reset the password for SYS or SYSTEM or use/omit my SID it does not authenticate me. I have restarted both oracle and the listener and reinstalled manay times. I am able to get to SQL> via command line but not via the links. I can’t find any other resources that have this particular problem either.

Comment by Jose — September 21, 2009 @ 11:10 pm | Reply
- Haven’t tried it by myself but just wanted to mention that iSQL*Plus is also in the list of unsupported products of Oracle 10g for Mac OS X release notes.
  
  Comment by Raimonds Simanovskis — September 22, 2009 @ 9:53 am | Reply
Hi.,
I am trying to install oracle database 10g on mac os x snow leopard.

I took help of Raimonds’s document. I configured all steps.

I start installing oracle s/w only it reaches 79% of installation. Now I am getting error “Unable to find make utility in location: /usr/bin/make” and struck.

What may be the reason.

Comment by SD — September 24, 2009 @ 7:57 am | Reply
- If you do not have /usr/bin/make then most probably you have not installed Xcode tools. This is separate installation package located on your Snow Leopard installation DVD.
  
  Comment by Raimonds Simanovskis — September 24, 2009 @ 5:39 pm | Reply
  - @Raimonds,
    
    I had installed xcode separately at the time of installation of snow leopard.
    
    Comment by SD — September 29, 2009 @ 6:45 am
“Open Terminal application and set shell settings in .bash_profile

vi .bash_profile
and enter

export DISPLAY=:0.0
export ORACLE_BASE=$HOME
umask 022
ulimit -Hn 65536
ulimit -Sn 65536
As you see I prefer to install all Oracle related files under home directory of oracle user therefore I am setting ORACLE_BASE to home directory. And also include ulimit settings – I forgot to do this initially and got strange TNS service errors because of that.

Now execute this script so that these settings are applied to current shell:

. ./.bash_profile”

I go the following errors during this step

-bash: ulimit: open files: cannot modify limit: Operation not permitted
-bash: ulimit: open files: cannot modify limit: Invalid argument

please advise…..

Comment by Srinivas — September 25, 2009 @ 5:50 am | Reply
- Have you changed kernel settings and rebooted your computer beforehand? You typically get this error if you try to increase limits to larger values than your kernel supports.
  
  Comment by Raimonds Simanovskis — September 25, 2009 @ 9:16 am | Reply
  - Hi Raimonds,
    
    Thank you for the reply.
    
    I am following the instructions and it asks you to reboot after setting Kernel parameters and creating java symbolic link.
    
    ‘After this reboot your computer so that these new kernel parameters would be taken into effect.
    
    After reboot you need to log in as new “Oracle software owner” user (as now Snow Leopard has stricter control for access to X11 display and therefore I couldn’t manage to start Oracle installation just from terminal).
    ”
    
    Please advise.
    
    Thanks,
    Srinivas
    
    Comment by Srinivas — September 25, 2009 @ 7:15 pm
Hi Raimonds,

Thank you for the reply.

I am following the instructions and it asks you to reboot after setting Kernel parameters and creating java symbolic link.

‘After this reboot your computer so that these new kernel parameters would be taken into effect.

After reboot you need to log in as new “Oracle software owner” user (as now Snow Leopard has stricter control for access to X11 display and therefore I couldn’t manage to start Oracle installation just from terminal).
”

Please advise.

Thanks,
Srinivas

Comment by Srinivas — September 25, 2009 @ 7:14 pm | Reply
Hi.,
I am trying to install oracle database 10g on mac os x snow leopard.

I took help of Raimonds’s document. I configured all steps.

I start installing oracle s/w only it reaches 79% of installation. Now I am getting error “Unable to find make utility in location: /usr/bin/make” and struck.

I installed xcode separately after installation of snow leopard.

can any one suggest what can be a reason ?

Comment by SD — October 1, 2009 @ 7:21 am | Reply
Hi, Can you please tell me,how to do the following step
–Now you need to modify $ORACLE_HOME/jdk/bin/java script and change “…java -Xbootclasspath…” to “…java -d32 -Xbootclasspath…”.–

Comment by John — October 2, 2009 @ 7:14 am | Reply
- Just edit $ORACLE_HOME/jdk/bin/java file :)
  
  Comment by Raimonds Simanovskis — October 2, 2009 @ 9:53 am | Reply
Hello,
I have installed 10g successfully but when I go to create a database through “Database Configuration Assistant” I get a pop up error message.. “ORA-03113: end-of-file on communication channel”, then there are two buttons “Ignore and Abort” If I click either the process ends.
Any ideas?
Thank you.
John McLeod

Comment by John McLeod — October 7, 2009 @ 2:17 pm | Reply
- I am also getting this error message. i have been able to get all the way to running dbca and i run in to this error where it gets “ORA-03113: end-of-file on communication channel”
  
  Comment by Jon Lundy — November 4, 2009 @ 11:22 pm | Reply
Hello Raimonds,

I’ve done all the preliminary steps in your document. When i run ./runInstaller -J-32, the Oracle Universal Intaller appears. When I press the “Next” button, I get the following Oracle error messages, OUI-10035: You do not have permission to write to the inventory location or OUI-10033. Any ideas why this is happening. I’m logged in as the “oracle user” i create in the earlier steps. Thanks, Henry

Comment by henry rivera — October 8, 2009 @ 9:44 pm | Reply
- Doesn’t it say where is inventory location where permissions are missing?
  One option is to try to unset ORACLE_BASE environment variable before starting installer – then it will try to install in default location under oracle user home directory.
  
  Comment by Raimonds Simanovskis — October 9, 2009 @ 2:17 pm | Reply
  - No it doesn’t give any specific information like that. How do I unset the ORACLE_BASE environment?
    
    Comment by henry rivera — October 9, 2009 @ 8:09 pm
  - unset ORACLE_BASE
    
    Comment by Figo Kim — October 19, 2009 @ 5:34 pm
Hey man, this is the best install guide that I have ever used. Worked flawlessly. Thanks!

Comment by Cordell — October 17, 2009 @ 3:32 am | Reply
Hmm, does this mean I mus operate oracle as the oracle user? what If i want to have my normal stuff open that i can access from my normal user, didn’t want to have two users like that.

Comment by John — October 17, 2009 @ 11:01 am | Reply
- It is recommended to have Oracle database server installed in separate “oracle” user account – in this way it is easier to reinstall the whole database if something goes wrong (just delete oracle user and all its home directory content).
  
  If you want to access database from your main user then install Oracle Instant Client or user JDBC driver to access it.
  
  Comment by Raimonds Simanovskis — October 19, 2009 @ 4:52 pm | Reply
How to drop a oracle user and dba group

Comment by Fahim — October 21, 2009 @ 9:35 am | Reply
Hey there!
Thanks for the how-to.
I’m having a little bit of trouble while running the Network Configuration Assistant, output follows:

$ netca

Oracle Net Services Configuration:
Invalid memory access of location 00000014 eip=18033523
/Users/oracle/oracle/product/10.2.0/db_1/jdk/jre/bin/java: line 2: 326 Bus error /System/Library/Frameworks/JavaVM.framework/Versions/1.5.0/Home/bin/java -d32 -Xbootclasspath/a:/Users/oracle/oracle/product/10.2.0/db_1/jdk/jre/lib/ext:/Users/oracle/oracle/product/10.2.0/db_1/jdk/lib/ext $*

I’ve changed the oracle java script to point directly to version 1.5.0 and to use the -d32 option but still can get it to work.
I’ve also tried with java 1.4.2 from leopard I got from the web (oneswarm) and the output is different:

$ netca

Oracle Net Services Configuration:
/Users/oracle/oracle/product/10.2.0/db_1/jdk/jre/bin/java: line 2: 340 Segmentation fault /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home/bin/java -d32 -Xbootclasspath/a:/Users/oracle/oracle/product/10.2.0/db_1/jdk/jre/lib/ext:/Users/oracle/oracle/product/10.2.0/db_1/jdk/lib/ext $*

The first output with 1.5.0 suggests it’s probably trying to run in 64bits even though I explicitly put the -d32 option into it.

Does anyone have a clue what I might be doing wrong?
Is there any way I can skip the network configuration assistant?

Many thanks.

Comment by Pedro Carrico — October 22, 2009 @ 10:44 am | Reply
Hi Raimonds,
I have installed 10g successfully but when I go to create a database through “Database Configuration Assistant” I get a pop up error message.. “ORA-03113: end-of-file on communication channel”.

I Send you the my configuration.
You have a idea ?

Regards and Thanks
Antonio M.

Darwin amusarra-mobile.local 10.0.0 Darwin Kernel Version 10.0.0: Fri Jul 31 22:47:34 PDT 2009; root:xnu-1456.1.25~1/RELEASE_I386 i386

ProductName: Mac OS X
ProductVersion: 10.6.1
BuildVersion: 10B504

Comment by Antonio Musarra — October 26, 2009 @ 11:25 pm | Reply
- Hi Raimonds,
  I send you an extract from the trace file.
  
  /u01/app/oracle/admin/orcl/udump/shirus_ora_386.trc
  Oracle Database 10g Release 10.2.0.4.0 – Production
  ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
  System name: Darwin
  Node name: amusarra-mobile.local
  Release: 10.0.0
  Version: Darwin Kernel Version 10.0.0: Fri Jul 31 22:47:34 PDT 2009; root:xnu-1456.1.25~1/RELEASE_I386
  Machine: i386
  Instance name: SHIRUS
  Redo thread mounted by this instance: 0
  Oracle process number: 0
  Unix process pid: 386, image: oracle@amusarra-mobile.local
  
  Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0×2773fbeb8, PC: [0x107b8d380, joxnfy_()+2763]
  %rax: 0×00000002773fbeb8 %rbx: 0×00000000000003f0 %rcx: 0×000000010904f078
  %rdx: 0×00000000000004e7 %rdi: 0×000000010904f0d2 %rsi: 0×0000000000000000
  %rsp: 0×00007fff5fbfad40 %rbp: 0×00007fff5fbfaf40 %r8: 0×000000010904f0c4
  %r9: 0×0000000000007fff %r10: 0×00000001073bf5a0 %r11: 0×000000010904f0cf
  %r12: 0×0000000000000000 %r13: 0×0000000000000000 %r14: 0×0000000000000000
  %r15: 0×0000000000000000 %rip: 0×0000000107b8d380
  *** 2009-10-26 22:07:25.928
  ksedmp: internal or fatal error
  ORA-07445: exception encountered: core dump [joxnfy_()+2763] [SIGSEGV] [Address not mapped to object] [0x2773FBEB8] [] []
  
  Comment by Antonio Musarra — October 26, 2009 @ 11:43 pm | Reply
Hi, Raimonds,

Your article is great. I followed your instruction step by step and got Oracle installed on Mac Snow Lepord successfully.

The only thing I noticed differently is that I have to start the listener before I can run “sqlplus system@orcl”.

Now I have another question: I want to change the web admin URL to localhost, like http://localhost:4889/em. I tried to change sysman/config/emd.properties. However, I still cannot access that URL after the db start.

Any idea how to fix this?

Thanks,

Bin

Comment by Bin Fan — October 27, 2009 @ 4:17 am | Reply
Further info about my previous post:

I tried to start the EMCA and got following errors:

emctl start dbconsole
/Users/oracle/oracle/product/10.2.0/db_1/bin/emctl: line 236: OS: command not found
/Users/oracle/oracle/product/10.2.0/db_1/bin/emctl: line 242: OS: command not found
/Users/oracle/oracle/product/10.2.0/db_1/bin/emctl: line 248: OS: command not found
/Users/oracle/oracle/product/10.2.0/db_1/bin/emctl: line 256: OS: command not found
OC4J Configuration issue. /Users/oracle/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_new-host.home_orcl not found.

Comment by Bin Fan — October 27, 2009 @ 2:49 pm | Reply
i have a ORA-03113 when i am trying to create a database
my bash_profile :
export ORACLE_BASE=/Volumes/IOMEGA-CLONE/ORACLE_Directory
export ORACLE_HOME=/Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1
export DYLD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_SID=orcl
PATH=$PATH:$ORACLE_HOME/bin
umask 022
ulimit -Hn 10240
ulimit -Sn 10240

my sysctl.conf :
kern.sysv.semmsl=87381
kern.sysv.semmns=87381
kern.sysv.semmni=87381
kern.sysv.semmnu=87381
kern.sysv.semume=10
kern.sysv.shmmax=33554432
kern.sysv.shmmin=1
kern.sysv.shmmni=256
kern.sysv.shmseg=64
kern.sysv.shmall=8192
kern.maxfiles=12288
kern.maxfilesperproc=10240
net.inet.ip.portrange.first=49152
net.inet.ip.portrange.last=65535
kern.corefile=/cores/core.%P
kern.maxproc=1024
kern.maxprocperuid=512

and i found this crash …
Process: oracle [866]
Path: /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/bin/oracle
Identifier: oracle
Version: ??? (???)
Code Type: X86-64 (Native)
Parent Process: ??? [1]

Date/Time: 2009-10-27 14:04:25.069 +0100
OS Version: Mac OS X 10.6.1 (10B504)
Report Version: 6

Exception Type: EXC_BAD_ACCESS (SIGABRT)
Exception Codes: KERN_INVALID_ADDRESS at 0×0000000000000000
Crashed Thread: 0 Dispatch queue: com.apple.main-thread

Thread 0 Crashed: Dispatch queue: com.apple.main-thread
0 libSystem.B.dylib 0×00007fff86ec2ff6 __kill + 10
1 oracle 0×000000010162f56a slcra + 1293
2 oracle 0×000000010163bea6 ssexhd + 1586
3 libSystem.B.dylib 0×00007fff86ed50aa _sigtramp + 26
4 ??? 0×00007fff5fbfb410 0 + 140734799787024
5 oracle 0×00000001017f4397 joxnfy + 42
6 oracle 0×0000000103cedb85 kscnfy + 834
7 oracle 0×0000000103eb53f1 ksmcpg + 69
8 oracle 0×0000000103e1874a ksucrp + 863
9 oracle 0×00000001017b221b opistr_real + 4141
10 oracle 0×00000001017b2e1e opistr + 1124
11 oracle 0×00000001017c8050 opiodr + 4976
12 oracle 0×0000000104af2747 ttcpip + 13847
13 oracle 0×000000010178e90a opitsk + 6019
14 oracle 0×00000001017a28cb opiino + 4032
15 oracle 0×00000001017c8050 opiodr + 4976
16 oracle 0×000000010177e2f1 opidrv + 1642
17 oracle 0×000000010162f6a1 sou2o + 139
18 oracle 0×00000001000017e2 opimai_real + 215
19 oracle 0×000000010000164f main + 147
20 oracle 0×00000001000015b4 start + 52

Thread 0 crashed with X86 Thread State (64-bit):
rax: 0×0000000000000000 rbx: 0×00000001089fff48 rcx: 0×00000001089ff348 rdx: 0×0000000000000000
rdi: 0×0000000000000362 rsi: 0×0000000000000006 rbp: 0×00000001089ff9f0 rsp: 0×00000001089ff348
r8: 0×0000000000000000 r9: 0×0000000000000000 r10: 0×00007fff86ebf036 r11: 0×0000000000000206
r12: 0×0000000000000000 r13: 0×0000000000000000 r14: 0×0000000000000000 r15: 0×0000000000000000
rip: 0×00007fff86ec2ff6 rfl: 0×0000000000000206 cr2: 0×0000000121932000

Binary Images:
0×100000000 – 0×1071b2fe7 +oracle ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/bin/oracle
0×107899000 – 0×107899fff +libodm10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libodm10.dylib
0×10789c000 – 0×1078c0ffb +libskgxp10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libskgxp10.dylib
0×1078c5000 – 0×1079aafff +libhasgen10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libhasgen10.dylib
0×1079d8000 – 0×1079d8fff +libskgxn2.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libskgxn2.dylib
0×1079db000 – 0×107a40fff +libocr10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libocr10.dylib
0×107a4e000 – 0×107a8dffc +libocrb10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libocrb10.dylib
0×107a99000 – 0×107afefff +libocrutl10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libocrutl10.dylib
0×107b0f000 – 0×1082dbfff +libjox10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libjox10.dylib
0×108485000 – 0×10848bfff +libclsra10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libclsra10.dylib
0×10848f000 – 0×1084a1fff +libdbcfg10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libdbcfg10.dylib
0×1084a4000 – 0×10862efe7 +libnnz10.dylib ??? (???) /Volumes/IOMEGA-CLONE/ORACLE_Directory/oracle/product/10.2.0/db_1/lib/libnnz10.dylib
0×7fff5fc00000 – 0×7fff5fc3bdef dyld 132.1 (???) /usr/lib/dyld
0×7fff82c2e000 – 0×7fff82c32ff7 libmathCommon.A.dylib ??? (???) /usr/lib/system/libmathCommon.A.dylib
0×7fff86e74000 – 0×7fff87032ff7 libSystem.B.dylib ??? (???) /usr/lib/libSystem.B.dylib
0×7fffffe00000 – 0×7fffffe01fff libSystem.B.dylib ??? (???) /usr/lib/libSystem.B.dylib

Comment by mignard olivier — October 27, 2009 @ 3:13 pm | Reply
Great post Ray. It helped me alot. I followed you post step by step and everything worked smoothly.

Comment by Cosnita Radu — October 29, 2009 @ 11:31 am | Reply
I followed your instruction step by step and got Oracle installed.

Thanks!!

Comment by soo — October 31, 2009 @ 4:01 pm | Reply
Your instructions worked flawlessly on a clean install of Snow Leopard (64 bit).

Comment by Frank — November 3, 2009 @ 2:28 am | Reply
Does anyone have this step by step? I cannot get this to work correctly?

Comment by P.Symonds — November 3, 2009 @ 9:59 pm | Reply
That’s the same message I get. Did you create a new volume? If so I think it might be a reference to oracle home that’s incorrect. I gabby had enough time to look further into this.

Comment by Paul Symonds — November 5, 2009 @ 8:04 am | Reply
I am also getting the “ORA-03113: end-of-file on communication channel” error when running the DCA on Snow Leopard 10.6.1, XCode 3.2 and JDK 1.6.

Anyone had luck in solving this error? It is preventing me from running Oracle :(

Comment by Antonio Saraiva — November 11, 2009 @ 7:56 pm | Reply
Just replaced my oracle binary with the one you provided and now I am able to get past the DCA stage :)

Thank you!

By the way, any idea why we are having those errors when compiling oracle in SL? Maybe there is something else I could try to understand better.

Thank you.

Comment by Antonio Saraiva — November 11, 2009 @ 9:13 pm | Reply
Hi,
Please if you can help

david-nahmiass-macbook:Install oracle$ ./runInstaller -J-d32
You do not have sufficient permissions to access the inventory ‘/Volumes/u01/app/oracle/oraInventory’. Installation cannot continue. Make sure that you have read/write permissions to the inventory directory and restart the installer.: Permission denied

Comment by David Nahmias — November 15, 2009 @ 1:02 pm | Reply
I get this error

Wed Nov 18 09:34:09 david-nahmiass-macbook.local java[935] : kCGErrorFail
ure: Set a breakpoint @ CGErrorBreakpoint() to catch errors as they are logged.
Can’t connect to window server – not enough permissions.
:0.0
:0.0
OUI-10025:Unable to start an interactive install session because of the followin
g error:Can’t connect to window server – not enough permissions. The DISPLAY env
ironment variable should be set to :, where the
is usually ‘0.0′.
OUI-10026:Depending on the Unix Shell, you can use one of the following commands
as examples to set the DISPLAY environment variable:
- For csh: % setenv DISPLAY 192.168.1.128:0.0
- For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
echo $SHELL
Use the following command to view the current DISPLAY environment variable setti
ng:
echo $DISPLAY
- Make sure that client users are authorized to connect to the X Server.
OUI-10027:To enable client users to access the X Server, open an xterm, dtterm o
r xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 based
program that comes with the native operating system such as ‘xclock’:
%
If you are not able to run xclock successfully, please refer to your PC-X Server
or OS vendor for further assistance.
Typical path for ‘xclock’: ”

Comment by David Nahmias — November 18, 2009 @ 4:38 pm | Reply
I’m having the following error when I try to finish creating the database by the command “dbca”:
“There is an error in creating the following process: /Users/oracle/oracle/product/10.2.0/db_1/bin/sqlplus -S /NOLOG
The error is:
Cannot run program
/Users/oracle/product/10.2.0/db_1/bin/sqlplus: error=86, Bad CPU type in executable”

Please, any idea? Help

Tks

Comment by Fabiano — November 20, 2009 @ 3:51 pm | Reply
Hello, i follow your instruction and all it’s OK. But i need to install Oracle Http Server and i don’t see it. Please help me?

Comment by juliengarcia — December 1, 2009 @ 11:32 am | Reply
- See http://download.oracle.com/docs/cd/B19306_01/relnotes.102/b25285/toc.htm#BABIJEFG
  
  Oracle HTTP server is not supported on Mac OS X.
  
  Comment by Raimonds Simanovskis — December 1, 2009 @ 1:46 pm | Reply
Is this tutorial only for the installation of Oracle on Mac OS X SL or Mac OS X SL Server? Or both?
Why do I keep getting the same error when trying to finish a creation of the database by the command “DBCA”? A window appears with the following message:
“There is an error in creating the following process: /Users/oracle/oracle/product/10.2.0/db_1/bin/sqlplus -S /NOLOG
The error is:
Cannot run program
/Users/oracle/product/10.2.0/db_1/bin/sqlplus: error=86, Bad CPU type in executable”.
And I can not do anything else. Unless close the application.

HELP ME! Please!

Comment by Fabiano Frota — December 1, 2009 @ 3:25 pm | Reply
Hi Ray, great docu how to install Oracle on mac. It was very helpful for me, but i still have a problem. Its regarding Oracle SQL Developer, which i know, was not the topic,but … I was trying to use it for developing under MAC, but i get this error “ORA-17410: No more data to read from socket ” when i try to connect to my database on localhost. Firstly i was thinking, that this is problem with java but now, i think, that this is caused because of “DEDICATED” server. What do you think ? I was trying to setup “shared server” but this dont look good. So what i wanted to tell :-) Have you got any errors when you was trying to connect to your db with newest version(1.5.5.) as it is settled here in this “manual” ? With using dedicated server ? Thank you for your answers and im sorry for my english :-)

Comment by oraclefreek — December 7, 2009 @ 4:52 pm | Reply
- I am now using latest SQL Developer 2.1 RC1 on Mac and it has no problems with connecting to local database server in dedicated server mode.
  
  Comment by Raimonds Simanovskis — December 7, 2009 @ 7:34 pm | Reply
  - Hmm, still not working :-( I have one more question, if it doesnt help, i will try to find other way :-) My oracle instance is PRD and im using hostname as localhost, port which is used 1521 as usuall but what i was wondering, is SID which is according to listner PLSExtProc. I use this setup when i get the error. Do you use please this settings, or are this settings correct set for your example installation ? Aha, sorry another question. I was looking for sample schema for 10g, but they are not in directory demo after installation. Where can i donwnload them ? According some forums on net, there should be another installation disk with these schema.
    thank you for answer
    
    Comment by oraclefreek — December 7, 2009 @ 8:57 pm
Still having the same doubt. As installed Oracle tutorial ene my Mac Book Pro with Mac OS X 10.6.2 installed. But I can not create the database by the DBCA command. Again I ask, this tutorial is only for Mac OS X Server?
Another question. With the update of Java pra Mac OS X. How will the installation now? From what I saw, now we have the Java 1.6 on Mac OS.
A window appears with the following message:
“There is an error in creating the following process: /Users/oracle/oracle/product/10.2.0/db_1/bin/sqlplus -S /NOLOG
The error is:
Cannot run program
/Users/oracle/product/10.2.0/db_1/bin/sqlplus: error=86, Bad CPU type in executable”.

Please Simanovskis, helpe me.

Tanks

Comment by Fabiano Frota — December 8, 2009 @ 1:31 am | Reply
Great instruction!
I almost finish the installing, yes, every thing goes well except the error 03113.
Thank you any way.
Snow Leopard:10.6.2

Comment by Alan — December 10, 2009 @ 9:04 pm | Reply
Installed and running on my MacBook Pro running Snow Leapord 10.6.2.
Had a few glitches, but only because I didn’t follow the instructions close enough.
Thanks for sharing!!!

Comment by John — December 11, 2009 @ 9:25 pm | Reply
I can not conect with other user just with Oracle owner and i need rmejiac user, what do i need to do?

Comment by Robert — December 14, 2009 @ 1:37 am | Reply
I successfully created database after download the ZIP file you provided.
I can’t tell you how exciting I was when the problem was fixed.
Thank you very much !

Comment by Alan — December 14, 2009 @ 4:07 pm | Reply
I have installed oracle as well and I have received the “ORA-03113: End-of-file on communication channel” error. After this error, I received an “ORA-03114: Not connect to Oracle” error also.

Thank you for any tips to resolve this.
JohnM

Comment by John McLeod — December 14, 2009 @ 4:53 pm | Reply
- This occurs while trying to create the first database using “dbca”
  
  JohnM
  
  Comment by John McLeod — December 14, 2009 @ 4:54 pm | Reply
Hi!!! I am getting the following comment when I execute the following task:

now execute this script so that these settings are applied to current shell:

. ./.bash_profile

-bash: ./.bash_profile: No such file or directory.

Under my oracle user account I have the following file

I am using TextWrangler to make sure all files are created correctly, no idea why the error message.

Comment by Ricky Ponte — December 16, 2009 @ 8:01 am | Reply
Thank you for your excellent work…..

But there is a problem in my MBP.

During the pre-installation, and when I tried to log as “oracle” user (su – oracle), I type the password, but I always log as “root” user. So I can’t complete the installation…..

Any ideas?

Comment by Dimitrios — December 25, 2009 @ 5:24 pm | Reply
“Switch back to Terminal tab with oracle user and add the following lines to .bash_profile of oracle user:”

Hi.

I dont know how to switch back to terminal with oracle user, and also how to find .bash_profiler…

please help me… im really stuck here…

Comment by Ehsan — December 29, 2009 @ 3:49 pm | Reply
Hi Raimonds,

This was working SPECTACULARLY until I got to the part where I had to download the db file to /var/root/Install. Since my background in Unix is super… Nonexistent, I ended up moving the file from my desktop to the directory. Which seemed to work fine. When it came to running it, I got this:

Khayra-Bundakjis-iMac:Disk1 root# ./runInstaller -J-d32
Starting Oracle Universal Installer…

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-01-15_05-17-25PM. Please wait …
The user is root. Oracle Universal Installer cannot continue installation if the user is root.
: No such file or directory

So I figured since it isn’t working from the root user, I could just install it normally from the desktop where I already had a copy of db. This happened:

Khayra-Bundakjis-iMac:~ oracle$ /Users/oracle/Desktop/db/Disk1/runInstaller ; exit;
Starting Oracle Universal Installer…

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-01-15_05-20-24PM. Please wait …logout

[Process completed]

I know, super-newbies are annoying when they try to do simple things, but bear with me please.

Thank you <3

Comment by Khayra — January 15, 2010 @ 4:25 pm | Reply
Ray,

I gave up twice, then I decided to try one more time.
Your zip file replacement, plus your detailed instructions did the trick.
Now I don’t have to run an XP virtualbox on my mini.
I appreciate the effort you made to put this info onto the web.
You’re a good man.

Cheers

Ian
Sydney

Comment by Ian — January 16, 2010 @ 3:19 am | Reply
Ray,

I just wanted to thank you for all of your analysis and hard work.

Regards,
Cliff

Comment by Cliff Buetikofer — January 17, 2010 @ 3:10 pm | Reply
I got it!
You make the world a better place <3

Comment by Khayra — January 20, 2010 @ 12:11 pm | Reply
It was working so well…

ERROR:
ORA-12541: TNS:no listener

Why? Where did the listener go? :(

Comment by Khayra — January 20, 2010 @ 7:36 pm | Reply
I was inspired by the excellent tutorial by Raimonds to create my article: Mac OS X Snow Leopard: PHP 5.3 + OCI8 (http://musarra.wordpress.com/2009/10/29/mac-os-x-snow-leopard-php-5-3-oci8/)

Thank you very much
Antonio M.

Comment by Antonio Musarra — January 22, 2010 @ 6:49 pm | Reply
Raimond,

Thanks for the tutorial, only one question, change in the
netca and netca line JREDIR=/Users/oracle/oracle/product/10.2.0/db_1/jdk/jre for JREDIR=/Users/oracle/oracle/product/10.2.0/db_1/jdk

Julian

Comment by jdarknet — January 23, 2010 @ 3:18 pm | Reply
Thank you!

Alex

Comment by Alexandros Matsopoulos — January 25, 2010 @ 12:01 am | Reply
hi,

Thank for the detailed installation document for oracle on snow leopard for which I was waiting. As per the instructions, I installed the oracle, but at the end of the installation the following error has occurred so kindly assist me on that,

Output generated from configuration assistant “Oracle Net Configuration Assistant”:
Command = /users/oracle/oracle/product/10.2.0/db_1/bin/netca /orahome /users/oracle/oracle/product/10.2.0/db_1 /orahnam OraDb10g_home1 /instype typical /inscomp client,oraclenet,javavm,server,ano /insprtcl tcp /cfg local /authadp NO_VALUE /nodeinfo NO_VALUE /responseFile /users/oracle/oracle/product/10.2.0/db_1/network/install/netca_typ.rsp
UnsatisfiedLinkError exception loading native library: njni10

Configuration assistant “Oracle Net Configuration Assistant” failed
—————————————————————————–
The “/users/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/configToolFailedCommands” script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.—————————————————————————–Output generated from configuration assistant “Oracle Net Configuration Assistant”:
Command = /users/oracle/oracle/product/10.2.0/db_1/bin/netca /orahome /users/oracle/oracle/product/10.2.0/db_1 /orahnam OraDb10g_home1 /instype typical /inscomp client,oraclenet,javavm,server,ano /insprtcl tcp /cfg local /authadp NO_VALUE /nodeinfo NO_VALUE /responseFile /users/oracle/oracle/product/10.2.0/db_1/network/install/netca_typ.rsp

Configuration assistant “Oracle Net Configuration Assistant” failed
—————————————————————————–
The “/users/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/configToolFailedCommands” script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.—————————————————————————–Output generated from configuration assistant “Oracle Net Configuration Assistant” (attempt 2):
Command = /users/oracle/oracle/product/10.2.0/db_1/bin/netca /orahome /users/oracle/oracle/product/10.2.0/db_1 /orahnam OraDb10g_home1 /instype typical /inscomp client,oraclenet,javavm,server,ano /insprtcl tcp /cfg local /authadp NO_VALUE /nodeinfo NO_VALUE /responseFile /users/oracle/oracle/product/10.2.0/db_1/network/install/netca_typ.rsp

Configuration assistant “Oracle Net Configuration Assistant” failed
—————————————————————————–
The “/users/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/configToolFailedCommands” script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.—————————————————————————–Output generated from configuration assistant “Oracle Net Configuration Assistant” (attempt 3):
Command = /users/oracle/oracle/product/10.2.0/db_1/bin/netca /orahome /users/oracle/oracle/product/10.2.0/db_1 /orahnam OraDb10g_home1 /instype typical /inscomp client,oraclenet,javavm,server,ano /insprtcl tcp /cfg local /authadp NO_VALUE /nodeinfo NO_VALUE /responseFile /users/oracle/oracle/product/10.2.0/db_1/network/install/netca_typ.rsp

Configuration assistant “Oracle Net Configuration Assistant” failed
—————————————————————————–
The “/users/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/configToolFailedCommands” script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.—————————————————————————–Output generated from configuration assistant “Oracle Net Configuration Assistant” (attempt 4):
Command = /users/oracle/oracle/product/10.2.0/db_1/bin/netca /orahome /users/oracle/oracle/product/10.2.0/db_1 /orahnam OraDb10g_home1 /instype typical /inscomp client,oraclenet,javavm,server,ano /insprtcl tcp /cfg local /authadp NO_VALUE /nodeinfo NO_VALUE /responseFile /users/oracle/oracle/product/10.2.0/db_1/network/install/netca_typ.rsp

Configuration assistant “Oracle Net Configuration Assistant” failed
—————————————————————————–
The “/users/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/configToolFailedCommands” script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.

Comment by vijay bhaskar — January 31, 2010 @ 8:06 am | Reply
Thanks for an excellent step by step. I followed it and was able to create working standard edition with no problem on snow leopard. I tried during the dbca configuration to reduce the number of processes to 75. Reverted to the default of 150 when I got failures during instance creation. Even the automatic startup instructions worked flawlessly for me.

Comment by Tony — February 4, 2010 @ 8:38 am | Reply
I think I may have found the answer for the “/Users/oracle/product/10.2.0/db_1/bin/sqlplus: error=86, Bad CPU type in executable” errors …

It’s not mentioned in the instructions anywhere, but an oracle database must be run on a 64-bit processor, not a 32-bit processor … Unfortunately, probably a lot of the people getting the error have an Intel computer, but not one with a 64-bit processor …

As an example, I have a Mac mini with an “Intel Core Duo” processor … This processor can’t run 64-bit programs …

If your processor type (look in “About This Mac” under your “Apple” menu) has the words “Intel Core Duo” or “Intel Core Solo”, you won’t be able to install Oracle on your computer … If your processor type has the words “Core 2 Duo” in it, you can install Oracle …

Which means that, since I got all the way down to the Database Configuration Assistant step before failing, I need to figure out how to uninstall all of this … Any suggestions?

Comment by Brad — February 8, 2010 @ 11:12 pm | Reply
Raimonds – Thank you for taking the time to prepare this excellent blog – with a few minor bumps along the way I was able to install 10g on Snow Leopard. One question I have if you find the time is in regard to the Hard&Soft file limits in the bash_profile.. I was unable to set these above 15000; every version of the installations I have read state they should be >60k. I am not sure why this is, and secondly if this is necessary why do you think Its not possible for me?

Again thank you for your excellent contributions..

Comment by Barry — February 10, 2010 @ 1:10 am | Reply
Great tutorial ..thankyou your issues ..

Comment by akin.temel — February 10, 2010 @ 5:06 pm | Reply
Could there be a reason why can’t execute the following command
. ~/.bash_profile
I am receiving a file not in directory response.
Thanks;
Ricky

Comment by Ricky — February 10, 2010 @ 9:22 pm | Reply
Raimonds, below are a couple improvements to your snow leopard oracle 10g install blog:
1) Although /etc/sysctl.conf sets kern.maxproc=2068 and kern.maxprocperuid=2068 at boot, launchctl sets a maxproc hard limit of 532. The following command shows the launchctl settings which are inherited by all children processes:
# launchctl limit (system wide)
$ launchctl limit (for the current user)
When terminal.app is used, the shell ulimit ‘ulimit -u’ cannot be set to 2068 as it is limited to the launchctl maxproc hard limit. To solve this. The following entry needs to be put in /etc/launchd.conf:
limit maxproc 2068
The system then must be rebooted for this setting to take effect. I have not figured out how to have the change take effect without a reboot.

After a reboot ‘ulimit -u’ will be 2068.

2) You can then run the oracle oui from the terminal without logging into the “Oracle Software User” from the gui login screen. Below are the steps to run the oui from a terminal when logged in as an admin user:

$ sudo -H -u oracle -i (enter the admin account password at the password prompt if prompted)
Make your modifications to .bash_profile and source them into the current environment.
$ cd
$ ./runInstaller -J-d32

PS: DISPLAY is inherted from the admin user with this login. DISPLAY is not used by the oracle oui. If X were needed, it is possible to make X work by using xauth and changing the DISPLAY socket permissions, but since it is not needed here I have not supplied the steps for this.

Thanks for your documenting this, it was helpful.

Comment by Doug — February 15, 2010 @ 6:50 am | Reply
I just had to say thank you so much for this guide, I got stuck at the very beginning (JDK issue on Snow Leopard) and would have never gotten past the core dumps on the oracle executable.

Comment by Eric Sarjeant — February 17, 2010 @ 11:09 pm | Reply
Hi Raimonds,

Thank you for the post. I got it running on OS X 10.6.2 Build 10C540 without much trouble.

But when I try to start the Oracle startup script I get:

“oracle is not in the sudoers file”

Any idea why I’m getting it when nobody else has??

Thanks,

Angelo

Comment by Angelo Corbo — February 19, 2010 @ 7:49 pm | Reply
- Hi Angelo
  I am also getting the same error.
  Did you resolve the situation at your end?
  
  thanks
  Ilango
  
  Comment by ilango gurusamy — February 22, 2010 @ 8:16 pm | Reply
  - Sorry Ilango,
    
    I haven’t had the time this week to reasearch it, but I’ll reasearch it a bit more, to try unlocking this problem. If I find a good solution I’ll post it here.
    
    Thanks,
    
    –angelo
    
    Comment by Angelo Corbo — February 25, 2010 @ 5:33 am
I have a question about the following:

sudo /Library/StartupItems/Oracle/Oracle start — This works fine but after reboot your the Oracle database will not start automatically? What is strange is that it was working but then it stopped. All scripts are in place as per instructions. Can anyone give me any pointers?

Comment by Paul — February 20, 2010 @ 11:16 pm | Reply
Hello,

Im having problems changing the kernel parameters. when Im in terminal it has rows of “~” then –insert– at the bottom, how do I submit changes to the kernel parameters?

Comment by Ryan — March 4, 2010 @ 5:59 am | Reply
Of note, I had an issue with starting this up due to my oraInst.loc pointing to my normal user (rather than the oracle installer user).

This file sits in /private/var/opt/oracle/ on my mac. You may need to change this from your user to the oracle user you created to install this.

Comment by Luke van der Hoeven — March 8, 2010 @ 10:50 pm | Reply
Awesome guide. Installed on a new imac with snow leopard. I can use sqlplus to connect to my database. Everything worked as the guide indicated.

Comment by gman — March 10, 2010 @ 6:14 am | Reply
Install ran fine, but…

when i attempt to launch netca, or dbca for that matter, I get the following error:

Exception in thread “main” java.lang.NoClassDefFoundError: assistansCommon
Caused by: java.lang.ClassNotFoundException: assistansCommon
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:315)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:330)
at java.lang.ClassLoader.loadClass(ClassLoader.java:250)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:398)

I’ve followed the details on regressing java. Any ideas on what stupid user error i am committing?

Comment by martin — March 10, 2010 @ 6:42 am | Reply
Hi Mr.Ray,

thanks for your great tutorial. I’ve already followed it and successfully install Oracle on my MacOSX Snow Leopard. And, btw, I quote this tutorial at my blog, and add some personal touch from myself. But, the big part of the tutorial is yours to take the credit. Thanks alot.

Comment by Reza Lesmana — March 10, 2010 @ 5:16 pm | Reply

RSS feed for comments on this post.

	Reza Lesmana on How to install Oracle Database…
	martin on How to install Oracle Database…
	gman on How to install Oracle Database…
	Luke van der Hoeven on How to install Oracle Database…
	Raimonds Simanovskis on ruby-plsql 0.4.2 – bette…

ray_apps_blog

September 14, 2009