Linux Installation Oracle 11g

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