Installing Oracle 10g R2 under CentOS 6.3 (X86_32)

First, hardware requirements

1. Memory & Swap

Minimum:1 GB of RAM
Recommended:2 GB of RAM or more

Check memory condition # grep memtotal/proc/meminfo# grep swaptotal/proc/meminfo

2. HDD

Since the CentOS installation is almost 4~5g, plus Oracle and so on, please prepare at least 10G of hard disk space.

Check disk condition # Df-h

Second, the software

System Platform: CentOS 6.3 (x32)

Centos-6.3-i386-bin-dvd1.iso

Oracle Version: Oracle 10g R2

10201_database_linux32.zip

Third, System installation note

Installation of the system must be installed in desktop mode, or you cannot install Oracle, also do not open Selinux,oracle official does not recommend the use of Selinux,centos firewall also temporarily shut down, reduce the trouble of installation. In order to prevent garbled in the Oracle installation process, it is recommended to use English as the system language for Oracle installation.

The system commands described in this article, without special markings, are "#" for root Privileges and "$" for Oracle permissions.

Iv. System Readiness prior to Oracle installation

First, please log in as the root account for some pre-set jobs.

1. Turn off the firewall and disable SELinux

# Setup

# Vi/etc/selinux/config

Modify the selinux=disabled, and then restart.
If you do not want to restart the system, use the command Setenforce 0

2. Install dependent packages

installation packages required by Oracle's official documentation:

To see if an Oracle-related package is installed:

Install the required packages in Yum mode:

# yum-y Install binutils compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc.i686 glibc-common glibc-devel glibc-devel.i686 glibc-headers ksh libaio libaio.i686 libaio-devel libaio-devel.i686 libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel make Sysstat

Finally need to install LIBXP This library, this must be installed, otherwise install Oracle will appear Java Exception.

# yum Install Libxp

3. Create Oracle Users and Groups

Only the single-host environment is discussed here, regardless of the configuration of the RAC environment.

Execute the following instructions to add the users and groups required for Oracle installation.

(1) Create Group Oinstall
# Groupadd Oinstall

(2) Create a group DBA
# Groupadd DBA

(3) Add user Oracle and add it to Oinstall and DBA Group
# useradd-m-G oinstall-g dba Oracle

(4) test if Oracle account is established
# ID Oracle

(5) Create a new Oracle password
# passwd Oracle

4. Add Oracle users to the sudo group

# vi/etc/sudoers
Find root all= (all) all this line, and then join at the bottom
Oracle All= (All) all
Enter wq! (because this is a read-only document so you need to add!) and press ENTER

5, configure the system kernel parameters

# vi/etc/sysctl.conf

and enter the following:

Kernel.shmall = 2097152//Indicates the total amount of shared memory (in pages) that the system can use at one time. The default value is 2097152 and usually does not need to be modified
Kernel.shmmax = 2147483648//Defines the maximum size, in bytes, of a shared memory segment. The default is 32M, which is too low for Oracle, usually set to 2G
Kernel.shmmni = 4096//is used to set the maximum number of shared memory segments in the system range. The default value for this parameter is 4096. Usually do not need to change
Kernel.sem = 250 32000 100 128//indicates the amount of semaphore set
Net.ipv4.ip_local_port_range = 1024 65000
NET.CORE.RMEM_DEFAULT=4194304//default Receive window size
Maximum size of the net.core.rmem_max=4194304//Receive Window
NET.CORE.WMEM_DEFAULT=262144//Default Send window Size
net.core.wmem_max=262144//maximum size of the sending window

There will be some duplicates of the current parameters, which are modified to provide on the file.

When you're done editing, save and then execute:

# sysctl–p

Enable the changes that you just made.

6. Edit/etc/security/limits.conf

# vi/etc/security/limits.conf
Add the following four lines
Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536

7. Edit/etc/pam.d/login

# Vi/etc/pam.d/login
Session required/lib/security/pam_limits.so
Session Required Pam_limits.so

8, modify the/etc/profile

# Vi/etc/profile

Add the following code to the profile file.

if [$USER = "Oracle"]; Then    if [$SHELL = "/bin/ksh"], then        ulimit-p 16384        ulimit-n 65536    else        ulimit-u 16384-n 65536    

9. Modify Linux distribution Information

Because CentOS 6 was not released when the Oracle 10g was released, Oracle 10g did not confirm support for CentOS 6 and needed to modify the file to support CentOS 6 for Oracle 10g. We need to manually modify the Linux release notes so that Oracle 10g supports CentOS 6. Edit/etc/redhat-release File # Vi/etc/redhat-release To change the contents of CentOS release 6.3 (Final) to Redhat 4

10. Create an Oracle installation folder and a data storage folder

#mkdir/opt/oracle
#mkdir/opt/oracle/102
#chown-R oracle:dba/opt/oracle

11. Configure the Linux hostCheck the/etc/hosts file for localhost records (point to 127.0.0.1), if not, there will be some problems in configuring the Oracle monitoring later, so that the monitoring can not be started, this record can be manually added here.

The first phase is complete, then, after completing these settings, please log out of the root account and log in to the system again with the Oracle account.

12. Configuring Oracle User Environment variables

$ cd/home/oracle
$ VI. bash_profile
Modify and add the following content

Oracle_base=/opt/oracle//The Oracle installation folder created above
Oracle_home= $ORACLE _base/102
Oracle_sid=orcl
Ld_library_path= $ORACLE _home/lib
Path= $PATH: $ORACLE _home/bin: $HOME/bin

Export oracle_base oracle_home oracle_sid ld_library_path PATH

After saving, use the following command to make the settings effective:

$ source/home/oracle/.bash_profile

V. Install Oracle and set up the settings

1. Unzip the installation file

Put the downloaded 10201_database_linux32.zip to the folder where Oracle will be installed/opt/oracle
Go back to terminal mode and go to the Oracle folder:

$ cd/opt/oracle

Decompression 10201_database_linux32.zip

$ unzip 10201_database_linux32.zip

You will then see a series of decompression actions.

Unzip the folder that you see the database in the same folder, go to the database folder:

$ CD Database

Prepare to perform database installation, if your CentOS is a Chinese environment, the installation will appear in Chinese garbled, please follow the following instructions

$ Export Lang=en_us

Then execute

$./runinstaller

If you are unable to see the installation interface, run the following command using the root account before running Setup: # Export display=:0.0
# Xhost +
$./runinstaller

Start the Setup program.

Since the relevant predecessor job has been done before, in this step you only need to select the UNIX DBA group as the DBA and the database password shared by the system and other accounts. Then select Next.

Similarly, select the group as a DBA group and press Next

In this step, click Checking Network Configuration requirements as user verified, and then press Next

The Install Summary screen appears at the end, and the installation is started as soon as the Install button is pressed.

Installation process ...

Database Setup Assistant, you can choose Password management for password modification, if you do not need to modify, just press the OK button.

The following setup scripts appear before the installation is complete:

Open a new terminal, Su to root.

The two-paragraph script that is required to execute is executed sequentially.

/opt/oracle/orainventory/orainstroot.sh
/opt/oracle/102/root.sh

The execution screen is as follows.
When you are done, go back to the installation window and press OK to complete all Oracle installations. The following screen appears when the installation is complete.

At this point, you can use the above URL as a test, the login number can be SYS or system
Http://CentOS-Oracle:5560/isqlplus
Http://CentOS-Oracle:5560/isqlplus/dba
Http://CentOS-Oracle:1158/em

Execute a query statement test

All of the above images have been successfully installed on behalf of Oracle.

However, because Oracle is not installed as a service in a Linux environment, it does not automatically start the server every time Linux is started, so there are some settings that need to be set up to start automatically and will be available in the next file.

Installing Oracle 10g R2 under CentOS 6.3 (x86_64)

Http://www.cnblogs.com/mchina/archive/2013/03/08/2934473.html

Linux Oracle Services Start & Stop scripts and boot from boot

Http://www.cnblogs.com/mchina/archive/2012/11/27/2782993.html

David Camp

• Technical Exchange, please add QQ Group:

System operation and Maintenance technology share: 315871865

• For business cooperation, please contact the author qq:562866602
• My number: Mchina_tang
• Write to me: [email protected]
• My address: Jiangsu/Suzhou

we always believe that sharing is a virtue | We believe, great people Share knowledge ...

Http://www.cnblogs.com/mchina/archive/2012/11/06/2737472.html

Installing Oracle 10g R2 under CentOS 6.3 (X86_32)