Category: Technical Knowledge

  • Installing Oracle E-Business Suite R12.2

    Being a non-DBA and non-developer it is not easy to install Oracle E-Business Suite R12.2. I did have to try a few times before succeeding but it is possible and hopefully now a bit easier with the guide. On the surface is looks straight forward but I would recommend to set aside a full week […]

  • Upgrading Oracle E-Business Suite R12.2.0 to R12.2.2

    This is a sub-post to Installing Oracle E-Business Suite R12.2. In general the patching process takes longer time than to install R12.2.0 so be sure to do plenty of cold-backups. Patch Directory For all patches; you need to download and unzip the patches in $PATCH_TOP: # . # mv {zipfile} $PATCH_TOP # cd $PATCH_TOP […]

  • Managing Oracle E-Business Suite R12.2

    This is a sub-post to Installing Oracle E-Business Suite R12.2. After installing R12.2.0 you can start to manage the installation. There are a few things you need to be aware of and that will also come in handy for your R12.2.2 upgrade. Login Use the following URL: http://hpserver.kentw:8000 Or if you use localhost: http://localhost.localdomain:8000 Login: […]

  • Installing Oracle E-Business Suite R12.2.0

    This is a sub-post to Installing Oracle E-Business Suite R12.2. There are two steps to this: R12.2 Staging R12.2.0 Installation R12.2 Staging Login as: oracle Download the following files from into directory /stage122: # mkdir /oracle/Stage122 # cd /oracle/Stage122 Use Firefox or similar to download: Name ZIP File Size Oracle Fusion Middleware Web Tier […]

  • Installing Oracle Enterprise Linux 6.4

    This is a sub-post to Installing Oracle E-Business Suite R12.2. These are instructions for non-DBA’s. I’m sure that there are smarter ways of doing this, but at least this is fairly simple and it works… Installing OEL 6.4 Name Part Number Size Oracle Linux Release 6 Update 4 for x86_64 (64 Bit) V37084-01 3.5G Burn […]

  • Installing an Oracle Server

    This is an example of a reasonable priced Oracle server. The configuration below was around £700. From R12.2 an Oracle Weblogic Server is included so you will need a lot more power to install R12.2 in a reasonable time. You could install and run R12.1 on a 4Gb Atom CPU based server but for R12.2 […]

  • Data Migration Strategy – a Functional Approach

    Having been on a few projects now where the data migration was treated as a technical exercise and felt the impact of this – now it’s time to describe the data migration from a functional perspective. Data migration strategy also called data conversion strategy is the basis for this. Focusing on the functional perspective helps […]

  • SQL Plus Instant Client

    As a functional consultant you’re often asked to run a SQL*Plus script from Oracle Support however these scripts does not always behave well with SQL Developer. So instead you can use a little tool called SQL Plus Instant Client. Installation You need to download: Instant Client Package – Basic: All files required to run OCI, […]

  • SQL Developer Tips

    This is my little collection of SQL Developer tips for functional consultants like myself – so nothing complicated really but good to know. Default Output directory: When running in script mode and you use the spool commend your output will be located in: %APPDATA%\SQL Developer Due to the space be sure to use "s: dir […]

  • WebADI and Excel 2013

    Office 2013 (or Office 365) has been released a now we all wonder if it will work with WebADI? You need to set the usual Internet Options and Excel Options. And it works: But there are a few quirks… Worst bit is the Oracle Add-In button is missing. It works ok but you need to […]