Linux System installation Oracle 11g

    due to project requirements, the need to install Oracle 11g on 64-bit Linux systems, a lot of content on the Internet, combined with their own practical experience, finally installed successfully, recorded, and shared to the needy comrades.

First, installation Preparation

If you are using a text-interface Linux, install the Linux GUI first. Because Oracle here is installed in the graphical interface, the recurrence starts the graphical installation.

Check that the required dependency packages are installed

Rpm-q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel GLib C-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make Numactl-devel sysstat Unix ODBC Unixodbc-devel

You can use the RPM on the CD to install, if still missing some rpm, you can go to http://rpmfind.net/download after installation, note the version.

Second, modify the 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 to enter edit mode, add the following content to the file.

1234567

oracle soft nproc 2047  oracle hard nproc 16384   oracle soft nofile 1024  oracle hard nofile 65536

Press ESC when editing is complete and enter ": Wq" to eject

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.

123	session required /lib/security/pam_limits.so session required pam_limits.so

Press ESC when editing is complete and enter ": Wq" to eject

3) Modify the 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

123456789101112131415161718192021

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

Press ESC when editing is complete and enter ": Wq" to eject

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

123456789101112131415161718192021222324252627

linux:~ # sysctl -p  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 = 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

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.

123456789101112131415

if [ $USER = "oracle" ]; then  if [ $SHELL = "/bin/ksh" ]; then   ulimit -p 16384   ulimit -n 65536   else   ulimit -u 16384 -n 65536   fi  fi

Press ESC when editing is complete and enter ": Wq" to eject

6) Create the relevant users and groups as the owner of the software installation and Support group.

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

123	useradd-g oinstall -g dba -m oracle   passwdoracle

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:

1234567

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:

1	chown-R oracle:oinstall /home/oracle/app

9) Configure the environment variables for the Oracle user, 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:

123456789

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

Press ESC when editing is complete and enter ": Wq" to eject

Third, the 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 copy it with other SSH FTP tools.

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

Enter the command:

123	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:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/85/8E/wKioL1eoUhTzotcOAABAkqc34Hs139.png ">

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

Note: If there is no graphical interface, there will be an error here.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/85/8E/wKiom1eoUhWQPQSrAAKHLfat7WU219.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/85/8E/wKioL1eoUhXQRVZ_AAImGsjepQo225.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/85/8E/wKiom1eoUhbzPzmtAAIUc7IzTTE797.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/85/8E/wKiom1eoUhiAMbEyAAKv40-SYPA031.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/85/8E/wKioL1eoUhmAG6g1AANSZ6eJ4Wg722.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/85/8E/wKiom1eoUhuRB3MbAALHJrRh9U0039.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/85/8E/wKioL1eoUhygVW-cAAMQuLFpoYc509.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/85/8E/wKiom1eoUh6TN835AANQyRyLMS0717.png "Name=" ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/85/8E/wKioL1eoUh_h250CAAJSgxV5T6I534.png ">

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/orainventory/orainstroot.sh a new terminal, enter the command:

123456789

su root   cd /home/oracle/app/oracle/product/11.2.0/dbhome_1  sh root.sh   cd /home/oracle/oraInventory sh orainstRoot.sh

Iv. Database Building 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.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/85/8E/wKiom1eoUiCww5ajAAK0QAv-C6w843.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/85/8E/wKioL1eoUiCBSrkjAALMtqTVTsY561.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/85/8E/wKioL1eoUiKSs4CoAAKL0C1mOlQ543.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/85/8E/wKiom1eoUiOz81WiAALoZEUZzw8954.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/85/8E/wKiom1eoUiPCh_T5AAKyyjrIu_8508.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/85/8E/wKioL1eoUiSDQjqTAAMkCKyCp80774.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/85/8F/wKiom1eoUiaRqBiWAALT8vkKi_w768.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/85/8E/wKioL1eoUifS_ixdAAMEg0vWjSU061.png ">

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/85/8E/wKioL1eoUijC63k-AAM2rd8v9_c380.png ">

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/85/8F/wKiom1eoUinA9rb5AAEwLyK8_wA923.jpg "border=" 0 " Name= "" "612" height= "409" >

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/85/8F/wKiom1eoUirxaygiAAIFbAQrMMI810.png ">

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

Oracle has been able to log on locally via Sqlplus. The following configuration is required if remote login is required

Iv. 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.

650) this.width=650; "Src=" Http://s3.51cto

Linux System installation Oracle 11g