Installation of Oracle 11g database

Installation of Oracle 11g database

1. Install the virtual machine, use VMware or VirtualBox, run the memory configuration to 4G, the hard disk expands automatically. (CPU virtualization does not need to be turned on)

2. Install the operating system and now install the OS version of Oracle Enterprise Linux 6.5 (basically the same as Red Hat Enterprise Linux 6.5) without the need for the reinstallation process

, you can customize to add users and groups later. The installation process (Oinstall and DBA groups, respectively, as the group of Oracle users and the subordinate group) is no longer redundant.

3. Create the appropriate paths/u01/app/oracle and/u01/software, as follows:

Mkdir-p/u01/{software,app}

Mkdir/u01/app/oralce

4. Close related services and SELinux

Service NetworkManager Stop

Service cups stop

Service Bluetooth stop

Service Iptables Stop

Chkconfig NetworkManager off

Chkconfig cups stop

Chkconfig bluetooth stop

Chkconfig iptables Stop

Close SELinux, edit/etc/sysconfig/selinux file

Modify the SELinux parameter to Disabled

The system requires a reboot to take effect, and after selinux the temporary switchover between the enforcing and permissive parameters can be done using the Setenforce command

5. Configure the network, edit the/etc/sysconfig/network_script/ifcfg-eth0, and modify the following:

Bootproto=static

Onboot=yes

Nm_controlled=no

IPADDR=192.168.64.101 (physical machine IP set to 192.168.64.100)

netmask=255.255.255.0 (or prefix=24)

Save and exit

Modify the/etc/hosts file to do domain name resolution locally

192.168.64.101 Oracle Oracle.example.com

Service Network restart

6. Add users and groups, and the main group of user oralce are Oinstall and DBAs, respectively:

Groupadd Oinstall && Groupadd dba

Useradd-g oinstall-g dba-s/bin/bash Oracle

7. Upload the installation media to/u01/software using SECURECRT

Use the root user to change/u01 and the owning and owning groups of the following directories

Chown-r oracle:oinstall/u01

Go to directory use the unzip command to extract two zip files (compressed files for installation media)

Unzip Packagename1.zip && unzip Packagename2.zip

8. Modify Bash's environment variables as an Oracle user

Vim ~/.bash_profile

Setting environment variables

Export Oracle_base=/u01/app/oracle

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

Export oracle_sid=enmoedu

Export path= $ORACLE _home/bin: $PATH

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

9. Preparation done, as Oracle user login GUI

Execute/u01/software/database/runinstaller into Oracle's graphical installation interface

Customize the database to install Oracle on demand

10. The installation process detects whether the system is missing a package, whether the environment variable is set correctly, and the limitations of the kernel parameter Pam module

parameter is set correctly

Follow the prompts to continue detection after executing the appropriate script as root

Continue installing the database after the modification is complete

* Note: The setup process will cause warning of parameter setting

Need to modify/etc/security/limit.conf set the following parameters

Oracle Soft Nproc 2048

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

The hard limit is the system's mandatory limit on Oracle users, which cannot exceed the set value, and the soft limit is more than the value to warn.

The Nproc parameter is a limit on the maximum number of processes available to a single user

The Nofile parameter is a limit on the maximum number of files that a single user can open.

Installation of Oracle 11g database