SHIFT

--- Sjoerd Hooft's InFormation Technology ---

User Tools

Site Tools


Sidebar

Sponsor:

Would you like to sponsor this site?
Or buy me a beer?:


Recently Changed Pages:

View All Pages
View All Q Pages


View All Tags


Sign up for Q to post comments.





WIKI Disclaimer: As with most other things on the Internet, the content on this wiki is not supported. It was contributed by me and is published “as is”. It has worked for me, and might work for you.
Also note that any view or statement expressed anywhere on this site are strictly mine and not the opinions or views of my employer.


Terms And Conditions for Q users


Pages with comments

PageDateDiscussionTags
2018/12/27 23:38 4 Comments
2018/12/11 20:07 2 Comments
2017/04/20 16:35 1 Comment
2017/04/20 15:28 1 Comment
2017/04/20 15:23 1 Comment
2017/04/19 14:59 1 Comment
2017/04/19 14:44 1 Comment
2017/04/17 20:10 1 Comment
2017/04/17 20:07 1 Comment
2017/04/17 19:58 1 Comment
2017/04/17 19:52 1 Comment

View All Comments

oracleclientinstall

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

You could leave a comment if you were logged in.
oracleclientinstall.txt · Last modified: 2013/03/08 05:01 by sjoerd