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