AIX + ORACLE10G Installation Guide (zt)

Jan 7 posted in Oracle (RSS), 290 views.

AIX + ORACLE10G Installation Guide

1 AIX system installation using the AIX 5300L5 the media, according to the system prompts to install this step is very simple, not detailed description of the installation is complete the system need to set a good time zone, time, and network.

2 file system to adjust the initial packed system, its file system is as follows:
# Df-k
Filesystem 1024-blocks Free% Used Iused% Iused Mounted on
/ dev/hd4 32768 15648 53% 1724 11% /
/ dev/hd2 1212416 8764 100% 31825 11% / usr
/ dev/hd9var 32768 23884 28% 369 5% / var
/ dev/hd3 65536 63404 4% 30 1% / tmp
/ dev/hd1 32768 31684 4% 18 1% / home
/ proc - - - - - / proc
/ dev/hd10opt 65536 14304 79% 981 6% / opt

View vg of
# Lsvg-l rootvg
rootvg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
hd5 boot 1 1 1 closed / syncd N / A
hd6 paging 16 16 1 open / syncd N / A
hd8 jfslog 1 1 1 open / syncd N / A
hd4 jfs 1 1 1 open / syncd /
hd2 jfs 37 37 1 open / syncd / usr
hd9var jfs 1 1 1 open / syncd / var
hd3 jfs 2 2 1 open / syncd / tmp
hd1 jfs 1 1 1 open / syncd / home
hd10opt jfs 2 2 1 open / syncd / opt

# Lsvg-p rootvg
rootvg:
PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION
hdisk0 active 543 481 108 .. 93 .. 63 .. 108 .. 109

In which there are vgroot spare 481 PP, because of my PP size 32M, so there is 481 * 32M = 15392M space can be used.

Next to the original file system to adjust. In / usr as an example:
The original / usr size of 32 (PPs) * 32M (PP SIZE) = 1G
# Lslv hd2
LOGICAL VOLUME: hd2 VOLUME GROUP: rootvg
LV IDENTIFIER: 0006faaa00004c0000000111fd3878b2.5 PERMISSION: read / write
VG STATE: active / complete LV STATE: opened / syncd
TYPE: jfs WRITE VERIFY: off
MAX LPs: 32512 PP SIZE: 32 megabyte (s)
COPIES: 1 SCHED POLICY: parallel
LPs: 32 PPs: 32
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: center UPPER BOUND: 32
MOUNT POINT: / usr LABEL: / usr

The / usr became the size of the 2G
# Chfs-a size = 2048M / usr
Filesystem size changed to 4194304

# Df-k
Filesystem 1024-blocks Free% Used Iused% Iused Mounted on
/ dev/hd4 32768 15632 53% 1724 11% /
/ dev/hd2 2097152 865732 59% 31825 7% / usr
/ dev/hd9var 32768 23884 28% 369 5% / var
/ dev/hd3 65536 63396 4% 30 1% / tmp
/ dev/hd1 32768 31684 4% 18 1% / home
/ proc - - - - - / proc
/ dev/hd10opt 65536 14304 79% 981 6% / opt

# Lslv hd2
LOGICAL VOLUME: hd2 VOLUME GROUP: rootvg
LV IDENTIFIER: 0006faaa00004c0000000111fd3878b2.5 PERMISSION: read / write
VG STATE: active / complete LV STATE: opened / syncd
TYPE: jfs WRITE VERIFY: off
MAX LPs: 32512 PP SIZE: 32 megabyte (s)
COPIES: 1 SCHED POLICY: parallel
LPs: 64 PPs: 64
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: center UPPER BOUND: 32
MOUNT POINT: / usr LABEL: / usr

Other file system set up according to their needs can be, and the following are my settings:
Filesystem 1024-blocks Free% Used Iused% Iused Mounted on
/ dev/hd4 32768 16708 50% 1777 11% /
/ dev/hd2 2097152 811420 62% 32230 7% / usr
/ dev/hd9var 262144 245636 7% 380 1% / var
/ dev/hd3 1048576 796292 25% 457 1% / tmp
/ dev/hd1 262144 253744 4% 27 1% / home
/ proc - - - - - / proc
/ dev/hd10opt 2097152 1938404 8% 2302 1% / opt

oracle installation required a larger space, so a separate designation of a file system.
# Crfs-v jfs-g rootvg-m / oracle-a size = 8196M-a bf = true
One type JFS file system, the size of the 8 G, support for large files.

The final division of the file system are as follows:
# Df-k
Filesystem 1024-blocks Free% Used Iused% Iused Mounted on
/ dev/hd4 32768 15580 53% 1727 11% /
/ dev/hd2 2097152 865732 59% 31825 7% / usr
/ dev/hd9var 262144 246068 7% 373 1% / var
/ dev/hd3 524288 507704 4% 34 1% / tmp
/ dev/hd1 262144 253748 4% 18 1% / home
/ proc - - - - - / proc
/ dev/hd10opt 2097152 1981172 6% 981 1% / opt
/ dev/lv00 8388608 8125260 4% 17 1% / oracle

