Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to install Oracle 11 in AIX6.1". In daily operation, I believe many people have doubts about how to install Oracle 11 in AIX6.1. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts about "how to install Oracle 11 in AIX6.1". Next, please follow the editor to study!

Best practices for AIX 6.1 to install Oracle 11.2.0.4 ASM RAC PSU

Recently, I have installed RAC many times on the AIX 6.1platform, and I have encountered all kinds of pits. Most of the reasons are due to incorrect configuration and permissions that do not follow the official documents. I have sorted out a relatively correct installation manual for later use. If there are any omissions, please correct 67549542@qq.com.

Refer to the official installation document of Oracle and see attachment e48294.pef.

Oracle Grid Infrastructure

Installation Guide

11g Release 2 (11.2) for IBM AIX on POWER Systems (64-Bit)

E48294-03

Operating system version: 6100-06-12-1339

Install sddpcm multipath software, see attachment for installation package

Smit installp

View the PCM disk

Pcmpath query device

If the command does not find the disk, you need to re-identify the disk.

Rmdev-Rdl fcs0

Rmdev-Rdl fcs1

Cfgmgr-v

Install the ssh software, see the attachment for the installation package

Configure SSH boot

Note install_assist:2:wait:/usr/sbin/install_assist / dev/console 2 > & 1 under / etc/inittab

Preparatory work:

/ etc/hosts

Xxx.xxx.101.182 rac1

Xxx.xxx.101.183 rac1-vip

Xx.xx.80.182 rac1-priv

Xxx.xxx.101.184 rac2

Xxx.xxx.101.185 rac2-vip

Xx.xx.80.184 rac2-priv

Xxx.xxx101.186 racdb-scan

Set the hostname hostname of xxx.xxx.101.182 to rac1

Set the hostname hostname of xxx.xxx.101.184 to rac2

/ etc/security/limits

Default:

Fsize =-1

Core = 2097151

Cpu =-1

Data =-1

Rss =-1

Stack =-1

Nofiles =-1

Parameter adjustment

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

No-r-o ipqmaxlen=512

No-p-o rfc1323=1

No-p-o sb_max=4194304

No-p-o tcp_recvspace=65536

No-p-o tcp_sendspace=65536

No-p-o udp_recvspace=655360

No-p-o udp_sendspace=65536

In some cases,

/ usr/sbin/no-o-p rfc1323=1 after the modification. The verification still fails. It's obviously changed to 1.

Query MOS may be a bug

If the parameter has been modified, you can ignore it

Chdev-l sys0-a maxuproc=16384

Chdev-l sys0-a ncargs=256

Create a group, user:

Mkgroup -'A' id='1000' oinstall

Mkgroup -'A' id='1020' asmadmin

Mkgroup -'A' id='1021' asmdba

Mkgroup -'A' id='1022' asmoper

Mkgroup -'A' id='1031' dba

Mkgroup -'A' id='1032' oper

According to the official documentation, the policy of separate installation and permissions of GI and DB is beneficial to multi-instance management.

Mkuser id='1100' pgrp='oinstall' groups='asmadmin,asmdba,asmoper,oper,dba' grid

Mkuser id='1101' pgrp='oinstall' groups='dba,asmdba,oper' oracle

Chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid

Chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

.profile

Grid:

Umask 022

Export ORACLE_BASE=/oracle/app/grid

Export ORACLE_HOME=/oracle/app/11.2/grid

Export ORACLE_SID=+ASM1

Export NLS_LANG=AMERICAN_AMERICA.UTF8

Export NLS_DATE_FORMAT= "yyyy-mm-dd hh34:mi:ss"

Export PATH=.:$ {PATH}: $HOME/bin:$ORACLE_HOME/bin

Export PATH=$ {PATH}: / usr/bin:/bin:/usr/bin/X11:/usr/local/bin

Export PATH=$ {PATH}: $ORACLE_BASE/common/oracle/bin

Export ORACLE_PATH=$ {PATH}: $ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

Export ORACLE_TERM=xterm

Export TNS_ADMIN=$ORACLE_HOME/network/admin

Export ORA_NLS10=$ORACLE_HOME/nls/data

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Export LD_LIBRARY_PATH=$ {LD_LIBRARY_PATH}: $ORACLE_HOME/oracm/lib

Export LD_LIBRARY_PATH=$ {LD_LIBRARY_PATH}: / lib:/usr/lib:/usr/local/lib

Export CLASSPATH=$ORACLE_HOME/JRE

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/jlib

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/rdbms/jlib

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/network/jlib

Export THREADS_FLAG=native

Export TEMP=/tmp

Export TMPDIR=/tmp

Oracle:

Umask 022

Export ORACLE_BASE=/oracle/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2

Export ORACLE_SID=ykcdb1

Export ORACLE_UNQNAME=ykcdb

Export NLS_LANG=AMERICAN_AMERICA.UTF8

Export NLS_DATE_FORMAT= "yyyy-mm-dd hh34:mi:ss"

Export PATH=.:$ {PATH}: $HOME/bin:$ORACLE_HOME/bin

Export PATH=$ {PATH}: / usr/bin:/bin:/usr/bin/X11:/usr/local/bin

Export PATH=$ {PATH}: $ORACLE_BASE/common/oracle/bin

Export ORACLE_PATH=$ {PATH}: $ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

Export ORACLE_TERM=xterm

Export TNS_ADMIN=$ORACLE_HOME/network/admin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Export LD_LIBRARY_PATH=$ {LD_LIBRARY_PATH}: $ORACLE_HOME/oracm/lib

Export LD_LIBRARY_PATH=$ {LD_LIBRARY_PATH}: / lib:/usr/lib:/usr/local/lib

Export CLASSPATH=$ORACLE_HOME/JRE

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/jlib

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/rdbms/jlib

Export CLASSPATH=$ {CLASSPATH}: $ORACLE_HOME/network/jlib

Export THREADS_FLAG=native

Export TEMP=/tmp

Export TMPDIR=/tmp

SSH password-free login

Both of the following nodes perform:

# su-grid

$/ usr/bin/ssh-keygen-t rsa

When prompted for a password, leave it blank and enter directly.

The following is performed only on node 1:

$touch ~ / .ssh/authorized_keys

$ssh ykc1 cat ~ / .ssh/id_rsa.pub > > ~ / .ssh/authorized_keys

$ssh ykc2 cat ~ / .ssh/id_rsa.pub > > ~ / .ssh/authorized_keys

$scp ~ / .ssh/authorized_keys ykc2:.ssh/authorized_keys

Execute ssh ykc1 ssh ykc2 ssh ykc2 ssh ykc1 on ykc1 in turn

The same is true for oracle users.

Batch modify disk attribute script

Lspv, to see how many hdisk modifies the I variable, execute, for example

ITunes 5

While ($I

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.