Oracle 11g Data installation process based on minimized CENTOS6.6 installation!

Linux Environment configuration

Os:centos 6.6

Db:oracle 11gR2

Installing Oracle into the Home/oracle directory

Configuration process: This article is from Oracle official documents + Online materials

Oracle Official Document: Http://www.oracle.com/pls/db112/homepage

1. Log in to the Linux root user

2. Check the machine hardware requirements

2.1 Memory requirements

Requires at least 1GB of memory
View Machine Memory Size
# grep Memtotal/proc/meminfo
Swap space Adjustment
Swapoff-v/dev/volgroup00/logvol01
lvresize-l +1024m/dev/volgroup00/logvol01 (lvextend-l +1024m/dev/volgroup00/logvol01 can also, and must ensure that the The volume group has a considerable capacity size of free pe/size)
Mkswap/dev/volgroup00/logvol01
Swapon-va
Free-m (see what happens after the swap is expanded)

2.2 Swap space requirements

Memory Size Swap Space size
1 GB ~ 2 GB Memory Size *1.5
2 GB ~ GB Memory Size
< GB
View swap space size
grep swaptotal/proc/meminfo

3. Check the operating system software requirements

Oracle's official documentation contains requirements for multiple Linux systems, please refer to the official documentation for details

The list of software requirements (RHEL6. x) is as follows: need to install desktop environment

#检查软件包

Yum-y Install binutils-2.20.51.0.2-5.11.el6 compat-libcap1-1.10-1 compat-libstdc++-33-3.2.3-69.el6 compat-lib     stdc++-33-3.2.3-69.el6.i686 gcc-4.4.4-13.el6 gcc-c++-4.4.4-13.el6 glibc-2.12-1.7.el6 glibc-2.12-1.7.el6 Glibc-devel-2.12-1.7.el6 glibc-devel-2.12-1.7.el6.i686 libgcc-4.4.4-13.el6 libgcc-4.4.4-13.el6 libstdc++- 4.4.4-13.el6 libstdc++-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6 libstdc++-devel-4.4.4-13.el6.i686 Libaio -0.3.107-10.el6 libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6 libaio-devel-0.3.107-10.el6.i686 make-3 .81-19.el6 Sysstat-9.0.4-11.el6

See if the package is installed on the system
# rpm-q Package_name

#安装开发包

Yum-y install NTP make OpenSSL openssl-devel pcre pcre-devel libpng libpng-devel libjpeg-6b libjpeg-devel-6b freetype fre Etype-devel gd gd-devel zlib zlib-devel gcc gcc-c++ libxpm libxpm-devel ncurses ncurses-devel libmcrypt libmcrypt-devel li BXML2 libxml2-devel imake autoconf automake screen sysstat compat-libstdc++-33 Curl Curl-devel elfutils-libelf-devel.x86 _64

#安装桌面环境 (later with graphical installation)

Yum groupinstall-y "desktop" "Desktop Platform" "Desktop Platform Development" "Fonts" "General Purpose Desktop" "Graphical administration Tools" "Graphics Creation Tools" "Input Methods" "X Window System" "Chinese support [zh]" " Internet Browser "

Yum-y Install Xorg-x11-drivers

Yum-y Install Unzip

4. Create the system groups and users required to install Oracle

Create an Oracle Inventory group
Groupadd Oinstall
Create a OSDBA Group
Groupadd dba
Creating Oracle Software Creators
USERADD-G oinstall-g dba Oracle
To modify the password for an Oracle user
passwd Oracle

5. Configure system kernel parameter values

Edit/etc/sysctl.conf File
Vim/etc/sysctl.conf
At the bottom of the open file, add the following:
FS.AIO-MAX-NR = 1048576
Fs.file-max = 6815744
Kernel.shmall = 2097152
Kernel.shmmax = 536870912
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 = 1048586
Change the current system kernel parameter value (let/etc/sysctl.conf take effect immediately)
# sysctl-p

6. Check Oracle Installation User (Oracle) resource limits

Modify the/etc/security/limits.conf file  
vim /etc/security/limits.conf  
Add the following content at the bottom of the open file  
oracle               soft    nproc   2047  
oracle              hard     nproc   16384  
oracle               soft    nofile  1024  
oracle               hard    nofile  65536  
oracle               soft    stack   10240  

7. Create the directory required to install the Oracle software

Mkdir-p/u01/app/
Chown-r oracle:oinstall/u01/app/
Chmod-r 775/u01/app/

8. Configure the environment where Oracle installation User (Oracle) is installed

Edit/home/oracle/.bash_profile
Vim/home/oracle/.bash_profile
Add the following to the open file
Umask 022
Export Oracle_base=/u01/app
Export Oracle_home= $ORACLE _base/oracle/product/11.2.0/db_1
Export ORACLE_SID=ORCL--oracle Instance name, can be modified
Export path= $PATH: home/bin: $ORACLE _home/bin

Make bash settings take effect

$ . ./.bash_profile

Edit/etc/pam.d/login
Vim/etc/pam.d/login
Add the following to the open file
Session required/lib/security/pam_limits.so
Session Required Pam_limits.so

Edit/etc/profile
Vim/etc/profile
Add the following to the open file
if [$USER = "Oracle" ]; Then
if [$SHELL = "/bin/ksh" ]; Then
Ulimit-p 16384
ulimit-n 65536 Else
Ulimit-u 16384-n 65536
Fi
Fi

9. See if the system supports the graphical interface

See if the display variable is set under root user
# echo $DISPLAY
If a value appears, the display variable is set, otherwise you will need to manually set the display

Garbled and prsv-00002 problems

Set into English interface

Export lang=en. US. UTF-8

Window resolution increases 1024x768

To modify the hostname of the host file

10. Start Installing Oracle Software

# cd/tmp
# Unzip Linux_11gr2_database_1of2.zip Linux_11gr2_database_2of2.zip
# Xhost +
# su-oracle
$ Export display=:0
$ cd/database
$./runinstaller
The system will then launch the Oracle graphical installation interface, which is the same as the installation process under Windows

During the installation process, you will be prompted to run two script files under the root user (specifically, which two, do not remember, follow the instructions).

11. Basic use After installation

Oracle under Linux is in a running state after installation is complete. After restarting the machine, Oracle does not add Oracle to the Windows service as it did under Windows, and the Orcle service needs to be started manually under Linux

Under Oracle User, execute the following command
Enter Sqlplus
$ sqlplus/nolog
Connect to the database as SYSDBA and start the Oracle database engine
sql< Conn/ as SYSDBA
sql< Startup
Exit Sqlplus, Run listener
sql< exit
$ lsnrctl Start

This makes it possible to connect to the Oracle database. If you want to manage Oracle with the EM provided by Oracle, you also need to start the EM console and run the following command:

$ emctl Start Dbconsole

This allows the EM console to be accessed via http://localhost:1158/em/.

Make

Add the file to the boot boot

[C-sharp]View plaincopy

1. # chmod 755/ETC/RC.D/INIT.D/ORADB

2. # chkconfig--add oradb

Restart Service

[C-sharp]View plaincopy

1. # Service ORADB Stop

2. # service ORADB Start

The next time the machine is started, the Oracle service will start with the machine.

Oracle database installation, configuration complete.

Default port number for the Tip:oracle database: The default port number for the 1521,oracle provided by the EM Manager is 1158.

This article is from the "Stupid Life" blog, make sure to keep this source http://chuanrensheng.blog.51cto.com/159174/1600946

Oracle 11g Data installation process based on minimized CENTOS6.6 installation!