Access教程 sql server教程 MySQL教程 DB2教程
  • ORACLE教程
  • 当前位置:教程 > 数据库 > ORACLE教程 > 正文

    CentOS 6.3 X86_64安装Oracle 11R2

    编辑:教程网 来源:网络 时间:2013年08月16日 14:27

    一、环境版本

    --------------------------------------------------------------------------------

    系统版本:CentOS 6.3 X86_64(最小化安装) 数据库版本:Oracle 11gR2X86_64(Release 11.2.0.1.0) 主机名:GZ-DDN IP地址:192.168.1.253 二、基本组件及更新

    --------------------------------------------------------------------------------

    #yum install wgetvim-enhanced which screen make setuptool system-config-network*system-config-firewall* xorg-x11-xauth && yum groupinstall “development tools” && yum update 三、Oracle依赖包安装及工具

    --------------------------------------------------------------------------------

    #yum install binutils compat-libstdc++-33elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gccgcc-c++ libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstatunixODBC unixODBC-devel pdksh 四、关闭selinux

    --------------------------------------------------------------------------------

    #vim/etc/selinux/config 将SELINUX=enforcin g改为 SELINUX=disabled 并重启生效 # setenforce 0

    五、修改内核参数

    --------------------------------------------------------------------------------

    [[email protected] ~]# vi /etc/sysctl.conf # make it comment #net.bridge.bridge-nf-call-ip6tables = 0 #net.bridge.bridge-nf-call-iptables = 0 #net.bridge.bridge-nf-call-arptables = 0 # add at the last line net.ipv4.ip_local_port_range = 9000 65500 fs.file-max = 6815744 kernel.shmall = 10523004 kernel.shmmax = 6465333657 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.core.rmem_default=262144 net.core.wmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_max=1048576 fs.aio-max-nr = 1048576 [[email protected] ~]# sysctl -p #使以上修改生效 六、添加oracle用户

    --------------------------------------------------------------------------------

    [[email protected] ~]# groupadd -g 200 oinstall [[email protected] ~]# groupadd -g 201 dba &mkdir /app/users [[email protected] ~]# useradd -u 440 -g oinstall -G dba -m -d/app/users/oracle oracle [[email protected] ~]#passwd oracle #设置oracle用户的密码 [[email protected] ~]# mkdir -p /oracle/DB #创建oracle要安装的目录 [[email protected] ~]# chown -R oracle:oinstall /oracle #设置目录权限

    在/etc/hosts中添加主机名解析 [[email protected]~]#vim /etc/hosts 添加以下行: 192.168.10.50 GZ-DDN

    [[email protected] ~]# vi/etc/pam.d/login # near line 14: add session required pam_selinux.so open session required pam_namespace.so session requiredpam_limits.so session optional pam_keyinit.so force revoke session include system-auth -session optional pam_ck_connector.so

    [[email protected] ~]# vi /etc/security/limits.conf # add at the last line oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536

    [[email protected] ~]# vi /etc/profile # add at the last line if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi [[email protected] ~]# su - oracle [[email protected] ~]$ vi .bash_profile (设置环境变量) export PATH ORACLE_BASE=/oracle/DB ORACLE_HOME=$ORACLE_BASE/oracle ORACLE_SID=DB01 PATH=$ORACLE_HOME/bin:$PATH exportORACLE_BASE ORACLE_HOME ORACLE_SID PATH alias sqlplus='rlwrap sqlplus' alias rman='rlwraprman' 退出当前会话,并重新以oracle用户登录后确认: [[email protected] ~]$ env|grepORA ORACLE_SID=DB01 ORACLE_BASE=/oracle ORACLE_HOME=/oracle/DB 至此,安装oracle的前期准备工作就全部完成了。

  • 原文来自 教程网 转载请注明:http://www.websmill.com/shujuku/ORACLE/32324.html

  • 上一篇:Oracle中巧取指定记录与巧用外关联查询
  • 下一篇:没有了