The Blog of Nenad

0. Requirements
To check the memory, recommended 512 MB
# grep MemTotal /proc/meminfo

To check the swap space, run:
# cat /proc/swaps

The Oracle Universal Installer requires up to 400 MB of free space in the /tmp directory. To check the space in /tmp, run:
# df /tmp

Disk Space: you will need about 2.5 GB for the database software. If you perform a typical database installation and not a customized database installation, then you will need about 3.5 GB of disk space.

1. Environment & system
- Required kernel parameters
SEMMNI 100 Defines the maximum number of semaphore sets in the entire system.
SEMMNS 256 Defines the maximum semaphores on the system. This setting is a minimum recommended value, for initial installation only. The SEMMNS parameter should be set to the sum of the PROCESSES parameter for each Oracle database, adding the largest one twice, and then adding an additional 10 for each database.
SEMOPM 100 Defines the maximum number of operations for each semop call.
SEMMSL 100 Defines the minimum recommended value, for initial installation only.
SHMMAX Set this parameter to half the size of physical RAM available on your system. This value cannot exceed 4294967295
SHMMNI 100 Defines the maximum number of shared memory segments in the entire system.
SHMALL 2097152 Defines the maximum total shared memory system wide.

- Modify your kernel settings in /etc/sysctl.conf (RedHat) as follows:
- Example settings, good for 10g also ---------------
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
kernel.hostname = rhl4.pkurs.com #<--- full qualified hostname !!
kernel.domainname = pkurs.com #<--- correct domain name !!
fs.file-max = 327679
-----------------------------------------------------

- Apply new kernel settings to current session with
# sysctl -p
- Run the following command to check the current kernel parameters have been sucessfully changed
# sysctl -a
- Hostname command should return the fully qualified hostname as shown below
# hostname
hostname.domainname
- If any Java packages are installed on the system, unset the Java environment variables, for example JAVA_HOME.
- The oracle account used to install Oracle 9.2.0.1, should not have the Oracle install related variables set by default. For example setting ORACLE_HOME, PATH, LD_LIBRARY_PATH to include Oracle binaries in .profile, .login file and /etc/profile.d should be completely avoided.

2a. Packages
rpm -q make \
compat-db \
compat-gcc-32 \
compat-gcc-32-c++ \
compat-oracle-rhel4 \
compat-libcwait \
compat-libgcc-296 \
compat-libstdc++-296 \
compat-libstdc++-33 \
gcc \
gcc-c++ \
gnome-libs \
gnome-libs-devel \
libaio-devel \
libaio \
make \
openmotif21 \
xorg-x11-deprecated-libs-devel \
xorg-x11-deprecated-libs \
ORBit-devel \
gtk+-devel \
imlib-devel \
glib-devel

*** libaio-devel CD3
*** gnome-libs-devel CD4
*** ORBit-devel CD4
*** glib-devel CD4
*** gtk+-devel CD4
*** imlib-devel CD4

2b. The compat-oracle-rhel4-1.0-3 and compat-libcwait-2.0-1 packages are available from Oracle Metalink Patch 4198954. Install them now.
While installing the patch you might receive the warning. It is a normal behaviour.
- warning ---------
rpm -ivh compat-libcwait-2.0-2.i386.rpm
Preparing... ########################################### [100%]
cat: /etc/ld.so.preload: No such file or directory
1:compat-libcwait ########################################### [100%]
-------------------

3. Creating Oracle User Accounts
su - root
groupadd dba # group of users to be granted with SYSDBA system privilege
groupadd oinstall # group owner of Oracle files
useradd -c "Oracle software owner" -g oinstall -G dba oracle
passwd oracle

4. Creating Oracle Directories
su - root
mkdir -p /u01/app/oracle/product/9.2.0
chown -R oracle.oinstall /u01
mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chmod 755 /var/opt/oracle

5. Setting Oracle Environments
export LD_ASSUME_KERNEL=2.4.19
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin

6. Start runInstaller
as root
# mount /mnt/cdrom
as oracle
$ /mnt/cdrom/runInstaller
- During the linking phase you might recieve the error if you have installed the agent. To overcome this problem. Please apply the Patch 3119415. (OPATCH utility needed)
- Also some "ins_ctx.k" file problem
- Also some "Apache/ports.ini" problem

7. Post Installation
7a. Before installing 9.2.0.5.0 Patchset, do the following:
7a1. Edit the /Disk1/install/oraparam.ini file supplied with the 9.2.0.5 patchset so that the line:
Linux=redhat-2.1,UnitedLinux-1.0,redhat-3,SuSE-7,SuSE-8
is changed to:
Linux=redhat-2.1,UnitedLinux-1.0,redhat-3,redhat-4,SuSE-7,SuSE-8
7a2. Now OUI 10.1.0.2 will start from /Disk1 (the 9.2.0.5 patchset staging area)
7a3. Install OUI 10.1.0.2 in main 9.2 ORACLE_HOME
7a. Install 9.2.0.5.0 Patchset, using installer from 9.2.0.5 Patchset shiphome
7b. Before installing the 9.2.0.6.0 patchset, you must download the Patch 4188455. To apply the patch:
7b0. Deinstall old OUI 2.2.0.10 from ORACLE_HOME (NOT NECESSARY)
7b1. Extract the patch 4188455 to a temp location, say, /tmp
7b2. Run the installer from the DB 9206 patchset shiphome with the argument -paramFile .
7b3. Install new OUI 10.1.0.3.0 in ORACLE_HOME using OUI from PatchSet 9.2.0.6.0 distribution. Newly installed OUI doesn't work from ORACLE_HOME.
7c. Install Patchset 9.2.0.6.0 using OUI from PatchSet 9.2.0.6.0 distribution.
*** Error linking ins_oemagent.mk
7d. After installing the 9.2.0.6.0 patchset, you should apply the Patch 4190568.
7e. Edit .bash_profile and add
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
8. Database creation with dbca utility: before using dbca, do the following (as root)
# touch /etc/rac_on
*** ORA-29807 encoutered while "Creating data dictionary views" - Ignored as advised on Metalink Note 237486.1

# posted by Gospodar Finansija @ 10:01 AM