3 inspection system physical memory
# Lsattr-E-l sys0-a realmem
realmem 1048576 Amount of usable physical memory in Kbytes False

# Lsattr-E-l mem0
goodsize 1024 Amount of usable physical memory in Mbytes False
size 1024 Total amount of physical memory in Mbytes False
You can see, my system's physical memory to 1G

4 Check the virtual memory
# Lsps-a
Page Space Physical Volume Volume Group Size% Used Active Auto Type
hd6 hdisk0 rootvg 512MB 4 yes yes lv
You can see my original virtual memory system, 512M, generally it needs to be set to twice the size of physical memory

By SWAP partition where the logical partition expansion of the size of 48 PP, that is 48 * 32M = 1536M, together with the original 512M just for the 2G
# Extendlv hd6 32
# Lsps-a
Page Space Physical Volume Volume Group Size% Used Active Auto Type
hd6 hdisk0 rootvg 2048MB 1 yes yes lv

5 Check CPU case
# Lsdev-C | grep proc
proc0 Available 00-00 Processor

# Lsattr-E-l proc0
frequency 450000000 Processor Speed False
smt_enabled false Processor SMT enabled False
smt_threads 0 Processor SMT threads False
state enable Processor state False
type PowerPC_POWER3 Processor type False

6 Verify that the system structure
# Getconf HARDWARE_BITMODE
64

7 confirmed that the system needed to install the oracle libraries to install the
lslpp-l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat
bos.perf.libperfstat bos.perf.proctools bos.adt.prof bos.cifs_fs.rte
Fileset Level State Description
-------------------------------------------------- --------------------------
Path: / usr / lib / objrepos
bos.adt.base 5.3.0.50 COMMITTED Base Application Development
Toolkit
bos.adt.lib 5.3.0.50 COMMITTED Base Application Development
Libraries
bos.adt.libm 5.3.0.40 COMMITTED Base Application Development
Math Library
bos.adt.prof 5.3.0.50 COMMITTED Base Profiling Support
bos.cifs_fs.rte 5.3.0.50 COMMITTED Runtime for SMBFS
bos.perf.libperfstat 5.3.0.50 COMMITTED Performance Statistics Library
Interface
bos.perf.perfstat 5.3.0.50 COMMITTED Performance Statistics
Interface
bos.perf.proctools 5.3.0.50 COMMITTED Proc Filesystem Tools

Path: / etc / objrepos
bos.cifs_fs.rte 5.3.0.50 COMMITTED Runtime for SMBFS
bos.perf.libperfstat 5.3.0.50 COMMITTED Performance Statistics Library
Interface
bos.perf.perfstat 5.3.0.50 COMMITTED Performance Statistics
Interface
If you have not installed library file, use the smitty (CLI) or the smit (GUI), the wizard to install it.

8 for the ORACLE10.2.0.1 version of the database needs to be confirmed the following patch installation:
/ usr / sbin / instfix-i-k "IY89080"
If a patch is not installed, use the smitty (CLI) or the smit (GUI), the wizard for installation,
Once on shore, patches, you need to restart the machine.

At this point, OS part of the installation is complete.

/********************
ORACLE 10.2.0.1 Installation and Configuration
********************/
One from the oracle website to download Oracle Database 10g Release 2 (10.2.0.1.0) for AIX5L
Download Web links are as follows: http://www.oracle.com/technology/so...201aixsoft.html
Note that download sites need to first register as a user oracle

Present the following documents:
10gr2_aix5l64_database.cpio.gz (1,268,576,110 bytes) (cksum - 3772623559)

A good compression packages will be available via FTP upload to the AIX, and through the following command to extract:
gunzip 10gr2_aix5l64_database.cpio.gz
cpio-idcmv <10gr2_aix5l64_database.cpio.gz

2 to create a user group oinstall and dba
3 Create oracle user, user group oinstall and dba
Modify the oracle user's system limits
vi / etc / security / limits
default:
fsize = -1
core = 2097151
cpu = -1
data = 262144
rss = 65536
stack = 65536
nofiles = 2000

root:

daemon:

bin:

sys:

adm:

uucp:

guest:

nobody:

lpd:

oracle:
data = -1
stack = -1

Modify the oracle user. Pofile file
ORACLE_BASE = / oracle; export ORACLE_BASE
ORACLE_HOME = $ ORACLE_BASE/product/10.2.0; export ORACLE_HOME
ORACLE_SID = icdvm; export ORACLE_SID

PATH = $ ORACLE_HOME / bin: $ PATH; export PATH
4 in order to root the implementation of rootpre.sh
5 to oracle User Login
export DISPLAY = the IP address of the machine: 0.0
If
export DISPLAY = 192.168.100.167:0.0
RunInstall.sh and then execute the script, according to the installation GUI wizard oracle

At this point, oracle installation is complete.