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

Oracle Study-- AIX 6.1 install Oracle 11gR2

System environment: AIX6100-09 (patch: sp3)

Oracle: Oracle 11gR2

1. View system hardware information

$prtconf | more

System Model: IBM,7028-6C4Machine Serial Number: 1096B0DProcessor 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: 3R041029Firmware Version: IBM,RG041029_d79e00_rConsole Login: enableAuto Restart: trueFull Core: false

2. To install Oracle 11gR2, you need page space of not less than 4G:

[root@aix203 database] lsps-aPage Space Physical Volume Volume Group Size% Used Active Auto Type Chksumpaging00 hdisk0 rootvg 2048MB 0 yes yes lv 0hd6 hdisk0 rootvg 2048MB 1 yes yes lv 0 [root@aix203 database] lsps-sTotal Paging Space Percent Used 2560MB 0 [root@aix203 database] swapUsage: swap- L swap-s swap-d device swap-a device [root@aix203 database] swap-a / dev/hd6swapon: Paging device / dev/hd6 is already active. [root@aix203 database] swap-d / dev/hd6 [root@aix203 database] swap-a / dev/hd6 [root@aix203 database] lsps-sTotal Paging Space Percent Used 4096MB 0%

3. View the packets that must be installed on the system

[root@aix203 /] lslpp-l | grep-I xlc xlC.aix61.rte 12.1.0.1 COMMITTED IBM XL C++ Runtime for AIX 6.1 xlC.cpp 9.0.0.0 COMMITTED C for AIX Preprocessor xlC.rte 12.1.0.1 COMMITTED IBM XL C++ Runtime for AIX xlC.sup.aix50.rte 9.0.0.1 COMMITTED XL Runtime for AIX xlC.sup.aix50.rte + Runtime for AIX 5 .2 [root@aix203 /] lslpp-l | grep bos.perf bos.perf.diag_tool 6.1.8.15 COMMITTED Performance Diagnostic Tool bos.perf.fdpr 6.1.8.15 COMMITTED Feedback Directed Program bos.perf.libperfstat 6.1.9.0 COMMITTED Performance Statistics Library bos.perf.perfstat 6.1.9.0 COMMITTED Performance Statistics bos.perf.pmaix 6.1.9.0 COMMITTED Performance Management bos .perf.proctools 6.1.9.0 COMMITTED Proc Filesystem Tools bos.perf.tools 6.1.9.0 COMMITTED Base Performance Tools bos.perf.tune 6.1.9.0 COMMITTED Performance Tuning Support bos.perf.diag_tool 6.1.8.15 COMMITTED Performance Diagnostic Tool bos.perf.libperfstat 6.1.9.0 COMMITTED Performance Statistics Library bos.perf.perfstat 6.1. 9.0 COMMITTED Performance Statistics bos.perf.pmaix 6.1.9.0 COMMITTED Performance Management bos.perf.tools 6.1.9.0 COMMITTED Base Performance Tools bos.perf.tune 6.1.9.0 COMMITTED Performance Tuning Support

4. View file system space information

# df-mFilesystem MB blocks Free% Used Iused% Iused Mounted on/dev/hd4 10240.00 4992.90 52% 13238 2 / / dev/hd2 2048.00 492.00 76% 31524 22% / usr/dev/hd9var 2048.00 2033.39 1% 479.1% / var/dev/hd3 2048.00 1797.96 13% 466 1% / tmp/dev/hd1 2048.00 2047.29 1% 121% / home/dev/hd11admin 2048.00 2047.35 1% 51% / admin/proc-/ proc/dev/hd10opt 2048.00 1934.11 6% 1923 1% / opt/dev / fslv00 10240.00 10238.09 1% 7.1% / u01aix219:/ware 15360.00 3711.85 76% 14106 2% / soft1/dev/lv00 128.00 123.94 4% 18 1% / var/adm/csd

5. Adjust the maximum number of processes enabled by the user

6. Root users check the environment before installation

#. / rootpre.sh

. / rootpre.sh output will be logged in / tmp/rootpre.out_16-03-02.15

Saving the original files in / etc/ora_save_16-03-02.15 purl 44purl 46....

Copying new kernel extension to / etc....

Loading the kernel extension from / etc

Oracle Kernel Extension Loader for AIX

Copyright (c) 1998 and 1999 Oracle Corporation

Successfully loaded / etc/pw-syscall.64bit_kernel with kmid: 0x20883000

Successfully configured / etc/pw-syscall.64bit_kernel with kmid: 0x20883000

The kernel extension was successfuly loaded.

Configuring Asynchronous I/O....

Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Configuring POSIX Asynchronous I/O....

Posix Asynchronous I/O is not installed on this system.

You will need to install it, and either configure it yourself using

'smit aio' or rerun the Oracle root installation procedure.

Checking if group services should be configured....

Nothing to configure.

-the detection indicates that "Asynchronous Igamo" is not enabled. After query, it will automatically enable Asynchronous Icano when there is a request for it under AIX 6.1s.

Check the system Icano condition:

# ioo-a | grep aio

Aio_active = 0; aio is not started

Aio_maxreqs = 65536

Aio_maxservers = 40

Aio_minservers = 10

Aio_server_inactivity = 300

Posix_aio_active = 0; aio is not started

Posix_aio_maxreqs = 65536

Posix_aio_maxservers = 30

Posix_aio_minservers = 3

Posix_aio_server_inactivity = 300

7. Install the system sp3 patch

8. Create an Oracle user

Create Oracle users and groups (install, dba)

# id oracle

Uid=300 (oracle) gid=300 (oinstall) groups=301 (dba)

# chown-R oracle:dba / U01

# su-oracle

$mkdir-p / u01/app/oracle

-and modify Oracle users' restrictions on resource access!

[oracle@aix209 ~] $cat .profile

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

ORACLE_SID=prod

PATH=$PATH:$ORACLE_HOME/bin

Export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

9. Install Oracle 11g software

Query patches, the system is missing these three patches:

[root@aix209 database] instfix-I | grep 41885

[root@aix209 database] instfix-I | grep 51456

[root@aix209 database] instfix-I | grep 52319

(after ignoring, continue with the installation, the installation is successful! )

10. Set up a database

-the library has been successfully built, and the Oracle 11gR2 installation is complete. The missing patches can be downloaded from the official IBM website.

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.