I am using Macbook Pro (OS- Mac OS X 10.07 - Lion). for development purpose I need oracle server. There is no package available for Mac in Oracle download session. Is anybody help me how to install Oracle 11g server on Mac OS X 10.07 ?
Edited by: user9258550 on Aug 9, 2011 4:21 AM
Download Virtualbox from here, and use the pre-built 11.2 Database VM downloadable from here
no need to configure the database and fiddle to get it running under MacOS, just fire up the VM and go.
Thank You Christian for quick reply.
I definitely try your solution. But Have I need to install Oracle client utility to connect Oracle server(In VirtualBox) ?
If yes.. Is there any steps for that ?
Edited by: user9258550 on Aug 9, 2011 5:00 AM
Well, in the VM itself there is of course a oracle client installed (comes with the database); if you want to connect from your host to the guest OS you'd need to install additional software. You might try SQL Developer, or if you need a full blown oracle client the 10.2.0.4 client for mac osx should be sufficient: http://www.oracle.com/technetwork/database/10204macsoft-098015.html
edit: ah, and of course SQL Developer is already installed in the VM; so if this is sufficent enough for you there is no need to install any additional software on your host.
Edited by: christian erlinger on 09.08.2011 05:05
What are the credentials to log into the database ??
Found the password.. For all schema's by default password is oracle
Thanks Christian, looking for something like this from many days...
I will be very thankful, if there are many applications like this... for BI Publisher, ADF, etc...
Edited by: Charan on Aug 10, 2011 6:05 PM
If memory serves the password of the OS user oracle and root should be oracle; the SYS password should be oracle too. If you can logon with SYS you can change the passwords of all users as you like ( alter user blabla identified by blub ).
If the root password isn't oracle (as said I can't remember 100%) one option would be to simply boot in single user maintenance mode and reset the root password: http://www.walkernews.net/2007/07/03/how-to-reset-linux-forgotten-root-password
If the sys password also isn't oracle you can create a new password file with orapwd