R12

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 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.