- Java Oracle Download For Mac
- Java Download For Mac Os X Yosemite
- Music Download For Mac
- Download Manager For Mac
September 14, 2009
How to install Oracle Database 10g on Mac OS X Snow Leopard
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. Apr 15, 2004 Re: Oracle 10g for Mac OS X Ronald Rood Apr 15, 2004 7:30 AM ( in response to fblindhe ) I hope not it's only for 64 bits but the chance exists. Don't forget that solaris and windows both still have 32 bits versions. Sign into Cloud. Access your cloud dashboard, manage orders, and more. Sign Up—Free Trial. The Easiest Way to Install Oracle Database on Apple macOS / OS X. Fortnite battle royale free download for mac. Using the 'Easy Connect' hostname/service_name form, I can simply use 'localhost' as if the database was on OS X: cjones@mac:~$ sqlplus cj/welcome@localhost/orcl. Easy to install Instant Client bundle. Download the Oracle Instant Client Basic, SDK and SQL*Plus ZIP files.
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 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:
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:
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:
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
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. 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:
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.
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:![Oracle Oracle](/uploads/1/3/3/9/133911061/962570277.jpg)
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):
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:
and execute it
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 :)
(If you installed Oracle Enterprise Edition then please substitute
oracle_se.zip
with oracle_ee.zip
)Now you can run Network Configuration Assistant
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
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
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.:
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:
and change it 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
Java Oracle Download For Mac
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 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.
Possibly related posts (automatically generated)
- Apr 12, 2009 » How to install Oracle Database 10g on Mac OS X Intel
- Mar 11, 2013 » 7 things that can go wrong with Ruby 1.9 string encodings
- Aug 27, 2007 » How to setup Ruby and Oracle client on Intel Mac
One of the great benefits to having an application developed on the Java platform is the ability to run it on many different operating systems. While Windows may still be the corporate standard in more shops than not, geeks worldwide know that Apple’s hardware and OS (OS X) are ‘superior.’ With yesterday’s release of Mountain Lion (10.8) I figured this was a good time to do a quick write-up on how to get started with SQL Developer on your [i]Mac[Book|Mini].
But wait, where is the Java?
The Java runtime that had been included with the OS X installs is no longer available in Mountain Lion. As I understand it, even if you had installed your own version of Java, when you upgrade or install 10.8, they will go away.
So if you try to run a previously installed version of SQL Developer, you won’t get very far. Java applications don’t run very well sans Java, tsk, tsk.
So for the n00bs out there (including me), here’s your
Step-By-Step Guide for Installing Java and SQL Developer
Let’s install Java first.
Getting to the download page is your first task. I’ll make it easy for you.
* Yes, I know we officially support 1.6 and not 1.7, but here’s a secret: 1.7 works just fine in version 3.2.20_09 of SQL Developer!
Once it’s downloaded, double-click it.
But wait! Oh no!
Open your preferences, go to the security panel, and select the unsigned software option
Now, we’re cooking with gas! https://badrenew942.weebly.com/blog/which-nord-vpn-to-download-for-mac. Try double-clicking the download again.
It should go without a hitch. If it does, you’ll see something like this:
Make sure the ‘right’ java is setup and working.
Open a terminal, and run
[text]
java -version
[/text]
java -version
[/text]
If you see ANYTHING but the following…
https://badrenew942.weebly.com/blog/samsung-ml-2250-printer-driver-download-for-mac. …you may have a problem.
But this is Apple and OS X, and so it will find Java just fine.
Ok, now we can worry about downloading and installing SQL Developer.
Java Download For Mac Os X Yosemite
Go here and download ‘Oracle SQL Developer for Mac OSX platforms.
Once it’s downloaded, you’ll need to extract it and run it.
Wait a second…
You know it’s going to ‘work’ if you see the splash screen 🙂
But My SQL Developer is Using the Wrong JDK!?
SQL Developer will use whatever Java it can find. If you have the 1.6JDK installed as well, it might find that first. If you want to force it to use the 1.7 you just installed, all you need to do is explore the SQL Developer package, and edit the sqldeveloper-Darwin.conf file in the bin directory.
You may have noticed that Java 1.6 installs to a different directory than 1.7 on OS X.
- 1.6 – /System/Library/java/JavaVirtualMachines/1.6.0.jdk/Contents/home/
- 1.7 – /Library/java/javaVirtualMachines/1.7.0.jdk/Contents/Home/
Music Download For Mac
Just update the ‘SetJavaHome’ entry to the version of Java you want SQL Developer to use when it runs.
A Few More Notes
Download Manager For Mac
You might be wondering why I installed Java 1.7 when we technically only support 1.6. Well, 1.7 will work, and that’s what many of our developer use internally. If you don’t like bleeding edge, feel free to follow the exact same instructions and grab JDK 6 instead.
This is one of the first work related blogs I’ve written on my home machine a la Mac. I didn’t have my trusted Windows friend SnagIt at hand, but @brentO turned me onto a free and very handy utility called ‘Skitch.’ It works, and once you forget all the normal Windows application ‘way of doing things,’ is also very intuitive. And it’s free, did I mention that? Thanks Brent!
If you don’t like that the application title has an underscore in it, e.g. ‘SQL_Developer,’ then here’s a nice post from @martinpaulnash explaining how to fix that too.