Using Oracle 11g thru VirtualBox appliance in Mac OS X Lion

By -
I just found that its quite a lot of handy work to make Oracle work in Mac OS X Lion.

Currently, I have this quite cool machine with good memory anyway, so I decided to step the easy way, than the "too-much-time-to-work way".


So, I just decided to use VirtualBox with Oracle's pre-built virtual appliance with Oracle 11g Enterprise Edition.


To use this, I use the steps below.



3. I added some specific ports, since I access it thru  NAT so whenever I am, it's easier for me just to hook up my virtual appliance and turn it on.

So you can issue these command in your terminal,

$> VBoxManage modifyvm "OTN Developer Days" --natpf1 "ssh,tcp,,2222,,22"
$> VBoxManage modifyvm "OTN Developer Days" --natpf1 "oracle,tcp,,8282,,8282"
$> VBoxManage modifyvm "OTN Developer Days" --natpf1 "oracle 2,tcp,,1521,,1521"
$> VBoxManage modifyvm "OTN Developer Days" --natpf1 "oracle em,tcp,,1158,,1158"

FYI: I use VirtualBox 4.1.4



The result screenshot above are the ports I have forwarded from my Guest VM Appliacne to my Host machine.


Hope this helps.

Comments

Anonymous said…
thnx alot, it saved my time, I tried configuring oracle on mac but failed,

Thanx.
January 27, 2012 at 8:08 PM
Anonymous said…
I am new to oracle and trying to install oracle db for beginner's practice on my MB with os X Lion. Will your method allow me to work with oracle 11 g .
April 10, 2012 at 3:46 PM
Unknown said…
Thanks for your posting. I installed it, logged into Linux as oracle/oracle, and did oracle start. I started SQL Developer and tried connecting to localhost:1521 with SID=orcl, and user/password = oracle/oracle, and it says I have a bad user name or password. Other SID values like the default of "xe" result in a different error, that there is no listener.

What oracle DB user name and password can I use to get onto the database as administrator so I can create additional users and so forth? I was expecting it to be oracle/oracle...

By the way, the name of the VM is now "Oracle Developer Days" rather than the "OCN Developer Days" shown in your commands for setting up NAT port mapping. Also the network adapters are all disabled initially. After I enabled Adapter 1 for NAT and looked at the advanced settings and Port Mapping, I could see the mappings configured by the commands you recommended.
July 19, 2012 at 6:13 PM
Anonymous said…
user: SYSTEM
password: oracle
August 1, 2012 at 2:56 PM
Post a Comment

Popular posts from this blog

LVM: How to remove a volume using pvremove

By -
First, I encountered this error "Can't pvremove physical volume "/dev/sdc1" of volume group "nova-volumes" without -ff" (I'm actually using OpenStack but it's another story). So to remove this, do first, ~# pvscan   PV /dev/sdb1   VG nova-volumes    lvm2 [1.82 TiB / 1.82 TiB free]   PV /dev/sda5   VG cloudmaster     lvm2 [297.85 GiB / 12.00 MiB free]   PV /dev/sdc1                      lvm2 [1.82 TiB]   Total: 3 [3.93 TiB] / in use: 2 [2.11 TiB] / in no VG: 1 [1.82 TiB] Then, when I do, ~# pvremove /dev/sdc1  Can't pvremove physical volume "/dev/sdc1" of volume group "nova-volumes" without -ff So I need to, ~# vgreduce nova-volumes /dev/sdc1   Removed "/dev/sdc1" from volume group "nova-volumes" Then do `pvscan` again, ~# pvscan   PV /dev/sdb1   VG nova-volumes    lvm2 [1.82 TiB / 1.82 TiB free]   PV /dev/sda5   VG clou...
Read more

Use Shell Editor for Eclipse for editing bash, ksh, csh in Unix/Linux system

By -
Image
I found ShellEd when googling for any shell editor. It was trouble at first because there's no  how-to that directs me, where I expect to have a direct link that I can copy-en-paste to my Eclipse for installation. So what I did, I download ShellEd (as of this writing file version ShellEd-Update-2.0.0_M3.zip) from sourceforge.net and install, as required, the Linux Tools . After installing Linux Tools, I then locate thru archive the ShellEd zip file and install it successfully. It works good and I feel satisfied with this cool tool to be embedded in eclipse. The sample attached shell script is from JBoss twiddle. It does supports syntax highlighting, intellisense which is cool. Hope this helps.
Read more