Shulou(Shulou.com)06/01 Report--

First, 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 errors can be installed one by one]

Second, create users and user groups

# groupadd oinstall

# groupadd dba

# useradd-g oinstall-G dba oracle

# passwd oracle

Create an oracle11g installation directory

# mkdir-p / u01amp 11g

# chown-R oracle:oinstall / u01 /

# chmod 775 / u01/

Fourth, modify kernel parameters

# vim / etc/sysctl.conf

Comment out the original data

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 # the reload takes effect immediately

Fifth, modify environmental variables

# vim ~ oracle/.bash_profile

Add the following

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 restrictions

# vim / etc/security/limits.conf

Add the following

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft stack 10240

7. Extract 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]

VIII. Interface installation

[switch to the oracle user created earlier]

English interface $export LANG=C

Chinese interface $export LANG=zh_CN.utf-8

When installing in Chinese, there is garbled code, 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/

Installation: enter the decompressed folder

$cd database/

$. / runInstaller

First interface [installation options]: create and select databases

Second interface [system class]: server tired

Third interface [node selection]: sample database installation

Fourth interface [installation type]: advanced installation

The fifth interface [Select product language]: choose simplified Chinese or English by default

Sixth interface [choose database version]: enterprise level

Seventh interface [specify installation location]: set oracle benchmark directory: / u01/11g/

Eighth interface [create product list]: default

Ninth interface [Select configuration type]: general purpose / transaction processing

Tenth face [specify database identifier]: global database name is set to ora11g

Eleventh interface [specify configuration options]

Memory: default

Character sets: using Unicode

Security: asserting all new security settings

Example scheme: it is recommended to check to create a database with an example scheme

12th interface [specify management options]: check to use database control to manage database

13th interface [specify database storage options]: check the file system

14th interface [specify reply options]: automatic backup is not enabled

Interface 15 [specify Scheme password]: choose to use the same password for all accounts

Sixteenth interface [privileged operating system group]: default

Seventeenth interface [perform prerequisite check]: check ignore all

18th interface [summary]: completed

Follow the prompts to enter the appropriate directory and execute the script [root permissions]

# cd / u01/oraInventory

#. / orainstRoot.sh

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

#. / root.sh

When the execution is complete, click OK

The oracle user logs in to Linux and executes the following command in the terminal:

Turn on Oracle snooping

$lsnrctl start

Enter sqlplus

$sqlplus / nolog

Log in to sqlplus using the sysdab role

SQL > conn / as sysdba

Step 4: start the database

SQL > startup

Shut down the database

SQL > shutdown is to wait for things to end before closing.

Force database shutdown

SQL > shutdown abort

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.