Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to install single-instance database Oracle 11G". In daily operation, I believe many people have doubts about how to install single-instance database Oracle 11G. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to install single-instance database Oracle 11G". Next, please follow the editor to study!

1. Introduction 1.1 purpose of the document

This manual can provide reference for system installers, implementers and administrators. In particular, the installer can refer to this document and install it according to the actual situation.

1.2 document users

The main users of this manual are system installers, implementers and administrators.

two。 Installation Notes 2.1 requirements description

According to the system planning, the system needs to install the database service and the application service to different servers, that is, the application is separated from the database machine.

2.2 Database server environment 2.2.1 hardware environment

Model: virtual machine

CPU: 2 core

Memory: 2G

Hard disk: 100g

2.2.2 Software environment

Operating system: RHEL6.5

Installation media: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit

Jdk1_6_0_29 64 bit

IP address: 192.168.8.111

2.3 Application server environment 2.3.1 hardware environment

Model: virtual machine

CPU:2 kernel

Memory: 2G

Hard disk: 100g

2.3.2 Software environment

Operating system: RHEL6.5

Installation media: jdk1_6_0_29 64 bit

Weblogic10.3.6

Zookeeper-3.4.6

IP address: 192.168.8.112

3 check configuration requirements 3.1 check / tmp directory space size description:

At least 1G of / tmp directory space is required.

Check the command:

# df-h/tmp

3.2 check the operating system

# cat / proc/version

# #

Prepare the media

Using the ftp tool, upload the installation media linux.x64_11gR2_database_1of2 and linux.x64_11gR2_database_2of2.zip to the server's directory / app/software/.

Create a directory / app/software to store the software required for installation

# mkdir-p / app/software

Ftp uploads files

And decompression

# #

Install jdk

Execute after empowerment. /

Check the JDK version

# java-version

Note: the jdk version must be 64-bit and above. If you are not satisfied, you need to reinstall JDK. To install JDK, please refer to

4. Database server configuration 4.1Hosts file configuration

Log in as a root user, and append the following text to the hosts file

Vi / etc/hosts

:: 1 localhost hq-tmpsdb01

10.80.36.143 hq-tmpsdb01

Note: hq-tmpsdb01 is the host and hostname is the host

127.0.0.1 localhost hq-tmpsdb01

4.2 system parameter adjustment

Log in to the system as the root user. Edit the / etc/sysctl.conf file and append the following.

Command: vi / etc/sysctl.conf

Kernel.sem = 250 32000 100 142

Kernel.shmall = 4294967296

Kernel.shmmax = 68719476736

Kernel.shmmni = 4096

Kernel.msgmax = 8192

Kernel.msgmnb = 65535

Kernel.msgmni = 2878

Fs.file-max = 6815744

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 4621440

Net.core.rmem_max = 4621440

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Fs.aio-max-nr = 1048576

Modprobe bridge

Lsmod | grep bridge

The installation directory of DB:

$mkdir-p / app1/oracle

Change of ownership

Oracle user, authorize the directory:

$chmod-R 755 / app1/oracle

/ app1 shared storage, later system recovery and other operations need to be in the app1 directory

5.4 Edit environment variabl

Change the. bash_profile file of the oracle user

Vi .bash _ profile

Umask 022

TMP=/tmp

TMPDIR=$TMP

Export TMP TMPDIR

ORACLE_SID=SUNTX

ORACLE_BASE=/app1/oracle

Export ORACLE_SID ORACLE_BASE

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Configuration of environment variables after java installation

Vi / etc/profile

Copy the following to the end of this file, then log out and log back in.

JAVA_HOME=/usr/java/jdk1.6.0_29

CLASSPATH=.:$JAVA_HOME/lib/tools.jar

PATH=$JAVA_HOME/bin:$PATH

Export JAVA_HOME CLASSPATH PATH

5.5Test graphical interface (VNC can be used)

Fill in / usr/bin/xterm-ls-display $DISPLAY at the command as shown below:

Click run if the following figure shows that x11 components are missing, you can install them.

Root executes # yum install xterm

After installation, execute it in the following window and go to the / app/software/datebase directory

Just execute. / runInstaller

The installation process is shown in the following figure

Warnings about small packages related to pdksh sometimes appear during installation

Workaround install pdksh

[root@hq-tmpsdb01 software] # rpm-ivh pdksh-5.2.14-30.x86_64.rpm

Warning: pdksh-5.2.14-30.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 73307de6: NOKEY

Error: Failed dependencies:

Pdksh conflicts with ksh-20120801-10.el6.x86_64

At this time, the conflict broke out again.

Then uninstall ksh

Rpm-e ksh-20120801-10.el6.x86_64

And then

Rpm-ivh pdksh-5.2.14-30.x86_64.rpm

Can

Modify the oracle user environment variable and add it to the last

Vi .bash _ profile

PATH=/usr/sbin:$PATH

PATH=$ORACLE_HOME/bin:$PATH

Export PATH

Export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

At this point, the study on "how to install single instance database Oracle 11G" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.