Redhat Linux AS4 install Oracle 10g (including startup)

Redhat Linux AS4 install Oracle 10g (10.2)

 

1. Hardware requirements

(1) memory> 1024 MB

Memory swap Partition

> 1024 MB 2 times memory

<2048 MB 1.5 times memory

<8192 MB 1 times memory

> 8192 MB 0.75 times memory

Display memory commands

2)/tmp> 400 M

3) detection command

Memory

# Grep MemTotal/proc/meminfo

Swap Partition

# Grep SwapTotal/proc/meminfo

/Tmp Partition

# Df-k/tmp

Cpu Information

# Grep "model name"/proc/cpuinfo

2. software requirements

1) Operating System

Red Hat Enterprise Linux AS/ES 3.0 (Update 4 or later)

Red Hat Linux 4.0

SUSE Linux Enterprise Server 9.0

Asianux 1.0

Asianux 2.0

2) Kernel

Red Hat Enterprise Linux 3.0 and Asianux 1.0

2.4.21-27.EL

Red Hat Enterprise Linux 4.0 and Asianux 2.0

2.6.9-5.EL

SUSE Linux Enterprise Server 9.0

2.6.5-7.201

3) specific package

Red Hat Enterprise Linux 3.0 and Asianux 1.0

Make-3.79.1

Gcc-3.2.3-34

Glibc-2.3.2-95.20

Compat-db-4.0.14-5

Compat-gcc-7.3-2.96.128

Compat-gcc-c ++-7.3-2.96.128

Compat-libstdc ++-7.3-2.96.128

Compat-libstdc ++ devel-7.3-2.96.128

Openmotif21-2.1.30-8

Setarch-1.3-1

Red Hat Enterprise Linux 4.0 and Asianux 2.0:

Binutils-2.15.92.0.2-13.EL4

Compat-db-4.1.25-9

Compat-libstdc ++-296-2.96-132.7.2

Control-center-2.8.0-12

Gcc-3.4.3-22.1.EL4

Gcc-c ++-3.4.3-22.1.EL44

Glibc-2.3.4-2.9

Glibc-common-2.3.4-2.9

Gnome-libs-1.4.1.2.90-44.1

Libstdc ++-3.4.3-22.1

Libstdc +-devel-3.4.3-22.1

Make-3.80-5

Pdksh-5.2.14-30

Sysstat-5.0.5-1

Xscreensaver-4.18-5.rhel4.2

Setarch-1.6-1

SUSE Linux Enterprise Server 9

Binutils-2.15.90.0.1.1-32.5

Gcc-3.3.3-43.24

Gcc-c ++-3.3.3.3-43.24

Glibc-2.3.3-98.28

Gnome-libs-1.4.1.7-671.1

Libstdc +++ 3.3.3-43.24

Libstdc +-devel-3.3.3-43.24

Make-3.80-184.1

Pdksh-5.2.14-780.1

Sysstat-5.0.1-35.1

Xscreensaver-4.16-2.6

4) command

Operating System Model

# Cat/etc/issue

Kernel model

# Uname-r

Query the installation package

# Rpm-q package_name

Query scripts in RL AS4

Rpm-qa binutils

Rpm-qa compat-db

Rpm-qa compat-libstdc ++-33

Rpm-qa control-center

Rpm-qa gcc

Rpm-qa gcc-c ++

Rpm-qa glibc

Rpm-qa glibc-common

Rpm-qa gnome-libs

Rpm-qa libstdc ++

Rpm-qa libstdc ++-devel

Rpm-qa make

Rpm-qa pdksh

Rpm-qa sysstat

Rpm-qa xscreensaver

Rpm-qa setarch

3. Installation

1) Environment

2048 MB memory, 146 GB hard disk

2) Partition

/30G

/Tmp 2G

/Var 3G

/App 20G

/App/oradata 60G

/App/orabc20G

3) Installation

Select all management tools, development tools, Gnome environment, Web Server, and FTP Server

All packages except sysstat are successfully installed,

Sysstat package on disk 4, rpm-I sysstat-5.0.5-1.i386.rpm

4. Install Oracle

1) Add a user group

Determine whether users and groups exist

Grep dba/etc/group

Grep oinstall/etc/group

Id oracle

Id nobody

If yes, do not add

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba oracle

-- Oracle already exists but is not an oinstall group or a non-dba group member

Usermod-g oinstall-G dba oracle

Useradd nobody

2) Kernel Parameters

