Step-by-step installation of an EBS 12.2 Vision instance

Oct 7, 2013 / By John Piwowar

Tags: , , , , ,

It’s here! It’s here! It’s finally here!

(what, you don’t get excited when you get new toys?)

Now that version 12.2 of Oracle Applications has been released, it’s time for eager Apps DBAs and non-DBA EBS geeks to get their hands dirty with new features! This post will walk through the steps required to install a single-node “Vision” instance of E-Business Suite Release 12.2. Apps DBAs can certainly learn a lot about the technical pieces of EBS 12.2 just by installing an empty, unconfigured “Prod” instance. I’m covering a Vision install in this post because I prefer having real data to play with, and don’t have time to learn how to configure all the apps modules myself. :)

This exercise is not for the faint of heart, nor the impatient, but it’s not terribly complicated. If you’ve done Vision installs for the 11i or R12.0/12.1 versions of E-Business Suite, you’re already familiar with the basics. Unlike previous versions of EBS, though, installing a test instance 12.2 onto a laptop or mid-grade workstation is a very tight squeeze. If you have a lab machine with server-class resources, I strongly recommend starting there. Since “can I run this on my personal workstation?” is a common question about EBS Vision installs, however, I’m going to walk through what I’ve done to get 12.2 running on my laptop.

Still with me? Let’s get going.

References

These are early days for EBS 12.2, and while this guide should be sufficient to get you started, you should keep an eye out for additional patches, updates to instructions, etc. Here are the base notes, and a few others released shortly after the software went GA. These are also the references you should consult if you suspect that I missed something in this guide. Hey, it could happen.

You will need…

At a minimum, your test server will need:

  • 2 CPU cores, more if you have them.
  • 8GB of RAM. No, really. You’ll need it all. If you skimp on memory, you’ll find that patching in particular will be intolerably long at best, and prone to failure at worst.
  • Lots of disk space. In addition to the usual 10-12 GB for root+swap, you need 40G for the software staging area, and 275-300G for the database and applications. If you want to split apps and database, allocate 200G for the database and the remainder for the apps. If possible, put your staging area and the install target on separate physical devices.
  • Access to the internet/web/cloud/whatever, for downloading patches and OS packages. Alternatively, you can transfer these things manually, but who needs that kind of inconvenience?

In addition, you will need a lot of patience, and probably some side projects that don’t involve using a keyboard. This little adventure is going to tie up your workstation for quite a while.

