1，系统准备
1.1 操作系统版本需求
AIX 5L V5.3 TL 09 SP1 ("5300-09-01"), 64 bit kernel
AIX 6.1 TL 02 SP1 ("6100-02-01), 64-bit kernel
6100-05-01-1016
[@more@]1.2 内存需求: (At least 4 GB of RAM)
/usr/sbin/lsattr -E -l sys0 -a realmem
realmem 32505856 Amount of usable physical memory in Kbytes False
1.3 Swap空间需求:
Between 4 GB and 8 GB 2 times the size of RAM
Between 8 GB and 32 GB 1.5 times the size of RAM
More than 32 GB 32 GB
/usr/sbin/lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto Type Chksum
hd6 hdisk0 rootvg 32768MB 1 yes yes lv 0
1.4 确认64位操作系统:
/usr/bin/getconf HARDWARE_BITMODE
64
bootinfo -K
64
1.5 软件需求
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat 6.1.2.1 or later
bos.perf.perfstat
bos.perf.proctools
xlC.aix61.rte:10.1.0.0 or later
gpfs.base 3.2.1.8 or later
可选:
gpfs.base (3.2.1.8 or later)(GPFS is required only if you want to use a cluster file system for Oracle clusterware or database files.)
lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat
bos.perf.libperfstat bos.perf.proctools xlC.aix61.rte
Fileset Level State Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
bos.adt.base 6.1.5.0 COMMITTED Base Application Development
Toolkit
bos.adt.lib 6.1.2.0 COMMITTED Base Application Development
Libraries
bos.adt.libm 6.1.5.0 COMMITTED Base Application Development
Math Library
bos.perf.libperfstat 6.1.5.0 COMMITTED Performance Statistics Library
Interface
bos.perf.perfstat 6.1.5.0 COMMITTED Performance Statistics
Interface
bos.perf.proctools 6.1.5.0 COMMITTED Proc Filesystem Tools
xlC.aix61.rte 10.1.0.3 COMMITTED XL C/C++ Runtime for AIX 6.1
Path: /etc/objrepos
bos.adt.base 6.1.5.0 COMMITTED Base Application Development
Toolkit
bos.perf.libperfstat 6.1.5.0 COMMITTED Performance Statistics Library
Interface
bos.perf.perfstat 6.1.5.0 COMMITTED Performance Statistics
Interface
1.6 系统补丁需求
These 6.1 fixes are already present in the following TL levels:
AIX 6.1 TL-02 SP-04 and later
AIX 6.1 TL-03 SP-02 and later
AIX 6.1 TL-04
1.7 应用用户准备, 2组1用户(group: oinstall,dba; user:oracle)
规划:
用户和组id和组id从401开始，用户名oracle，组名oinstall,dba
用户limit参数配置:
Shell Limit (As Shown in smit) Recommended Value
--------------------------------------------------
Soft FILE size -1 (Unlimited)
Soft CPU time -1 (Unlimited)
Note: This is the default value.
Soft DATA segment -1 (Unlimited)
Soft STACK size -1 (Unlimited)
Soft Real Memory size -1 (Unlimited)
Processes (per user) -1 (Unlimited)
测试oinstall组是否存在，不存在则创建:
more /etc/oraInst.loc
grep oinstall /etc/group
mkgroup -'A' id='401' oinstall
测试dba组是否存在，不存在则创建
grep dba /etc/group
mkgroup -'A' id='402' dba
测试oracle用户是否存在，不存在则创建，primary group: oinstall
id oracle
useradd -d /home/oracle -m -u 401 -g oinstall -G dba oracle
passwd oracle
配置oracle用户limit
smitty user
1.8 系统参数配置:
1.8.1 配置进程数
Parameter Recommended Value
---------------------------------
maxuprocs 16384
ncargs 128
Maximum number of PROCESSES allowed per user [16384]
ARG/ENV list size in 4K byte blocks [256]
smitty chgsys
1.8.2 配置允许打开文件数
vi /etc/security/limits
default:
nofiles = 8000
1.8.3 配置aio(On AIX 6, the AIO device drivers are enabled by default)
确认aio_maxreqs = 65536
ioo -o aio_maxreqs
aio_maxreqs = 65536
命令ioo -o用来:displays the value or sets Tunable to NewValue
Adjust the initial value of maxservers to 10 times the number of disks that are to be used concurrently but no more than 80.
To monitor the number of AIO server processes that have started, enter the following
ps -ek | grep -v grep | grep -v posix_aioserver | grep -c aioserver
1.8.4 the kernel TCP/IP ephemeral port range parameters are set to 9000-65500
/usr/sbin/no -a | fgrep ephemeral
tcp_ephemeral_low = 32768
tcp_ephemeral_high = 65535
udp_ephemeral_low = 32768
udp_ephemeral_high = 65535
no -p -o tcp_ephemeral_low=9000
no -p -o tcp_ephemeral_high=65500
no -p -o udp_ephemeral_low=9000
no -p -o udp_ephemeral_high=65500
1.9 文件系统准备
At least 1 GB of space in the /tmp directory
At least 7.44 GB space for data files software files
At least 1.55 GB space for data files data files
1.9.1 扩展/tmp文件系统4G以上
1.9.2 创建/oradb文件系统30G(先创建lv，手动指定lv的名字)
1.9.3 创建/oradata文件系统500G(先创建lv，手动指定lv的名字)
1.9.4 修改/oradb和/oradata的用户属组和属主
chown oracle:oinstall /oradb
chown oracle:dba /oradata
1.10 oracle环境变量准备
ORACLE_BASE=/oradb/app/oracle
ORACLE_SID=qasdb01
export ORACLE_BASE ORACLE_SID
确认ORACLE_HOME和TNS_ADMIN环境变量没有配置
unset ORACLE_HOME
unset TNS_ADMIN
1.11 Oracle软件准备
/sapdataremote/ora11gr2/p10098816_112020
2, 图形方式安装Oracle软件
2.1 Running the rootpre.sh Script
su -
cd /sapdataremote/ora11gr2/p10098816_112020/1/database
./rootpre.sh
2.2 Installing Oracle Database
su - oracle
cd /sapdataremote/ora11gr2/p10098816_112020/1/database
./runInstaller
Has 'rootpre.sh' been run by root? [y/n] (n)
y
Configure security Updates: Provide your email address
(Remain empty)
Download Software Updates
Skip software updates
Installation Option
Install database software only
Grid Installation Options
Single instance database installation
Product Languages
English
Simplified Chinese
Database Edition
Enterprise Edition
Installation Location
Oracle Base: /oradb/app/oracle
Software Location: /oradb/app/oracle/g11
Create Inventory
Inventory Directory: /oradb/app/oraInventory
oraInventory Group Name: oinstall
Operating System Group
Database Administrator Group: dba
Database Operator Group: dba
Prerequisite Checks
如果有check Failed:
点击Fix & Check Again，会在/tmp目录下产生一个runfixup.sh，用root执行runfixup.sh，执行完毕，点击OK
Install Product
安装最后，使用root执行脚本:
/oradb/app/oraInventory/orainstRoot.sh
/oradb/app/oracle/g11/root.sh
设置: ORACLE_HOME= /oradb/app/oracle/g11
3, 创建数据库
3.1 修改环境变量
PATH=$PATH:/oradb/app/oracle/g11/bin:/oradb/app/oracle/g11/OPatch:/oradb/app/oracle/g11/jdk/jre/bin:/oradb/app/oracle/g11/owb/bin:/oradb/app/oracle/g11/owb/bin/unix
ORACLE_BASE=/oradb/app/oracle
ORACLE_SID=qasdb01
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
ORACLE_HOME=/oradb/app/oracle/g11
LIBPATH=:/oradb/app/oracle/g11/lib
LD_LIBRARY_PATH=:/oradb/app/oracle/g11/lib
export PATH ORACLE_BASE ORACLE_SID NLS_LANG ORACLE_HOME LIBPATH LD_LIBRARY_PATH
3.2 创建数据库，图形方式运行dbca
dbca
Step 2 - Database Templates
Custom Database(select)
Step 3 - Database Identification
Global Database Name:qasdb01;
SID: qasdb01
Step 4 - Management Options
Configure Enterprise Manager(no select)
Automatic Maintenance Tasks: Enable automatic maintenance tasks(select)
Step 5 - Database Credentials
Use the Same Administrative Password for All Accounts: xxxxxxxx
Step 6 - Database File Locations
Storage Type: File System
Use Common Location for All Database Files: /oradata
Step 7 - Recovery Configuration
Specify Fast Recovery Area(select)
Fast Recovery Area: /oradata/{DB_UNIQUE_NAME}/fast_recovery_area
Fast Recovery Area Size: 4977M
Enable Archiving(select)
Automatic Archiving(select)
archive Log File Format: %t_%s_%r.dbf
Archive Log Destinations: /oradata/{DB_UNIQUE_NAME}/archivelog
Step 8 - Database Content
Oracle Text(select)
Oracle OLAP(select)
Oracle Spatial(select)
Enterprise Manager Repository(select)
Oracle Warehouse Builder(select)
Step 9 - Initialization Parameters
Memory: Custom
SGA Size: 10240M
PGA Size: 5120M
Sizing
Block Size: 8192Byte
Processes: 2000
Character Sets
Database Character Set: AL32UTF8
National Character Set: UTF8
Connection Mode
Dedicated Server Mode(select)
All Initialization Parameters
audit_file_dest: /oradata/{DB_UNIQUE_NAME}/dump/adump
control_file: ("/oradata/{DB_UNIQUE_NAME}/control01.ctl", "/oradata/{DB_UNIQUE_NAME}/control02.ctl")
core_dump_dest: /oradata/{DB_UNIQUE_NAME}/dump/cdump
db_files: 500
diagnostic_dest: /oradata/{DB_UNIQUE_NAME}/dump
open_cursors: 3000
open_links: 20
open_links_per_instance: 20
Step 10 - Database Storage
Controlfile
control01.ctl: /oradata/{DB_UNIQUE_NAME}/
control02.ctl: /oradata/{DB_UNIQUE_NAME}/
Step 11 - Creation Options
Create Database(select)
Save as a Database Template(select)
Name: qasdb01
Generate Database Creation Scripts
Directory: /oradata/{DB_UNIQUE_NAME}/scripts
Database Components:
Memory: Custom
SGA Size: 10240M
PGA Size: 5120M
Sizing
Block Size: 8192Byte
Processes: 2000
Character Sets
Database Character Set: AL32UTF8
National Character Set: UTF8
Connection Mode: Dedicated Server Mode
All Initialization Parameters
audit_file_dest: /oradata/{DB_UNIQUE_NAME}/dump/adump
control_file: ("/oradata/{DB_UNIQUE_NAME}/control01.ctl", "/oradata/{DB_UNIQUE_NAME}/control02.ctl")
core_dump_dest: /oradata/{DB_UNIQUE_NAME}/dump/cdump
db_files: 500
open_links:20
open_links_per_instance: 20
diagnostic_dest: /oradata/{DB_UNIQUE_NAME}/dump
Redo Log Groups
Log File Size: 500M
