Linux Installation Oracle

Source: Internet
Author: User
Tags dba sqlplus

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 (specific to the location in the personal system, this is to the previous level of the product directory)
Export ORACLE_SID=ORCL (no modification is required by default)
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-After adding the completion environment variable, you need to switch to the root user and run 2. sh files with root privileges.

One in/home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh

The other is/home/oracle/app/orainventory/orainstroot.sh.

Do the following:

Cd/home/oracle/app/oracle/product/11.2.0/dbhome_1

SH root.sh

Cd/home/oracle/app/orainventory

SH orainstroot.sh

8-Open the monitor lsnrctl start with the Oracle user, see the display listening on, then Sqlplus/as SYSDBA; access the Oracle 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

Reference post: http://www.cnblogs.com/zhrq/p/4148801.html

Linux Installation Oracle

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.