x64）上安装Oracle 10g r2（10.2.0.5）

总述要安装Oracle 10.2.0.5必须先安装10.2.0.1，安装顺序为10.2.0.1->10.2.0.5->EM补丁->创建实例->修复EM中文乱码问题->创建自启动1.安装rpm包nano /v.sh将下面内容复制进去对于 x64位版#！/bin/bashrpm -Uvh kernel-headers-2.6.18-194.el5.x86_64.rpmrpm -Uvh glibc-headers-2.5-49.x86_64.rpmrpm -Uvh glibc-devel-2.5-49.i386.rpmrpm -Uvh glibc-devel-2.5-49.x86_64.rpmrpm -Uvh libgomp-4.4.0-6.el5.x86_64.rpmrpm -Uvh compat-gcc-34-3.4.6-4.x86_64.rpmrpm -Uvh libstdc++-devel-4.1.2-48.el5.x86_64.rpmrpm -Uvh gcc-4.1.2-48.el5.x86_64.rpm rpm -Uvh gcc-c++-4.1.2-48.el5.x86_64.rpmrpm -Uvh make-3.81-3.el5.x86_64.rpmrpm -Uvh libXp-1.0.0-8.1.el5.x86_64.rpmrpm -Uvh libXp-1.0.0-8.1.el5.i386.rpm rpm -Uvh openmotif-2.3.1-2.el5_4.1.x86_64.rpmrpm -Uvh setarch-2.0-1.1.x86_64.rpmrpm -Uvh compat-db-4.2.52-5.1.x86_64.rpmrpm -Uvh compat-gcc-34-3.4.6-4.x86_64.rpmrpm -Uvh compat-gcc-34-c++-3.4.6-4.x86_64.rpmrpm -Uvh compat-libstdc++-33-3.2.3-61.x86_64.rpmrpm -Uvh libXau-devel-1.0.1-3.1.x86_64.rpmrpm -Uvh libXau-devel-1.0.1-3.1.i386.rpmrpm -Uvh libXp-devel-1.0.0-8.1.el5.x86_64.rpm rpm -Uvh libXp-devel-1.0.0-8.1.el5.i386.rpm对于 x32版本#！/bin/bashrpm -Uvh kernel-headers-2.6.18-194.el5.i386.rpmrpm -Uvh glibc-headers-2.5-49.i386.rpmrpm -Uvh glibc-devel-2.5-49.i386.rpmrpm -Uvh libgomp-4.4.0-6.el5.i386.rpmrpm -Uvh compat-gcc-34-3.4.6-4.i386.rpmrpm -Uvh libstdc++-devel-4.1.2-48.el5.i386.rpmrpm -Uvh gcc-4.1.2-48.el5.i386.rpmrpm -Uvh gcc-c++-4.1.2-48.el5.i386.rpmrpm -Uvh make-3.81-3.el5.i386.rpmrpm -Uvh libXp-1.0.0-8.1.el5.i386.rpmrpm -Uvh openmotif-2.3.1-2.el5_4.1.i386.rpmrpm -Uvh setarch-2.0-1.1.i386.rpmrpm -Uvh compat-db-4.2.52-5.1.i386.rpmrpm -Uvh compat-gcc-34-3.4.6-4.i386.rpmrpm -Uvh compat-gcc-34-c++-3.4.6-4.i386.rpmrpm -Uvh compat-libstdc++-33-3.2.3-61.i386.rpmrpm -Uvh libXau-devel-1.0.1-3.1.i386.rpmrpm -Uvh libXp-devel-1.0.0-8.1.el5.i386.rpm
存盘，转到安装 dvd的rpm目录下（CentOS是Centos 目录, Oralce Linux是 Server目录），执行bash /v.sh2.调整内核参数nano /etc/sysctl.conf#将原来的# kernel.shmmax和kernel.shmall这两行参数屏蔽kernel.shmall = 2097152 #///取大的，所以不用改kernel.shmmax = 2147483648 #///取大的，所以不用改kernel.shmmni = 4096# semaphores: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=262144net.core.rmem_max=262144net.core.wmem_default=262144net.core.wmem_max=262144
/sbin/sysctl -p --重新加载nano /etc/security/limits.conf --加入以下四行代码* soft nproc 2047* hard nproc 16384* soft nofile 1024* hard nofile 65536nano /etc/pam.d/login --加入下面一行代码session required pam_limits.so 3.增加用户及组groupadd oinstallgroupadd dbagroupadd operuseradd -g oinstall -G dba oraclepasswd oracle4.创建安装Oracle的文件夹，并设置其相应权限给Oracle用户。mkdir -p /u01/app/oracle/product/db_1chown -R oracle.oinstall /u01chmod 775 /u01

Oracle GROUPING函数的使用Oracle中游标的使用案例相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（0）