Oracle Database 10g For Mac Os X

  • Oracle Database 11g Release 2. Standard Edition, Standard Edition One, and Enterprise Edition. 7/13: Patch Set 11.2.0.4 for Linux and Solaris is now available on support.oracle.com.Note: it is a full installation (you do not need to download 11.2.0.1 first).
  • Oracle Database 10g and Oracle JDeveloper 10g Are Now Shipping. With the certification of Oracle Database 10g on Mac OS X Server and Oracle JDeveloper 10g on Mac OS X, Oracle and Apple deliver a flexible, affordable and easy-to-manage enterprise database platform that is ideal for developing and deploying grid computing solutions. Here are major reasons to develop and deploy Oracle Database.

April 12, 2009

How to install Oracle Database 10g on Mac OS X Intel

Oracle 10g database home page

UPDATE: Created instructions how to install Oracle 10g on Mac OS X Snow Leopard

Couple days ago Oracle developers on Mac OS X received Easter present – finally Oracle Database 10g was released for Mac OS X 10.5 Intel platform. This download includes installation guide for Mac OS X but as any Oracle installation guide it is quite long and contains a lot of unnecessary information for first time install as well as does not contain some necessary information.

Therefore I am posting here my shorter tutorial how to install it. And this tutorial is targeted to developers who want to install local Oracle database for development needs on their MacBook, iMac or Mac Pro.

Initial preparation

If you are a developer then I suppose you already have Xcode tools installed which are required also for Oracle installation. And I tried these steps on Mac OS X latest version 10.5.6.

Oracle Database 10g Release 2, Oracle SQL Developer, and Oracle JDeveloper are fully certified on Mac OS X. Turn your Mac into a full-fledged development environment and deploy Xserve-based grids. Oracle latest versions are not available for MAC OS. The last available version for direct MAC OS is Oracle 10G. Having said that, it is not really impossible to have Oracle database on MAC. Install a VM in MAC and get your databas.

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

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):

Change password for oracle user:

Change default kernel parameters:

and enter values recommended by Oracle:

After this reboot your computer so that these new kernel parameters would be taken into effect. After reboot open again Terminal and now login as oracle user:

Set shell settings in .bash_profile

and enter

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:

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

Now you are ready to start installation:

Installation

In installation wizard I selected the following options:

  • Advanced Installation – so that I can change some default options
  • Standard Edition – as I don’t need additional features of Enterprise Edition
  • Create Database / General Purpose
  • Global database name: orcl, SID: orcl
  • Character set: UTF-8 AL32UTF8
  • Create database with sample schemas
  • Selected “Use the same password for all the accounts” – do not specify default “manager” password as it will not be allowed :)
  • Password Management – selected this to unlock necessary sample accounts (e.g. HR schema account that I use as default test schema)

At the end of installation you will be instructed to run one shell script from root.
Hopefully installation will complete successfully.

Additional oracle user settings

If you will use oracle user later then add the following lines to .bash_profile of oracle user:

After this relogin as oracle user and verify listener status:

and if it is down then start it with

and verify if you can connect to Oracle database with sample user (that I unlocked during installation)

If it fails then do some investigation :)

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:

and change the contents of the file to:

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

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:

Oracle 10g download

and enter the following:

and then make this script executable

and in addition create properties file:

with the following contents:

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

to stop the database and

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:

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 Db 10g Free Download

  • 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
  • If you would like to use PHP then you can check out this tutorial

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

Possibly related posts (automatically generated)

  • Sep 14, 2009 » How to install Oracle Database 10g on Mac OS X Snow Leopard
  • Jul 21, 2009 » Initial version of DataMapper Oracle adapter
  • Mar 11, 2013 » 7 things that can go wrong with Ruby 1.9 string encodings

Oracle 10g Database Home Page