DBA installs Oracle database11g database graphics tutorials under Linux _oracle

ORACLE11G is a more generic version, trying to install Oracle 12c unfortunately failed, there is no way
The following is the collation of information

1. Attached to the installation file

Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip? authparam=1407205871_4259949f8bacf912168631692563a693
Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip? Authparam=1407205876_ec394cc017d1815a8cce7cc31e0f0bb9

2. The concrete steps are as follows

Step1. Download installation files
Step2. Configure initialization environment before installation
Step3. Install Oracle Installer-database
Step4. Configuring Oracle Database-configuration
Step5. Configure Listener
Step6. Start the database and test for success

3. Installation of OEM considerations

4. Start the database step

Start listening./lsnrctl start
Start Stacks sqplus> start up

ii. Pre-installation configuration initialization Environment

1. Create Oracle users under Linux, and Admin group Log on to Linux as root, execute the following command

#/usr/sbin/groupadd DBA
#/usr/sbin/groupadd Oper
#/usr/sbin/groupadd Oinstall
#useradd Oracle
#/usr/sbin/usermod-g oinstall-g dba Oracle (DBA as Administrative Group)
#/usr/sbin/useradd-g oinstall-g dba Oracle
#passwd Oracle

2. Pre-Create installation directory

#mkdir-P/opt/oracle/product
#mkdir-P/opt/oracle/product/11.2.0/db_home1
#mkdir-P/opt/orainventory
#mkdir-P/opt/oracle/oradata
#mkdir-P/var/opt/oracle

3. Set the owner-owned group and permissions for the directory

#chown-R oracle.oinstall/opt/oracle
#chown-R Oracle.oinstall/opt/oracle/oradata
#chown-R oracle.oinstall/opt/oracle/product/11.2.0/db_home1
#chown-R Oracle.dba/opt/orainventory
#chown oracle.dba/var/opt/oracle
#chmod-R 775/opt/oracle
#chmod-R 755/var/opt/oracle

4. Set user Oracle's environment variables in the file to add the following:

#su-oracle
#vi/home/oracle/.bash_profile

Export Oracle_base=/opt/oracle
Export Oracle_home= $ORACLE _base/product/11.2.0/db_home1
Export Oracle_sid=prod
Export Oracle_owner=oracle
Export oracle_term=vt100
Export Path=path:oracle_home/bin: $HOME/bin
Export Path=oraclehome/bin:oracle_home/apache/apache/bin: $PATH
Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib:/usr/local/lib
Export Ld_library_path
Classpath=oraclehome/jre:oracle_home/jlib: $ORACLE _home/rdbms/jlib
Classpath=classpath:oracle_home/network/jlib
Export CLASSPATH
Path= $PATH:/usr/sbin; Export PATH
Path= $PATH:/usr/bin; Export PATH

$ source/home/oracle/.bash_profile

iii. installation of Oracle Installer-database

Using the Oracle account, upload the Oracle installation files to the server and unzip

Cd/opt/oracle/database
./runinstaller

1. Configure Security Updates

2. Installation options

3. Grid options

4. Installation Type

5. Typical Installation

6. Prerequisite Checks

7. Summary

8. Install the Product

9. After installation, execute the following two scripts with root

Iv. Configuring Oracle Database-configuration

1.1 Running the DBCA script configuration database

Cd/opt/oracle/product/11.2.0/db_home1/bin

./DBCA

2.1 Create a database

2.2 Database Templates

2.3 Database Identification

2.4 Management Options

2.5 Database Credentiais

2.6 Database File Locations

2.7 Database Content

2.8 Initilization Paramters

2.9 Creation Options

V. Configuration of Listener

1.1 Running NETCA script configuration database Monitor

Cd/opt/oracle/product/11.2.0/db_home1/bin

./NETCA

2. Configure Listener

2.1 Listener Configuration

2.2 Create an Listener

2.3 Confirm Port Number

3. Configure the server local Net Service Name Configuration

3.1 Add local Net Service Name Configuration

3.2 Service Name

3.3 TCP and Host Name

Vi. initiating database monitoring and database testing

1. Start database monitoring

Cd/opt/oracle/product/11.2.0/db_home1/bin
./lsnrctl Start

2. Start the database

Sqlplus '/as sysdba '
Sql>startup

3. View process after startup

4.1. Exception (Start database listener failure Modify configuration file)

/etc/selinux/config
./lsnrctl error while loading shared libaries libclntsh.so.11.1

4.2. Exception (Start database listener failure Modify configuration file)

Abnormal:

Lsnrctl message1070

Solution Method:

Confirm that the environment variable $oracle_home is correct in the/home/.bash_profile

4.3. Exception (cannot use Sqlplus)

Abnormal

Sqlplus ora-01034

Ora-01034:oracle not avaiable
Ora-27101:shared Memory realm does not exist
Process id:0
Session id:0 Serial number:0

Resolution method

Login via SYSDBA, start database and log in as normal user

4.4 When verifying, prompt for missing installation package

Yum Install unixodbc-devel-2.2.11
Yum Install unixODBC-2.2.11
Yum Install sysstat-5.0.5
Yum Install libaio-devel-0.3.105
Yum Install liaio-devel-0.3.105
Yum Install compat-libstdc++-33-3.2.3
Yum Install Libaio-devel
Yum Install Pdksh
Yum Install Elfutils-libelf-devel
Yum Install Sysstat

4.5 when validating, OS Kernel parmaters

Modify/etc/sysctl.conf This file, and then activate with Sysctl-p

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

5 Oracle Yum Installation Yi

STEP1, check the network environment, ensure the smooth network
[root@gavinsit]# cat/etc/issue
[root@gavinsit]# Ping www.baidu.com

STEP2, check if Yum is installed
[Root@gavinsit]# Rpm-qa | grep Yum

STEP3, switching to directory/etc/yum.repos.d/
[root@gavinsit]# cd/etc/yum.repos.d/

STEP4, get the configuration file and modify it accordingly
[Root@gavinsit] #yum. repos.d]# wget Http://public-yum.oracle.com/public-yum-ol6.repo

STEP5, install Oracle-rdbms-server-11gr2-preinstall pack with Yum
[root@gavinsit]# Yum Install Oracle-rdbms-server-11gr2-preinstall