Cara Singkat untuk Instalasi Oracle11gR2 on AIX 7.1

          
Berikut ini adalah mekanisme untuk melakukan Instalasi Oracle11gR2 di AIX 7.1. Mekanisme untuk instalasi Oracle di AIX ini lebih simple daripada instalasi di RedHat atau SUSE (http://bicarait.com/2013/04/28/step-by-step-cara-instalasi-database-oracle-10g-atau-11g-di-linux-red-hat-atau-fedora/).
Anyway, here you go : (saya belum sempat rapihkan tulisannya, jadi silahkan disimak dengan baik2)
1. Check real memory dan processor :
/usr/sbin/lsattr -E -l sys0 -a realmem
prtconf  | grep proc
2. Check swap dan tmp :
/usr/sbin/lsps -a
df -gh
if RAM Between 1 GB and 2 GB then Swap Space 1.5 times the size of the RAM
if RAM Between 2 GB and 16 GB then Equal to the size of the RAM
if RAM More than 16 GB then 16 GB
# df -g
perubahan swap caranya :
Determine the current amount of paging space available to the server by issuing the following command.
lsps -a
This command will result in output similar to the following sample output:
Page Space      Physical Volume      Volume Group      Size          %Used
hd6             hdisk0               rootvg            5632MB         2
Determine the size of a logical partition by issuing the following command:
lslv hd6
This command will result in output that will include partition information similar to the following sample information:
LPs:                          44
PP SIZE:                      128 megabyte(s)
chps -s 10 hd6
adds 10 logical partitions to the logical volume hd6, which results in adding 1280 Mb to the paging space.
atau pakai smitty
# /usr/bin/getconf HARDWARE_BITMODE
# bootinfo -K
# df -k /tmp
The following operating system filesets are required for AIX 7.1:
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
xlC.aix61.rte.10.1.0.0 or later
xlC.rte.10.1.0.0 or later
gpfs.base 3.3.0.11 or later
# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools xlC.aix61.rte xlC.rte gpfs.base
# oslevel -s
# getconf KERNEL_BITMODE
Authorized Problem Analysis Reports (APARs) for AIX 7L:
If you are using the minimum operating system TL level for AIX 7.1 listed above, then install all AIX 7L 7.1 Authorized Problem Analysis Reports (APARs) for AIX 7.1 TL 0 SP1, and the following AIX fixes:
IZ87216
IZ87564
IZ89165
IZ97035
To determine if an APAR is installed, enter a command similar to the following:
# /usr/sbin/instfix -i -k “IZ87216 IZ87564 IZ89165 IZ97035”
# /usr/sbin/no -a | fgrep ephemeral
tcp_ephemeral_low = 32768
tcp_ephemeral_high = 65535
udp_ephemeral_low = 32768
udp_ephemeral_high = 65535
# /usr/sbin/no -p -o tcp_ephemeral_low=9000 -o tcp_ephemeral_high=65500
# /usr/sbin/no -p -o udp_ephemeral_low=9000 -o udp_ephemeral_high=65500
Creating the Oracle Inventory Group
If the oraInst.loc file does not exist, then create the Oracle Inventory group using the following procedure:
Enter the following command:
# smit security
tambahkan oinstall dan dba sebagai group
tambahkan oracle dan grid sebagai user dari kedua group diatas
# id oracle
# id grid
Enter the following command:
vi /etc/security/limits
Shell Limit (As Shown in smit)    Recommended Value
Soft FILE size    -1 (Unlimited)
Soft CPU time    -1 (Unlimited)
Note: This is the default value.
Soft DATA segment    -1 (Unlimited)
Soft STACK size    -1 (Unlimited)
Soft Real Memory size    -1 (Unlimited)
Processes (per user)    -1 (Unlimited)
Note: This limit is available only in AIX 6.1 or later. Refer to “Configure System Configuration Parameters” for information on configuration of processes per user limits.
Atau… lakukan perintah ini saja :
# vi /etc/security/limits
/etc/security/limits:
default:
fsize = -1
core = 2097151
cpu = -1
data = -1
rss = 65536
stack = 65536
nofiles = 20000
root:
fsize=-1
stack=-1
rss=-1
oracle:
fsize=-1
stack=-1
rss=-1
# su – oracle
# ulimit -a
Lakukan ini :
# lsattr -E -l sys0 -a maxuproc
# chdev -l sys0 -a maxuproc=16384
# lsattr -E -l sys0 -a maxuproc
# lsattr -E -l sys0 -a ncargs
# chdev -l sys0 -a ncargs=256
/usr/sbin/no -a
ipqmaxlen = 512
rfc1323 = 1
sb_max = 1310720 (2*655360) –not needed
tcp_recvspace = 65536
tcp_sendspace = 65536
udp_recvspace = 655360 (10 * udp_sendspace, must be less than sb_max)
udp_sendspace = 65536
change:
no -r -o ipqmaxlen=512
no -r -o rfc1323=1
no -r -o sb_max=1310720
no -r -o tcp_recvspace=65536
no -r -o tcp_sendspace=65536
no -r -o udp_recvspace=655360
no -r -o udp_sendspace=65536
# reboot
# vi /home/oracle/.profile
umask 022
AIXTHREAD_SCOPE=S
export AIXTHREAD_SCOPE=S
ORACLE_HOSTNAME=oracle.bicarait.com
export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1
export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LD_LIBRARY
ORACLE_SID=ibm
export ORACLE_SID
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export PATH
CLASSPATH=$ORACLE_HOME/jdbc/lib/?
export CLASSPATH
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
Buat direktori untuk oracle installation.
# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle
Unzip paket yang mau diinstall di dalam direktori yang dimiliki oleh oracle.
Jalankan sebagai user oracle di dalam graphic mode :
$ ./runInstaller
lalu ikuti langkah2nya, sepeti rootpre.sh, jalankan script sebagai root, dll (silahkan cari referensi mengenai instalasi via wizard oracle)
atau jika ingin melewatkan saja pre-Req cek, maka lakukan ini (tidak direkomendasikan)
./runInstaller -ignoreSysprereqs -ignorePrereq
YUP SELAMAT. Proses Instalasi Oracle selesai.
Silahkan dicatat alamat untuk Enterprise Manager-nya.
—————————————–
FREQUENTLY ASKED QUESTIONS :
1). Kasus kika rootvg tidak cukup, maka :
We are now going to discuss extending a filesystem under JFS on AIX machine. It is really pretty simple, actually in just 3 commands (including the checking) we could easily extend an AIX filesystem. But for the benifit of everybody, I would include extra checking and commands for us to fully appreciate this task.
Check your filesystems current size and % utilization:
[root@aix] / > df -g /ora/fs1263/u06
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/or1263u06    150.00     53.07   65%      118     1% /ora/fs1263/u06
Check your Logical Volume and see what Volume Group it resides:
[root@aix] / > lslv or1263u06
LOGICAL VOLUME:     or1263u06              VOLUME GROUP:   datavg
LV IDENTIFIER:      000000000108ffffffff.6 PERMISSION:     read/write
VG STATE:           active/complete        LV STATE:       opened/syncd
TYPE:               jfs2                   WRITE VERIFY:   off
MAX LPs:            2048                   PP SIZE:        256 megabyte(s)
COPIES:             1                      SCHED POLICY:   parallel
LPs:                600                    PPs:            600
STALE PPs:          0                      BB POLICY:      relocatable
INTER-POLICY:       minimum                RELOCATABLE:    yes
INTRA-POLICY:       middle                 UPPER BOUND:    32
MOUNT POINT:        /ora/fs1263/u06        LABEL:          /ora/fs1263/u06
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?:     NO
Check the information regarding the Volume Group, this includes the free PP’s and PP size:
[root@aix] / > lsvg datavg
VOLUME GROUP:       datavg             VG IDENTIFIER:  000000000108ffffffff
VG STATE:           active             PP SIZE:        256 megabyte(s)
VG PERMISSION:      read/write         TOTAL PPs:      2626 (672256 megabytes)
MAX LVs:            256                FREE PPs:       576 (147456 megabytes)
LVs:                19                 USED PPs:       2589 (662784 megabytes)
OPEN LVs:           19                 QUORUM:         4 (Enabled)
TOTAL PVs:          7                  VG DESCRIPTORS: 7
STALE PVs:          0                  STALE PPs:      0
ACTIVE PVs:         7                  AUTO ON:        yes
MAX PPs per VG:     32512
MAX PPs per PV:     1016               MAX PVs:        32
LTG size (Dynamic): 256 kilobyte(s)    AUTO SYNC:      no
HOT SPARE:          no                 BB POLICY:      relocatable
If you have available PPs for your desired filesystem, let us extend it:
[root@aix] / > chfs -a size=+134G /ora/fs1263/u06
Filesystem size changed to 595591168
How is our filesystem now:
[root@aix] / > df -g /ora/fs1263/u06
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/or1263u06    284.00    187.05   35%      118     1% /ora/fs1263/u06
If in case you encounter an error message:
0516-787 extendlv: Maximum allocation for logical volume or1263u06
is 1024.
Check on the maximum LPs for the Logical Volume – this must be increased to accomodate the new size. Where LPs = LV in MB / LP in MB then change the maximum LP to the ouput:
[root@aix] / > chlv -x 2048 or1263u06
2). Setelah restart mesin, Oracle tidak UP.
$ sqlplus /nolog
orcl> conn / as sysdba
orcl> startup
kalau mau buat login sysdba selain sys, bisa dengan ini :
orcl> create user ibm identified by ibm;
orcl> grant dba to ibm;
$ emctl start dbconsole
$ lsnrctl start