Installing Oracle 11g R2 Based on IBM AIX

1. Basic hardware requirements for installing Oracle databases

1.1 Basic Requirements for memory

At least 1 GB of physical memory

Oracle officially recommends 2 GB memory or more

Here, we can meet the basic conditions in the experiment environment. In the actual production environment, the business usage and system architecture should be fully evaluated to determine the memory allocation and reservation.

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Enter
# Getconf REAL_MEMORY11927552
Our memory is 12 GB, which is very abundant. This is similar to the memory used by the actual production system.

The following table lists the relationships between memory and swap space.

Available Memory RAM	Exchange Space Requirements
1 GB to 2 GB	1.5 times the memory size
2 GB to 16 GB	Equal to the memory size
More than 16 GB	16 GB

 

To view the size of the swap space of the AIX6.1 system to be installed, run the following command:

# Lsps-

Page Space Physical Volume Group Size % Used Active Auto Type Chksum

Hd6 hdisk0 rootvg 11264 MB 1 yes lv 0

The output result is 12 GB of physical memory. The system still occupies a small part here. If not,

The chps-s number hd6 increases the swap space. For example, the chps-s 28 hd6 28 * pp size can be used to calculate the number.

1.2 disk space requirements

L at least 1 GB/TMP directory Space

We continue to meet the conditions. This space can actually be increased. We also need to use it to store the oracle 11g installation package. Here we will continue to the next step for 20G.

1.3 running level requirements

L ensure that the system runs in Level 2 mode

# Cat/etc/. init. state

2. check software requirements

2.1 Operating System Requirements

L AIX 5L V5.3 TL 09 SP1 ("5300-09-01"), 64-bit kernel

L AIX 6.1 TL 02 SP 1 ("6100-02-01), 64-bit kernel

L AIX 7.1 TL 0 SP 1 ("7100-00-01"), 64-bit kernel

We can meet the basic conditions listed above, or a higher revision, but it cannot be lower than the one listed above. We installed the AIX 6.1 system and confirmed the operating system version. The command is as follows:

# Oslevel-s

6100-07-00-0000

If the installation conditions are met, proceed to the next step.

2.2 install the OS environment package required for oracle 11G

Make sure that the following operating system environment packages are installed

Bos. adt. base

Bos. adt. lib

Bos. adt. libm

Bos. perf. libperfstat 6.1.2.1or later

Bos. perf. perfstat

Bos. perf. proctools

XlC. aix61.rte. 10.1.0.0or later

XlC. rte.10.1.0.0or later

Gpfs. base 3.2.1.8or later

Command line query for Installation

# Lslpp-l bos. adt. base bos. adt. lib bos. adt. libm bos. perf. perfstat \

Bos. perf. libperfstat bos. perf. proctools

Generally, you only need to upgrade AIX to the latest TL. This step should be correct.

3. create the required OS group and user

3.1 create an oinstall, dba group, and oracle user

In command line mode:

# Smit mkgroup create oinstall and dba groups

# Smit mkuser: Create an oracle user, set the oracle master group to oinstall, and set the group to dba.

# Passwd an oracle Password

# Id oracle

Uid = 202 (oracle) gid = 201 (oinstall) groups = 202 (dba)

3.2 configure Kernel Parameters

In command line mode:

# Change vi/etc/security/limits to-1

Default:

Fsize =-1

Core =-1

Cpu =-1

Data =-1

Rss =-1

Stack =-1

Nofiles =-1

Set the maximum value of aio to 65536, which is the default value of the system and does not need to be modified.

# Ioo-o aio_maxreqs

Aio_maxreqs = 65536

It must be declared that the rootpre. sh script must be run on AIX 5L to enable the aio function. It is enabled by default in AIX 6L. In AIX 5 and 6, 65536 (6 k) values are used for maximum asynchronous io.

4. Create an oracle software installation directory and configure oracle user environment variables

4.1 As shown below

# Mkdir-p/u01/app/oracle

# Chown-R oracle: oinstall/u01/app/oracle

# Chmod-R 775/u01/app/oracle

$ Su-oracle

$ Vi/home/oracle/. profile

Write the environment variables you need in the blank space.

Export ORACLE_BASE =/u01/app/oracle

Export ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/db_1

Export ORACLE_SID = xupeng11g

Export PATH =/usr/sbin: $ PATH

Export PATH = $ ORACLE_HOME/bin: $ PATH

Save and exit

$ ../. Profile: the current environment variable takes effect

 

For more details, please continue to read the highlights on the next page:

1 2 3 4 5 6 Next Page