Redhat 6.2 Oracle 11g R2 Installation detailed 1th/2 page _oracle

I. Configuring System Parameters

We need to configure the system parameters to be used before Oracle is installed

1. Modify System kernel Parameters

modifying sysctl.conf files

Add the following in the file/etc/sysctl.conf:

Kernel.sem = 250 32000 100 128

Kernel.shmall = 2097152

Kernel.shmmax = 2147483648

Kernel.shmmni = 4096

FS.AIO-MAX-NR = 1048576

Fs.file-max = 6815744

Net.core.rmem_default = 4194304

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Net.ipv4.ip_local_port_range = 9000 65500

Note: The value of Kernel.shmmax is half of the physical memory. If the server is 4G RAM, then his value is 2147483648

Parameter description: Kernel.shmmni: Maximum number of shared memory segments across the system

Fs.file-max: Maximum number of file handles allowed in the system

Net.core.rmem_default: Default value for socket receive buffer size

Net.core.rmem_max: The maximum socket receive buffer size

Net.core.wmem_default: Default value for socket send buffer size

Net.core.wmem_max: Maximum socket send buffer size

Net.ipv4.ip_local_port_range: The IPV4 port range that the application can use

Make kernel parameters Effective after modification is complete

Sysctl–p output:

2, modify the Hosts file

Under/etc/hosts Add the following content

192.168.100.197 Oracle Oracle.localdomain Rhel6.localdomain

The host name must be mapped to the real ip192.168.100.197 address of the host, or Oracle might simply build the listener on the 127.0.0.1. Host names can be set according to personal preferences.

3. Create users and user groups

[Root@rhel6 ~]# Groupadd dba

[Root@rhel6 ~]# Groupadd Oinstall

[Root@rhel6 ~]# useradd-g oinstall-g dba Oracle

[Root@rhel6 ~]# passwd Oracle

When Oracle users are created, they belong to the Oinstall and DBA and use passwd Oracle to set passwords for Oracle users

4. New Installation directory

We install Oracle under Home/app/oracle and need to create a new directory under Home

Mkdir-p/home/app/oracle

Mkdir-p/home/app/orainventory (log directory)

5, set the ownership and permissions of the directory

root@ubuntu:~# chmod-r 755/home/app (permissions)

root@ubuntu:~# chown-r oracle:oinstall/home/app/oracle (ownership)

root@ubuntu:~# chown-r oracle:oinstall/home/app/orainventory (ownership)

6. Configure Oracle User Environment variables

[Oracle@linux02 ~]$ su Oracle (Switch to Oracle user)

[oracle@linux02 ~]$ Vi. Bash_profile

(. Bash.profile is hidden under/home/oracle to view with Ls–a)

Add the following content to it

tmp=/tmp; Export TMP

Tmpdir= $TMP; Export Tmpdir

Oracle_base=/home/app/oracle; Export Oracle_base (ORACLE directory created by the corresponding user)

Oracle_home= $ORACLE _base/product/11.2.0/dbhome_1; Export Oracle_home

ORACLE_SID=ORCL; Export Oracle_sid

Oracle_term=xterm; Export Oracle_term

Path= $ORACLE _home/bin:/bin:/usr/bin:/usr/sbin: $PATH; Export PATH

Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib; Export Ld_library_path

Classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib;

Export CLASSPATH

if [$USER = "Oracle"]; Then
if [$SHELL = "/bin/ksh"]; Then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi
Umask 022

(The value of Oracle_sid can be set by itself, this is set to ORCL, and the Oracle_sid should be set to ORCL for subsequent installations:)

Immediately after completion is the environment variable effective source. bash_profile

Check if environment variable is in effect env |grep ORA

7. Modify/etc/security/limits.conf File

At the end of the file "/etc/security/limits.conf", add the following:

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

8. Modify/etc/pam.d/login File

At the end of the file "/etc/pam.d/login", add the following:

Session Required Pam_limits.so

9. Modify/etc/profile File

At the end of the file "/etc/profile", add the following:

if [$USER = "Oracle"]; Then
if [$SHELL = "/bin/ksh"]; Then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Umask 022
Fi

10, firewall settings

Add the following content to the file "/etc/sysconfig/iptables":

-A input-m state--state new-m tcp-p TCP--dport 22-j ACCEPT

-A input-m state--state new-m tcp-p TCP--dport 1521-j ACCEPT

-A input-m state--state new-m tcp-p TCP--dport 1158-j ACCEPT

The Oracle remote access port defaults to 1521,oem Port 1158, and if you customize the new port, open the appropriate port.

(The configuration of the new open port must be immediately followed by the configuration of Port 22)

Reboot firewall: [root@oracle sysconfig]# service iptables restart, output following reboot successful:

iptables:flushing firewall rules: [OK]

Iptables:setting chains to Policy Accept:filter [OK]

iptables:unloading modules: [OK]

iptables:applying firewall rules: [OK]

Second, Oracle Software Installation

1. Start Oracle Installation

Locate the database after unpacking the package Runinstaller choose to open in the terminal, after the installation of the file check to install the graphical interface:

2. Configure Security Updates

Uncheck, do not receive security updates, then click "Next", Pop-up prompts window, select "Yes":

3. Choose installation option

3 installation options are available:

Creating and configuring Databases

Install only the database software

Upgrade an existing database

Here we select the first "Create and Configure Database" and click "Next":

4. Select System Class

Desktop class: If you want to install in a notebook or desktop class system, select this option, which includes starting the database and allowing minimum configuration.

Server class: Select this option to allow more advanced configuration options if you want to install in a server class system, such as what is used when Oracle is deployed in production data centers.

To be able to use more advanced configuration options, we select "Server Class" and click "Next":

5. Node selection

Single Instance database installation

Real Application Clusters Database installation

Select Single Instance database setup, and then click Next:

6. Choose the type of installation

Contains 2 options:

Typical installation: Perform a full Oracle database installation with a basic configuration

Advanced Installation: You can select advanced options, such as: use different passwords for SYS, Sysman, System, and DBSNMP accounts, select database character set, product language, automatic backup, custom install and standby storage options (such as automated storage management).

Select Advanced installation, and then click Next:

7. Select Product language

"Chinese" has been added by default and the "Simplified Chinese" is found in the left language list so we can access it remotely in the window system and add it to the right, then click "Next":

8. Select Database Version

Contains 3 options:

Enterprise Edition: Self-managed databases with scalability, high performance, high availability, and security capabilities to meet the needs of most high standards of mission-critical applications.

Standard Edition: Standard Edition is ideal for Workgroups, departments, and small and midsize enterprises seeking low-cost solutions.

Standard Version 1: Standard Version 1 is the ideal choice for Workgroups, departments, and small businesses looking for low-cost solutions.

Select Enterprise Edition, then click Next:

9. Specify the installation directory

To set the Oracle base directory as a new directory:/home/app/oracle, the software location is automatically:/home/app/oracle/product/11.2.0/dbhome_1, and then click "Next":

10. Create Product List

Set up a new directory for the Oracle manifest directory:/home/app/orainventory, select the group "Oinstall" and click "Next":

Current 1/2 page 12 Next read the full text