When making your R12 server available on-line you need to protect your FND user password.
This assumes that you have ONLY opened port 8000 for APPS login access.
For any other access I can only recommend to use VPN as a full OEL and RDBMS lock down is very complex.
I used the following script (use at your [...]
Want to access your R12 installation from a client site?
No problem – pick up the R12 installation described earlier and install the hard disk in a HTPC!
For the purpose I bought a Acer AspireRevo R3700 with the following relevant specifications:
Processor Intel® Atom D525 processor 1.8GHz
Memory 2GB DDR3 800MHz
Graphics NVIDIA ION graphics solution
Networking Gigabit Ethernet, Wake-on-LAN [...]
So we have installed R12 on a external USB hard disk according to my instructions but now we want more performance and flexibility?
You can either run out and buy a huge server and re-install on that or try to use two laptops instead of one?
Equipment used:
Router – Draytek 2820
Laptop 1 – R12 server: Lenovo [...]
Well having installed and worked with R12.0.4 it very fast becomes clear that a new version is needed.
So I downloaded R12.1.1 from Oracle eDelivery. 40 files in excess of 45Gb to the joy of my ISP.
NOTE until 20/11-2009 there was a corrupt file on eDelivery and it took me a while to convince Oracle that [...]
This is a couple of useful scripts to test downloaded files.
This approach is recommended when downloading huge amounts of data like when downloading Oracle R12 installations files.
In addition to testing the downloaded files also be sure to use a download manager.
The basic zip test command is:
$ unzip –t –qq {zipfile}
I made a Linux script for [...]
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. [...]
Well why make a post about this?
OEL does not seem to be a complete operating system – it feels like Linux 5 years ago with loads of drivers missing and command line fiddling.
One chapter for each part…
Graphics
This does work out of the box but the built in driver is not great and make the fan [...]
This post is written in Windows 7 RC running in Virtualbox inside Oracle Enterprise Linux (OEL) 5.3 – good fun!
OEL is in reality a Red Hat Enterprise Linux, which is a bit amputated in term of applications and drivers.
The reason for this constellation is OEL 5.3 Supports eBusiness Suite R12 and RDBMS 10g.
Next step is [...]
I recommend you to start with this article to get R12 up and running.
Firefox
Firefox 3 does not work with R12. I could get forms to work however framework pages had problems with buttons. So install Firefox 2 instead.
Java Plug-in
For R12.0.4 on OEL desktop you want to use JRE 1.5.0.13 otherwise you have to fiddle with [...]
Use this script (vis.sh) to initialise the Oracle environment.
I recommend you to start with this article to get R12 up and running.
Run as Oracle user:
$ . ./vis.sh
Note the dot and space in front of a script to assign variables to the current environment.
#!/bin/bash
shopt -s expand_aliases
ORACLE_SID=VIS
ORACLE_HOST=`hostname -s`
CONTEXT_NAME=${ORACLE_SID}_${ORACLE_HOST}
TECH_HOME=/oracle/${ORACLE_SID}/db/tech_st/11.1.0
APPS_HOME=/oracle/${ORACLE_SID}/apps/apps_st/appl
alias techenv=’. ${TECH_HOME}/$CONTEXT_NAME.env’
alias appsenv=’. ${APPS_HOME}/$CONTEXT_NAME.env’
APPSENV=”$APPS_HOME/$CONTEXT_NAME.env”
if [ ! -f $APPSENV ];
then
echo [...]