Install steps

  1. Download the EBS install media.
    I covered this in my earlier post about 12.2 prep, so I won’t duplicate it here. Pay close attention to which zip files are actually required!
  2. Set up your Linux server.
    My server is running 64-bit Oracle Enterprise Linux (OEL) 6.4. If you’re installing on a different platform, your experience may be different. A full walkthrough of how to install Linux is beyond the scope of this post. If you need guidance, I recommend this OEL 6 install guide by the inimitable Tim Hall.I’ve covered most of the setup requirements (packages, disk sizing, etc.) in my previous post. Here are a few more details:

    • Important warning: Keep your hostname short! There’s an item buried at the end of Note 1320300.1 that warns against using a SID and hostname combination that would make the instance name for the 10.1.2 ORACLE_HOME (EBS_web_SID_hostname) longer than 30 characters. If your hostname is too long, the installer will fail when attempting to create the EBS web tier.
    • Set up /etc/hosts and /etc/sysconfig/network as described in the “Verifying Host Names” section of Note 1330701.1.
    • Adjust /etc/sysctl.conf. Full requirements are in Note 1330701.1, though I found that after installing the oracle-rdbms-server-11gR2-preinstall package, I only needed to make one change:
      kernel.sem = 250 32000 100 142
    • Create database and application software owners, oraInventory, and and /etc/oraInst.loc
      It’s possible to have the entire instance owned by a single user, but splitting the ownership of the database and applications between two OS users makes management of the services a bit clearer, and more closely reflects the situation you’d expect to see in real life. You could also use the ‘oracle’ user created by the 11gr2 pre-install rpm as the database owner if you prefer, instead of ‘oravis’.

      [root@breen ~]# useradd oravis -g dba
      [root@breen ~]# useradd applvis -g dba
      [root@breen ~]# groups oravis applvis
      oravis : dba
      applvis : dba
      [root@breen ~]# passwd applvis
      Changing password for user applvis.
      New password:
      Retype new password:
      passwd: all authentication tokens updated successfully.
      [root@breen ~]# passwd oravis
      Changing password for user oravis.
      New password:
      Retype new password:
      passwd: all authentication tokens updated successfully.
      [root@breen ~]# cd /u01
      [root@breen u01]# mkdir -m 775 oraInventory
      [root@breen u01]# chgrp dba oraInventory
      [root@breen u01]# chown oravis oraInventory
      [root@breen u01]# echo "inventory_loc=/u01/oraInventory" > /etc/oraInst.loc
      [root@breen u01]# chmod g+w /etc/oraInst.loc
      [root@breen u01]# chgrp dba /etc/oraInst.loc
      
    • Adjust limits.conf
        * hard nofile 65536
        * soft nofile 4096
        * hard nproc 16384
        * soft nproc 2047
        * hard stack 16384
        * soft stack 10240
    • Create empty stage area and software install target. In my case, my staging directory is in /mnt/stage, and my database and software are going on /u01:
      [root@breen u01]# df -h
      Filesystem            Size  Used Avail Use% Mounted on
      /dev/mapper/vg_breen-lv_root
                             20G  2.3G   17G  12% /
      tmpfs                 3.0G     0  3.0G   0% /dev/shm
      /dev/sda1             485M   55M  405M  12% /boot
      /dev/mapper/vg_breen-lv_u01
                            287G  191M  272G   1% /u01
      /dev/sdd1              79G  184M   75G   1% /mnt/stage
      192.168.56.1:/Users/jpiwowar/R12.2.2
                            465G  383G   82G  83% /mnt/zips
      [root@breen u01]# mkdir -p oracle/VIS
      [root@breen u01]# chmod -R 775 .
      [root@breen u01]# chgrp -R dba .
      [root@breen u01]# cd /mnt/stage
      [root@breen u01]# mkdir Stage122
  3. Stage the software (buildStage.sh)Unlike earlier installs of Oracle Applications, staging is not as simple as unzipping all of the install media yourself. Use of the Oracle-supplied script to build a staging area is required. As you might guess from the df output in the previous step, I put the zip files containing the EBS 12.2 software in /mnt/zips. This is where buildStage.sh will find and unpack the install media; the only thing we need to unzip manually is the Rapid Install software.When the buildStage.sh run is complete, look for a “Stage area verified” message. If directories are listed as invalid, or if you see a message indicating that the stage area is incomplete, you’ll need to identify the missing files and add them to your zip file location. Hint: if you need to run buildStage.sh again, move the already-unzipped files out of the zip file stage location, and only add the new files for the next buildStage run. The second run will move along more quickly. Also, be aware that stage area “verification” is very basic: “Do the directories exist? Are they non-empty?” There is still a risk that a corrupted zip file could sink the whole enterprise. Hopefully you validated the zips after download with md5sum. :)
    [root@breen stage]# pwd
    /mnt/stage
    [root@breen stage]# cd Stage122/
    [root@breen Stage122]# unzip -q '/mnt/zips/V35215-01*.zip' -d .
    [root@breen Stage122]# cd startCD/Disk1/rapidwiz/bin/
    [root@breen bin]# ./buildStage.sh
    Rapid Install Platform Menu
    
    ------------------------------------------------------
    
    1.    Oracle Solaris SPARC (64-bit)
    
    2.    Linux x86-64
    
    3.    IBM AIX on Power Systems (64-bit)
    
    4.    HP-UX Itanium
    
    5.    Exit Menu
    
    Enter your choice [5]: 2
    
    /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin
    
    Please enter the directory containing the zipped installation media:
    /mnt/zips
    Unzipping V29764-01.zip
    Unzipping V29856-01.zip
    Unzipping V35215-01_1of3.zip
    Unzipping V35215-01_2of3.zip
    Unzipping V35215-01_3of3.zip
    Unzipping V35230-01_1of2.zip
    Unzipping V35230-01_2of2.zip
    Unzipping V35231-01_1of5.zip
    Unzipping V35231-01_2of5.zip
    Unzipping V35231-01_3of5.zip
    Unzipping V35231-01_4of5.zip
    Unzipping V35231-01_5of5.zip
    Unzipping V35802-01.zip
    Unzipping V35803-01_1of3.zip
    Unzipping V35803-01_2of3.zip
    Unzipping V35803-01_3of3.zip
    Unzipping V35804-01_1of2.zip
    Unzipping V35804-01_2of2.zip
    Unzipping V35807-01.zip
    Unzipping V35808-01.zip
    Unzipping V35809-01.zip
    Unzipping V35810-01.zip
    Unzipping V35811-01.zip
    Unzipping V35812-01.zip
    Unzipping V35813-01.zip
    Unzipping V37515-01_1of6.zip
    Unzipping V37515-01_2of6.zip
    Unzipping V37515-01_3of6.zip
    Unzipping V37515-01_4of6.zip
    Unzipping V37515-01_5of6.zip
    Unzipping V37515-01_6of6.zip
    Unzipping V39571-01.zip
    Unzipping V39615-01.zip
    Applying one-off patches
    All files have been unzipped.
    Stage area is complete.
    
    Done Unzipping shiphome ...
    
    StageBuilder will now stage the tech patches for Linux_x64...
    
    Copying one-off patches to shiphome
    
    /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip -d /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches
    
    Archive:  /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16303726/p16303726_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14123213/p14123213_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13923995/p13923995_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14751895/p14751895_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16163946/p16163946_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14207902/p14207902_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/15967134/p15967134_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16438289/p16438289_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13931044/p13931044_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16342486/p16342486_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14398795/p14398795_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12951696/p12951696_112030_Generic.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12942119/p12942119_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14698700/p14698700_112030_Generic.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16587934/p16587934_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16105745/p16105745_112030_Generic.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16040940/p16040940_112030_Linux-x86-64.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13583235/p13583235_1036_Generic.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14825718/p14825718_10123_LINUX.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14353879/p14353879_10123_LINUX.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14614795/p14614795_101231_LINUX.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16209520/p16209520_10123_GENERIC.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16275529/p16275529_10105_LINUX.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14597598/p14597598_1036_Generic.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14577216/p14577216_101231_Generic.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16784403/p16784403_101232_LINUX.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14386347/p14386347_111160_Generic.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16199894/p16199894_111160_Generic.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14374587/p14374587_10123_GENERIC.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/10152652/p10152652_10123_LINUX.zip
     extracting: /mnt/stage/Stage122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/11669923/p11669923_10123_GENERIC.zip
    
    Done Copying additional patches
    
    Verifying stage area...
    
    Directory /mnt/stage/Stage122/TechInstallMedia is valid
    Directory /mnt/stage/Stage122/TechPatches/DB is valid
    Directory /mnt/stage/Stage122/TechPatches/MiddleTier is valid
    Directory /mnt/stage/Stage122/EBSInstallMedia/AppDB is valid
    Directory /mnt/stage/Stage122/EBSInstallMedia/Apps is valid
    Directory /mnt/stage/Stage122/EBSInstallMedia/AS10.1.2 is valid
    Directory /mnt/stage/Stage122/TechInstallMedia/database is valid
    Directory /mnt/stage/Stage122/TechInstallMedia/ohs11116 is valid
    Directory /mnt/stage/Stage122/TechInstallMedia/wls1036_generic is valid
    
    Stage area verified.
    
    Press enter to continue...
  4. [Optional] Adjust the RMAN restore script for the Vision database install, as discussed in my previous post.
    [root@breen stage]# cd Stage122/startCD/Disk1/rapidwiz/template/
    [root@breen template]# cp restore-single2.sql restore-single2.sql.orig
    [root@breen template]# vi restore-single2.sql
    [root@breen template]# cat restore-single2.sql
    --lines snipped for brevity--
    set linesize 300
    spool %s_db_oh%/appsutil/out/%s_contextname%%/%restore-single2.rman
    select 'configure device type DISK parallelism 1;' from dual;
    select 'catalog start with ''INSTALL'' NOPROMPT;' from dual;
    select 'RUN { ' from dual;
    select 'set newname for datafile '||file#||' to '||'''%s_dbhome1%/'||substr(NAME,instr(NAME,'%/%',-1)+1,length(NAME))||''';' from v$datafile;
    --lines snipped for brevity--
    [root@breen template]# diff restore-single2.sql restore-single2.sql.orig
    17d16
    < select 'configure device type DISK parallelism 1;' from dual;
  5. Start the EBS Installer
    I ran my installer in VNC, because I don’t have a graphical console configured on my server. If you opted to install Gnome when you installed OEL, then you can just log in as root and launch the installer from the desktop.

    [root@breen ~]# vncserver :1
    
    New 'breen.local.org:1 (root)' desktop is breen.local.org:1
    
    Starting applications specified in /root/.vnc/xstartup
    Log file is /root/.vnc/breen.local.org:1.log
    
    [root@breen ~]# export DISPLAY=:1
    [root@breen ~]# xhost +
    access control disabled, clients can connect from any host
    [root@breen ~]# /mnt/stage/Stage122/startCD/Disk1/rapidwiz/rapidwiz
    
    Rapid Install Wizard is validating your file system......
    CMDDIR=/mnt/stage/Stage122/startCD/Disk1/rapidwiz
    Rapid Install Wizard will now launch the Java Interface.....
  6. Answer all the installer questions (screenshots ahoy, cap’n!)
    There are a handful of possible options, but for the most part I’m taking the defaults. Fewer changes means fewer opportunities for error. I’ll experiment more when I’m not writing docs for others. ;-)

    • A few boring first steps: Opening splash screen; Confirming a new, non-express install; Declining security emails (unless you’re into that sort of thing); Confirming a new configuration…
      122RapidWizSplash122ChooseInstallType122EMailPrompt 122CreateNewConfig
    • Take the default port settings (note the two sets of ports, for patch and run filesystems)
      122PortSettings
    • Database node configuration. In this case, two changes to make: selecting ‘oravis’ as the datbaase OS user, and changing the base dir to /u01/oracle/VIS. This will cascade through the rest of the config, no need to change elsewhere.
      122DBNodeConfig
    • For the app node configuration, just change the Apps OS owner to ‘applvis’
      122AppNodeConfig
    • On the next screen, set a password for the Weblogic admin user, and supply the password you’d previously set for the applvis user. I left the remaining passwords at the default values, in compliance with protocol El-Ay-Zed-Why.
      122Passwords
    • Click Next on the node info screen, and the system checks will start. Assuming you’ve sized your disks correctly, and set up the target directories, everything should look great at the end. Otherwise, fix any issues (denoted by a red “X” or “?”) and retry.
      122NodeInfo122SysCheck122ValidateComplete
    • When the validation checks are all green, you can launch the install and find something else to do for a few hours:
      122GoButton

    You’re going to be staring at that “Installing Oracle Applications…” window with its blue bars for quite a while. You can also watch for output from the terminal where you launched rapidwiz, and tail the log files there:

    [root@breen u01]#
    
    Configuration file written to: /u01/oracle/VIS/fs1/inst/apps/VIS_breen/conf_VIS.txt
    
    Configuration file written to: /u01/oracle/VIS/fs2/inst/apps/VIS_breen/conf_VIS.txt
    Configuration file written to: /u01/oracle/VIS/11.2.0/appsutil/conf_VIS.txt
    Database logfile - /u01/oracle/VIS/11.2.0/appsutil/log/VIS_breen/10051848.log
  7. Confirm that you have all green checkmarks in the post-install verification window.
    On a slower system, the first pass at checking some of the services (HTTP, WLS Admin, etc) may fail. Before digging too far into troubleshooting, click “Retry” to see if the validation steps pass on a second attempt.
    Post-install validation window, EBS 12.2

