Oracle10g 在linux as 5as 6下的安装.doc

Oracle10g 在linux as 5/as 6下的安装一Oracle安装前配置1.red hat 5下安装时需检查以下安装包make-3.79.1 gcc-3.2.3-34 glibc-2.3.2-95.20 glibc-devel-2.5-12.i386.rpm glibc-headers-2.5-12.i386.rpm compat-db-4.0.14-5 compat-gcc-7.3-2.96.128 compat-gcc-c+-7.3-2.96.128 compat-libstdc+-7.3-2.96.128 compat-libstdc+-devel-7.3-2.96.128 libXpm-3.5.5-3.i386.rpm libXp openmotif21-2.1.30-8 setarch-1.3-1 libgomp-4.1.1-52.el5.i386.rpm查询所需安装包是否完整rpm -q gcc make binutils openmotif setarch compat-db compat-gcc compat-gcc-c+ compat-libstdc+ compat-libstdc+-devel libXp 由于缺失的包之间有严格的依赖关系，所以必须按照如下顺序安装缺失的包rpm -Uvh compat-db-4*rpm -Uvh libaio-0*rpm -Uvh compat-libstdc+-33-3*rpm -Uvh glibc-headers-2.5-12.i386.rpmrpm -Uvh glibc-devel-2.5-12.i386.rpmrpm -Uvh compat-gcc-34-3*rpm -Uvh compat-gcc-34-c+-3*rpm -Uvh libXp-1*rpm -Uvh openmotif-2*rpm -Uvh gcc-4*rpm -Uvh glibc-2.5-12.i686.rpmrpm -Uvh libgomp-4.1.1-52.el5.i386.rpmrpm -Uvh gcc-4.1.1-52.el5.i386.rpm安装完成后仍然提示部分包没有安装，不过不影响使用package compat-gcc is not installedpackage compat-gcc-c+ is not installedpackage compat-libstdc+ is not installedpackage compat-libstdc+-devel is not installed另一种说法：查询所需安装包是否完整rpm -q gcc make binutils openmotif setarch libXp 而对于需要安装的包，按如下关键字搜索和安装即可 compat - libXp - openmotif 全部安装完毕即可(我是这样做的) * 2.red hat 6.1下安装时需检查以下安装包(1).redhat6.1 安装oracle10g 在执行命令./runInstaller安装报以下错误时，需要安装相关补丁包。(2)在red hat 6.1 安装时需要安装以下包rpm -ivh libX11-*rpm -ivh libXt*rpm -ivh libXext-*rpm -ivh libXa-*rpm ivh libXau-*rpm ivh libSM-*rpm ivh libICE-*rpm ivh libXi-*rpm ivh libxcb-*rpm ivh libuuid-* (3)在redhat 6.1上oracle10g 仅安装了以上的包，仍然还是不行的，在安装过程中仍会报缺少包。例如下图(4)red hat 6.1 上安装oracle前 ，建议安装以下包。# rpm -ivh libstdc+-devel-4.4.4-13.el6.i686.rpm -nodeps kernel-headers-2.6.32-71.el6.i686.rpm glibc-headers-2.12-1.7.el6.i686.rpm glibc-devel-2.12-1.7.el6.i686.rpm gnome-icon-theme-2.28.0-2.el6.noarch.rpm dmz-cursor-themes-0.4-4.el6.noarch.rpm sgml-common-0.6.3-32.el6.noarch.rpm libaio-devel-0.3.107-10.el6.i686.rpm ncurses-devel-5.7-3.20090208.el6.i686.rpm elfutils-libelf-devel-0.148-1.el6.i686.rpm compat-gcc-34-3.4.6-19.el6.i686.rpm libXxf86misc-1.0.2-1.el6.i686.rpm libXxf86vm-1.1.0-1.el6.i686.rpm libXt-1.0.7-1.el6.i686.rpm libXmu-1.0.5-1.el6.i686.rpm mpfr-2.4.1-6.el6.i686.rpm cpp-4.4.4-13.el6.i686.rpm xorg-x11-xauth-1.0.2-7.1.el6.i686.rpm compat-gcc-34-c+-3.4.6-19.el6.i686.rpm libdaemon-0.14-1.el6.i686.rpm avahi-0.6.25-8.el6.i686.rpm avahi-glib-0.6.25-8.el6.i686.rpm shared-mime-info-0.70-4.el6.i686.rpm libIDL-0.8.13-2.1.el6.i686.rpm ORBit2-2.14.17-3.1.el6.i686.rpm GConf2-2.28.0-6.el6.i686.rpm gnome-vfs2-2.24.2-6.el6.i686.rpm libbonobo-2.24.2-4.el6.i686.rpm libtool-ltdl-2.2.6-15.5.el6.i686.rpm unixODBC-2.2.14-11.el6.i686.rpm gtk2-engines-2.18.4-5.el6.i686.rpm libmcpp-2.7.2-4.1.el6.i686.rpm mcpp-2.7.2-4.1.el6.i686.rpm xorg-x11-server-utils-7.4-15.el6.i686.rpm libXv-1.0.5-1.el6.i686.rpm ConsoleKit-x11-0.4.1-3.el6.i686.rpm xorg-x11-xinit-1.0.9-13.el6.i686.rpm libXp-1.0.0-15.1.el6.i686.rpm libXxf86dga-1.1.1-1.el6.i686.rpm libdmx-1.1.0-1.el6.i686.rpm xorg-x11-utils-7.4-8.el6.i686.rpm compat-db43-4.3.29-15.el6.i686.rpm compat-db42-4.2.52-15.el6.i686.rpm ppl-0.10.2-11.el6.i686.rpm cloog-ppl-0.15.7-1.2.el6.i686.rpm gcc-4.4.4-13.el6.i686.rpm gcc-c+-4.4.4-13.el6.i686.rpm compat-libstdc+-33-3.2.3-69.el6.i686.rpm compat-db-4.6.21-15.el6.i686.rpm gnome-themes-2.28.1-6.el6.noarch.rpm system-icon-theme-6.0.0-2.el6.noarch.rpm system-gnome-theme-60.0.2-1.el6.noarch.rpm unixODBC-devel-2.2.14-11.el6.i686.rpm readline-devel-6.0-3.el6.i686.rpm libgnome-2.28.0-11.el6.i686.rpm2.增加Oracle安装和使用的用户(1) 新增组和用户groupadd oinstallgroupadd dbauseradd -g oinstall -G dba -d /home/oracle oraclepasswd oracleuseradd d /home/用户名 用户名 u id g 用户组注意几个命令行的使用：切换用户：Su 用户名增加用户：Useradd: 删除用户：userdel: rm rf 用户名修改用户权限：Chmod R 775 /home/用户名修改用户组：chown R oracle:dba /home/oracle /指定文件的所属用户和所属组修改用户密码：passwd 用户名查看用户：more /etc/passwd 查看用户组：more /etc/group775代表意思： rwx（4+2+1）：rwx（4+2+1）：rwx（4+2+1）*注意：配置文件用vi命令修改4.修改配置文件(1) /etc/sysctl.conf 行末添加以下内容，已有的修改kernel.shmall = 2097152 kernel.shmmax = 8147483648 kernel.shmmni = 4096 # semaphors: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_default=262144 net.core.wmem_max=262144运行下面的命令使得内核参数生效/sbin/sysctl -p (2) /etc/security/limits.conf 行末添加以下内容#use for oracle * soft nproc 2047 * hard nproc 16384 * soft nofile 1024 * hard nofile 65536 (3) /etc/pam.d/login 行末添加以下内容session required pam_limits.so(4) /etc/selinux/config更改 SELINUX=disabled 关闭防火墙，必须的(5) /etc/redhat-release Linux版本信息，5不支持Oracle，安装后可以改回去Red Hat Enterprise Linux AS release 3 (Taroon) 或Red Hat Enterprise Linux AS release 4 (Nahant Update 4)(6) gedit /etc/profile 就是增加JDK配置的文件，在增加JDK配置后紧接着增加如下内容if $USER = oracle ;thenif $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi(6) bash_profile 在创建用户后在用户的目录下有一个.bash_profile(使用Oracle用户)并在文件中增加如下内容(ORACLE_BASE是最重要的，他代表Oracle的安装路径)(在安装时就可以创建数据库，如果安装完毕重启，则再启动监听时无法启动，则要注意ORACLE_HOME在数据库安装后要根据实际路径进行修改)ORACLE_BASE=/home/oracle ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 ORACLE_SID=tspfPATH=$PATH:$HOME/bin:$ORACLE_HOME/bin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH二数据的安装执行命令cpio -idmv conn / as sysdbaSqlstartup -启动数据库服务Sqlshutdown immediate-关闭数据库服务$ lsnrctl start -启动监听$ lsnrctl stop -关闭监听$ lsnrctl stauts -查看监听状态7.创建用户create user ltpf identified by ltpf default tablespace USERS temporary tablespace TEMP profile DEFAULT; grant connect to tspon;-赋权 grant