Linux Installation Oracle 11g

Source: Internet
Author: User

Installation Environment

Linux server: SuSe10 SP2 64-bit

Oracle Server: ORACLE11GR2 64-bit

System Requirements
    1. Linux Installation Oracle System requirements

System Requirements

Description

Memory

Must be higher than 1G of physical memory

Swap space

Typically twice times the memory, for example: 1G of memory can be set to swap partition 3G size

Hard disk

Above 5G

2. Modifying operating system core parameters

Under root user, perform the following steps:

1 Modify the user's shell limit, modify the/etc/security/limits.conf file

Input command: VI /etc/security/limits.conf, press i key to enter the editing mode, the following content to join the file.

Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536

When you are finished editing, press ESC Key, enter " : Wq " Save to exit

2) Modify the/etc/pam.d/login file, enter the command: Vi/etc/pam.d/login, Press the I key to enter the editing mode, the following content to join the file.

Session required/lib/security/pam_limits.so
Session Required Pam_limits.so

When you are finished editing, press ESC Key, enter " : Wq " Save to exit

3 ) Modify Linux kernel, modify the/etc/sysctl.conf file, enter the command: vi/etc/sysctl.conf, Press the I key to enter the editing mode, add the following content to the file

Fs.file-max = 6815744
FS.AIO-MAX-NR = 1048576
Kernel.shmall = 2097152
Kernel.shmmax = 2147483648
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Net.ipv4.ip_local_port_range = 9000 65500
Net.core.rmem_default = 4194304
Net.core.rmem_max = 4194304
Net.core.wmem_default = 262144
Net.core.wmem_max = 1048576

When you are finished editing, press ESC Key, enter " : Wq " Save to exit

4 to make the/etc/sysctl.conf change take effect immediately, execute the following command. Input: Sysctl-p display as follows:

linux:~ # sysctl-p

< strong>net.ipv4.icmp_echo_ignore_broadcasts = 1

Net.ipv4.conf.all.rp_filter = 1

Fs.file-max = 6815744

FS.AIO-MAX-NR = 1048576

Kernel.shmall = 2097152

Kernel.shmmax = 2147483648

Kernel.shmmni = 4096

Kernel.sem = 32000

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 4194304

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

5) Edit/etc/profile, enter the command: Vi/etc/profile, Press the I key to enter the editing mode, the following content to join 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

When you are finished editing, press ESC Key, enter " : Wq " Save to exit

6 create related users and groups as the owner of the software installation and Support group.

To create a user, enter a command:

Groupadd Oinstall
Groupadd dba

To create an Oracle user and password, enter the command:

USERADD-G oinstall-g dba-m Oracle

passwd Oracle

Then will let you enter the password, the password any input 2 times, but must be consistent, enter the confirmation

7 CREATE database software directory and data file directory, directory location, according to their own situation, pay attention to disk space, here I put it under the Oracle user, for example:

Enter the command:

Mkdir/home/oracle/app

Mkdir/home/oracle/app/oracle

Mkdir/home/oracle/app/oradata

mkdir/home/oracle/app/oracle/ Product

8) Change Directory owner is owned by Oracle user, enter command:

Chown-r Oracle:oinstall/home/oracle/app

9) Configure environment variables for Oracle users, first, switch to the newly created Oracle user,

Input: Su–oracle, and then directly in the input: Vi. bash_profile

Press I to edit. Bash_profile, enter edit mode to add the following:

Umask 022

Export Oracle_base=/home/oracle/app

Export Oracle_home= $ORACLE _base/oracle/product/11.2.0/dbhome_1

Export ORACLE_SID=ORCL

Export path= $PATH: $HOME/bin: $ORACLE _home/bin

Export Ld_library_path= $ORACLE _home/lib:/usr/lib

When you are finished editing, press ESC Key, enter " : Wq " Save to exit

installation Process

1) When the above system requires that the operation is complete, log off the system and log in with the Oracle user on the graphical interface. First copy the downloaded Oracle installation package to Linux, and we recommend copying it with Xmanager or other FTP tools.

Open a terminal and run the unzip command to extract the Oracle installation files, such as:

Enter the command:

Unzip Linux.x64_11gR2_database_1of2.zip

Unzip Linux.x64_11gR2_database_2of2.zip

After the decompression is complete, the CD enters its extracted directory.

Enter the command:

CD Database

Use the LS command to view the files contained in the extracted database, such as:

2) perform the installation, enter the command:./runinstaller

In This step, you can see that you can see a lot of rpm Package No, we can install Linux from the CD or ISO to find the missing package, use the FTP upload to Linux and then use the RPM–IVH xxx.rpm--nodeps–force to install it (plus--nodeps- force represents a mandatory installation, which is directly using the RPM–IVH xxx.rpm installation is not successful in the case of the installation process slightly.

Wait until the package is all installed, and again in the Oracle graphical interface, perform the installation process 2, down in the environmental inspection process, passed.

After the installation is complete, you will be prompted to execute 2 shell scripts with root privileges. Follow the path to its prompt to find its location, such as: Mine is/home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh.

And/home/oracle/app/orainventory/orainstroot.sh a new terminal, enter the command:

Su–root

Cd/home/oracle/app/oracle/product/11.2.0/dbhome_1

SH root.sh

Cd/home/oracle/app/orainventory

SH orainstroot.sh

Database Build Library

1) or in Oracle user's graphical interface Oracle user, a new terminal, the direct input command DBCA will pop up the following interface. We use a custom database here.

Enter a unified password (you can also set its password separately)

Database storage location, I use the default

Do not specify fast recovery and archiving

Remove the infrequently used modules

Memory allocations and specified character sets

After a long wait, when you see this interface, the Oracle Build library is complete

can use Sqlplus to test, the new Open a command window, enter the Sqlplus, and then enter the user name and password, you can test, here do not do too much introduction.

Configuring monitoring and local network services

1) in Oracle User's graphical interface Oracle user, the new terminal is opened, the input command NETCA will pop up the following interface.

2) Create a listening service (acting as an Oracle Server for other Oracle clients to connect to this Oracle server)

3) Configure the local Network service name (acting as Oracle client, connecting to other Oracle servers)

Enter the instance name of the database for the connected Oracle server

Enter the IP address of the Oracle server

Check test

Click Change Login to enter one of the user names and passwords for the connected Oracle server, click OK

See this interface to show that the test was successful (if unsuccessful, see if the network is unblocked, whether the connected Oracle server is started, whether the listener is started, etc.)

Name a local network service name you set

Then next, next, you can

This makes the Oracle Server installation configuration basically complete.

Linux Installation Oracle 11g

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.