Installing Oracle under Linux [CentOS 6.5]

Source: Internet
Author: User
Tags dba sqlplus

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]

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.