AIX5.3安装oracle数据库软件，搭建oracle10g数据库详细步骤
一、准备工作：
1、查看系统版本
[root@aix210: /]$ oslevel -r
5300-08
08版本不能安装11g，只能安装10g。09版本才可以安装11g。
2、查看系统版本
[root@aix210: /]$ bootinfo -K
64
如果不是64，那么要做升级：
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
如果没安装：
用 smit installp 安装软件disk1、disk2、disk3
7、检查补丁包
[root@aix210: /]$ instfix -ik IY58143
All filesets for IY58143 were found.
如果补丁没有被发现，那么重新安装disk1、disk2、disk3
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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30134188/viewspace-1736788/ ，如需转载，请注明出处，否则将追究法律责任。
