1. Create oinstall, dba, and quota groups
2. Oracle users
3. system parameter optimization (aio has been dynamically configured in AIX 6L and does not need to be configured. Running rootpre. sh to warn aio problems can be ignored)
4. Check the system software package (the dependent software package must be filled with smit installp)
Bos. adt. base
Bos. adt. lib
Bos. adt. libm
Bos. perf. libperfstat
Bos. perf. perfstat
Bos. perf. proctools
Rsct. basic. rte (For RAC configurations only)
Rsct. compat. clients. rte (For RAC tolerations only)
The August 2007 ibm c ++ Runtime Environment Components for AIX (9.0.1)
XlC. aix61.rte: 9.0.0.1
XlC. rte: 9.0.0.1
# Smit limit Ge // Insert the first system disk and select the installation Language
5. Create the vg-type scanable (orignal and big) ---- auto start --- no concurennt --- PP size 256
Scanable is especially important when you use oracle raw bare devices.
6. Create a File System
# Smit crfs // enhence journaled filesystem (jfs2)/mount point/size
System LV:
Mklv-y 'users _ 512m'-t 'jfs2 '-w'n'-S'-r'n' jzhcdatavg 2
Mklv-y 'tools _ 512m'-t 'jfs2 '-w'n'-S'-r'n' jzhcdatavg 2
Mklv-y 'temp _ 512m'-t 'jfs2 '-W' n'-S' n '-R' n' jzhcdatavg 2
Mklv-y 'undotbs1 _ 2g'-t 'jfs2 '-W' N'-S' n'-R' n 'jzhcdatavg 8
Mklv-y 'undotbs2 _ 2'-t' jfs2 '-W' N'-S' n'-R' n 'jzhcdatavg 8
Mklv-y 'log11 _ 1g '-t 'jfs2'-w'n'-S' n '-r'n' jzhcdatavg 4
Mklv-y 'log12 _ 1g '-t' jfs2'-w'n'-S' n '-r'n' jzhcdatavg 4
Mklv-y 'log21 _ 1g '-t 'jfs2'-w'n'-S' n '-r'n' jzhcdatavg 4
Mklv-y 'log22 _ 1g '-t' jfs2'-w'n'-S' n '-r'n' jzhcdatavg 4
Mklv-y 'log31 _ 1g '-t' jfs2'-W' N'-S' n '-R' n' jzhcdatavg 4
Mklv-y 'log32 _ 1g '-t' jfs2'-w'n'-S' n '-r'n' jzhcdatavg 4
Mklv-y 'indx _ 512m'-t 'jfs2 '-W' n'-S' n '-R' n' jzhcdatavg 2
Mklv-y 'spfile _ 512m'-t 'jfs2 '-W' n'-S' n '-R' n' jzhcdatavg 2
Mklv-y 'cntrl1 _ 512m'-t 'jfs2 '-W' n'-S' n '-R' n' jzhcdatavg 2
Mklv-y 'cntrl2 _ 512m'-t 'jfs2 '-W' n'-S' n '-R' n' jzhcdatavg 2
Mklv-y 'cntrl3 _ 512m'-t 'jfs2 '-W' n'-S' n '-R' n' jzhcdatavg 2
Mklv-y 'sysaux _ 2'-t' jfs2 '-W' N'-S' n'-R' n 'jzhcdatavg 8
Mklv-y 'systems _ 2'-t 'jfs2 '-w'n'-S' n'-r'n' jzhcdatavg 8
Mklv-y 'srvcfg _ 512m'-t 'jfs2 '-W' n'-S' n '-R' n' jzhcdatavg 2
Data LV:
Mklv-y 'data1lv01_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv02_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv03_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv04_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv05_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv06_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv07_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv08_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv09_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv10_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv11_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv12_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv13_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv14_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv15_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv16_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv17_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv18_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv19_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Mklv-y 'data1lv20_1g '-t 'jfs2-W' N'-S'-R' n' hc_datavg1 4
Install oracle on a single-host AIX
# Vi. profile
Umask 022
PS1 = "['whoam' @ 'hostname':" '$ PWD] $'
Export PS1
ORACLE_BASE =/oracle/app/oracle
Export ORACLE_BASE
ORACLE_SID = cachedb
Export ORACLE_SID
ORACLE_HOME =/oracle/app/oracle/product/10.2.0/db_1
Export ORACLE_HOME
NLS_LANG = 'American _ AMERICA. ZHS16GBK'
Export NLS_LANG
LD_LIBRARY_PATH = $ ORACLE_HOME/lib
Export LD_LIBRARY_PATH
PATH =/usr/bin:/etc:/usr/sbin:/usr/ucb: $ HOME/bin:/usr/bin/X11:/sbin :.
Export PATH
PATH = $ ORACLE_HOME/bin: $ PATH
Export PATH
Export DBCA_RAW_CONFIG =/home/oracle/raw_map.txt // raw Device File
The/home/oracle/raw_map.txt file is
System =/dev/rsystems_2g
Users =/dev/rusers_512m
Temp =/dev/rtemp_512m
Undotbs1 =/dev/rundotbs1_2g
Undotbs2 =/dev/rundotbs2_2g
Control1 =/dev/rcntrl316512m
Control2 =/dev/rcntrl2_512m
Control3 =/dev/rcntrl3_512m
Redo1_1 =/dev/rlog11_1g
Redo1_2 =/dev/rlog12_1g
Redo2_1 =/dev/rlog21_1g
Redo2_2 =/dev/rlog22_1g
Redo3_1 =/dev/rlog31_1g
Redo3_2 =/dev/rlog32_1g
Spfile =/dev/rspfile_512m
Indx =/dev/rindx_512m
Tools =/dev/rtools_512m
Sysaux =/dev/rsysaux_2g
Start Database Installation
Run./runInstaller
# Dbca database creation
1. custom installation database custom database
2. raw bare device. Select mapping file/home/oracle/raw_map.txt
3. Create a database based on the created LV
SQL> select * from v $ tablespace; // system tablespace
TS # NAME INC BIG FLA ENC
----------------------------------------------------
0 SYSTEM YES NO YES
1 UNDOTBS1 YES NO YES
2 SYSAUX YES NO YES
3 TEMP NO YES
4 USERS YES NO YES