Ubuntu12.04 (amd64) Installation Oracle11g Summary

My current system is Ubuntu12.04amd64, which has two users: root and wwr. The following installation steps are performed under the wwr user. Download the corresponding Orac from the Oracle Official Website

My current system is Ubuntu 12.04 amd64, which has two users: root and wwr. The following installation steps are performed under the wwr user. Download the corresponding Orac from the Oracle Official Website

I started the Oracle database course. Textbooks and teachers both use 10 Gb of lectures. However, Oracle 11g has been released for a long time, and its functions tend to be stable. It also provides complete online materials, therefore, we plan to install an Oracle 11 GB for learning.

My current system is Ubuntu 12.04 amd64, which has two users: root and wwr. The following installation steps are performed under the wwr user. Download the Oracle database version from the Oracle official website (linux. x64_11gR2_database, two files in total ). The following installation steps combine several posts on the Internet. Although there are many minor problems after the test, the Oracle database has been installed successfully.

1. Update the system to the latest version and execute the following code on the terminal. It takes a long time to connect to the Internet.

Sudo apt-get update

Sudo apt-get dist-upgrade

2. Install the dependency package. It also requires a long time to connect to the Internet.

Sudo apt-get install alien binutils build-essential cpp-4.4 debhelper g + +-4.4 gawk gcc-4.4 gcc-4.4-base gettext html2text ia32-libs intltool-debian ksh lesstif2 lib32bz2-dev lib32z1-dev libaio-dev ready libc6 libc6-dev libc6-dev-i386 libdb4.8 libelf -dev libelf1 libltdl-dev libltdl7 libmotif4 libodbcinstq4-1 libodbcinstq4-1: i386 libqt4-core libqt4-gui libsqlite3-0 libstdc + + 5 libstdc + 6 libstdc + + 6-4.4-dev lsb-core lsb-cxx lsb-desktop lsb-graphics lsb-qt4 make odbcinst pax po-debconf rpm-common sysstat unixodbc-dev unzip

3. Create a user or user group (optional. It can be used by the current wwr user, But I created an oracle user during installation)

Sudo groupadd oinstall
Sudo groupadd dba
Sudo mkdir-p/opt/oracle
Sudo useradd-g oinstall-G dba-d/opt/oracle-s/bin/bash oracle
Sudo passwd oracle
Sudo chown-R oracle: oinstall/opt/oracle
Sudo groupadd oinstall
Sudo groupadd dba
Sudo mkdir-p/opt/oracle
Sudo useradd-g oinstall-G dba-d/opt/oracle-s/bin/bash oracle
Sudo passwd oracle
Sudo chown-R oracle: oinstall/opt/oracle
Sudo groupadd oinstall
Sudo groupadd dba
Sudo mkdir-p/opt/oracle
Sudo useradd-g oinstall-G dba-d/opt/oracle-s/bin/bash oracle
Sudo passwd oracle
Sudo chown-R oracle: oinstall/opt/oracle

Iv. Check System Variables

/Sbin/sysctl-a | grep sem
/Sbin/sysctl-a | grep shm
/Sbin/sysctl-a | grep file-max
/Sbin/sysctl-a | grep aio-max
/Sbin/sysctl-a | grep ip_local_port_range
/Sbin/sysctl-a | grep rmem_default
/Sbin/sysctl-a | grep rmem_max
/Sbin/sysctl-a | grep wmem_default
/Sbin/sysctl-a | grep wmem_max

Add the corresponding data in/etc/sysctl. conf according to the result.

Fs. aio-max-nr = 1048576
Fs. file-max = 6815744
Kernel. shmall = 2097152
Kernel. shmmax = 536870912
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
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 = 1048586

Run the following command to update kernel parameters:

Sudo sysctl-p