Oracle 11g free download - Oracle 10g, OpenLink Lite Edition ODBC Driver for Oracle 10g, Apple Mac OS Update 8.6, and many more programs.
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. Oracle and Apple Announce OpenJDK Project for OSX. Oracle and Apple announced the OpenJDK project for Mac OS X. Apple will contribute most of the key components, tools and technology required for a Java SE 7 implementation on Mac OS X, including a 32-bit and 64-bit HotSpot-based Java virtual machine, class libraries, a networking stack and the foundation for a new graphical client.
April 12, 2009
How to install Oracle Database 10g on Mac OS X Intel
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.
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
Oracle 10g Database Home Page
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:
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:
Oracle Database 10g For Mac Os X 10.10
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
- 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