Archive for October 2010

How to workaround the issue with changing DVD when staging Oracle E-Business Suite R12 Software   4 comments

Starting with R12, Oracle E-Business suite installation media has the special perl script  adautostg.pl to load the installation software and  the EBS database files from a set of DVDs to the staging area. However this perl script may run into some issues when changing DVDs:

  1. The Perl script doesn’t eject the old DVD  once it finishes copying files from the DVD

  2. Once users  manually put the new DVD to the DVD driver, OS automatically mount the DVD into a different mount point for a different DVD, for example, the DVD mount point can be /media/oradb01 for Database disk1 DVD and /media/oradb02 for Database disk2 DVD. But the perl script only looks for the same mount for all the DVDs. Therefore, once we put the new DVD to the DVD driver, the Perl script just can’t find the new DVD as the DVD mount point has been changed from the previous mount point and the staging process can’t go any further.

The issue can be solved with the  following workaround:

.  Use  the fix mount point, for example, /media/oracle to the when running the staging script

.  To change the DVD, manually dismount the DVD and eject the DVD. After put the new DVD, the OS automatically mounts the new DVD to a new mount point. We need to dismount the DVD from the new OS assigned mount point and manually mount the DVD to the fixed  mount point such as /media/oracle.

For example, the following steps allow us to change the database disk1 DVD to database disk2 DVD once the staging script finishes the database disk1 and prompts for database disk2:

       $umount /media/oracle   (un-mount Database disk1 DVD)

      $eject                              (eject Database disk1 DVD)

      Manually remove the old database disk1 DVD from the DVD driver

    Manually put the new database disk2 DVD to the DVD driver

    $umount /media/oradb02  (un-mount the new database  disk2 DVD from the default mount point /media/oradb02)

   $mount –t iso9660 /dev/scd1 /media/oracle  (manually mount the new database disk2 DVD to the fixed mount point /media/oracle

By combing these two workarounds, there are the steps to run the perl script:

[root@gfsdevdb u01]# /media/oracle/Disk1/rapidwiz/adautostg.pl

Starting AutoStaging at Mon Sep 27 14:22:10 2010

Using adautostg.pl version 120.12

This script allows you to stage Oracle Applications which contains:

    – Database Technology Stack (11g)

    – Database (Vision or Fresh)

    – Applications Technology Stack (10.1.2, 10.1.3)

    – Applications APPL_TOP & COMMON_TOP

Enter a directory path where the media is to be staged (For example: To create 

the stage area at /u01/StageR12 enter /u01 ) :/u01

The stage area will be created at /u01/StageR12

Do you use AutoMount to mount/umount the media y/n [y]?y

Select Option 1 for a complete Oracle Application Environment Install.

    1  – Complete Oracle Apps Env (11g, Database, 10.1.2, 10.1.3, APPL & COMM)

Or choose the individual components you want staged

    2  – Database Technology Stack Only (11g)

    3  – Database Only (Vision or Fresh)

    4  – Applications Technology Stack Only (10.1.2, 10.1.3)

    5  – APPL_TOP & COMMON_TOP Only

Enter number codes separated by spaces [1]:

Checking diskspace …Ok.

Staging startCD …Done.

Staging Rdbms …

Insert the DVD labeled Oracle Applications Rapid Install – Rdbms Disk 1  and press <ENTER>:

Before press <ENTRE>, do the following steps in a separate window:

[root@gfsdevdb u01]# umount  /media/oracle

[root@gfsdevdb u01]# eject /media/oracle

Put the RDBMS disk1 to the DVD driver

    $umount /media/oradb01

    $mount -t iso9660 /dev/scd1 /media/oracle

Then press <ENTER> to load RDBMS disk1 to the staging

And continue this way to load the 9  database disks, one application technology stack (tools) disk and two APPL_TOP disks.