Quick Installation Point Oracle Database 11g – Linux (32 bit or 64 bit)


This is a step point for you to installation database 11g. You can set or change this step as you needed for you system.

cek ram, swap, shared memory, system architecture, tmp (400MB), freespace

# grep MemTotal /proc/meminfo

# grep SwapTotal /proc/meminfo

# df -k /dev/shm/

# uname -m

# df -k /tmp

# df -k

cek versi distro linux

# cat /proc/version

cek kernel requirement

# uname -r

cek package

# rpm -q <nama_rpm>

# rpm -qa <nama_rpm>

# rpm -qa | grep <rpm_name>

# rpm -q binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio-devel libaio libgcc libstdc++ libstdc++-devel make numactl pdksh sysstat unixODBC unixODBC-devel

install package

# rpm -ivh <nama_rpm>

# rpm -ivh –force glibc-devel-2.5-12.i386.rpm

upgrade package

# rpm -Uvh <nama_rpm>

atau

browse ke cdrom yg telah ada cd/iso linuxnya

/media/cdrom/RedHat/RPMS/

untuk package gcc install yg ini = gcc-java-3.4.6-10.i386.rpm

untuk package gcc-c++ install yg ini = gcc-c++-3.4.6-10.i386.rpm

verify /etc/hosts digunakan utk name resolution

# cat /etc/nsswitch.conf | grep hosts

cek hostname, domain name

# hostname

# domainname

verify hosts file berisi fully qualified hostname & localhost

# cat /etc/hosts

edit for redhat 4.0 yonan :

# vi /etc/hosts

127.0.0.1               localhost.localdomain localhost

10.8.102.49             redhat1

ubah hostname

# hostname redhat1

cek kembali hostname nya apakah sudah berubah

# hostname

buat oracle user dan group

harus sebagai root :

# groupadd oinstall

# groupadd dba

# useradd -g oinstall -G dba oracle

# passwd oracle

New UNIX password:oracle

configure kernel parameters (edit/tambahkan) di /etc/sysctl.conf

# vi /etc/sysctl.conf

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

setting shell limit untuk user oracle (add lines)

add line :

# vi /etc/security/limits.conf

oracle    soft        nproc 2047

oracle    hard       nproc 16384

oracle    soft        nofile 1024

oracle    hard       nofile 65536

oracle  hard    stack   10240

# vi /etc/pam.d/login

add line :

session required pam_limits.so

configure shell limit utk user oracle di file /etc/profile as root

# vi /etc/profile

umask 022

if [ $USER = “oracle” ]; then

if [ $SHELL = “/bin/ksh” ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

execute change pada kernel parameters

# /sbin/sysctl -p

confirm perubahan

# /sbin/sysctl -a

# vi /etc/profile (utk bash, bourne, ksh)

if [ $USER = “oracle” ]; then

if [ $SHELL = “/bin/ksh” ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

create oracle base directory

# mkdir -p /oraclebase

# mkdir -p /oraclebase/oracle

# chown -R oracle:oinstall /oraclebase

# chmod -R 775 /oraclebase

create database file directory

# mkdir /oraclebase/oradata

# chown oracle:oinstall /oraclebase/oradata

# chmod 775 /oraclebase/oradata

untuk di rhel langkah ini tidak perlu :

configuring oracle user’s environment

# xhost +

# su – oracle

$ export DISPLAY=<nodename>:<port>

$ xhost +

$ xclock

cek default shell

$ echo $SHELL

Open the Oracle user’s shell startup file in any text editor

# su – oracle

>> Bash shell:

$ vi .bash_profile

>> Bourne or Korn shell:

$ vi .profile

>> C shell (csh or tcsh):

% vi .login

Enter or edit the following line

ORACLE_BASE=/oraclebase

ORACLE_HOME=$ORACLE_BASE/oracle

ORACLE_SID=sitaqdb

ORACLE_UNQNAME=sitaqdb

export ORACLE_BASE

export ORACLE_HOME

export ORACLE_SID

export ORACLE_UNQNAME

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

export PATH

run shell startup script

>> Bash shell:

$ . ./.bash_profile

>> Bourne or Korn shell:

$ . ./.profile

>> C shell:

% source ./.login

Siapkan /source

switch to root

mount DVD

atau

copy source

# mount /media/cdrom

# cd /source

# mkdir database

# cp -rpf /media/cdrom/database/* /source/database/

as oracle, runInstaller -> install software only

kalau pake ignoreSysPrereqs :

$ ./runInstaller -ignoreSysPrereqs

netca (create listener)

dbca (create database)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s