Parameter Value File

Semms l 250/proc/sys/kernel/sem

Semmns 32000

Semopm 100

Semmni 128

Shmall 2097152/proc/sys/kernel/shmall

Shmmax Half the size of physical memory (in bytes)/proc/sys/kernel/shmmax

Shmmni 4096/proc/sys/kernel/shmmni

File-max 65536/proc/sys/fs/file-max

Ip_local_port_range Minimum: 1024/proc/sys/net/ipv4/ip_local_port_range

# Maximum: 65000

Rmem_default 1048576/proc/sys/net/core/rmem_default

Rmem_max 1048576/proc/sys/net/core/rmem_max

Wmem_default 262144/proc/sys/net/core/wmem_default

Wmem_max262144/proc/sys/net/core/wmem_max

Command

Semmsl, semmns, semopm, and semmni #/sbin/sysctl-a | grep sem

Shmall, shmmax, and shmmni #/sbin/sysctl-a | grep shm

File-max #/sbin/sysctl-a | grep file-max

Ip_local_port_range #/sbin/sysctl-a | grep ip_local_port_range

Rmem_default #/sbin/sysctl-a | grep rmem_default

Rmem_max #/sbin/sysctl-a | grep rmem_max

Wmem_default #/sbin/sysctl-a | grep wmem_default

Wmem_max #/sbin/sysctl-a | grep wmem_max

Modify the configuration file/etc/sysctl. conf to add or modify

Kernel. shmall = 2097152

Kernel. shmmax = 2147483648

Kernel. shmmni = 4096

Kernel. sem = 250 32000 100 128

Fs. file-max = 65536

Net. ipv4.ip _ local_port_range = 1024 65000

Net. core. rmem_default = 1048576

Net. core. rmem_max = 1048576

Net. core. wmem_default = 262144

Net. core. wmem_max = 262144

Restart

3) set the shell of the oracle user

A) Add the following line to/etc/security/limits. conf.

Oracle soft nproc 2047

Hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

B) Add the following lines to/etc/pam. d/login.

Session required/lib/security/pam_limits.so

Session required pam_limits.so

C) modify the Shell default Startup File

Add the following lines to/etc/profile under Bourne, Bash, and Korm shell.

If [$ USER = "oracle"]; then

If [$ SHELL = "/bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

In C shell, add the following lines to/etc/csh. login.

If ($ USER = "oracle") then

Limit maxproc 16384

Limit descriptors 65536

Endif

4) create the required directory

Mkdir/app/oracle

Chown-R oracle: oinstall/app/oracle

Chmod-R 775/app/oracle

Chown-R oracle: oinstall/app/oradata

Chmod-R 775/app/oradata

Chown-R oracle: oinstall/app/orabp

Chmod-R 775/app/orabp

There is only one hard disk. If there are multiple hard disks, you need to create a mount point, such as u01,

The directory is/u01/app/oracle. There is only one hard disk, and the mount point is/

5) set the oracle user environment

A) if oracle is installed on a remote system, it is displayed in the local X-Windows.

Xhost host_name

B) use oracle to log on to X-windows or su-oracle.

C) view the default Shell

Echo $ SHELL

D) bash

Vi. bash_profile

If ORACLE_SID, ORACLE_HOME, and ORACLE_BASE are set, delete the corresponding row.

E) umask 022

F) save the file and execute

.. Bash_profile

G) set the DISPLAY variable

DISPLAY = localhost: 0.0; export DISPLAY

On the remote display page, change localhost to remote host.

H) if the/tmp space is insufficient, you need to set the TMP and TMPDIR variables.

$ Su-root

# Mkdir/mount_point/tmp

# Chmod a + wr/mount_point/tmp

# Exit

Under bash

$ TMP =/mount_point/tmp

$ TMPDIR =/mount_point/tmp

$ Export TMP TMPDIR

I) Confirm ORACLE_HOME, TNS_ADMIN is not set

$ Unset ORACLE_HOME

$ Unset TNS_ADMIN

J) check whether the settings are correct

$ Umask

$ Env | more

6) install Oracle

A) obtain the Oracle installer

Download from the Oracle website for free. You only need a simple registration and get a zip file.

Unzip 10201_database_linux32.zip

If you are installing a CD, mount the media

B) Run

RunInstaller

C) the installation process is very similar to that of Windows.

Select oinstall when selecting the dba group

Modify the default directory, such as the installation directory and Inventory directory.

Install