The process is as follows:
1-Confirm the following installation package, if not installed, find the appropriate package from the CD to install
#rpm-qa | grep binutils
Binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
Elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125
Glibc-2.5-12
Glibc-common-2.5-12
Glibc-devel-2.5-12
gcc-4.1.1-52
gcc-c++-4.1.1-52
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.1-52
libstdc++-4.1.1
Libstdc++-devel-4.1.1-52.e15
make-3.81-1.1
sysstat-7.0.0
unixODBC-2.2.11
unixodbc-devel-2.2.11
libxp-1.0.0-8.1.el5.i386.rpm
libxp-devel-1.0.0-8.1.el5.i386.rpm
Installing RPM Packages
#rpm-IVH example.rpm
2-Modifying kernel parameters
Add the following line to the/etc/sysctl.conf file:
#fs. File-max = PROCESSES *
Fs.file-max = 65536
Kernel.shmall = 2097152
Kernel.shmmax = 2147483648
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Net.ipv4.ip_local_port_range = 1024 65000
Net.core.rmem_default = 4194304
Net.core.rmem_max = 4194304
#net. core.rmem_default=8388608
#net. core.rmem_max=8388608
Net.core.wmem_default = 262144
Net.core.wmem_max = 262144
Run the following command to change the core parameters to make the memory parameters effective
# sysctl-p
3-Set the shell Limits (System resource limit), improve the efficiency of software operation//This step, do not do also can. I haven't even added it before.
Add the following lines to the/etc/security/limits.conf file:
Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536
Add or edit the following. the/etc/pam.d/login file, if it does not already exist:
Session required/lib/security/pam_limits.so
Session Required Pam_limits.so
4-Create user, user group
#/usr/sbin/groupadd Oinstall
#/usr/sbin/groupadd DBA
#/usr/sbin/useradd-g oinstall-g dba Oracle
#passwd Oracle
5-Unzip the installation package, run Runinstaller, and enter Oracle's graphical interface Setup program
If you are in the root user's graphical interface, you may need to perform xhost+, then su-oracle, into the extracted Oracle installation package./runinstaller
Remote can use VNC to open graphical interface installation
Sometimes encountered when the Oracle installation graphical interface can not boot, this time to see if the system is not a hint of libxp-1.0.0-8.1.el5.i386.rpm, LIBXP-DEVEL-1.0.0-8.1.EL5.I386.RPM package, these two packages are not the default when installing the operating system and need to be selected manually before they are installed.
Sometimes encountered the installation interface garbled problem, the workaround is as follows:
Execute the following command before installing:
Unset LANG
Unset Lc_all
Unset lc_message
And then
./runinstaller
6-Modify the. BASHRC for Root and Oracle users to set environment variables, for example:
Export Oracle_base=/home/oracle/app/oracle
Export ORACLE_SID=ORCL
Export Oracle_home=/home/oracle/app/oracle/product/11.1.0/db_1
Export path= $PATH: $ORACLE _home/bin
Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
7-Modify the/home/oracle/app/oracle/product/11.1.0/db_1/network/admin/directory files: Mainly configure the monitoring, by default, listen to the native database, no need to modify
8-Start monitoring Lsnrctl with Oracle user, then DBCA CREATE database
9-Modify/etc/oratab file
Orcl:/home/oracle/app/oracle/product/11.1.0/db_1:n---> Change to Y
10-Set Oracle to boot, add the following 2 lines in the/etc/rc.local file:
Su-oracle-c ' lsnrctl start '
Su-oracle-c ' Dbstart '
11-Change Character Set
[[Email protected] ~] $sqlplus/as SYSDBA
Sql>shutdown IMMEDIATE;
Sql>startup MOUNT;
Sql>alter SYSTEM ENABLE RESTRICTED SESSION;
Sql>alter SYSTEM SET job_queue_processes=0;
Sql>alter DATABASE OPEN;
Sql>alter database Character set Internal_use ZHS16GBK;
Sql>shutdown IMMEDIATE;
sql>startup;
12-Create a user, set a password, and authorize
Sql> create user Db_user identified by <passwd>;
User created.
Sql> Grant SYSDBA to Db_user;
Grant succeeded.
Sql> Grant DBA to Db_user;
Grant succeeded.
13-Reboot the system to see if the Oracle database is self-booting
14-Database Import, export
14-1 Import
Imp db_user/[email protected] file=/home/example.dmp full=y
14-2 Export
Exp Db_user/[email protected] Log=/home/oracle/example.log file=/home/oracle/example.dmp Owner=db_user
RHEL5 installation Oracle11