ITPub博客

首页 > 数据库 > Oracle > AIX5.3安装oracle数据库软件,搭建oracle10g数据库详细步骤

AIX5.3安装oracle数据库软件,搭建oracle10g数据库详细步骤

原创 Oracle 作者:Toooooooo晓旭 时间:2015-07-18 00:08:40 0 删除 编辑

一、准备工作:

 

1、查看系统版本

 

[root@aix210: /]$ oslevel -r

5300-08

 

08版本不能安装11g,只能安装10g09版本才可以安装11g

 

2、查看系统版本

 

[root@aix210: /]$ bootinfo -K

64

 

如果不是64,那么要做升级:

 

计算机生成了可选文字: 一一-一32位内核升级到64位
12
In一,f/u,r/1lb/boo七/unlx6任
In一,f/u,r/1lb/boo七/unix64
bo,b00七一已d/dev/lpldevlce
曰hU七do公n一Fr
/unlx
/u,r/
工:b/b。。:,un:x
澎澎澎澎
3弓S',
从6弓位降级至叮32位
日,
In一,f/u,r/1lb/boo七/unlxmp
In一sf/usr/1lb/boot/unlxJ"p
bo,boot一。d/dev/lpldevlc.
曰hU七dOUn一Fr
/unlx
/usr/1lb/boot/unlx
弃#弃#
D12345

 

3、检查磁盘空间

 

[root@aix210: /]$ df -m

Filesystem    MB blocks      Free %Used    Iused %Iused Mounted on

/dev/hd4       20480.00  13146.64   36%     8627     1% /

/dev/hd2        5120.00   3010.71   42%    48649     4% /usr

/dev/hd9var     5120.00   4779.85    7%     2025     1% /var

/dev/hd3        5120.00   4918.89    4%       72     1% /tmp

/dev/hd1        5120.00   3692.08   28%     2554     1% /home

/proc                 -         -    -         -     -  /proc

/dev/hd10opt    2048.00   1839.49   11%     3515     1% /opt

/dev/lv_data1   1024.00    991.80    4%       18     1% /data1

/dev/fslv00     1024.00   1023.52    1%        4     1% /data2

aix106:/ware   21504.00   4588.56   79%    15148     1% /soft106

 

4、创建一个 /u01的文件系统(这台机器上本来就有/u01这个文件系统)

 

[root@aix210: /]$ mount /u01

[root@aix210: /]$ df -m

Filesystem    MB blocks      Free %Used    Iused %Iused Mounted on

/dev/hd4       20480.00  13146.64   36%     8627     1% /

/dev/hd2        5120.00   3010.71   42%    48649     4% /usr

/dev/hd9var     5120.00   4779.85    7%     2025     1% /var

/dev/hd3        5120.00   4918.89    4%       72     1% /tmp

/dev/hd1        5120.00   3692.08   28%     2554     1% /home

/proc                 -         -    -         -     -  /proc

/dev/hd10opt    2048.00   1839.49   11%     3515     1% /opt

/dev/lv_data1   1024.00    991.80    4%       18     1% /data1

/dev/fslv00     1024.00   1023.52    1%        4     1% /data2

aix106:/ware   21504.00   4588.56   79%    15148     1% /soft106

/dev/lv00       5120.00   4959.25    4%       17     1% /u01

 

5、检查交换分区(4g以上)

 

[root@aix210: /]$ lsps -a

Page Space      Physical Volume   Volume Group    Size %Used Active  Auto  Type

paging00        hdisk0            rootvg        4096MB     1   yes   yes    lv

hd6             hdisk0            rootvg        4096MB     1   yes   yes    lv

 

6、检查必要的软件包

 

[root@aix210: /]$ 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@aix210: /]$ lslpp -l |grep -i xlc.rte

  xlC.rte                    9.0.0.1  COMMITTED  XL C/C++ Runtime

[root@aix210: /]$ lslpp -l |grep -i xlc

  xlC.aix50.rte              9.0.0.1  COMMITTED  XL C/C++ Runtime for AIX 5.2

  xlC.cpp                    9.0.0.0  COMMITTED  C for AIX Preprocessor

  xlC.rte                    9.0.0.1  COMMITTED  XL C/C++ Runtime

