Tanti Technology

My photo
Bangalore, karnataka, India
Multi-platform UNIX systems consultant and administrator in mutualized and virtualized environments I have 4.5+ years experience in AIX system Administration field. This site will be helpful for system administrator in their day to day activities.Your comments on posts are welcome.This blog is all about IBM AIX Unix flavour. This blog will be used by System admins who will be using AIX in their work life. It can also be used for those newbies who want to get certifications in AIX Administration. This blog will be updated frequently to help the system admins and other new learners. DISCLAIMER: Please note that blog owner takes no responsibility of any kind for any type of data loss or damage by trying any of the command/method mentioned in this blog. You may use the commands/method/scripts on your own responsibility. If you find something useful, a comment would be appreciated to let other viewers also know that the solution/method work(ed) for you.

Sunday, 2 March 2014

Oracle Client Installation AIX


Pre Installation Tasks

Oracle client has several requirements. Please note that this article is purely for my environment because we don't use an out-of-the-box installation but AIX SOE. I can skip these steps because they are all taken care of in the SOE, or because the blades are specifically bought for this purpose and meet requirements by far:
  • X Window System requirements
  • Hardware requirements
  • Operating System level
  • Operating System filesets
  • Network setup
  • Check for unprivileged user nobody

Creating Users and Groups

Oracle Inventory Group (oinstall)

You must create this group the first time you install Oracle software on the system. The usual name chosen for this group is oinstall. This group owns the Oracle inventory, which is a catalog of all Oracle software installed on the system.
sudo mkgroup oinstall

Creating the OSDBA Group (dba)

You must create this group the first time you install Oracle Database software on the system. It identifies operating system user accounts that have database administrative privileges (the SYSDBA privilege).
sudo mkgroup dba

Creating the OSOPER group (oper)

This is an optional group. Create this group if you want a separate group of operating system users to have a limited set of database administrative privileges (the SYSOPER privilege).
sudo mkgroup oper

Creating the Oracle Software Owner User (oracle)

Note: most security auditors will not let you use a user called oracle, so keep that in mind.
You must create this user the first time you install Oracle software on the system. This user owns all of the software installed during the installation. This user must have the Oracle Inventory group as its primary group. It must also have the OSDBA group as secondary groups. 
sudo mkuser pgrp="oinstall" groups="oinstall,dba,oper" shell='/bin/bash' rlogin='false' sugroups='ALL' su='true' loginretries='10' maxage='0' maxrepeats='8' minlen='5' minother='1' maxexpired='-1' minalpha='3' minage='0' histsize='0' histexpire='0' "oracle"
Set this for the user:
  Soft FILE size                                     [-1]
  Soft CPU time                                      [-1]
  Soft DATA segment                                  [-1]
  Soft STACK size                                    [-1]
And set the password:
>sudo passwd oracle

Changing password for "oracle"
oracle's New password:
Re-enter oracle's new password:

>sudo pwdadm -c oracle

System Environmentals

You need to set the maximum number of processes users are allowed to run:
sudo chdev -l sys0 -a maxuproc='2048' 

Oracle Directories

/opt>sudo mkdir oracle
/opt>sudo chown oracle:oinstall oracle
Gives:
drwxr-xr-x   2 oracle   oinstall        256 Mar 19 11:22 oracle

Installation

One note: I am not allowed to log in on the server using a local account (due to the security policy) so I first need to login using my personal account, su to the oracle user and then run the installation. But because I'm su-ing, I cannot use the X Server authentication for my account, why not, and how to solve this is explained in this section.
After you know you have your X Server working you can start the installation as the oracle user you just created:
oracle@oracleserver:/home/oracle>cd /tmp/sft/Disk1/
oracle@oracleserver:/tmp/sft/Disk1>./runInstaller
**************************************************************************
******

Your platform requires the root user to perform certain pre-installation
OS preparation.  The root user should run the shell script 'rootpre.sh' be
fore
you proceed with Oracle installation.  rootpre.sh can be found at the top
level
of the CD or the stage area.

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

**************************************************************************
******

Has 'rootpre.sh' been run by root? [y/n] (n)
y

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-03-19_12-10-24PM. Please wait ...oracle@oracleserver:/tmp/sft/Disk1>Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
Here starts the graphical installation:

In the first screen I entered the oracle inventory directory as /home/oracle/oraInventory. You could also decide to set this directory next to the client, so in my case in /opt/oracle/oraInventory.
oraclientinstall01.jpg
oraclientinstall02.jpg
oraclientinstall03.jpg
oraclientinstall04.jpg
oraclientinstall05.jpg
oraclientinstall06.jpg
oraclientinstall07.jpg
When you get to this screen you have to run the showed scripts as root, although the first script can be executed by someone who is allowed to sudo:
oracle@oraleserver:/home/oracle/oraInventory>sudo ./orainstRoot.sh
Changing permissions of /home/oracle/oraInventory to 775.
Changing groupname of /home/oracle/oraInventory to oinstall.
The execution of the script is complete

For the second script you have to be root:
su - root
root's Password:
# bash
bash-3.2# cd /opt/oracle/client/
bash-3.2# ./root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /opt/oracle/client

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

Now, all that is left is to close the installation:
oraclientinstall08.jpg 

No comments:

Post a Comment