Oracle Single-instance database installation configuration

Note:

1. This manual is a sample installation based on the RHEL6.6 x86_64 + Oracle 11.2.0.4 version, please refer to.
2. When operating system installation, be aware of installing the graphical interface, or you may encounter various display problems when you install Oracle.
3. Oracle installation checks the operating system swap size, should be set at least 4GB, of course, this option can be ignored, does not affect database use.
4. The character set settings for the Oracle database need to be confirmed with the developer or application provider, otherwise garbled characters may occur.

Host IP Planning

Modify the/etc/hosts file to add the corresponding record

172.16.1.61 NCDB

User planning

Create a user group

Groupadd Oinstallgroupadd dba

Create user

USERADD-G oinstall-g dba Oracle

Set the Oracle user password

passwd Oracle Password: Oracle

Directory Planning

If there is a clear requirement, plan according to the requirements.

Example:

/u01 Oracle Installer Directory

/orabak/arch Oracle Archive Files Directory

/orabak/backup Oracle Backup Directory

/oradata Oracle Data Files directory

1,/u01/oracle/app/oradata         (Oracle  800g)  Oracle Data Files directory 2,/u01/oracle/app/ Arch     (Archive  500g)  Oracle archive file directory 3,/u01/oracle/app/orabak        (backup  remainder)   /u01/oracle/app/oradata//u01/oracle/app/oradata//U01/ORACLE/APP/ORADATA/ORCL /redo

Modify Directory Permissions:

chown -R oracle:oinstall  /u01/oracle/app

Install the required rpm

Note: The corresponding configuration is based on the specific system version.

mkdir/mnt/ServerMount/dev/cdrom/mnt/SERVERCD/etc/Yum. repos.d/CPRhel-source.repo rhel-Source.repo.bakCat>rhel-source.repo<<Eof[rhel-Source]name=red Hat Enterprise Linux $releasever-Sourcebaseurl=file:///Mnt/serverEnabled=1Gpgcheck=1Gpgkey=file:///Etc/pki/rpm-gpg/rpm-gpg-key-redhat-releaseEOFYum Install-Y binutils*Yum Install-Y compat-db*Yum Install-Y compat-libstdc*Yum Install-Y control-center*Yum Install-YGCC*Yum Install-Y glibc*Yum Install-Y gnome-libs*Yum Install-Y libstdc++*Yum Install-Y MakeYum Install-y sysstatYum Install-y setarchYum Install-Y libaio*Yum Install-Y libxp*Yum Install-Y libxt*Yum Install-Y libawt*Yum Install-y UnixODBCYum Install-y smartmontoolsYum Install-Y elfutils-libelf-devel*

If there is pdksh, then install, if not also can choose the system comes with the Ksh

Yum Install -yksh*-ivh Pdksh

modifying system kernel Parameters

#-- set open files and number of processes limit cat >>/etc/security/limits.conf<<eof#oracle settingoracle      Soft    nproc   2047Oracle      hard    nproc   16384Oracle      Soft    nofile  Oracle hard    nofile   65536  EOF

#--Setting the maximum number of bootable processes and the maximum number of files that can be opened

Edit/etc/profile, enter command: Vi/etc/profile, press I to enter edit mode, add the following content to the file.

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

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

Cat>>/etc/pam.d/Login<<eof#oracle settingsession Required/lib64/security/pam_limits.sosession Required Pam_limits.soeofCat>>/etc/sysctl.conf<<eof#oracle Settingfs.aio-MAX-NR =1048576FS.file-max =6815744Kernel.shmmni=4096Kernel.sem= - 32000  -  -Net.ipv4.ip_local_port_range=9000 65500Net.core.rmem_default=262144Net.core.rmem_max=4194304Net.core.wmem_default=262144Net.core.wmem_max=1048586EOF

The execution sysctl–p takes effect.

Unzip the media file

Description: Different version media names are different.

For example:

CD/softwareunzip P13390677_112040_linux-x86-64_1of7. Zip Unzip P13390677_112040_linux-x86-64_2of7. Zip

To grant media permissions to Oracle users:

chown -R oracle:oinstall database/

Set up the environment. Bash_profile

Note: Modify the oracle_sid to the actual SID

su - oracleVI /home/oracle/. Bash_profileexport oracle_base=/u01/oracle/  Appexport oracle_home= $ORACLE _base/product/11.2. 0/ dbhome_1export oracle_sid=orclexport PATH= $ORACLE _home/bin: $PATHexport Nls_lang =american_america. Al32utf8

Effective environment variables:

source. bash_profile

Installing the Database

Using the Oracle user to install the database

CD database/. /runinstaller

Oracle Single-instance database installation configuration