Post-install steps

The following post-install steps are split between Notes 1320300.1 and 1330701.1. There’s patching involved, which is pretty exciting, because you get to use the online patching tool (adop) right away (yay)! They’re hot patches, though, so it’s not a full, true online patch cycle yet (boo). That comes when it’s time to update to EBS 12.2.2 (yay)! I’m presenting these steps in the order that I executed them, which in retrospect might not have been the most efficient, but it didn’t break anything. A few post-install steps are given as pre-requisites for the 12.2.2 upgrade, so in the interest of keeping this post short (hah!) I’m leaving them until a later blog post.

Since some of the steps required everything but the WLS admin server to be down, and one of the steps requires a database bounce, I just stopped all apps services before working on these steps:

[root@breen template]# sudo su - applvis
[applvis@breen ~]$. /u01/oracle/VIS/EBSapps.env run

E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/oracle/VIS/fs1/EBSapps/appl
PATCH File System : /u01/oracle/VIS/fs2/EBSapps/appl
Non-Editioned File System : /u01/oracle/VIS/fs_ne
DB Host: breen.local.org  Service/SID: VIS

[applvis@breen ~]$ export PATH=$PATH:$ADMIN_SCRIPTS_HOME
[applvis@breen ~]$ adstpall.sh

You’ll need to supply the WLS admin password in addtion to the APPS username and password when running adstpall.sh. Get used to that.

