ray_apps_blog

September 14, 2009

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

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

sl_oracle.jpgOracle 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:

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

Possibly related posts: (automatically generated)

96 Comments »

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. Hi Raimonds – I only got one installation though.

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

  15. 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

  16. 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

  17. 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

  18. 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

  19. 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

  20. 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

  21. 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

  22. 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

  23. 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

  24. 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

  25. “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

  26. 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

  27. 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

  28. 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

  29. 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

  30. 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

  31. 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

  32. 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

  33. How to drop a oracle user and dba group

    Comment by Fahim — October 21, 2009 @ 9:35 am | Reply

  34. 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

  35. 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

  36. 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

  37. 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

  38. 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

  39. 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

  40. I followed your instruction step by step and got Oracle installed.

    Thanks!!

    Comment by soo — October 31, 2009 @ 4:01 pm | Reply

  41. Your instructions worked flawlessly on a clean install of Snow Leopard (64 bit).

    Comment by Frank — November 3, 2009 @ 2:28 am | Reply

  42. 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

  43. 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

  44. 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

  45. 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

  46. 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

  47. 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

  48. 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

  49. 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

  50. 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

  51. 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

  52. 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

  53. 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

  54. 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

  55. 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

  56. 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

  57. 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

  58. 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

  59. 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

  60. “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

  61. 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

  62. 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

  63. 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

  64. I got it!
    You make the world a better place <3

    Comment by Khayra — January 20, 2010 @ 12:11 pm | Reply

  65. 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

  66. 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

  67. 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

  68. Thank you!

    Alex

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

  69. 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

  70. 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

  71. 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


RSS feed for comments on this post.

Leave a comment

Blog at WordPress.com.