RHEL64上ORACLE10g的安装.docx

1、RHEL64上ORACLE10g的安装RHEL6.4上ORACLE 10g的安装一、概述根据Oracle官方文档的建议，在机器内存小于1G的情况下，swap分区大小应该设置为内存的2倍大，若内存大于2G则swap分区设置为内存大小一样。为防止Oracle安装过程中出现乱码，建议使用英文作为系统语言，进行Oracle的安装工作。二、oracle安装前的准备 1.配置yum源由于下面oracle软件包的安装时用的yum命令安装，在使用yum命令安装软件的时候，必须提前配置yum源，下面就其具体的安装方法进行详细的说明。a.创建CDROM加载目录# mkdir /media/rhel6b.加载CDR

2、OM放入安装光盘，加载光驱。# mount /dev/cdrom /media/rhel6c.备份rhel-source.repo文件# cp /etc/yum.repos.d/rhel-source.repo /etc/yum.repos.d/bakd.编辑rhel-source.repo文件# vi /etc/yum.repos.d/rhel-source.repo向rhel-source.repo文件添加内容如下：Servername=Serverbaseurl=file:/media/rhel6/Serverenabled=1gpgcheck=0HighAvailabilityname

3、=HighAvailabilitybaseurl=file:/media/rhel6/HighAvailabilityenabled=1gpgcheck=0LoadBalancername=LoadBalancerbaseurl=file:/media/rhel6/LoadBalancerenabled=1gpgcheck=0ScalableFileSystemname=ScalableFileSystembaseurl=file:/media/rhel6/ScalableFileSystemenabled=1gpgcheck=0ResilientStoragename=ResilientSt

4、oragebaseurl=file:/media/rhel6/ResilientStorageenabled=1gpgcheck=02.安装依赖的软件包 oraclelndb # rpm -q gcc make binutils openmotifgcc-4.4.7-3.el6.x86_64make-3.81-20.el6.x86_64binutils-2.20.51.0.2-5.36.el6.x86_64openmotif-2.3.3-5.el6_3.x86_64-rootCombaHms Server# rpm -q gcc make binutils openmotif setarch

5、compat-db compat-gcc compat-gcc-c+ compat-libstdc+ compat-libstdc+-devel libXpgcc-4.4.7-3.el6.x86_64make-3.81-20.el6.x86_64binutils-2.20.51.0.2-5.36.el6.x86_64openmotif-2.3.3-5.el6_3.x86_64package setarch is not installedcompat-db-4.6.21-15.el6.x86_64package compat-gcc is not installedpackage compat

6、-gcc-c+ is not installedpackage compat-libstdc+ is not installedpackage compat-libstdc+-devel is not installedlibXp-1.0.0-15.1.el6.x86_64libXp-1.0.0-15.1.el6.i686rootCombaHms Server# yum install compat-libstdc* compat-gcc* libXp* libXt* libstdc+-devel* glibc-devel*3.配置oracle安装环境a.建oracle用户和组rootComb

7、aHms Server# /usr/sbin/groupadd oinstallrootCombaHms Server# /usr/sbin/groupadd dbarootCombaHms Server# /usr/sbin/useradd -m -g oinstall -G dba oraclerootCombaHms Server# passwd oracleChanging password for user oracle.New UNIX password: BAD PASSWORD: it is too shortRetype new UNIX password: passwd:

8、all authentication tokens updated successfully.b.创建oracle目录，并给予权限rootCombaHms Server# mkdir -p /export/home/oracle/product/10.2.0/db_1rootCombaHms Server# mkdir -p /export/home/oracle/product/10.2.0/oradatarootCombaHms Server# mkdir -p /export/home/oracle/installrootCombaHms Server# chown -R oracle:

9、oinstall /export/home/oraclerootCombaHms Server# chmod -R 775 /export/home/oraclec.修改系统内核参数 rootCombaHms Server# vi /etc/sysctl.conf# For install oraclekernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144net.core

10、.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144d.编辑/etc/security/limits.confrootCombaHms Server# vi /etc/security/limits.conf# For Oracle Installoracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536e.编辑/etc/pam.d/loginrootCombaHms Ser

11、ver# vi /etc/pam.d/login # For Oracle Installsession required /lib/security/pam_limits.so备注:此处机器重启后会影响用户登录!小技巧:一般情况下可以先通过SSH客户端软件或telnet用root登录,把以上修改屏蔽掉先,再通过实体机器登录,登录后再修改回来,虽然有点烦,暂时没有找到合适方法,但确实很实用f.编辑/etc/profilerootCombaHms Server# vi /etc/profile# For Oracle Installif $USER = oracle ; then if $SHE

12、LL = /bin/ksh ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022fig.编辑/etc/csh.loginrootCombaHms Server# vi /etc/csh.login# For Oracle Installif ( $USER = oracle ) then limit maxproc 16384 limit descriptors 65536 umask 022endifh.配置oracle用户环境变量oracleCombaHms $ vi .bash_

13、profileORACLE_BASE=/export/home/oracleORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1ORACLE_SID=hmsNLS_LANG=AMERICAN_AMERICA.ZHS16GBKPATH=/bin:/sbin:/usr/bin:/usr/sbin:$ORACLE_HOME/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libTEMP=/tmpTMPDIR=/tmpexport ORALCE_BASE ORACLE_HOME ORACLE_SID NLS_L

14、ANG PATH LD_LIBRARY_PATH DISPLAY TMPDIR TEMPumask 022if $USER = oracle ; thenif $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi#PATH=$PATH:$HOME/bin#export PATHi.将dba组添加到内核中rootCombaHms # id oracleuid=500(oracle_ gid =502(oinstall) groups=502(oinstall),501(dba)

15、rootCombaHms #vi /etc/sysctl.conf 在/etc/sysctl.conf文件中添加如下该行：vm.hugetlb_shm_group = 50-j.配置主机名rootCombaHms # vi /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost.localdomain localhost:1 localhost6.localdomain6 localhos

16、t6172.16.15.34 CombaH CombaHms-三、开始安装oracle1.解压释放安装文件oracleCombaHms $ gunzip 10201_database_linux_x86_64.cpio.gz oracleCombaHms $ cpio -idv-SQL startup;ORACLE instance started.Total System Global Area 1325400064 bytesFixed Size 2020576 bytesVariable Size 335547168 bytesDatabase Buffers 973078528 byt

17、esRedo Buffers 14753792 bytesDatabase mounted.Database opened.SQL-SQL shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL create user comba identified by password; User created.SQLSQL grant dba to comba;Grant succeeded.SQL=tnsping测试网络连接=四、windows 客户端工具连接测试 客户端工具已经连接并可以维护数据库啦!-=原始数据库导入工作=这里我们拿个库来做个测试CMS800.dmp.oracleCombaHms $ ls -lrttotal 791404-rwxrwxr-x 1 oracle oinstall 7963648 May 11 2010 CMS800.dmp 注意啦:imp comba/passwordhms file=CMS800.dmp full=y,不需要分号”我们再次使用客户端工具查看刚刚导入的数据库表:已经全部导入成功啦,到这里已经全部完成工作以上部署工作在没有任何报错的情况下完成,可以借签