AIX6.1 install Oracle 11g R2

AIX6.1 install Oracle 11g R2

1. Check the server status before installation
(1) view memory size
# The/usr/sbin/lsattr-E-l sys0-a realmem command is long. If you forget it, you can use man lsattr.
(2) view swap space
# Lsps-
Page Space Physical Volume Group Size % Used Active Auto Type
Hd6 hdisk0 rootvg 512 MB 1 yes lv
(3) Check the system structure. ORACLE Installation in AIX requires a 64-bit system.
# Getconf HARDWARE_BITMODE and getconf KERNEL_BITMODE
64
Or
# Bootinfo-K
64
(4) Check the OS version. 11GR2 requires a version later than 5300-09.
Version 5300-09 or later
(5) Check related packages required for oracle Installation
Bos. adt. base
Bos. adt. lib
Bos. adt. libm
Bos. perf. libperfstat 6.1.2.1 or later
Bos. perf. perfstat
XlC. aix50.rte: 8.0.0.7 or later (AIX 5.3)
XlC. rte: 8.0.0.7 or later (ibm aix 5.3)
XlC. aix61.rte: 9.0.0.1 or later (AIX 6.1)
XlC. rte: 9.0.0.1 or later (ibm aix 6.1)
Gpfs. base 3.2.1.8 or later
Rsct. basic. rte)
(6) adjust parameters
A. Adjust the maxuproc (Maximum number of PROCESSES in the System) Official Website prompt "Verify that the value shown for Maximum number of PROCESSES allowed per user is greater than or equal to 2048 ."
Modify through smitty chgsys or directly through commands
# Chdev-l sys0-a maxuproc = 16384
Sys0 changed
B. Adjust the ncargs (system block size) Official Website prompts "Oracle recommends that you set the ncargs system attribute to a value greater than or equal to 128 ."
# Chdev-l sys0-a ncargs = 128
(PS: when the operation was performed, the system prompts that the operation failed. Later, through smitty chgsys, check the value shown for ARG/ENV in it, which is 512, which meets the requirements on the official website, so the command was changed to 512)
C. Adjust asynchronous io and restart pstat-a | grep aios (skip this step if not)
# Smitty aio
D. Modify the default parameter in the/etc/security/limits file (restart required)
Default:
Fsize =-1 # (Unlimited)
Core =-1 # (Unlimited)
Cpu =-1 # (Unlimited)
Data =-1 # (Unlimited)
Rss =-1 # (Unlimited)
Stack =-1 # (Unlimited)
Nofiles =-1 # (Unlimited)
E. Optimize Virtual Memory Management
Vmo-p-o minperm % = 3
Vmo-p-o maxperm % = 90
Vmo-p-o maxclient % = 90
Vmo-p-o lru_file_repage = 0
Vmo-p-o strict_maxclient = 1
Vmo-p-o strict_maxperm = 0
F. Adjust Network Parameters
No-r-o ipqmaxlen = 512
No-p-o rfc1323 = 1
No-p-o sb_max = 131072 // 2*65536
No-p-o tcp_recvspace = 65536
No-p-o tcp_sendspace = 65536
No-p-o udp_recvspace = 655360
No-p-o udp_sendspace = 65536
(7) create users and groups
Smitty mkgroup
Create a dba group: Enter dba in group NAME, and press enter by default.
Create an oinstall group: Enter oinstall in group NAME, and press enter by default.
Create an oracle user: Select oinstall for Primary GROUP, select DBA for Group SET, and keep other options as default. (SET the password after creation)
Ability to modify oracle users:
# Chuser capabilities = CAP_NUMA_ATTACH, CAP_BYPASS_RAC_VMM, CAP_PROPAGATE oracle
# LSUSEr a capabilities oracle
Oracle capabilities = CAP_NUMA_ATTACH, CAP_BYPASS_RAC_VMM, CAP_PROPAGATE
(8) set Environment Variables
After logging on as an oracle user, add environment variables as follows:
Cd ~
Vi. profile
Export PS1 = '[''hostname'': $ LOGIN: $ PWD] $'
Export EDITOR = vi
Export ORACLE_SID = oracl # This setting requires the Instance name when dbca is created
Export ORACLE_BASE =/oracle ### oracle Installation Base directory
Export ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/db_1
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib
Export PATH = $ ORACLE_HOME/bin:/usr/sbin:/usr/X11R6/bin:/sbin
Export NLS_DATE_FORMAT = "YYYY-MM-DD HH24: MI: SS"
Export TMPDIR =/tmp
PS: After the preceding variables are defined, it is found that the environment variables do not take effect after xmanager is used for login. However, telnet logon takes effect because CDC is used for login. dtprofile file,
Change # DTSOURCEPROFILE = true to DTSOURCEPROFILE = true
(9) create a file directory defined in the Environment Variable
$ Mkdir-p $ ORACLE_BASE
$ Mkdir-p $ ORACLE_BASE/product/11.2.0/db_1
(10) change the oracle software storage directory and installation directory to oralce
$ Su
# Chown-R oracle: oinstall/soft # This is the directory for storing the oracle Installation Package
# Chown-R oracle: oinstall/oracle # This is the installation directory ($ ORACLE_BASE)
(11) start to install database software
Download and unzip the software
Aix.ppc64_11gR2_database_1of2.zip
Aix.ppc64_11gr2_database5of2.zip
Go to the installation file storage directory/database, and first run rootpre. sh under the root user.
#./Rootpre. sh
./Rootpre. sh output will be logged in/tmp/rootpre. out_12-08-20.21: 18: 00
Saving the original files in/etc/ora_save_12-08-20.21: 18: 00 ....
Copying new kernel extension to/etc ....
Loading the kernel extension from/etc
Oracle Kernel Extension Loader for AIX
Copyright (c) 1998,1999 Oracle Corporation
Successfully loaded/etc/pw-syscall.64bit_kernel with kmid: 0x3fa3700
Successfully configured/etc./pw-syscall.64bit_kernel with kmid: 0x3fa3700
The kernel extension was successfuly loaded.
Processing ing Asynchronous I/O ....
Processing ing POSIX Asynchronous I/O ....
Checking if group services shocould be configured ....
Nothing to configure.
In this way, the environment variables will take effect after you log on to xmanager again.
(12)
Test whether the graphic interface is normal because the oracle software is installed on the graphic interface.
Oracle users
$ Xhost +
Access control disabled, clients can connect from any host
$ Xclock (this command may not be used, but the clock can be displayed as normal under root)
If there is no problem, you can install it on the GUI.
$./RunInstaller

Recommended reading:

How to install Oracle 11g on Linux

Detailed description of the installation process of Oracle 11g Database in Linux

How to install Oracle 11g R2 single-instance database on CentOS 5.6

To install Oracle Clusterware on an Oracle vmvm

Install Oracle 11 GB single-instance database on Linux under vmvm