Oracle Applications DBA Blog

Release 12 Installation on Sun Solaris

Ever since the release of Oracle Applications release 12 i have been waiting do a post on the installation but never did get the chance. Now finally here it is.
The current post is a step by step documentation of install ting Oracle Applications Release 12 on Sun Solaris 8, 64 bit.

Before you begin the installation make you have staged your software. If you are staging from the DVD pack you can use the adautostg.pl script.
If you have downloaded from edelivery you can just unzip the various parts.

The staged directory structure should look something similar.
oraAS/
oraAppDB/
oraApps/
oraDB/
startCD/

Creating OS Users
The next step is to create two OS users for the database and the primary application tier.

useradd -g dba -d /home/applsam applsam
useradd -g dba -d /home/applsam orasam

Oracle Inventory.
Next i will set up my global inventory to a different location. It better to have this specially when you have multiple instances of different versions on the same box.

cd /var/opt/oracle/
vi oraInst.loc
inventory_loc=/d01/rel12/rel12inv
inst_group=dba

Pre requisite Patches and Packages
Make sure you have all the pre requisite patches and the packages for your OS platform.
You can find the list in the metalink note 402312.1
also you will need an approximate of 140GB to complete a VISION installation of Release 12.More Detailed space requirements can be found in the above mentioned release notes.

Starting The installation.
You can start the installation by setting the appropriate DISPLAY and the running rapidwiz. In a multi user installation you must start the installation from root

/startCD/Disk1/rapidwiz
./rapidwiz

The first screen is the rapid install welcome screen



Next you will be asked to select the type of installation you want to go ahead with. You can choose a standard or an express install. you can also choose to upgrade you oracle applications.



Release 12 comes bundled with Oracle Configuration Manager(OCM).OCM is a tool which allows oracle to gather system information about your instances to help provide support. In case you are planning to install OCM make sure the user through which the installation is  is being done is access to crontab.



If you have chosen to install OCM you will be provided with a screen to enter your CSI number and metalink account name.  Also your proxy details to connect to the internet.



If you have an existing configuration file yo can choose that here or choose to create a new config file for your installation.



Next you specify the port pool for your instance.



The Next screen allows you to specify your Database tier configuration details.



Now you specify the configuration details of your primary application tier.



The following screen shows your nodes and configuration, it also allows you to add a new server to this configuration.



After this a quick pre installation validation check is done,



The next screen allows you to review the components you are about to install.



The installation now begins.




After the installation a post validation similar to 11.5.10 is done and you can log on into the instance.

Posted by Sam at 01:56 AM | Permalink | Comments (7) | TrackBacks (0)

Demystifying RapidInstall

The RapidInstall is a Oracle tool that is responsible for doing the installation of Oracle Application. The latest version of  RapidInstall does most of the install and configuration process for us behind the scenes. In today’s post we will try to look what the RapidInstall actually does.

The installation of Oracle Application by RapidInstall happens in two phases

• The Database Tier Installation
• The Application Tier Installation

It also happens in the order mentioned. Not surprisingly when we are doing the installation in a multi node environment we start the installation from our database tiers first.

The RapidInstall executable is present in the startCD/Disk1/rapidwiz directory. Since the installation user interface is GUI driven it should be run either at the console or in a Xwindows session.

Pre Installation Tasks and Checks

The first task performed by the RapidInstall is to verify the user inputs entered through the first few screens of the Oracle  Applications installation. These values can either be entered manually or they can be picked up through a configuration file. In either case the RapidInstall makes a note of these values in a configuration file and before verifying their availability.

The tasks which the RapidInstall does at this stage includes

The RapidInstall in the very first stage makes a note of the type of Oracle Applications Installation which is being done  that is a Single Node or a Multi Node. It also take registers if the instances uses high availability features like load balancing or SHARED APPL_TOP.

In case of a multi node environment it also now registers the various node names and the their OS platforms in the configuration file.

The RapidInstall makes a note of the OS User and group for the Oracle user

It also makes a note of the directory structure and checks their availability which is required to hold the Database Tier of Oracle Applications which includes

Base Install directory
Oracle Home           
Data Top (SYS)        
Data Top (LOG)        
Data Top (TXN)        
Data Top (ARCHIVE)    

Now the RapidInstall proceed to make a note of the OS user and the OS group for the the Application Tier nodes if it is a multi node system this is process is repeated for all the nodes.

The RapidInstall now validates the directory structure required to hold the application tier file system which includes

