Oracle Study--aix 6.1 installation of Oracle 11gR2

Oracle Study--aix 6.1 installation of 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: POWER 4Processor Version:pv_4_2number of processors:2processor Clock speed:1453 mhzcpu type:64-bitkernel type:64-bitl PAR info:1 nullmemory size:4096 mbgood Memory size:4096 mbplatform Firmware level:3r041029firmware version:ibm,rg0410 29_d79e00_rconsole Login:enableauto Restart:truefull Core:false

2, install Oracle 11GR2 need page space is not less than 4g:

[[Email protected] 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[[email protected] database]lsps - Stotal paging space   percent used      2560mb                0%     [[email protected]  database]swapusage:  swap -l        swap -s         swap -d device         swap -a device[[email protected] database]swap -a /dev/hd6swapon:  paging device /dev/hd6 is already active. [[Email protected] database]swap -d /dev/hd6[[email protected] database]swap  -a /dev/hd6[[email protected] database]lsps -sTotal Paging Space    Percent Used      4096MB                0%

[[Email protected] /]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 c/c++ runtime for aix 5.2[[email protected] /]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

# 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%       12     1% /home/dev/ hd11admin   2048.00   2047.35    1%         5     1% /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 user to enable the maximum number of processes

650) this.width=650; "Src=" http://img.blog.csdn.net/20160318163541863?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

6, the root user to do before the installation of environmental testing
#./rootpre.sh
./rootpre.sh output would be logged in/tmp/rootpre.out_16-03-02.15:44:46
Saving the original files in/etc/ora_save_16-03-02.15:44:46 ....
Copying new kernel extension to/etc ....
Loading the kernel extension from/etc
Oracle Kernel Extension Loader for AIX
Copyright (c) 1998,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 the this system.
You'll 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 the this system.
You'll 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.

----detection indicates that asynchronous I/O is not enabled, and the asynchronous I/O is automatically enabled when there is an I/O request under AIX 6.1.

To view system I/O conditions:
# Ioo-a |grep AIO

aio_active = 0; Aio not started
Aio_maxreqs = 65536
Aio_maxservers = 40
Aio_minservers = 10
aio_server_inactivity = 300
posix_aio_active = 0; Aio not started
Posix_aio_maxreqs = 65536
Posix_aio_maxservers = 30
Posix_aio_minservers = 3
posix_aio_server_inactivity = 300

7. Installation System SP3 patch

650) this.width=650; "Src=" http://img.blog.csdn.net/20160318163953725?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

650) this.width=650; "Src=" http://img.blog.csdn.net/20160318163923029?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

8. Create Oracle Users

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 the limitations of Oracle user access to resources!

[[Email protected] ~] $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

650) this.width=650; "Src=" http://img.blog.csdn.net/20160318164448645?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

Query patches, the system is missing these three patches:
[Email protected] database]instfix-i |grep 41885
[Email protected] database]instfix-i |grep 51456
[Email protected] database]instfix-i |grep 52319

(after ignoring, continue the installation, the installation succeeds!) ）

10. Establish a Database

650) this.width=650; "Src=" http://img.blog.csdn.net/20160318164700994?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

650) this.width=650; "Src=" http://img.blog.csdn.net/20160318164716916?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

-----Build the library successfully, the Oracle 11GR2 installation is complete, the missing patches can be downloaded from the official IBM website!

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1752632

Oracle Study--aix 6.1 installation of Oracle 11gR2