Oracle Study之--AIX 6.1安装Oracle 11gR2

￡神魔★判官ぃ 2022-07-29 08:43 191阅读 0赞

**Oracle Study之--AIX 6.1安装Oracle 11gR2**

**系统环境：AIX6100-09 （补丁：sp3）**

**Oracle：   Oracle 11gR2**

**1、查看系统硬件信息**

**$ prtconf |more**

System Model: IBM,7028-6C4
    Machine Serial Number: 1096B0D
    Processor Type: PowerPC_POWER4
    Processor Implementation Mode: POWER 4
    Processor Version: PV_4_2
    Number Of Processors: 2
    Processor Clock Speed: 1453 MHz
    CPU Type: 64-bit
    Kernel Type: 64-bit
    LPAR Info: 1 NULL
    Memory Size: 4096 MB
    Good Memory Size: 4096 MB
    Platform Firmware level: 3R041029
    Firmware Version: IBM,RG041029_d79e00_r
    Console Login: enable
    Auto Restart: true
    Full Core: false

**2、安装Oracle 11gR2需要page space不小于4g：**

[root@aix203 database]lsps -a
    Page Space      Physical Volume   Volume Group    Size %Used Active Auto  Type Chksum
    paging00        hdisk0            rootvg        2048MB     0   yes   yes    lv     0
    hd6             hdisk0            rootvg        2048MB     1   yes   yes    lv     0
    [root@aix203 database]lsps -s
    Total Paging Space   Percent Used
          2560MB               0%
         
    [root@aix203 database]swap
    Usage:  swap -l
            swap -s
            swap -d device
            swap -a device
    
    [root@aix203 database]swap -a /dev/hd6
    swapon: 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 -s
    Total Paging Space   Percent Used
          4096MB               0%

**3、查看系统所必须安装的数据包**

[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 C/C++ 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、查看文件系统空间信息**

# df -m
    Filesystem    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% /u01
    aix219:/ware   15360.00   3711.85   76%    14106     2% /soft1
    /dev/lv00        128.00    123.94    4%       18     1% /var/adm/csd

**5、调整用户启用最大进程数**

![Center][]

**6、root用户做安装前的环境检测**  
\# ./rootpre.sh  
./rootpre.sh output will 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 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.  
  
**---- 检测提示“异步I/O"没有被启用，经查询，在AIX 6.1下会当有I/O请求时，自动启用异步I/O 。**

**查看系统I/O情况：**  
\# ioo -a |grep aio

aio\_active = 0                      ；aio未启动  
                   aio\_maxreqs = 65536  
                aio\_maxservers = 40  
                aio\_minservers = 10  
         aio\_server\_inactivity = 300  
              posix\_aio\_active = 0                       ；aio未启动  
             posix\_aio\_maxreqs = 65536  
          posix\_aio\_maxservers = 30  
          posix\_aio\_minservers = 3  
   posix\_aio\_server\_inactivity = 300

**7、安装系统sp3补丁**

**![Center 1][]**

**![Center 2][]**

**8、创建Oracle用户**

创建Oracle用户和组（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  
  
**----并修改Oracle用户对资源访问的限制 ！**

\[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、安装Oracle 11g软件**

**![Center 3][]**  
  
查询补丁，系统缺少这三个补丁：  
\[root@aix209 database\]instfix -i |grep 41885    
\[root@aix209 database\]instfix -i |grep 51456  
\[root@aix209 database\]instfix -i |grep 52319

（忽略后，继续安装，安装成功！）

**10、建立数据库**

**![Center 4][]**

**![Center 5][]**

**----- 建库成功，至此Oracle 11gR2安装完成，所缺的补丁可以从IBM官方网站下载 ！**

[Center]: /images/20220728/0be7b5993b6d41658c067619480bd251.png
[Center 1]: /images/20220728/d91e252c9a4f4c1cbfb42f8a080cd2a5.png
[Center 2]: /images/20220728/257c87f18d1c4696a30d041663ed0e63.png
[Center 3]: /images/20220728/615856adab0f4f3eb1d0ca8a4df52b21.png
[Center 4]: /images/20220728/dad00581e5ac4c668f7511e5b6a03296.png
[Center 5]: /images/20220728/2d15b022157744dab3b0c7264205f891.png