Redhat Installing the Oracle 11G database

Environment: Redhat 6.5 + Oracle 11G
1. Turn off the Linux firewall and disable SELinux

2, installation of the required RPM package
Yum install-y binutils compat-libcap compat-libstdc gcc gcc-c++ glibc glibc-devel libgcc libstdc libstdc++-devel Libaio L Ibaio-devel make Sysstat UnixODBC unixodbc-devel Pdksh

3. Create OS user group, user
Groupadd Oinstall
Groupadd dba
Useradd–g oinstall–g dba Oracle

4. Configuring Kernel Parameters
Vi/etc/sysctl.conf
FS.AIO-MAX-NR = 1048576
Fs.file-max = 6815744
Kernel.shmall = 2097152
Kernel.shmmax = 1043888128
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 = 1048576
Sysctl-p (manual execution of the effective command)

5. Configure the restriction conditions
Vi/etc/security/limits.conf
Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536

6. Create the installation directory
Mkdir-p/u01/app/oracle
Chown-r oracle:oinstall/u01/app/
Chmod-r 775/u01/app/

7. Configuring Oracle User Environment variables
VI. bash_profile
Export Oracle_base=/u01/app/oracle
Export Oracle_home=/u01/app/oracle/product/11.2.0/dbhome_1
Export ORACLE_SID=ORCL
Export path= $ORACLE _home/bin: $PATH

8. Open Xmanager Passive, execute in system
[Email protected] ~]# export display=192.168.1.100:0.0
(IP for machines that need to receive Oracle Graphical interface installation)

9. Install Oracle Database (install database software, create monitoring NETCA, create DATABASE DBCA)
[Email protected] ~]$ cd/soft/database/
[Email protected] database]$./runinstaller
(1) Open the Oracle 11g installation Interface

(2) Skip software updates

(3) Install only database software

(4) Single Instance database installation

(5) Select the installation path

(6) Execute configuration script


(7) Installation complete

10. Configure Database Monitoring
(1) Execute NETCA command under Oracle User
[Email protected] ~]$ NETCA
(2) Popup Configuration Interface
(3) Keep the next step until you finish.

11. Install the database
(1) Execute the DBCA command under Oracle User
[Email protected] ~]$ DBCA
(2) Eject the installation interface

(3) Create a database

(4) Create a password for the database user (choose to create a unified password here)

(5) Select the database storage type (select File System here)

(6) Turn on and specify the Flash back area (turn on or off according to actual demand)

(7) Select a sample scenario (turn on or off based on actual requirements)

(8) Configure shared memory, character set, and other information

(9) After clicking Finish, the database starts to install

(10) Enter the database and view the database status
[Email protected] ~]$ Sqlplus/as SYSDBA
Sql> Show user;
USER is "SYS"
Sql> select status from V$instance;

STATUS

OPEN

Redhat Installing the Oracle 11G database