Base Install directory
APPL_TOP Mount point  
APPL_TOP aux. 1       
APPL_TOP aux. 2       
APPL_TOP aux. 3      
COMMON_TOP          
8.0.6 ORACLE_HOME   
iAS ORACLE_HOME    
Temp Directory

Next the RapidInstall makes a note of the selected product and the product groups join the form of the internal product codes.

Now the RapidInstall makes a note of the selected languages and the database and Application character set selected.

After this the RapidInstall makes a note of the port pool entered and check the port availability for your Database,RFC,Forms Listener,Martics Server,Matrics Client,Forms Servlet Port Range,Reports Listener,Web Listener,JTF Fulfillment Server, Map Viewer Servlet,OEM Web Utility,VisiBroker OrbServer Agent,MSCA Server,MSCA Dispatcher,OACORE Servlet Port Range,Discoverer Servlet Port Range and the XMLSVCS Servlet Port Range.

The RapidInstall will now verify the Operating System version and patch level. For this it will use the checkOS.sh script located in rapidwiz/bin of your startCD.

At this stage the RapidInstall will create the directories for holding the database tier and application Tier of Oracle Applications, In case of a multi node system it will create the directories on the node in which the RapidInstall is run.

The RapidInstall now performs a check for the Operating System utilities which are required to perform the installation. The script used for this purpose is the adchkutl.sh. This checks for the following utilities
make
ld
cc
ar
ksh

Database Tier Install Tasks

Now the RapidInstall creates the Database Tier XML file. This is done using the adxdbctx.tmp template file. A temporary XML context file is located in the /tmp directory and the final file is copied on to the $ORACLE_HOME/appsutil directory.

After this the context file for the APPL_TOP is created. The template file used in this case is adxmlctx.tmp.

Now the stage is set for the creation of the database for Oracle Application. The RapidInstall uses the adridb.drv driver file for this purpose. This driver calls the adrun9i.sh file along with details of the XML context file as parameter. The adrun9i.sh  is responsible for the RDBMS installation based upon the operating system platform. RapidInstall executes this script as the Oracle OS user.

The RapidInstall will now check the contents of your stage area and start the unzipping of the required files for the database installation. At this stage the adrun9i.sh will call the instconf.drv to perform the instance configuration. Also executed is the addbtmpl.drv driver.

The next stage involves RapidInstall making the Oracle binaries. This involves copying the object files to the Oracle Home and making the required Oracle Executables. The adlnkoh.sh is executed by RapidInstall to do the linking.

The RapidInstall now starts the listener, It starts the database and registers it with the Operating system.

The database is created with default character set, the adsvdcnv.sh is executed to perform any character set conversion  required.

At the next stage the ADX Database Utility is run to perform the context value management for on your database based upon the values present in your context file.

At this stage the RapidInstall does a restart of your oracle applications database tier services this time using the Oracle Applications startup and shutdown scripts.

Application Tier Install Process

The RapidInstall first check the integrity of your stage location and unzips the required files to Application tier directories. If they were not created earlier RapidInstall now does the require per requisite checks and creates these  directories for you.

For the Applications Tier install the main driver file used by the RapidInstall is the adriapps.drv.This driver file call two additional script files which are the adrunias.sh and adrunat.sh

The adrunias.sh reads your APPL_TOP context file and relinks the executables for your iAS ORACLE_HOME.
The adrunat.sh again uses your context file to set up the other APPL_TOP executables and files.

Both the scripts run autoconfig to setup the environment and configuration files.

The interoperability patch 3830807 is also applied by RapidInstall at this stage for 3.0 compatibility.

At the next stage RapidInstall will call the ADX Database Utility which will read the APPL_TOP context file and perform context value management for the application tier context file.

Next RapidInstall will set the APPL_TOP file ownership and file permissions.

At this stage RapidInstall executes several scripts from your COMMON_TOP/admin/install directory. These scripts have sql scripts encapsulated within them and create the database objects and set attributes for them accordingly. Some of them also update the profile option values at the database level.

After this RapidInstall attempts to start all configured Applications Tier services that have been configured for that  particular node using the oracle Applications startup scripts.

A post installation check is carried out by RapidInstall now which first checks the Database availability check. For this the riwTDBup.sh script is used.

An environment check is done by sourcing each of the environment files which are
Database ORACLE_HOME environment file
Apps ORACLE_HOME environment file
iAS ORACLE_HOME environment file
ADOVARS environment file

A dbc file check is then initiated to verify the values present.

Next follows a HTTP check which is done by seeing the accessibility of the Oracle Applications HTTP URL.

