R12 – Virtualbox Connection
So you got R12 up and running and want to connect to it from a Vbox machine?
I’m running R12.0.4 on OEL5.3 with Virtualbox 2.2.2 having a Windows 7 machine.
R12
R12 is installed on OEL with the hostname: localhost.localdomain
Firefox works locally against R12 so the EBS stack in working at this point.
Start the database, listener and apps. See Managing R12:
$ addbctl start
$ addlnctl start VIS
$ adstrtal apps/apps
To test if a database network connection would work try:
$ sqlplus apps/apps@VIS
Virtualbox
Installed Vbox 2.2.2 on OEL. Get it from http://www.virtualbox.org
Setup Vbox host-only network in \File\Preferences
and give it a ip like 192.168.2.7 on the adapter tab:
and setup the dhcp tab like this:
When the Vbox machine is started you should be able to ping it:
Windows 7 in Virtualbox
I use Windows 7 RC.
Create a Vbox machine and mount the downloaded Win7 ISO as CDROM and run install:
You get it from here:
Setup Vbox networking like this:
This will communicate through the 192.168.2.7 ip address.
When Window 7 is installed create a new entry in the file:
C:\windows\system32\drivers\etc\hosts
like this:
Pointing to localhost.localdomain so Firefox R12 login works.
To ensure everything work try to ping localhost:
SQLDeveloper
If you want to do development then this tool is great. Get it from:
http://www.oracle.com/technology/products/database/sql_developer/index.html
I installed version 1.5.1.
Setup the connection:
I just used the ip address here and it works fine.
Firefox
To run R12 forms and framework you need Firefox 2.
Install Firefox 2 in Win7. I installed version 2.0.0.14. Get it from:
http://www.mozilla.com/en-US/firefox/all-older.html
Allow localhost.localdomain is Firefox security:
and pop-ups:
To start R12 enter the URL:
http://localhost.localdomain:8000/OA_HTML
And you get the login screen:
Java
Java is a must for R12. Check the version required when you have logged in to R12 and click a forms screen
In 12.0.4 it is 1.5.0.13:
Then install Java 1.5.0.13 to ensure you don’t get plug-in issues with R12. Get it from:
http://java.sun.com/products/archive/j2se/5.0_13/index.html
As Firefox only supports one Java plug-in at any one time check the directory for plug-ins:
C:\ > DIR “C:\Program Files\Mozilla Firefox\plugins”
Ensure you only have one Java plug-in here. If it is missing the do this:
C:\ > copy C:\Program Files\Java\jre1.5.0_13\bin\NPJPI150_13.dll C:\Program Files\Mozilla Firefox\plugins
Restart Firefox and now everything should work.
