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

Oracle installation

Http://www.cnblogs.com/gaojun/archive/2012/11/22/2783257.html

Http://www.jb51.net/article/53769.htm

Http://www.jb51.net/article/53769.htm

The above is for reference.

The above is where I refer to during installation.

Oracle download address, there are two files, download both

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

Memory requirements greater than 1G

2. Dependent package

Compat-libstdc++-33-3.2.3-61.i386.rpm

Compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm

Libaio-0.3.105-2.i386.rpm

Libaio-0.3.107-10.el6.x86_64.rpm

Libaio-devel-0.3.105-2.i386.rpm

Libaio-devel-0.3.105-2.x86_64.rpm

Libgcc-3.4.6-3.i386.zip

Libgcc-4.4.7-4.el6.x86_64.rpm

Libstdc++-3.4.6-11.i386.rpm

Libstdc++-devel-3.4.6-3.1.i386.rpm

Libstdc++-4.4.7-4.el6.x86_64.rpm

Pdksh-5.2.14-37.el5_8.1.x86_64.rpm-- downloaded from 51CTO

UnixODBC-2.2.11-7.1.i386.rpm

UnixODBC-2.2.11-7.1.x86_64.rpm

UnixODBC-devel-2.2.11-7.1.i386.rpm

UnixODBC-devel-2.2.11-7.1.x86_64.rpm

Gcc*

Ksh-20120801-10.el6.x86_64.rpm

Use yum install XX-nodeps-force to force installation when it cannot be installed

Yum groupinstall "Desktop"

Yum groupinstall "X Window System"

Yum groupinstall "KDE Desktop"

The installation of Oracle requires a graphical user interface, which must be installed, otherwise there will be no later interface and will not be able to operate.

All of the above are in the image. You can install it using yum. Later, you need to check the pksh. There is also this in the image. But when using yum to install, it is said that pksh and pdksh conflict with each other, so I will put the security in my image.

Take out the package and use rpm ivh pkshXXXXX.rpm-force-nodeps to force the installation, otherwise it will not be installed. But for dependent packages, different oracle versions and different systems may have different package requirements, but they are about the same. We can install these in advance and check what is missing later.

III. Environmental configuration

1. Create oracle installation users

Create an oinstall group

[root@tsp-rls-dbserver tmp] # groupadd oinstall

Create a dba group

[root@tsp-rls-dbserver tmp] # groupadd dba

Create a new user oracle and set its primary group to oinstall and secondary group to dba

[root@tsp-rls-dbserver tmp] # useradd-g oinstall-G dba oracle

View the ID information of the created user

[root@tsp-rls-dbserver tmp] # id oracle

Set the oracle user password

[root@tsp-rls-dbserver tmp] # passwd oracle

2. Set user environment variables

The Oracle software will be installed using the oracle user, and the home directory is / home/oracle;. If you install it in a custom path, you need to create a path and set its running permissions.

Modify the user environment variable file / home/oracle/.bash_profile and execute the command:

[root@tsp-rls-dbserver oracle] # vi / home/oracle/.bash_profile

Add the following information at the end of the file:

Export ORACLE_SID=ORATSP

Export ORACLE_BASE=/u01/app-this environment variable setting is very important

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

Export PATH=$PATH:$ORACLE_HOME/bin

Execute the source command to make the environment variable parameters take effect

[root@tsp-rls-dbserver oracle] # source / home/oracle/.bash_profile

View environment variable parameters command:

[root@tsp-rls-dbserver oracle] # env | more

Note: the path set here

First, use root to create mkdir / u01/app

B. Set up users and user groups chown oracle:oinstall / u01/app

C, the compressed package of oracle should be put under this path, and then decompressed

D, make sure that the disk space of this path is large enough, if it is too small, the installation will report an error. It is about 20g, and a few gigabytes will definitely not work.

2. Modify the system kernel and environment parameters

Modify kernel parameters

Execute the following command to modify the configuration file / etc/sysctl.conf

[root@tsp-rls-dbserver oracle] # vi / etc/sysctl.conf

Add the following information at the end of the file:

Fs.file-max= 6815744

Fs.aio-max-nr=1048576

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.sem= 250 32000 100 128

Note: kernel.shmmax and kernel.shmmax parameters should be kept unchanged and can be appropriately adjusted if necessary.

Execute the command sysctl to make the kernel parameters take effect:

[root@tsp-rls-dbserver oracle] # sysctl-p

Modify number of processes and maximum sessions

Execute the following command to modify the configuration file / etc/security/limits.conf

[root@tsp-rls-dbserver oracle] # vi / etc/security/limits.conf

Add the following information at the end of the file:

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Set association information

Execute the following command to modify the associated file / etc/pam.d/login

[root@tsp-rls-dbserver oracle] # vi / etc/pam.d/login

Add the following information at the end of the file:

Session required pam_limits.so

Modify system startup environment parameters

Execute the following command to modify the system startup environment parameter file / etc/ profile

[root@tsp-rls-dbserver oracle] # vi / etc/profile

Add the following information at the end of the file:

If [$USER = "oracle"]; then

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

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

Modify host resolution information

Execute command, modify / etc/hosts file

[root@tsp-rls-dbserver ~] # vi / etc/hosts

Add the following information at the end of the file:

192.168.211.128 tsp-rls-dbserver

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.