Shulou(Shulou.com)06/01 Report--

Oracle Study-- AIX5.3 installation Oracle 11gR2

System environment:

Operating system: AIX5300-09

Oracle: Oracle 10gR2 (64)

For the version of AIX5.3, if you install Oracle 11g, you need to upgrade the system to the version of AIX 5300-09. For specific upgrade methods, please see my other blog post:

Http://tiany.blog.51cto.com/513694/1368026

First, prepare before installation

1. Check the version of the operating system

[root@aix211 /] # oslevel-r

5300-09

2. View system hardware information

[root@aix211 /] # prtconf | grep-I mem

Memory Size: 4096 MB

Good Memory Size: 4096 MB

+ mem0 Memory

[root@aix211 /] # lsattr-El mem0

Goodsize 4096 Amount of usable physical memory in Mbytes False

Size 4096 Total amount of physical memory in Mbytes False

[root@aix211 /] # prtconf | more

System Model: IBM,7028-6C4Machine Serial Number: 1040F8AProcessor Type: PowerPC_POWER4Processor Implementation Mode: POWER4Processor Version: PV_4_2Number Of Processors: 2Processor Clock Speed: 1453 MHzCPU Type: 64-bitKernel Type: 64-bitLPAR Info: 1 NULLMemory Size: 4096 MBGood Memory Size: 4096 MBPlatform Firmware level: 3R061030Firmware Version: IBM,RG061030_d79e19_rConsole Login: enableAuto Restart: trueFull Core: false

3. Check the kernel version of the system

[root@aix211 /] # bootinfo-K

sixty-four

If the kernel version is not 64-bit, you can upgrade the kernel version to 64-bit

-32-bit kernel upgrade to 64-bit # ln-sf / usr/lib/boot/unix_64 / unix# ln-sf / usr/lib/boot/unix_64 / usr/lib/boot/unix# bosboot-ad / dev/ipldevice# shutdown-Fr degraded from 64-bit to 32-bit # ln-sf / usr/lib/boot/unix_mp / unix# ln-sf / usr/lib/boot/unix_mp / usr/lib/boot/unix# bosboot-ad / dev/ipldevice# shutdown-Fr

4. View file system space

Note: make sure there is enough system space to install Oracle (at least more than 7G)

[root@aix211 /] # df-m

Filesystem MB blocks Free% Used Iused% Iused Mounted on/dev/hd4 11648.00 7924.90 32% 7005 1% / / dev/hd2 2560.00 640.46 75% 45334 7% / usr/dev/hd9var 640.00 269.07 58% 1198 1% / var/dev/hd3 1152.00 1007.09 13% 179 1% / tmp/dev/hd1 128.00 123.80 4% 851% / home/proc-/ proc/dev/hd10opt 384.00 107.30 73% 4829 5% / opt/dev/lv00 128.00 123.94 4% 18 1% / var/adm / csd/dev/u01 20480.00 8254.35 42063 1% / u01/dev/lv_data1 2048.00 1983.67 4% 17.1% / data1/dev/fslv00 2112.00 2111.36 1% 41% / dsk1192.168.8.212:/ware 20480.00 9504.80 54% 5824 1% / ware

-Note:

1. / tmp must ensure that at least 400m of space is required

2. If / U01 is placed under'/', at least more than 7g of space is required.

3. Ensure enough space for the rest of / usr,/var.

5. View the page swap space

[root@aix211 /] # lsps-aPage Space Physical Volume Volume Group Size% Used Active Auto Typepaging01 hdisk2 oravg 1024MB 1 yes yes lvlv_pg01 hdisk1 oravg 1024MB 1 yes yes lvhd6 hdisk0 rootvg 2048MB 1 yes yes lv [root@aix211 /] # lsps-sTotal Paging Space Percent Used 4096MB 1%

Note:

Page space can be set to 2 times the size of Physical Memory or the same size as memory

6. Check the software and patches needed by the system

-View the installation and patches of the package

[root@aix211 /] # lslpp-l | grep bos.adt