[root@aix210: /]$ lslpp -l |grep 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

 

如果没安装:

 

计算机生成了可选文字: 「root目口1x211/】.mkdlr/曰oftl
[root目曰ix211/』#shn"mnl,nt一e
export11曰t犷or曰ix106:
/目曰re
/目arel
曰iX106
/export/nim/曰cripts/。i义206。script
/export/ni二/曰c=ript曰/曰ixi91。‘cript
/export/nlm/曰oript曰/Jix222。6cript
/export/nim/3c=ript3/dix19,。3cript
/export/nim/曰cript曰/己ix205。吕c=rlpt
/曰xport/nim/soript曰/曰ix211。6cript
/export/nim/6cript曰/曰ix200。曰cript
/export/nim/3cript3/.ix240。3cript
/export/lpp一曰ource/lpp一曰ourcel
/曰x00rt/s口ot/s00tl/Ugr
LrO0t世口IX211/」林mount口IX10b:/“口re
(evergone)
(evergone)
曰i盆206
曰ix191
JIX222
口iX199
dix205
曰iX211
曰iXZOO
曰iX240
dix206,曰ix191,己ix222,曰ix199,dix205,曰ix211,曰ix200,己ix240
曰ix206,曰ix191,曰ix222,曰ix199,曰ix205,曰ix211,曰i又200,曰ix240
/90犷tl

 

smit installp 安装软件disk1disk2disk3

 

7、检查补丁包

 

[root@aix210: /]$ instfix -ik IY58143

    All filesets for IY58143 were found.

 

如果补丁没有被发现,那么重新安装disk1disk2disk3

 

8、修改内核参数

 

[root@aix210: /]$ smit system

 

                                                        System Environments

 

Move cursor to desired item and press Enter.

 

  Stop the System

  Aix Security Expert

  Assign the Console

  Change / Show Date, Time, and Time Zone

  Manage Language Environment

  Change / Show Characteristics of Operating System

  Change / Show Number of Licensed Users

  Broadcast Message to all Users

  Manage System Logs

  Change / Show Characteristics of System Dump

  Change System User Interface

  Change/Show Documentation Services

  Web-based System Manager

  Enable 64-bit Application Environment

  Manage Remote Reboot Facility

  Manage System Hang Detection

 

                                         Change / Show Characteristics of Operating System

 

Type or select values in entry fields.

Press Enter AFTER making all desired changes.

 

[TOP]                                                   [Entry Fields]

  System ID                                           0X036E8091862B9601

  Partition ID                                        0X036E8091862B9601

  Maximum number of PROCESSES allowed per user       [2048]                                                                      +#

  Maximum number of pages in block I/O BUFFER CACHE  [20]                                                                        +#

  Maximum Kbytes of real memory allowed for MBUFS    [0]                                                                         +#

  Automatically REBOOT OS after a crash               true                                                                       +

  Continuously maintain DISK I/O history              false                                                                      +

  HIGH water mark for pending write I/Os per file    [0]                                                                         +#

  LOW water mark for pending write I/Os per file     [0]                                                                         +#

  Amount of usable physical memory in Kbytes          4194304

  State of system keylock at boot time                normal

  Enable full CORE dump                               false                                                                      +

  Use pre-430 style CORE dump                         false                                                                      +

[MORE...13]

 

9、启动异步I/O

 

[root@aix210: /]$ smit chaio

 

                                          Change/Show Characteristics of Asynchronous I/O

 

Type or select values in entry fields.

Press Enter AFTER making all desired changes.

 

                                                        [Entry Fields]

  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 

 

10、建立用户和组

 

建立用户:oracle ;建立组:oinstal dba

 

修改用户属性:

 

[root@aix210: /]$ smit chuser

 

                                              Change / Show Characteristics of a User

 

Type or select a value for the entry field.

Press Enter AFTER making all desired changes.

 

                                                        [Entry Fields]

* User NAME                                          [oracle] 

 

修改这四个参数:

 

   Soft FILE size                                     [-1]                                                                         #

  Soft CPU time                                      [-1]                                                                         

  Soft DATA segment                                  [-1]                                                                         #

  Soft STACK size                                    [-1]                                                                         #

 

这几个参数是修改Oracle资源限制,-1代表不做任何限制

 

11、修改 .profile 参数文件

 

[oracle@aix210 ~]$cat .profile

 

 

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

 

export PATH

 

if [ -s "$MAIL" ]           # This is at Shell startup.  In normal

then echo "$MAILMSG"        # operation, the Shell checks

fi                          # periodically.

export ORACLE_SID=prod

export ORA_CRS_HOME=/u01/crs_1

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

export PATH=$PATH:/u01/crs_1/bin:$ORACLE_HOME/bin:/usr/es/sbin/cluster:/usr/es/sbin/cluster/utilities:/usr/es/sbin/cluster/sbin:/usr/es/sbin/cluster/diag:$ORA_CRS_HOME/bin

umask 022

 

二、安装Oracle软件(把database 这个目录拷贝到本机上,再安装)

 

[root@aix210: /]$ showmount -e aix106

export list for aix106:

/ware                             (everyone)

/ware1                            (everyone)

/export/nim/scripts/aix206.script aix206

/export/nim/scripts/aix191.script aix191

/export/nim/scripts/aix222.script aix222

/export/nim/scripts/aix199.script aix199

/export/nim/scripts/aix205.script aix205

/export/nim/scripts/aix211.script aix211

/export/nim/scripts/aix200.script aix200

/export/nim/scripts/aix240.script aix240

/export/lpp_source/lpp_source1    aix206,aix191,aix222,aix199,aix205,aix211,aix200,aix240

/export/spot/spot1/usr            aix206,aix191,aix222,aix199,aix205,aix211,aix200,aix240

[root@aix210: /]$ mount aix106:/ware /soft

[root@aix210: /]$ cd /soft

[root@aix210: /soft]$ ls

10gr2_aix5l64_cluster.cpio.gz  aix_ssh.tar                    disk2                          lost+found

70286C4F.BIN                   bak                            disk3                          oracle11g

aix_5300_04_csp                database                       hacmp5.2

aix_5309                       database.tar.gz                hacmp5.2_patch

aix_bash_ssh.tar               disk1                          hp

[root@aix210: /soft]$ cp -R database /home/oracle

[root@aix210: /soft]$ su - oracle

[YOU HAVE NEW MAIL]

[u@h W]$bash

[oracle@aix210 ~]$ls

database  inc0.log  inc1.log  single

[oracle@aix210 ~]$cd database

[oracle@aix210 database]$ls

Disk1

[oracle@aix210 database]$cd Disk1

[oracle@aix210 Disk1]$ls

doc           install       response      rootpre       runInstaller  stage         welcome.html

[oracle@aix210 Disk1]$export DISPLAY=192.168.8.69:0.0

[oracle@aix210 Disk1]$./runInstaller

**************************************************************************

******

 

Your platform requires the root user to perform certain pre-installation

OS preparation.  The root user should run the shell script 'rootpre.sh' be

fore

you proceed with Oracle installation.  rootpre.sh can be found at the top

level

of the CD or the stage area.

 

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle

installation.

Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

 

**************************************************************************

******

 

Has 'rootpre.sh' been run by root? [y/n] (n)

y

 

Starting Oracle Universal Installer...

 

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-07-01_02-08-17PM. Please wait ...[oracle@aix210 Disk1]$Jul 1, 2015 2:08:34 PM java.util.prefs.FileSystemPreferences$3 run

INFO: Created system preferences directory in java.home.

Oracle Universal Installer, Version 10.2.0.1.0 Production

Copyright (C) 1999, 2005, Oracle. All rights reserved.






[root@aix210: /]$ /u01/app/oracle/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oracle/oraInventory to 775.

Changing groupname of /u01/app/oracle/oraInventory to dba.

The execution of the script is complete

[root@aix210: /]$ /u01/app/oracle/product/10.2.0/db_1/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

     ORACLE_OWNER= oracle

     ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y

  Copying dbhome to /usr/local/bin ...

The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y

 Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.


 三、建库

[oracle@aix210 Disk1]$dbca