When reviewing my adop output below, please don’t jump to any conclusions about “normal” patch timing. Remember, this output is generated on a severly underpowered system, and all of these steps were run before I figured out that my VM needed an extra 2GB of RAM. :-)

  1. 10.1.2 ORACLE_HOME stub library update (Note 1330701.1, “After Installing or upgrading”)
    [applvis@breen other_patches]$ getOraPatch 'https://updates.oracle.com/Orion/Services/download/p12415211_10105_LINUX.zip?aru=13727149&patch_file=p12415211_10105_LINUX.zip'
    Oracle Support Userid: ****
    Oracle Support Password: 2013-09-27 01:17:42 URL:http://aru-akam.oracle.com/adcarurepos/vol/patch22/PLATFORM/CORE/LINUX/R80101050/p12415211_10105_LINUX.zip?FilePath=/adcarurepos/vol/patch22/PLATFORM/CORE/LINUX/R80101050/p12415211_10105_LINUX.zip&File=p12415211_10105_LINUX.zip&params=bk42aDg3bEszbXAwb0RORUM2ampZZzphcnU9MTM3MjcxNDkmZW1haWw9cGl3b3dhckBweXRoaWFuLmNvbSZmaWxlX2lkPTQyNjI3MzE0JnBhdGNoX2ZpbGU9cDEyNDE1MjExXzEwMTA1X0xJTlVYLnppcCZ1c2VyaWQ9by1waXdvd2FyQHB5dGhpYW4uY29tJnNpemU9MTc3OTkmY29udGV4dD1BQDEwK0hAYWFydXZtdHAwNC5vcmFjbGUuY29tK1BAJmRvd25sb2FkX2lkPTg5ODY4NDYy&AuthParam=1380337651_3587efa97fc97049e42d12077c59cbfa [17799/17799] -> "p12415211_10105_LINUX.zip" [1]
    Completed with status: 0
    [applvis@breen other_patches]$ unzip -tq p12415211_10105_LINUX.zip
    No errors detected in compressed data of p12415211_10105_LINUX.zip.
    [applvis@breen other_patches]$ unzip -q p12415211_10105_LINUX.zip
    [applvis@breen other_patches]$ cd /u01/oracle/VIS/fs1/EBSapps/10.1.2/lib/
    [applvis@breen lib]$ cp -p -R stubs stubsORIG
    [applvis@breen lib]$ cd stubs
    [applvis@breen stubs]$ cp /mnt/stage/other_patches/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so .
    [applvis@breen stubs]$ ln -sf libgcc_s-2.3.2-stub.so libgcc_s.so.1
    [applvis@breen stubs]$ ln -sf libgcc_s.so.1 libgcc_s.so
    [applvis@breen stubs]$ $ORACLE_HOME/appsutil/clone/adlnktools.sh
    adlnktools.sh started at Fri Sep 27 01:34:32 PDT 2013
    Log file located at /u01/oracle/VIS/fs1/inst/apps/VIS_breen/logs/ora/10.1.2/install/make_09270134.log
    
    adlnktools.sh completed sucessfully
    [applvis@breen stubs]$ grep -i err /u01/oracle/VIS/fs1/inst/apps/VIS_breen/logs/ora/10.1.2/install/make_09270134.log
    [applvis@breen stubs]$ grep -i warn /u01/oracle/VIS/fs1/inst/apps/VIS_breen/logs/ora/10.1.2/install/make_09270134.log
    [applvis@breen stubs]$ grep -i fail /u01/oracle/VIS/fs1/inst/apps/VIS_breen/logs/ora/10.1.2/install/make_09270134.log
  2. Patch 17064510 (12.2 Release notes, Note 1320300.1) to fix fs_clone
    As promised, here’s our first run of adop, albeit in hotpatch mode, which doesn’t require prepare or cutover/finalize steps. Make sure the WLS admin server is up ($ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start), or you’ll get a message like this:
    ***** W A R N I N G *****
    ADMIN SERVER is down. Cannot proceed further...
    Please start the ADMIN SERVER.
    
    adop exiting with status = 3 (Fail)

    I staged the patches in the default expected directory in the non-editioned filesystem, but you can specify a patchtop if you prefer.

    [applvis@breen other_patches]$ unzip -tq p17064510_R12.TXK.C_R12_GENERIC.zip
    No errors detected in compressed data of p17064510_R12.TXK.C_R12_GENERIC.zip.
    [applvis@breen other_patches]$ unzip -q p17064510_R12.TXK.C_R12_GENERIC.zip -d $APPL_TOP_NE/../patch
    [applvis@breen other_patches]$ adop phase=apply patches=17064510 hotpatch=yes
    
    Enter the APPS password:
    Enter the SYSTEM password:
    Enter the WLSADMIN password:
    
     Please wait. Validating credentials...
    
     Enter the RUN file system context file name [/u01/oracle/VIS/fs1/inst/apps/VIS_breen/appl/admin/VIS_breen.xml]:
    
     [STATEMENT] [END   2013/09/27 02:47:18] Performing verification of parameters
     [STATEMENT] [START 2013/09/27 02:47:19] Checking for the required ENV setup
     [STATEMENT] [END   2013/09/27 02:47:19] Checking for the required ENV setup
    
     ************* Start of  session *************
      version: 12.2.0
      started at: Fri Sep 27 2013 02:47:19
    
     APPL_TOP is set to /u01/oracle/VIS/fs1/EBSapps/appl
     [STATEMENT] [START 2013/09/27 02:47:20] Determining admin node
     [STATEMENT] [END   2013/09/27 02:47:22] Determining admin node
     [STATEMENT]  Recommended Worker Count:  2 Max Allowed Workers: 10
     [STATEMENT] [START 2013/09/27 02:47:26] Acquiring lock on sessions table
     [STATEMENT] [END   2013/09/27 02:47:28] Acquiring lock on sessions table
     [STATEMENT] [START 2013/09/27 02:47:28] Checking for any pending sessions
     [STATEMENT] [START 2013/09/27 02:47:33] Staging the current session
       [STATEMENT] [START 2013/09/27 02:47:38] Checking if node "breen" is abandoned
       [STATEMENT] [END   2013/09/27 02:47:40] Checking if node "breen" is abandoned
     [STATEMENT] [END   2013/09/27 02:47:42] Staging the current session
     [STATEMENT] [START 2013/09/27 02:47:44] Unlocking sessions table
     [STATEMENT] [END   2013/09/27 02:47:45] Unlocking sessions table
     [STATEMENT] [START 2013/09/27 02:47:45] adzdoptl.pl run
       [STATEMENT] Session ID: 2
       [STATEMENT] Phase: apply
       [STATEMENT] Log file: /u01/oracle/VIS/fs_ne/EBSapps/log/adop/2/adop_20130927_024700.log
       [STATEMENT] [START 2013/09/27 02:47:55] Invoking admerge
       [STATEMENT] [END   2013/09/27 02:47:56] Invoking admerge
       [STATEMENT] [START 2013/09/27 02:47:56] apply phase
         [STATEMENT] APPLY Phase START TIME: 27-09-2013 02:47:58
         [STATEMENT] [START 2013/09/27 02:48:00] Performing Check for Logon Trigger existence and enablement
         [STATEMENT] [END   2013/09/27 02:48:08] Performing Check for Logon Trigger existence and enablement
         [STATEMENT] [Start 2013/09/27 02:48:13] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
           [STATEMENT] Reading defaults file /u01/oracle/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt
           [STATEMENT] Substituting tokens ...
           [STATEMENT] Regenerating defaults file ...
         [STATEMENT] [End   2013/09/27 02:48:13] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
         [STATEMENT] Calling: adpatch  workers=2    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/u01/oracle/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt patchtop=/u01/oracle/VIS/fs_ne/EBSapps/patch/17064510 driver=u17064510.drv logfile=u17064510.log
         [STATEMENT] ADPATCH Log directory: /u01/oracle/VIS/fs_ne/EBSapps/log/adop/2/apply_20130927_024700/VIS_breen/17064510/log
         [STATEMENT] Running: adpatch  workers=2    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/u01/oracle/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt patchtop=/u01/oracle/VIS/fs_ne/EBSapps/patch/17064510 driver=u17064510.drv logfile=u17064510.log stdin=yes
    
     Successfully created out directory
    
         [STATEMENT] [START 2013/09/27 03:33:22] Running finalize since in hotpatch mode
           [STATEMENT] [START 2013/09/27 04:02:21] Compiling Invalid Objects as part of Finalize
           [STATEMENT] [END   2013/09/27 04:02:42] Compiling Invalid Objects as part of Finalize
         [STATEMENT] [END   2013/09/27 04:02:43] Running finalize since in hotpatch mode
         [STATEMENT] [START 2013/09/27 04:02:44] Performing Automatic DB cutover
           [STATEMENT] [Start 2013/09/27 04:02:45] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
             [STATEMENT] Reading defaults file /u01/oracle/VIS/fs2/EBSapps/appl/admin/VIS_patch/adalldefaults.txt
             [STATEMENT] Substituting tokens ...
             [STATEMENT] Regenerating defaults file ...
           [STATEMENT] [End   2013/09/27 04:02:46] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
           [STATEMENT] Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=2 restart=no abandon=yes defaultsfile=/u01/oracle/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt patchtop=/u01/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cutover.log driver=ucutover.drv
           [STATEMENT] ADPATCH Log directory: /u01/oracle/VIS/fs_ne/EBSapps/log/adop/2/apply_20130927_024700/VIS_breen/log
           [STATEMENT] Running: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=2 restart=no abandon=yes defaultsfile=/u01/oracle/VIS/fs1/EBSapps/appl/admin/VIS/adalldefaults.txt patchtop=/u01/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cutover.log driver=ucutover.drv stdin=yes
    
     Successfully created out directory
         [STATEMENT] [END   2013/09/27 04:06:11] Performing Automatic DB cutover
         [STATEMENT] [START 2013/09/27 04:06:11] Running cutover since in hotpatch mode
         [STATEMENT] [END   2013/09/27 04:06:16] apply phase
         [STATEMENT] [START 2013/09/27 04:06:17] Generating Post Apply Reports
           [STATEMENT] APPLY Phase END TIME: 27-09-2013 04:06:18
             [STATEMENT] [START 2013/09/27 04:06:21] Generating Report to spool all logs from ad_zd_logs
               [STATEMENT] Report: /u01/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql
    
               [STATEMENT] Output: /u01/oracle/VIS/fs_ne/EBSapps/log/adop/2/apply_20130927_024700/VIS_breen/adzdshowlog.out
    
             [STATEMENT] [END   2013/09/27 04:07:01] Generating Report to spool all logs from ad_zd_logs
         [STATEMENT] [END   2013/09/27 04:07:02] Generating Post Apply Reports
       [STATEMENT] [END   2013/09/27 04:07:05] adzdoptl.pl run
       [STATEMENT] adop phase=apply - Completed Successfully
    
       [STATEMENT] Log file: /u01/oracle/VIS/fs_ne/EBSapps/log/adop/2/adop_20130927_024700.log
    
     adop exiting with status = 0 (Success)
    
  3. Maintain snapshots
    Not convinced that this is 100% necessary for a “play around” system, but I’m being a good kid and following the docs. :) I’ll spare you the full output this time. Just run:
    [applvis@breen scripts]$ adadmin menu_option=UPDATE_CURRENT_VIEW
    	(many lines of output later)
    AD Administration is complete.
    
    Errors and warnings are listed in the log file
    /u01/oracle/VIS/fs_ne/inst/VIS_breen/logs/appl/conc/log/adadmin.log
    
    and in other log files in the same directory.
    
  4. Run utlirp/utlrp to fix timestamp issues with package dependencies
    Again, for a test system, one might be tempted to ignore this, but the install docs say it’s mandatory for Vision installs. Remember, we’re going to be recompiling all the PL/SQL in the database. That’s 10′s of thousands of objects. This is going to take a long time. Go play outside or something.

    [oravis@breen ~]$ sqlplus / as sysdba @$ORACLE_HOME/rdbms/admin/utldtchk.sql
    
    SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 27 15:07:42 2013
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
    SQL> SET FEEDBACK 1
    SQL> SET NUMWIDTH 10
    SQL> SET LINESIZE 80
    SQL> SET TRIMSPOOL ON
    SQL> SET TAB OFF
    SQL> SET PAGESIZE 100
    SQL>
    SQL> column d_owner format B99999
    SQL> column p_owner format B99999
    SQL> column d_name format a22;
    SQL> column p_name format a22;
    SQL> column reason format a18;
    SQL>
    SQL> select d.owner# d_owner, d.name d_name, p.owner# p_owner, p.name p_name,
      2     case
      3        when p.status not in (1, 2, 4) then 'P Status: ' || to_char(p.status)
      4     else 'TS mismatch:      ' ||
      5        to_char(dep.p_timestamp, 'DD-MON-YY HH24:MI:SS') ||
      6        to_char(p.stime, 'DD-MON-YY HH24:MI:SS')
      7     end reason
      8     from sys.obj$ d, sys.dependency$ dep, sys.obj$ p
      9     where d.obj# = dep.d_obj# and p.obj# = dep.p_obj#
     10       and d.status = 1                                    -- Valid dependent
     11       and bitand(dep.property, 1) = 1                     -- Hard dependency
     12       and d.subname is null                               -- !Old type version
     13       and not(p.type# = 32 and d.type# = 1)               -- Index to indextype
     14       and not(p.type# = 29 and d.type# = 5)               -- Synonym to Java
     15       and not(p.type# in(5, 13) and d.type# in (2, 55))   -- TABL/XDBS to TYPE
     16       and (p.status not in (1, 2, 4) or p.stime != dep.p_timestamp);
    
    D_OWNER D_NAME                 P_OWNER P_NAME                 REASON
    ------- ---------------------- ------- ---------------------- ------------------
        359 HAB_RT_EXEC_PROC_RUN_M     359 WB_RT_VERSION          TS mismatch:
            ETRICS                                                16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
        359 WB_RTI_OBJECT_CATALOG      359 WB_RT_VERSION          TS mismatch:
                                                                  16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
        359 UAB_RT_EXEC_PROCESS        359 WB_RT_VERSION          TS mismatch:
                                                                  16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
        359 UAB_RT_EXEC_PROCESS_RU     359 WB_RT_VERSION          TS mismatch:
            NS                                                    16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
        359 UAB_RT_EXEC_PROC_RUN_C     359 WB_RT_VERSION          TS mismatch:
            OUNTS                                                 16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
        359 UAB_RT_EXEC_PROC_RUN_M     359 WB_RT_VERSION          TS mismatch:
            ETRICS                                                16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
          1 WB_OLAP_AW_PRECOMPUTE      359 WB_OLAP_AW_PRECOMPUTE  TS mismatch:
                                                                  23-SEP-10 05:17:34
                                                                  26-NOV-12 18:48:25
    
        359 ALL_RT_INSTALLATIONS       359 WB_RT_VERSION          TS mismatch:
                                                                  16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
        359 RAB_RT_INSTALLATIONS       359 WB_RT_VERSION          TS mismatch:
                                                                  16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
        359 HAB_RT_EXEC_PROCESS        359 WB_RT_VERSION          TS mismatch:
                                                                  16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
        359 HAB_RT_EXEC_PROCESS_RU     359 WB_RT_VERSION          TS mismatch:
            NS                                                    16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
        359 HAB_RT_EXEC_PROC_RUN_C     359 WB_RT_VERSION          TS mismatch:
            OUNTS                                                 16-SEP-10 09:13:44
                                                                  26-NOV-12 18:48:19
    
    12 rows selected.
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup upgrade
    ORACLE instance started.
    
    Total System Global Area 2137886720 bytes
    Fixed Size                  2230072 bytes
    Variable Size             452987080 bytes
    Database Buffers         1660944384 bytes
    Redo Buffers               21725184 bytes
    Database mounted.
    Database opened.
    SQL> set timing on
    SQL> @?/rdbms/admin/utlirp
    PL/SQL procedure successfully completed.
    (output snipped, you're welcome!)
    SQL> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup
    ORACLE instance started.
    
    Total System Global Area 2137886720 bytes
    Fixed Size                  2230072 bytes
    Variable Size             452987080 bytes
    Database Buffers         1660944384 bytes
    Redo Buffers               21725184 bytes
    Database mounted.
    Database opened.
    SQL> set timing on
    SQL> @?/rdbms/admin/utlrp
    (output snipped)
    SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    [oravis@breen ~]$ sqlplus / as sysdba @$ORACLE_HOME/rdbms/admin/utldtchk.sql
    
    SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 27 23:50:15 2013
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
    (snippety-doo-dah)
    no rows selected
    
    SQL>
    
  5. Seed table update: Patch 16605855
    One more hotpatch, and this phase of the install is complete. As instructed, stop all app services if they’re started (adstpall.sh). Then start the WLS admin server if it’s not already (adadminsrvctl.sh start)

    [applvis@breen other_patches]$ getOraPatch 'https://updates.oracle.com/Orion/Services/download/p16605855_12.2.0_R12_GENERIC.zip?aru=16201490&patch_file=p16605855_12.2.0_R12_GENERIC.zip'
    Oracle Support Userid: ****
    Oracle Support Password: 2013-09-28 00:09:33 URL:http://aru-akam.oracle.com/adcarurepos/vol/patch43/PLATFORM/Generic/relR12/p16605855_12.2.0_R12_GENERIC.zip?FilePath=/adcarurepos/vol/patch43/PLATFORM/Generic/relR12/p16605855_12.2.0_R12_GENERIC.zip&File=p16605855_12.2.0_R12_GENERIC.zip&params=RGRuaHEyTDQvOUdkb3IvQmsvck5PZzphcnU9MTYyMDE0OTAmZW1haWw9cGl3b3dhckBweXRoaWFuLmNvbSZmaWxlX2lkPTYzMjYyOTc5JnBhdGNoX2ZpbGU9cDE2NjA1ODU1XzEyLjIuMF9SMTJfR0VORVJJQy56aXAmdXNlcmlkPW8tcGl3b3dhckBweXRoaWFuLmNvbSZzaXplPTIzNzk4MCZjb250ZXh0PUFAMTArSEBhYXJ1dm10cDAzLm9yYWNsZS5jb20rUEAmZG93bmxvYWRfaWQ9ODk5MjUwMjQ@&AuthParam=1380419967_28dfc2102fe846ff2174b1e94a41a82d [237980/237980] -> "p16605855_12.2.0_R12_GENERIC.zip" [1]
    Completed with status: 0
    [applvis@breen other_patches]$ unzip -q p16605855_12.2.0_R12_GENERIC.zip -d $APPL_TOP_NE/../patch
    [applvis@breen other_patches]$ adop phase=apply patches=16605855 hotpatch=yes
    (adop output snipped)
    [applvis@breen other_patches]$ $ADMIN_SCRIPTS_HOME/adstrtal.sh

That’s a wrap! (Sort of…)

At this point, you can start exploring your 12.2 instance a little bit. You’ll find that on the surface it looks a lot like a 12.0 or 12.1 instance. The login URL, if you’ve followed these instructions, should be http://breen.local.org:8000/OA_HTML/AppsLocalLogin.jsp (substitute your hostname for breen.local.org, of course). If you can’t guess the default password for SYSADMIN and other user accounts, you’ll find them in the Install/Upgrade Guide.

But wait, there’s more! In upcoming posts, I’ll cover some basic orientation to your new Vision instance, and then we’ll dive in to upgrading it to version 12.2.2, which is where you’d expect to be if you were deploying 12.2 in real life.

64 Responses to “Step-by-step installation of an EBS 12.2 Vision instance”

  • Raj says:

    John, Very good posting. Being non DBA, Was able to bring instance up via this post.

    After I restarted my computer, I’m unable to start WLS. Getting below message in log file. No detail error mss is there. Would appreciate your assistance to resolve ..

    ERROR: Unable to establish connection with the WebLogic AdminServer.
    Cannot register the WLS Notification Listeners.
    Exiting.
    The program exited with status 1

    • John Piwowar says:

      Hi Raj,

      In order to help more, I’d need to see the steps you took to start the services, and the output. I will only allow myself one flailing guess without more info: Are you sure that you sourced your environment correctly before running adstrtal.sh (I assume that’s what you ran)? The easiest way to do make sure you’re using the ‘run’ and not the ‘patch’ environment is to use the script Oracle provided with the Vision install: /u01/oracle/VIS/EBSapps.env

  • Ervin McFadden says:

    Can this be done with Oracle VirtualBox?

  • Karthikeyan Mahalingam says:

    John,

    Very good posting. But still few steps are pending like 12.2.2 AD and TXK Release Update Packs,12.2.2 Suite-Wide Release Update Pack and few Pre and Post steps of the patches.

    • John Piwowar says:

      Hi Karthikeyan,

      You are correct! I have a followup post for the 12.2.2 steps partly drafted, but life has been unexpectedly busy since I posted this guide. :) Fortunately, the 12.2.2 upgrade is pretty straightforward, just need to follow the steps in the docs. No hidden gotchas, just a lot of waiting.

  • longman says:

    John, i don’t see any “10.1.2 ORACLE_HOME stub library update (Note 1330701.1, “After Installing or upgrading”)” in note 1330701.1. is it misstake or i am wrong?

    • John Piwowar says:

      Hi Longman,

      According to the Change Record for the Note, this step was removed on 01 November, because the patch is now included as part of the 12.2 distribution. This means that people who downloaded early, but haven’t installed yet, might need to re-download the software. :)

      • longman says:

        1. so it is not necessary step if i have downloaded and have installed 12.2 some days ago, because it has included in last version install files, isn’t it?
        2. i have tried to install 166058555.. for beginning US version, then UK (Ukrainian), but UK version on installing step have said that patch was installed on system and have decided to stop further installation.
        command to install localized patch:
        adop phase apply=166058555_UK:u166058555.drv hotpatch=yes

        but in the install log i have saw such records:

        adpatch workers=4 flags=autoskip console=no interactive=no defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD_patch/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/166058555 driver=u166058555.drv

        if i have correct understood, it tries to install base version one more time (and don’t tries to install localized driver), where is my fault? thanks!

        • longman says:

          maybe problem in “hotpatch”-mode? because without it patching has processed successfully.. but why we can install base patch version in “hotpatch”-mode and installing of localized version is impossible?

        • John Piwowar says:

          Hi longman,

          1) That’s correct: if you downloaded the files after November 12, 2013, you should be ok. That’s the last updated date for the install media on Edelivery.

          2) I don’t think the issue in this case is related to NLS patching or the hotpatch option. From the logs, it looks like you’re specifying an invalid patch number, with an extra ’5′ at the end: 166058555 instead of 16605855.

          • longman says:

            extra ’5′ in logs is my fault in the post writing, i have edited logs manually before posting.. so all info, that i have described, is true and question about NLS patch is actual) if you will get additional info about this – please post it here.. thanks!

  • Maris Elsins says:

    Hi John,

    Is the blog post on “upgrading it to version 12.2.2″ coming soon?

    • John Piwowar says:

      Hi Maris,

      Hopefully. :) The good news is that it’s a straightforward process as described in the notes, but I understand the value of a “cookbook.”

      Feedback from others, and changes to the docs, have made it clear that there are some revisions required to this post as well, to make a few steps more clear.

  • Vlad says:

    Hi, John,

    The best R12.2 installation guide! Thanks for this work.

    Tried to find where is mentioned “10.1.2 ORACLE_HOME stub library update (Note 1330701.1, “After Installing or upgrading”), and found notes for 12.1.* only. Is it your guru’s postinstall step or is it really necessary for 12.2? :-)

    Regards,
    Vlad.

  • Kostyantyn says:

    Hi. Could you help me to solve an issue with adstpall.sh? When i am starting it then i am getting error like this.

    [root@node1 scripts]# ./adstpall.sh applR12/applR12

    You are running adstpall.sh version 120.22.12020000.5

    Enter the WebLogic Server password:
    adstpall.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

    USAGE: adstpall.sh [-skipNM] [-skipAdmin] [-nothreading]
    adstpall.sh -secureapps [-skipNM] [-skipAdmin]
    adstpall.sh -nodbchk [-skipNM] [-skipAdmin]

    adstpall.sh: exiting with status 1

  • Kostyantyn says:

    i am doing it by he reason as i have error like this after instalation OEBS 12.2 http://dbalertlog.blogspot.com/2013/10/ebs-122-post-install-steps-failing-http.html and i am trying fix them, but can not do it through issue with adstpall.sh

    • John Piwowar says:

      Hi Kostyantyn,

      Sorry for the delayed reply. I’m still catching up after the holidays. Two things I see here:
      1) You’re running adstpall.sh as root. This script should be run as the owner of the applications software (commonly referenced as the “applmgr” user, though the example in this blog post uses “applvis”).
      2) “Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong”: You don’t mention if you’ve tried to change the apps password, but the password you’re using (“applR12″) is not the default password for the apps user (“apps”).

  • Shoaib says:

    Hi John,

    Here I am looking for bit of a help, buildStage.sh script is not working for me when I am trying to create stage for R 12.2.2 it ca,’t find TechInstallMedia folder and subfolders.

    Any help or tip will be much appreciated, i have downloaded the files twice but still no luck.

    Thanks

    • John Piwowar says:

      Hi Shoaib,

      If buildStage.sh isn’t finding the right folders during the verify phase, some parts weren’t unzipped properly. Are you sure that you have have downloaded all the required files? Do the checksums for the files you’ve downloaded match the ones listed on edelivery?

  • kumar says:

    Hi shoaib,

    You have to download the techinstall one off patches which is included in r12.2.2 media pack in edelivery. Then move to software location and then try to rebuild the stage.

  • michis says:

    Hi,

    change one of the two tags “Oracle E-Business Suite” on the tag “Oracle E-Business Suite 12.2″

    http://www.pythian.com/blog/tag/12-2/
    http://www.pythian.com/blog/tag/oracle-e-business-suite-12-2/

  • longman says:

    Hi, John!
    i have the question. my thoughts: i have run and patch filesystem (FS). if i can apply the patches to the patch FS so i think that i must have the ability to test patched system before it will become as production run system. my abstract situation: i shutdown run system and with some actions i start patched system, where i can see how system is working with my applied bugfixing/patching/nls_patching.. is it real or it is only my dreams? i don’t find such information in the documentation. thanks!

    • John Piwowar says:

      Hi Longman,

      Unfortunately, it doesn’t work that way. You will still need a test system to test and validate changes. :) Users can only access the “Run” system, not the “patch” system.

  • Shoaib says:

    Thanks guys – I am sorted, instance was installed successfully but didn’t get a chance to complete post- installation steps.

    Thanks for your response anyway.

    Kind Regards

    Shoaib

  • Ravi Reddy says:

    Thanks for this clear and concise guide to help install EBS 12.2.0. I have never worked with EBS earlier and was still able to install it. I am stuck at patching 17064510. What is the default SYSTEM password for oracle database. Help will be appreciated.

  • Ravi Reddy says:

    I am a newbie to EBS and followed your instruction to get it installed on VMWARE Fusion running on a Mac Mini( OS X 10.9). The installation was successful and I am able to login into EBS. I work on fusion middleware and also get into security and access related tussle with the APPS administrator. Now I have my own environment and play around as I please. The problem I am facing is with ISG. I wasn’t able to find some clear instructions on how to use it. I am conversant with JDE E1 and BSSV technology. I am not sure if there is a separate process to setup ISG or is it already installed after the above mentioned steps.

  • sanjay naik says:

    MY 12.2 install failing ,with following error, I did 12.1.1 install with no issue

    installActions2014-02-18_08-37-44PM.log
    NFO: ———————————————–
    INFO: *********************************************
    INFO: Users With Same UID: This test checks that multiple users do not exist with user id as “0″.
    INFO: Severity:CRITICAL
    INFO: OverallStatus:VERIFICATION_FAILED
    INFO: ———————————————–
    INFO: Verification Result for Node:versatile
    WARNING: Result values are not available for this verification task
    INFO: Error Message:root,|sql,|0
    INFO: Cause:Cause Of Problem Not Available
    INFO: Action:User Action Not Available
    INFO: *********************************************

    I cleaned all my failed install three time , including oraInventory .. no luck

    • John Piwowar says:

      Hi Sanjay,

      This didn’t happen for my install, so I’m assuming there’s something different about your OS setup. The error is claiming that there are two users in /etc/passwd with uid 0, which suggests there’s some detail of your OS install/config that’s amiss.

  • Fadi Abadir says:

    I am installing a VISION instance from r12.2 and it is giving error complaining about oraInventory although it has read/write/exec permission on everything in it

    Below is the log file oracle.apps.fnd.txk.install0.log details

    Process Completed (255) /home/stage/stage122/TechInstallMedia/ohs11116/Disk1/runInstaller -waitForCompletion -ignoreSysPrereqs -force -silent -responseFile /home/applmgr/VIS/fs2/inst/apps/VIS_erp/temp/cfgHome/response/APPS_OHS_HOME/txkOHS_11116.rsp
    Stdout:
    Stderr: You do not have sufficient permissions to access the inventory ‘/home/oracle/oraInventory’. Installation cannot continue. Make sure that you have read/write permissions to the inventory directory and restart the installer.: Permission denied

    2014-02-23T14:32:43
    1393158763630
    57
    oracle.apps.fnd.txk.install
    SEVERE
    oracle.apps.fnd.txk.config.InstallService
    printError
    10
    oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed : Exit=255 See log for details. CMD= /home/stage/stage122/TechInstallMedia/ohs11116/Disk1/runInstaller -waitForCompletion -ignoreSysPrereqs -force -silent -responseFile /home/applmgr/VIS/fs2/inst/apps/VIS_erp/temp/cfgHome/response/APPS_OHS_HOME/txkOHS_11116.rsp
    at oracle.apps.fnd.txk.config.OUIPatchActionNode.processState(OUIPatchActionNode.java:159)
    at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)
    at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)
    at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79)
    at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68)
    at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594)
    at oracle.apps.fnd.txk.config.InstallService.doInvoke(InstallService.java:224)
    at oracle.apps.fnd.txk.config.InstallService.invoke(InstallService.java:237)
    at oracle.apps.fnd.txk.config.InstallService.main(InstallService.java:291)

    • John Piwowar says:

      Hi Fadi,

      Unfortunately, I don’t know very much about your setup. When I ran my install, I used a different inventory location and software owner than the ones you’re using. Therefore, I can only offer general advice: make sure that:
      1) You’re running the installer as root
      2) The inventory directory exists before you run the installer
      3) The inventory location is in /etc/oratab before you run the installer

  • François Gendron says:

    I see a lot of blogs, including this one, who refer to the file /u01/oracle/VIS/EBSapps.env, but I do not have that file at the end of a R12.2 install with Start CD 12.2.0.47.

    I have the /u1/oracle/VIS/fs1/EBSapps/appl/APPSVIS_xxx.env and the same in fs2.

    Am I missing some step that creates the /u01/oracle/VIS/EBSapps.env?

    • John Piwowar says:

      Hi François,

      Which install type (standard/express) and database type (Vision/fresh) did you choose for the installation? Some of my colleagues reported that the EBSapps.env script did not exist for them, but they did not install a Vision demo database. From your comment, it looks like you installed a Vision demo database, not a “fresh” database, but I want to be sure. :)

      I also used an earlier version of startCD. I hope they didn’t take the script out in later revisions; it’s really useful.

      • François Gendron says:

        John,

        I did indeed install a standard Vision (VIS) instance, not express.

        Does this mean I have to remember which fs1 or fs2 env file to use?

        François

        • John Piwowar says:

          Hi François,

          One final question: have you updated the instance to 12.2.2 yet? I did some research, and found a My Oracle Support Note that suggests the EBSapps.env script isn’t delivered until 12.2.2, and provides another method for 12.2.0: Note 1545584.1.

          Of course, that makes me wonder why this post, which only addresses 12.2.0, references EBSapps.env. It’s possible that I copied that part of my stop/start instructions from the wrong set of notes. If that’s the case, I apologize for the confusion. Note 1545584.1 suggests a workaround for 12.2.0, but you’re probably better off to just apply the 12.2.3 patch anyway. :)

          • François Gendron says:

            John,

            Thank you for the information on note 1545584.1.

            My question was indeed because I am working on directly applying 12.2.3 on my new 12.2.0 instance, and trying to figure out my first time patching with adop.

            Hopefully will have a 12.2.3 instance today!

            Thanks for you help,

            François

  • Rohit says:

    Hi John,
    Thank you for the great article. This along with the install guide has been a very useful resource for my R12.2 Vision Install.

    I am working on installing the R12.2 as a multi-node setup with the DB and Apps server residing on two different VMs. The DB server is up and running but while trying to run rapidwiz I am running into issues. The conf_.txt file from the DB server has been imported and when trying to use it for loading the configuration returns the following error.

    “RW-00014: – Invalid configuration file. Incorrect value for ‘NUMBER_OF_HOSTS’ in ini file”

    Any ideas or suggestions what could be causing this error and steps that can be taken to over come this issue

    Thanks a lot for your help.

    -Rohit

    • Rohit says:

      Just as an update for the issue the resolution was a patch from Oracle.
      Please refer to the following Oracle Support document

      R12.2: How To Create the Stage In Preparation For Installation (Doc ID 1596433.1)

      thanks
      Rohit

  • Ateeq ur Rehman says:

    Dear Jhon
    Thanks for this post, its really a big help to install EBS R12 and you describe all detail in beautiful way. I am trying to install EBS R12 12.2 on Oracle Linux 6. i completed all steps successfully. on 12% of installation of repidwiz one error is generating on running “adrundb.sh” script . this is exactly at Restoring Database Via RMAN. I checked log files. in log file following error is showing .

    Context Value Management will now update the Context file

    #

    # A fatal error has been detected by the Java Runtime Environment:

    #

    # SIGSEGV (0xb) at pc=0x0000003a69014d70, pid=17052, tid=139644905621264

    #

    # JRE version: 6.0_17-b04

    # Java VM: Java HotSpot(TM) 64-Bit Server VM (14.3-b01 mixed mode linux-amd64 )

    # Problematic frame:

    # C [ld-linux-x86-64.so.2+0x14d70]

    #

    # An error report file with more information is saved as:

    # /tmp/hs_err_pid17052.log

    #

    # If you would like to submit a bug report, please visit:

    # http://java.sun.com/webapps/bugreport/crash.jsp

    # The crash happened outside the Java Virtual Machine in native code.

    # See problematic frame for where to report the bug.

    #

    ERROR: Context Value Management Failed.

    Terminate.

    can you please help me to resolve this problem.

    A lot of Thsnks in advance.

    Kindly yours

    Ateeq ur Rehman

  • Thanks for your post. It is excellent.
    Concerning the required downloads.
    1. Is this download required to be in the stage directory? In (Doc ID 1588372.1) it references the Oracle E-Business Suite Release 12.2.0 for Rapid Install Technology One-Off Patches.
    2. Your download list includes the documentation. That differs from the DOC as well. If I place the documents in the stage122 directory will the build stage fail?
    Thanks,

    Paul

    • John Piwowar says:

      Hi Paul,

      Thanks for pointing these things out.
      1) Good eye. It’s possible that I had a mistake in my post, since I can see that the part number for one-off patches ( V35813-01) is listed as part of the “Rapid Install Databases VISION” list. It’s also possible that Oracle changed the name of the file after I wrote my post, but no one ever went broke betting on me making typos. ;)
      2) I doubt that the documentation zip will break the stage area, but I didn’t include it when building my stage directory.

  • shadab akram khan says:

    hi all,

    i m trying to install EBS 12.2.0 on windows i m getting error in post installation step please help me resolving this error
    Virtual Directory

    checking URL = http://appserp.pilog.in:8000/OA_MEDIA/FNDLOGOL.gif
    Page is responding
    checking URL = http://appserp.pilog.in:8000/OA_JAVA/oracle/apps/fnd/admin/server/server.xml
    Page is responding
    checking URL = http://appserp.pilog.in:8000/OA_CGI/FNDWRR.exe
    RW-50016: Error: – {0} was not created:
    File = {1}

    Thanks & Regards
    Shadab

  • Hosney Osman says:

    i am using EBS version 12.2.3
    using weblogic 11
    i want to change the weblogic login password
    is there any additional steps related to EBS

  • Harshal D says:

    Hello there,

    Can you share your getOraPatch script as well? That looks very interesting to me…

    Thank you,
    Cheers,
    H

  • Thanks for your document. Very well done.

    During the buildstage.sh it completed and showed a valid status

    The buildstage just completed.
    It shows all areas as valid yet we had an unzipping error:
    Unzipping V35807-01.zip
    Error unzipping file V35807-01.zip
    java.util.zip.ZipException: error in opening zip file 11 java.util.zip.ZipFile.open(Native Method)
    at java.util.zip.ZipFile.(Unknown Source)
    at java.util.zip.ZipFile.(Unknown Source)
    at oracle.apps.ad.rapidwiz.util.StageBuilder.createStage(StageBuilder.java:90)
    at oracle.apps.ad.rapidwiz.util.StageBuilder.run(StageBuilder.java:40)
    at oracle.apps.ad.rapidwiz.util.StageBuilder.main(StageBuilder.java:471)

    Even the during the buildstage.sh the EBS ssye
    Verifying stage area…
    Directory /StageR122/TechInstallMedia is valid
    Directory /StageR122/TechPatches/DB is valid
    Directory /StageR122/TechPatches/MiddleTier is valid
    Directory /StageR122/EBSInstallMedia/AppDB is valid
    Directory /StageR122/EBSInstallMedia/Apps is valid
    Directory /StageR122/EBSInstallMedia/AS10.1.2 is valid
    Directory /StageR122/TechInstallMedia/database is valid
    Directory /StageR122/TechInstallMedia/ohs11116 is valid
    Directory /StageR122/TechInstallMedia/wls1036_generic is valid
    Stage area verified.

    How should I proceed?

    Paul

    • John Piwowar says:

      Hi Paul,

      You might want to confirm that the md5sums for the downloaded files are valid. It’s possible you have a corrupt zip file. The “validation” part of buildstage.sh isn’t a very robust check. It checks for expected directory structures, but doesn’t validate the contents for completeness.

  • Dilipkmg says:

    Please Provide 12.1.3 to 12.2 upgrade

    Thanks in advance

    Thanks
    Dileep

    • John Piwowar says:

      Hi Dilip,

      I don’t think a blog post about the upgrade process would add very much to the already-published upgrade instructions. I recommend reviewing the available notes on My Oracle Support and following those instructions carefully. :)

  • Farhan Ziya says:

    Thanks John Piwowar for the great post. it really helped us get the EBS ready in a day.

    We followed the steps mentioned above and successfully installed the Oracle EBS on an OEL machine. But we are not able to see some of the modules mentioned below:-
    1. Oder Management (OM)
    2. Trading Community Architecture (TCA)
    3. Interface Table of AR
    4. Inventory (INV)
    5. General Ledger(GL)
    6. FND
    7. FND Application Object Lib

    Please help us with the steps required to get these modules installed.

    Thanks,
    Farhan

    • John Piwowar says:

      Hi Farhan,

      If you installed the Vision database, as described in the instructions, these modules should be available to you already. How did you conclude that the listed modules are not in place? Are you sure you didn’t perform a fresh install (empty database instead of Vision demo db)?

      • Farhan Ziya says:

        Thanks John for the reply.

        When we launch the EBS application we are unable to see these modules in the “Main Menu”.
        Please note that, we have followed exactly the same steps as in this post except the option number-4 (Adjust the RMAN restore script for the Vision database install, as discussed in my previous post) as its mentioned as optional. We have also not performed the “post-install steps”.

        Please help me as what shall I do next to get these modules installed and be visible in the Main Menu.

        Thanks,
        Farhan

  • Farhan Ziya says:

    Thanks John for the reply,

    When we go to http://ebs.test.com:8000/OA_HTML/AppsLocalLogin.jsponly, we can not see these modules there.
    We have followed exactly the same steps mentioned in this blog except the option no 4 ([Optional] Adjust the RMAN restore script for the Vision database install, as discussed in my previous post.).
    Since it is mentioned as optional we didn’t perform this step.

    Please suggest the next course of action.

    Thanks,
    Farhan

  • Farhan Ziya says:

    Hi John,

    Please note that, We have also not performed the “post-install steps”.

    I have been digging into google for this case and found in a blog which says that I need to install “Oracle E-Business Suite Extensions for Oracle Endeca” to get these additional modules.
    I am totally new to Oracle and will really appreciate if you can please help me to get these modules up and running.

    Thanks,
    Farhan

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>