Total Tayangan Halaman

Powered By Blogger

Rabu, 27 April 2011

ORACLE 11g R2 Solaris x86_64 Installation Guide on Solaris 10 u9 x86_64

I. Prerequisite Installation
a. RAM min 4G
HDD min 3.73 for Software and 1.48 for Data Files (Standard edition)
b. JRE or JDK file version 1.5 or above.
By default, Solaris 10 u9 has installed java on the system.
For example, the following is the java version on 192.168.1.51
# java -version
java version "1.6.0_21"
Java(TM) SE Runtime Environment (build 1.6.0_22-b04)
Java HotSpot(TM) 64-Bit Server VM (build 17.1-b03, mixed mode)
c. Package Requirement files
Install package files as follow with the command :
#pkgadd –d . package_directory_name
The followings are the Package files to be needed by Oracle 11g R2 installation.

SUNWarc ready installed
SUNWbtool ready installed
SUNWhea ready installed
SUNWlibC ready installed
SUNWlibm ready installed
SUNWlibms ready installed
SUNWsprot ready installed
SUNWtoo ready installed
SUNWi1of ready installed
SUNWi1cs (ISO8859-1) need to be installed from DVD OS Source folder “Products”
SUNWi15cs (ISO8859-15)  need to be installed from DVD OS Source folder “Products”
SUNWxwfnt ready installed
SUNWcsl ready installed

The Package files can be found in folder “product” of DVD Solaris 10 u9.
To determine the package is installed on the system, use the following command
#pkginfo –i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibms SUNWsprot
#pkginfo –i SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt

d. Patches Requirement files
Install patches files as follow with the command :
#patchadd –M patch_id
The followings are the Patchesfiles to be needed by Oracle 11g R2 installation.

120754-06: SunOS 5.10_x86 libmtsk
119961-05: SunOS 5.10_x86: Assembler
119964-14: SunOS 5.10_x86 Shared library patch for C++_x86
137104-02
139575-03
139556-08
141445-09 (11.2.0.2)
141415-04

The patches usually is ready installed on Solaris 10 u9, but if not installed, you should have from Oracle – Solaris support.

To determine the package is installed on the system, use the following command
# /usr/sbin/patchadd -p | grep patch_number(without version number)
# /usr/sbin/patchadd –p | grep 120754

II. Oracle 11gR2 Installation
Login as root into Solaris 10 u9.
Add group installation and dba
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
Add user oracle
If user oracle exist please check by command:
# /usr/sbin/usermod -g oinstall -G dba oracle

If user oracle doesn’t exist please type the following command:
# useradd -g oinstall -G dba -d /export/home/oracle -s /usr/bin/bash oracle
# mkdir /export/home/oracle
# chown oracle:oinstall /export/home/oracle
# passwd –r files oracle
Login as “oracle” user into Solaris 10 u9.
# su - oracle
Copy the zip installation file :
“solaris.x64_11gR2_database_1of2.zip & solaris.x64_11gR2_database_2of2.zip” into oracle home directory: export /home/oracle
Use WinSCP to copy zip file from your windows xp into oracle home directory

Unzip the zip installation file :
$ unzip solaris.x64_11gR2_database_1of2.zip
$ unzip solaris.x64_11gR2_database_2of2.zip

You will have “database” folder containing the installation oracle files.

Login as root into Solaris 10 u9.
Edit and Setup Kernel Parameter, bu use the project to configure kernel parameter, it will impact to /etc/system file
#projadd -U oracle -K "project.max-shm-memory=(priv,4g,deny)" oracle
#projmod -sK "project.max-sem-nsems=(priv,256,deny)" oracle
#projmod -sK "project.max-sem-ids=(priv,100,deny)" oracle
#projmod -sK "project.max-shm-ids=(priv,100,deny)" oracle

# cat /etc/project

Verify resource control is actived
# su - oracle
$ id -p
uid=100(oracle) gid=100(dba) projid=100(group.dba)
$ prctl -n project.max-shm-memory -i process $$
$ exit

Make Folder installation and change the directory the permission to “oracle” user software
# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle

# mkdir -p /u02/oradata
# chown -R oracle:oinstall /u02/oradata
# chmod -R 775 /u02/oradata
Login as “oracle”user by type :
# su – oracle

Edit and setup your profile (bash profile)
$ vi .bash_profile
Add the following line into .bash_profile file
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_home; export ORACLE_HOME
ORACLE_SID=sales; export ORACLE_SID
PATH=$PATH:/usr/local/bin:/usr/ccs/bin:/export/home/oracle/database:$ORACLE_HOME/bin

Relogin as “oracle” user to get an effect from .bash_profile.
$ exit
# su – oracle

Set DISPLAY variable on the local or remote machine
$ export DISPLAY=local_host:0.0

$ export 192.168.1.57:0.0
 if installed through server/local machine
$ export 192.168.1.222:0.0
 if installed through remote (using xManager remote desktop)

Now to enable X applications, run the following commands on the other terminal winndows of the local computer:
# login: root
# xhost +

Install the Oracle Database by type the following command:
$cd database
$pwd
/home/oracle/database
$./runInstaller


“Good Luck”

III. Error Installation

1. This is a prerequisite condition to test whether the hard limit for "maximum user processes" is set to at least 16384.

Solaris kernel modification with the following commands:
# RAM_MB=`prtconf |grep Memory|awk '{print $3 }'`
# echo $RAM_MB
3072
# SHMMAX=`expr $RAM_MB \* 1024 \* 1024 \* 70 / 100`
# echo $SHMMAX
2254857830
# projadd -U oracle user.oracle
# projmod -s -K "project.max-sem-ids=(priv,100,deny)" user.oracle
# projmod -s -K "process.max-sem-nsems=(priv,256,deny)" user.oracle
# projmod -s -K "project.max-shm-memory=(priv,$SHMMAX,deny)" user.oracle
# projmod -s -K "project.max-shm-ids=(priv,100,deny)" user.oracle
# projmod -s -K "process.max-file-descriptor=(priv,65536,deny)" user.oracle
# echo "set max_nprocs = 30000" >> /etc/system
# echo "set maxuprc = 16384" >> /etc/system
# init 6

Cek with command:
# kstat |grep v_maxup
v_maxup 16384
v_maxupttl 29995

# kstat |grep v_proc
v_proc 30000

Tidak ada komentar:

Posting Komentar