A JSP check is done by using the dbc file, if your dbc file check fails most likely this check will also fail.

The login check is finally done using the ICXINDEX.htm file. 

Posted by Sam at 05:49 PM | Permalink | Comments (4) | TrackBacks (0)

Installing Oracle Applications 11.5.10.2 on Linux AS 4

In today’s post i will describe the steps to install oracle Application on linux. This is a simple single node installation.

Conventions
# prompt refers to my root prompt.
$ prompt refer to my user account prompts.
All OS commands are in italics as usual.

Verify OS version

The fist step would be however to verify your Linux installation. You could check the version of the Linux installed by the
command

# cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 2)

Operating System utilities Check

Perl Software

You must have perl 5.0053 or higher installed to be able to create the staging area using the perl script adautostg.pl

Java Requirement

On 11.5.10, Rapidwiz, installs the J2SE 1.4.2 automatically for systems running on Sun Solaris, Linux, or Windows Operating Systems.

Additional Patches

For Redhat linux 4 you must apply patch 4198954

This will installt the OS packages

compat-oracle-rhel4-1.0-5.i386.rpm
compat-libcwait-2.1-1.i386.rpm

Create directories to hold your Oracle Applications

# mkdir sam
# ls -l
total 24
drwx------ 2 root root 16384 Aug 30 14:41 lost+found
drwxr-xr-x 2 root root 4096 Sep 21 11:55 sam
# chmod -R 777 sam

OS user creation

I am following a unix multi user installation so you need to create two OS user accounts,orasam for the database and applsam for the applications.

# useradd -g dba -d /u05/sam/orasam orasam
# useradd -g dba -d /u05/sam/applsam applsam

Xhost client settings

If you are installing using a Remote XServer you may need execute the following command

# xhost +
access control disabled,clients can connect from any host

Set umask 022 for both the user accounts

Setting umask to 022 ensures that group and others have read and execute permissions,
but not write permission.

# su - orasam
$ vi .bash_profile
add the line at the end
umask 002

# su - applsam
$ vi .bash_profile
add the line at the end
umask 002

Modify the orainventory for your new installation

# vi /etc/oraInst.loc

inventory_loc=/u05/sam/oraInventory
inst_group=dba

Set the LD_ASSUME_KERNEL parameter for both the user accounts orasam
and applsam

# su - orasam
$ vi .bash_profile
add the lines at the end
LD_ASSUME_KERNEL=2.4.19
export LD_ASSUME_KERNEL

# su - applsam
$ vi .bash_profile
add the lines at the end
LD_ASSUME_KERNEL=2.4.19
export LD_ASSUME_KERNEL

Starting the installation

You start the installation as the root user by running the rapidwiz executable from

# cd /u02/stage11i102/startCD/Disk1/rapidwiz
# ./rapidwiz

The first which you see screen is the rapid install welcome screen.

In the next screen you see,It presents you with choices either to do a fresh installation or perform an upgrade of an existing instance, I choose the first oiption.

In case you have a configuration file you can browse and choose the file here. This option is useful while doing multi node installation. Since this is a fresh install I choose NO.

The next screen is used to decide if you wish to do a single node or a multi node installation, we chose a single node installation here.

In this screen you sepcify your database OS user account and its base directory.

 The following screen prompts to choose the kind of licensing we wish to have for our e business suite (in case of Vision installations you will not see this screen)

 

This screen is used to choose the country specific functionalities or localizations which might be required.

The next screen is used to select any additional language which we might want to install with ebusiness suite. You must have staged the appropriate language CD before selecting the language.

You must now select the character set for your database and applications, I used UTF8 to allow me to add additional languages in the future.

In this screen you specify your OS application user account and the base directory for it. You can click on advanced to further edit the directory structure.

Now you specify your domain name, and port pool. Your port pool is used to assign the ports for your various oracle application process without causing a conflict

You can specify a location to save the configuration information you have entered so far. In case of a multi node installation this config file is used to do the installation on the other nodes.

The installer will now perform a check for all the OS utilities disk space permissions port availability and display the results.

You will be prompted to start the installation of oracle applications in the next screen.

 

A progress window will now display the status of your installation while you grab a drink for your self

 

After the installation is completed a post installation sheck will be done to ensure that all the services are working as desired.

Note: The installtion described above was single node installation of PROD instance of Oracle Applications on a Linux environment.

Posted by Sam at 06:25 PM | Permalink | Comments (23) | TrackBacks (0)