Install Oracle11GR2 database in RedHat6

OracleDatabase, also known as OracleRDBMS, or Oracle for short. It is a relational database management system of oracle. Currently, it still occupies a major share in the database market

Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of oracle. Currently, it still occupies a major share in the database market

Oracle Database, also known as Oracle RDBMS, or Oracle for short. Is a relationship between OracleDatabaseManagement System. It still occupies a major share in the database market. Lawrence herison and his friends, former colleagues Bob Miner and Ed Oates established the Software Development lab Consulting Company (SDL, Software Development Lab) in 1977)

Oracle Database 11 GB (built on the unique grid computing capability of Oracle) enables Oracle customers to respond quickly to changing business conditions, gain competitive advantages through technological innovation, and reduce costs.

With Oracle Database 11 GB, you can:

Use Real Application Testing to make new technologies faster

Advanced Oracle data compression and Partitioning technologies (Partitioning) allow you to manage more data with less storage space

Use Oracle SecureFiles to store all data in the Oracle database to simplify the system

Use Oracle Active Data Guard to maximize ROI for disaster recovery

Automated Management enables key personnel to focus on strategic tasks

And so on ..

Deploying Oracle on Linux

We use RedHat Enterprise Edition as the Oracle operating system. The latest version is 6.1. You can choose 32-bit or 64-bit Linux based on the CPU architecture. Generally, the 64-bit version can manage larger memory and hard disk space, it should be the first choice for enterprise applications.

Oracle 11g R2 database installation hardware configuration requirements:

At least 1 GB of memory is required.

The Enterprise Edition requires 3.95 GB of hard disk space and at least 1.7 GB of space to store data files.

Based on the system memory size, you need to properly set the swap partition size: When the memory is-m, the swap partition size should be twice the memory size;-2g, the swap partition size should be 1.5 times the memory size; 2-8 GB, the swap partition size is the same as the memory; 8 GB or above, the swap partition is 0.75 times the memory size. In addition, you need to reserve about 10 GB of hard disk space for the operating system. We recommend that you have at least 20 GB of space remaining for the hard disk space.

Install RedHat in accordance with the graphical Installation Wizard (requires more than 1 GB of memory), pay special attention to the following points during the installation process:

Select English as the Display language. Do not select Chinese as the English language to avoid garbled characters in the subsequent Oracle Installation Wizard.

Select custom installation, and make sure that the tools in "compatibility libraries", "Java Platform", and "Development" are selected,

Check "compatibility libraries" to ensure that most of the software packages required for Oracle Installation and work are installed. Otherwise, some Link errors may occur during Oracle Installation, such as ins_ctx.mk error. Now you can go to the Oracle official site to download the Oracle database package. At the same time, we need to modify some Redhat configuration files.

Set static IP

To install an Oracle machine, you need to configure a static IP address. You can use the following command to set it:

# System-config-network

This step is very important. If DHCP is assigned a dynamic IP address to the machine, the Oracle service (such as the listener) cannot be started.

Modify Kernel Parameters

Edit/etc/sysctl. conf and make the following changes:

# Controls the maximum shared segment size, in bytes # kernel. shmmax = 68719476736 # Controls the maximum number of shared memory segments, in pages # kernel. shmall = 4294967296kernel. shmall = 2097152kernel. shmmax = 536670912kernel. shmmni = 4096kernel. sem = 250 32000 100 FS. file-max = 6553600net. ipv4.ip _ local_port_range = 1024 65000net. core. rmem_default = 4192134net. core. wmem_default = 262144net. core. rmem_max = 4192134net. core. wmem_max= 262144

After saving, run:

# Sysctl-p

To make the parameter take effect.

If you are in trouble, a script for modifying kernel parameters will be generated during Oracle Installation and you will be prompted to run the script.