Bos.adt.base 5.3.8.0 COMMITTED Base Application Development bos.adt.debug 5.3.8.0 COMMITTED Base Application Development bos.adt.graphics 5.3.7.0 COMMITTED Base Application Development bos.adt.include 5.3.8.0 COMMITTED Base Application Development bos.adt.insttools 5.3.8.0 COMMITTED Tool to Create installp bos.adt.lib 5.3.8.0 COMMITTED Base Application Development bos.adt.libm 5.3.8.0 COMMITTED Base Application Development bos.adt.libmio 5.3.8.0 COMMITTED Modular IO Library bos.adt.prof 5.3.8.1 COMMITTED Base Profiling Support bos.adt.prt_tools 5.3.0.0 COMMITTED Printer Support Development bos.adt.samples 5.3.7.0 COMMITTED Base Operating System Samples bos.adt.sccs 5.3.8.0 COMMITTED SCCS Application Development bos.adt.syscalls 5.3.7.0 COMMITTED System Calls Application bos.adt.utils 5.3.8.0 COMMITTED Base Application Development bos.adt.data 5.3.0.0 COMMITTED Base Application Development

[root@aix211 /] # lslpp-l | grep-I xlc.rte

XlC.rte 9.0.0.1 COMMITTED XL Compact + Runtime

[root@aix211 /] # lslpp-l | grep-I xlc

XlC.aix50.rte 9.0.0.1 COMMITTED XL Citrus + Runtime for AIX 5.2 xlC.cpp 9.0.0.0 COMMITTED C for AIX Preprocessor xlC.rte 9.0.0.1 COMMITTED XL Citrus + Runtime

[root@aix211 /] # lslpp-l | grep-I bos.perf

Bos.perf.diag_tool 5.3.0.50 COMMITTED Performance Diagnostic Tool bos.perf.libperfstat 5.3.8.0 COMMITTED Performance Statistics Library bos.perf.perfstat 5.3.8.1 COMMITTED Performance Statistics bos.perf.proctools 5.3.8.0 COMMITTED Proc Filesystem Tools bos.perf.tools 5.3.8.0 COMMITTED Base Performance Tools bos.perf.tune 5.3.8.0 COMMITTED Performance Tuning Support bos.perf.diag_tool 5.3.0.50 COMMITTED Performance Diagnostic Tool bos.perf.libperfstat 5.3.8.0 COMMITTED Performance Statistics Library bos.perf.perfstat 5.3.8.1 COMMITTED Performance Statistics bos.perf.tools 5.3.8.0 COMMITTED Base Performance Tools bos.perf.tune 5.3.8.0 COMMITTED Performance Tuning Support

View the required patches

[root@aix211 /] # instfix-ik IY58143 All filesets for IY58143 were found. [root@aix211 /] # instfix-ik IY59386 All filesets for IY59386 were found. [root@aix211 /] # instfix-ik IY60930 All filesets for IY60930 were found. [root@aix211 /] # instfix-ik IY66513 All filesets for IY66513 were found. [root@aix211 /] # instfix-ik IY70159 All filesets for IY70159 were found. [root@aix211 /] # instfix-ik IY68989 All filesets for IY68989 were found.

7. Modify the kernel parameters of the system and start ASYNC I _ Unio

-modify system kernel parameters

[root@aix211 /] # smit system

Change / Show Characteristics of Operating System= > Maximum number of PROCESSES allowed per user [2048]

-enable system Asynchronous Ibank O

[root@aix211 /] # smit chaio

MINIMUM number of servers [1] MAXIMUM number of servers per cpu [10] maximum number of REQUESTS [ 4096] server PRIORITY [39] STATE to be configured at system restart available State of fast path enable

8. Establish Oracle users and groups and environment variables

-establish users and groups:

Groups: oinstall 、 Dbausers: oracle [root@aix211 /] # smit chuser (modify the limit for oracle users to read memory pages) Soft FILE size [- 1] Soft CPU time [- 1] Soft DATA segment [- 1] Soft STACK size [- 1] Soft CORE file size [- 1] [root@aix211 database] # cat / Etc/security/limits oracle: fsize =-1 data =-1 stack =-1 core =-1 [oracle@aix211 ~] $cat .profilepath = / usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.export PATHif [- s "$MAIL"] # This is at Shell startup. In normalthen echo "$MAILMSG" # operation, the Shell checksfi # periodically.ORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1ORACLE_SID=prodPATH=$PATH:$ORACLE_HOME/binexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATH [oracle@aix211 ~] $

Second, install Oracle software

-install oracle 11g software

Installation completed:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.