CentOS 6.3 Environment Oracle 11gR2 Database Installation

CentOS 6.3 Environment Oracle 11gR2 Database Installation

CentOS 6.3 Environment Oracle 11gR2 Database Installation

1. install necessary OS installation packages

We recommend that you install the operating system to the maximum extent, because the impact of current hardware on the maximum installation on the database server is negligible, to avoid unnecessary trouble.

If the installation is not maximized, use yum for online update and installation according to the official Oracle documents or the prompt that a package is missing during the installation process to ensure that the server can be connected to the Internet normally. For example:

Yum install gcc ++

2. Create oracle users and user groups

#/Usr/sbin/groupadd oinstall
#/Usr/sbin/groupadd dba
#/Usr/sbin/useradd-g oinstall-G dba oracle (#/usr/sbin/usermod-g oinstall-G dba oracle)
# Passwd oracle

3. Create an installation directory

# Mkdir-p/home/oracle/app/
# Chown-R oracle: oinstall/home/oracle/app/
# Chmod-R 775/home/oracle/app/

4. Modify the corresponding configuration file
Root User Logon modification:

Vim/etc/sysctl. conf

Fs. aio-max-nr = 1048576
Fs. file-max = 6815744
Kernel. shmall = 2097152
Kernel. shmmax = 536870912
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Net. ipv4.ip _ local_port_range = 9000 65500
Net. core. rmem_default = 262144
Net. core. rmem_max = 4194304
Net. core. wmem_default = 262144
Net. core. wmem_max = 1048576
--------------------------------------
Vim/etc/security/limits. conf

Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
Oracle soft stack 10240

5. graphical installation of oracle11g
Copy the Oracle11g installation package to the corresponding directory, for example,/home/oracle/. decompress the package to the Database folder;
Install: $/home/oracle/database/runInstaller
If an installation package fails during the check of the installation package, run the yum command again to install the package. After the installation package is complete, run the database 11g again.
At the end of the installation, execute the script under root as prompted.

6. After the installation is complete, configure the Database Listener and the local database service and Firewall

$ Netmgr
$ Netca
$ Dbca
# Setup configure the corresponding firewall port or directly turn off the Firewall
Pl/SQL connectivity test...

VII. ORACLE service Automatic startup configuration

1. Modify oratab as the root user
# Vi/etc/oratab

Xx:/opt/oracle/11.2.0: Y (N changed to Y) -------- xx indicates the database instance name.

Esc: wq! Save

 

2. oracle users modify dbstart and dbshut

# Vi/opt/oracle/11.2.0/bin/dbstart

ORACLE_HOME_LISTNER = $ ORACLE_HOME (originally $1)

Esc: wq! Save

 

# Vi/opt/oracle/11.2.0/bin/dbshut

ORACLE_HOME_LISTNER = $ ORACLE_HOME (originally $1)

Esc: wq! Save

3. add content to rc. local as the root user.

# Vi/etc/rc. d/rc. local

Add the following content to the file

Su-oracle-c "lsnrctl start"

Su-oracle-c "dbstart"

Esc: wq! Save

4. Restart

# Reboot

Notes on installing Oracle 11g R2 in Oracle Linux 6.3

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian