Installing Oracle under Linux [CentOS 6.5]

One, install the Oracle dependency package

# yum 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 UnixODBC unixodbc-devel-y

"Installation error can be installed individually"

Second, create users and user groups

# Groupadd Oinstall

# Groupadd DBA

# USERADD-G OINSTALL-G dba Oracle

# passwd Oracle

Iii. Creating the ORACLE11G installation directory

# mkdir-p/u01/11g

# Chown-r ORACLE:OINSTALL/U01/

# chmod 775/U01/

Iv. Modifying kernel parameters

#vim/etc/sysctl.conf

Add the following:

#use for Oracle

Kernel.shmall = 2097152

Kernel.shmmax = 2147483648

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 1024 65000

Net.core.rmem_default = 4194304

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048586

# sysctl-p #重新载入立即生效

V. Modifying environment variables

#vim ~oracle/.bash_profile

Add the following content

Export PATH

Export oracle_base=/u01/11g

Export Oracle_home= $ORACLE _base/product/11.2.0

Export oracle_sid=ora11g

Export path= $PATH: $HOME/bin: $ORACLE _home/bin

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

Vi. Setting Resource Limits

#vim/etc/security/limits.conf

Add the following content

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

Oracle Soft Stack 10240

Vii. Unzip the installation file

Unzip Linux.x64_11gR2_database_1of2.zip

"Link: http://down.51cto.com/data/2298433"

Unzip Linux.x64_11gR2_database_2of2.zip

"Link: http://down.51cto.com/data/2298433"

Eight, the interface of the installation

"Switch to Oracle user created earlier"

English Interface $ export lang=c

Chinese interface $ export Lang=zh_cn.utf-8

Chinese installation, there is garbled, the solution:

1, Mkdir-p/usr/share/fonts/zh_cn/truetype

2. Download Zysong.ttf font file

"Link: http://down.51cto.com/data/2298433"

3. Enter the character File transfer folder

CP zysong.ttf/usr/share/fonts/zh_cn/truetype/

First interface "Installation Options": Creating and selecting databases

Second interface "System class": Server tired

Third interface "Node selection": Sample Database Installation

Interface "Installation Type": Advanced installation

Interface "SELECT Product language": Default selection Simplified Chinese, English

Interface "SELECT Database Version": Enterprise level

Seventh interface "Specify installation Location": Set Oracle Base directory:/u01/11g/

Eighth interface "Create product List": Default

Nineth interface "Select Configuration Type": General purpose/Transaction processing

Tenth session "Specify database Identifier": The global database name is set to ora11g

11th interface "Specify configuration Options"

Memory: Default

Character set: Using Unicode

Security: Assert all new security settings

Example scenario: We recommend that you tick create a database with an example scenario

12th Interface "Specify Management options": Check the Database control

13th interface "Specify Database storage Options": Tick file system

14th interface "Specify reply Options": Automatic backup is not enabled

15th interface "Specify scheme password": Choose to use the same password for all accounts

16th Interface "Privileged operating system Group": Default

17th Interface "Perform prerequisite checks": tick Ignore All

18th Interface "Summary": Complete

Follow the prompts to enter the appropriate directory, execute the appropriate script "root permission"

# cd/u01/orainventory

#./orainstroot.sh

# cd/u01/11g/product/11.2.0/

#./root.sh

When the execution is complete, click OK

Oracle user logs on to Linux and executes the following command in the terminal:

Turn on Oracle snooping

$ lsnrctl Start

Enter Sqlplus

$ sqlplus/nolog

Sign in with the Sysdab role Sqlplus

Sql> Conn/as SYSDBA

Fourth step: Start the database

Sql> Startup

Close the database

Sql> shutdown is to wait for things to end before closing

Forcing the database to close

sql> Shutdown Abort

Installing Oracle under Linux [CentOS 6.5]