redhat5.1上安装oracle 10.2g客户端及配置使用

一)安装

1.命令 rpm -q gcc make binutils setarch compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel unixODBC unixODBC-devel libaio-devel

  显示木有安装的,则安装上,可以把redhat的安装盘挂载redhat的系统上,到server目录下找到名字差不多的rpm;

  安装的过程中可能会报错,缺少.so的链接文件,则在server目录下找到相应的安装文件安装

  rpm -i openmotif-2.3.1-2.el5.i386.rpm
      libXp.so.6 is needed by openmotif-2.3.1-2.el5.i386
      参考http://www.linuxidc.com/Linux/2011-01/31646.htm
      rpm -i libaio-0.3.106-3.2.i386.rpm
      rpm -i openmotif-2.3.1-2.el5.i386.rpm
  rpm -i compat-gcc-34-g77-3.4.6-4.i386.rpm
      compat-libf2c-34 = 3.4.6-4 is needed by compat-gcc-34-g77-3.4.6-4.i386
          libg2c.so.0 is needed by compat-gcc-34-g77-3.4.6-4.i386
      参考http://www.2cto.com/database/201305/207856.html
      rpm -ivh compat-libf2c-34-3.4.6-4.i386.rpm
      rpm -ivh compat-gcc-34-g77-3.4.6-4.i386.rpm、

  都安装好之后,再次运行刚开始的命令,我这里,还是有以下包显示未安装
    package compat-gcc is not installed
    package compat-gcc-c++ is not installed
    package compat-libstdc++ is not installed
    package compat-libstdc++-devel is not installed

  这时,可以不必理会,参考http://hi.baidu.com/winlei/item/cfa1109bad9ab68d58146105

  安装rpm,可以到系统盘的安装包里,运行yum list | grep ***  找到想应的rpm安装包;再运行yum install ***(比如compat*,一次安装多个)

2.OS系统参数配置

  vi /etc/sysctl.conf    添加:

    #below for oracle10g
    kernel.core_uses_pid = 1
    kernel.shmmax = 536870912
    kernel.shmmni = 4096
    kernel.shmall = 2097152
    kernel.sem = 250 32000 100 128
    net.core.rmem_default = 4194304
    net.core.rmem_max = 4194304
    net.core.wmem_default = 262144
    net.core.wmem_max = 1048576
    fs.file-max = 6815744
    net.ipv4.ip_local_port_range = 9000 65500
    fs.aio-max-nr = 1048576

3. vi /etc/security/limits.conf  添加:

    #use for oracle
    soft nproc 2047
    hard nproc 16384  
    soft nofile 1024
    hard nofile 65536

4. vi /etc/selinux/config  确保:

    SELINUX=disabled

5. vi /etc/profile  添加:

    if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
    else
    ulimit -u 16384 -n 65536
    fi
    fi

    export ORACLE_BASE=/u01/app/oracle
    export ORACLE_SID=orcl

6.添加用户组和用户

    groupadd dba
      groupadd oinstall
      useradd oracle -g oinstall -G dba
      passwd oracle

7.新建目录权限 

      mkdir -p /u01
      chown -R oracle:dba /u01
      chmod -R 755 /u0

8. su –oracle  (最好是注销,再用oracle账号登录)

9. cd ~

  vi .bash_profile  添加;

    #oracle environment add from 2013-08-07
    export ORACLE_BASE=/u01/app/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/11.1.0.6
    export ORACLE_SID=orcl
    export PATH=$PATH:$ORACLE_HOME/bin
    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

10. unset LANG  (以防安装界面显示不全,oracle的安装界面是Java做的,可能是redhat系统中文的支持问题)

  进到oracle安装包的安装目录.../oracle_database_10g/database

  运行  ./runInstaller

二)配置

1. cd $ORACLE_HOME/network/admin

  即cd /u01/app/oracle/product/11.1.0.6/network/admin

2. netca

  这个命令会弹出配置界面,也可以vi编辑,如下

  vi tnsnames.ora  添加:(依据实际情况,以下举一个例子)

  ORCL_39 =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.39)(PORT = 1529))  
      )
      (CONNECT_DATA =
        (SERVICE_NAME = orcl)
      )
    )

3.测试能不能连接成功

  tnsping orcl_39

  tnsping 192.168.6.39:1529/orcl

4.进入sqlplus  (命令的格式如下)

  sqlplus 用户名/密码@orcl_39

灰常感谢龙哥,全程指导

ps:64位的redhat6上安装oracle11g时,遇到一个问题:

问题描述:

  运行sqlplus时,

  ERROR:
  ORA-01034: ORACLE not available
  ORA-27101: shared memory realm does not exist
  Linux Error: 2: No such file or directory

解决:参考http://www.itpub.net/forum.php?mod=viewthread&tid=359574&highlight=

  /etc/oratab

  oradb:/home/oracle/product/8.1.7:Y

oracle11g的安装过程:http://www.cnblogs.com/zhangyongli2011/archive/2012/04/04/2431953.html

原文地址:https://www.cnblogs.com/-wangjiannan/p/3246328.html