Quick Installation Point Oracle Database 10g – AIX 5L / AIX 6 64Bit


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, tmp (400MB), freespace
# /usr/sbin/lsattr -E -l sys0 -a realmem
# /usr/sbin/lsps -a
# df -k /tmp
# df -k
# /usr/bin/getconf HARDWARE_BITMODE
# oslevel -r

cek fileset
# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat \
bos.perf.libperfstat bos.perf.proctools bos.adt.prof

# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat \
bos.perf.libperfstat bos.perf.proctools

untuk AIX 5L
# lslpp -l xlC.aix50.rte:7.0.0.4 or later
# lslpp -l xlC.rte:7.0.0.1 or later

lslpp -l | grep xlC

sv
untuk AIX 6.1
# lslpp -l xlC.aix61.rte:9.0.0.1 xlC.rte:9.0.0.1

install fileset (masukan cd source AIX)
# smitty installp (trus masukan device cdrom utk sourcenya)

cek hostname
# hostname

buat oracle inventory group (oinstall)
# more /etc/oraInst.loc (cek if exists)
# smit security -> buat oinstall
F10 to exit

buat osdba group (dba)
# smit security -> buat dba
F10 to exit

buat oracle software owner user (oracle)
# id oracle (cek)
# smit security
Choose the appropriate menu items to create the oracle user, specifying the following information:
>> In Primary GROUP field, specify the Oracle Inventory group = oinstall.
>> In Group SET field, specify the OSDBA group = dba
Press F10 to exit.

Set the password of the oracle user:
# passwd oracle

cek/create user nobody (optional)
# id nobody (cek)
# smit security -> buat nobody
F10 to exit

configure shell limit
# smit chuser
di USER NAME field, masukkan nama oracle software owner (oracle)
cek, dan modify :
Soft FILE size         -1 (Unlimited)
Soft CPU time         -1 (Unlimited)
Soft DATA segment     -1 (Unlimited)
Soft STACK size     -1 (Unlimited)

configure system configuration parameters
# smit chgsys
cek/edit : Maximum number of PROCESSES allowed per user
is greater than or equal to 2048

create oracle base directory
# mkdir -p /oraclebase
# chown -R oracle:oinstall /oraclebase
# chmod -R 775 /oraclebase

configuring oracle user’s environment (VNC/XMING)
# 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
umask 022
export ORACLE_BASE=/oraclebase
export ORACLE_HOME=$ORACLE_BASE/oracle
export ORACLE_SID=orcl
#export LIBPATH=$ORACLE_HOME/lib
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib
#export ORACLE_TERM=vt100
PATH=$PATH:$HOME/bin
export PATH
Add one of the following lines to the file to set the AIXTHREAD_SCOPE
environment variable to S (system-wide thread scope):
>> Bourne shell (sh), Bash shell (bash), or Korn shell (ksh):
export AIXTHREAD_SCOPE=S
>> C shell (csh or tcsh):
setenv AIXTHREAD_SCOPE S

export PATH

if [ -s “$MAIL” ]           # This is at Shell startup.  In normal
then echo “$MAILMSG”        # operation, the Shell checks
fi                          # periodically.

export CRS_HOME=/oraclebase/crs
export ORACLE_BASE=/oraclebase
export ORACLE_HOME=/oraclebase/oracle
export ORACLE_SID=hqcms1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib
export OBJECT_MODE=32_64
export AIXTHREAD_SCOPE=S
export PATH=$PATH:$CRS_HOME/bin:$ORACLE_HOME/bin

umask 022

if [ -t 0 ]; then
stty intr ^C
fi

run shell startup script
>> Bash shell:
$ . ./.bash_profile
>> Bourne or Korn shell:
$ . ./.profile
>> C shell:
% source ./.login

untuk verify klo environment dah di set properly
$ umask
$ env | more

switch to root
mount DVD

run rootpre.sh (gunakan rootpre.sh baru utk AIX 6.1)
exit root account

copy ftp patch 10.2.0.4 yg size 2gb selalu mentok di 1gb:
set ulimit jadi -1 di /etc/security/limits

as oracle, runInstaller -> install software only
kalau AIX 6.1 pake ignoreSysPrereqs :
$ ./runInstaller -ignoreSysPrereqs

netca (create listener)

dbca (create database)

—–catatan—–

default oracle home oracle
/u01/oracle
/u01/oradata
/u01/flash_recovery_area

smitty user = buat bikin user
smitty group = buat bikin group
smitty jfs2 = buat file system (cari vg yg kosong,pilih lalu bikin filesystem dgn sebuah direktori(/source), lalu mount ke os direktori tsb(mount /source)

buat filesystem
# smitty jfs2

siapin /source

copy source
# smitty cdrfs -> add -> device name (esc-4) -> mount point (/cdrom)
# mount /cdrom
# mount /dev/cd0
# cd /cdrom
# ls
client        companion     doc           index         welcome.html
clusterware   database      gateways      index.pdx
# cd /source
# mkdir database
# cp -rpf /cdrom/database/* /source/database/

# chown -R oracle:oinstall /home/oracle/.ssh/
# chmod -R 775 oracle /home/oracle/.ssh/

rubah/nambah swap
# lsvg –> cek vg yg akan dipake utk swap
# lsvg rootvg –> liat PP Size
# smitty pgsp
number of logical partition = n

*) n = [swap size] : pp size

default:
fsize = -1
core = 2097151
cpu = -1
data = 262144
rss = 65536
stack = 65536
nofiles = 2000

Installasi Patchset
========================
file Patchset biasanya berupa zip
&unzip namafile.zip

jalankan tools patch di oracle:/u01/oracle/OPatch

arahkan ke folder yg telah di unzip

[HQORFDEV1:oracle:/u01/oracle/OPatch:] opatch apply /source/oracle_patches/6980307

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 )

w

Connecting to %s