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

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip?AuthParam=1479527366_c5c6af19e54f7eed218aafe6914b194e (download address)

Do not have less than 2G of memory during installation

1. Log in to the operating system using the root user

2. Yum installs unzip software to extract the uploaded Oracle installation files.

[root@CentOS ~] # yum install unzip-y

3. Extract the Oracle installer

[root@CentOS ~] # cd / tmp

[root@CentOS tmp] # unzip linux.x64_11gR2_database_1of2.zip & & unzip linux.x64_11gR2_database_2of2.zip

(here are two packages, both 1 and 2 need to be downloaded)

4. Yum installs vim software for editing configuration files (personal habits, do not install vim, you can also use vi).

[root@CentOS tmp] # yum install vim-y

5. Add the hostname to the / etc/hosts file

[root@CentOS tmp] # vim / etc/hosts

Add 192.168.206.135 CentOS

6. Close selinux

[root@CentOS tmp] # vim / etc/selinux/config

Set up SELINUX=disabled

[root@CentOS tmp] # setenforce 0

7. Turn off the firewall

[root@CentOS tmp] # service iptables stop

8. Install the Oracle 11g dependency package

[root@CentOS tmp] # yum install-y binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel make numactl sysstat libXp unixODBC unixODBC-devel-y

9. Add installation users and user groups

[root@CentOS tmp] # groupadd oinstall

[root@CentOS tmp] # groupadd dba

[root@CentOS tmp] # useradd-g oinstall-G dba oracle

[root@CentOS tmp] # passwd oracle

[root@CentOS tmp] # id oracle

Uid=1001 (oracle) gid=1001 (oinstall) group = 1001 (oinstall), 1002 (dba)

10. Modify kernel parameter configuration file

[root@CentOS ~] # vim / etc/sysctl.conf

Add the following

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Kernel.shmall = 2097152

Kernel.shmmax = 1073741824

[root@CentOS] # sysctl-p

Where kernel.shmmax = 1073741824 is half of the native physical memory (2G) in byte.

There will be a mistake:

11. Modify the user's restriction file

[root@CentOS ~] # 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

Modify the / etc/pam.d/login file:

[root@CentOS ~] # vim / etc/pam.d/login

Add the following:

Session required / lib64/security/pam_limits.so

Session required pam_limits.so

Modify the / etc/profile file:

[root@CentOS ~] # vim / etc/profile

Add the following:

If [$USER = "oracle"]; then

If [$SHELL = "/ bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

twelve。 Create installation directory and set file permissions

[root@CentOS] # mkdir-p / u01/app/oracle/product/11.2.0

[root@CentOS ~] # mkdir / u01/app/oracle/oradata

[root@CentOS ~] # mkdir / u01/app/oracle/inventory

[root@CentOS ~] # mkdir / u01/app/oracle/flash_recovery_area

[root@CentOS] # chown-R oracle:oinstall / u01/app/oracle

[root@CentOS] # chmod-R 775 / u01/app/oracle

13. Set oracle user environment variables

[root@CentOS ~] # su-oracle

[oracle@CentOS ~] $vim .bash _ profile

Add the following:

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/11.2.0

ORACLE_SID=orcl

PATH=$PATH:$ORACLE_HOME/bin

Export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

[root@oracle11g ~] # xhost +

Access control disabled, clients can connect from any host

[root@oracle11g ~] # su-oracle

[oracle@oracle11g ~] $unzip linux.x64_11gR2_database_1of2.zip

[oracle@oracle11g ~] $unzip linux.x64_11gR2_database_2of2.zip

[oracle@oracle11g ~] $cd database/

[oracle@oracle11g database] $. / runInstaller

Here, you need to run. / runlnstaller under the graphical interface installation, or you will make an error.

Note that there will be an error in. / runInstaller. You need to install yum groupinstall "KDE Desktop" and restart the server under the graphics boundary.

[root@oracle11g ~] # sh / u01/oraInventory/orainstRoot.sh

Execute / u01 / script with a root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= / u01/oracle/product/11.2.0.1/db_1

Enter the full pathname of the local bin directory: [/ usr/local/bin]:

Copying dbhome to / usr/local/bin...

Copying oraenv to / usr/local/bin...

Copying coraenv to / usr/local/bin...

Creating / etc/oratab file...

Entries will be added to the / etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

. Log in to oracle database

[oracle@oracle11g database] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 12 23:22:35 2016

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > select * from dual

D

-

X

SQL > select instance_name from v$instance

INSTANCE_NAME

-

Orac11g

SQL >

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.