linux上oracle10g安装配置文档

关于这篇文档摘要目录1安装准备 (1)1.1操作系统补丁准备 (1)1.2ORACLE用户及属组 (1)1.3核心参数检查 (2)1.4修改系统限制 (3)1.4.1PAM 配置文件修改 (3)1.5设置ORACLE用户环境变量 (3)2介质安装 (4)2.1修改用户环境变量，启动图形终端 (4)2.2安装步骤 (5)2.3数据库补丁 (9)2.4补丁安装步骤 (10)2.5安装OPATCH (13)2.6安装CPU补丁12419258 (13)3TAR包安装 (14)4创建实例 (15)5配置监听 (24)6客户端本地NET服务名配置 (29)附录A参考资料 (34)A.1附录A.1 ORACLE基础操作命令 (34)图目录图2-2欢迎界面 (5)图2-3产品清单和操作组设置 (6)图2-4选择按照数据库类型 (6)图2-5指定主目录 (7)图2-6检查系统界面 (7)图2-7设置配置选项 (8)图2-8安装组件概要 (8)图2-9安装结束界面 (9)表目录表4-1Oracle8i,oracle 9i, oracle 10g 补丁列表 (9)1 安装准备摘要：介绍orace10G在suse11下安装的准备工作1.1 操作系统补丁准备1. 在图形界面中，以root用户登录选择菜单［yast→Software→SoftwareManagement］2. 在弹出的菜单中，选择[Search]项，输入“orarun”，进行search，检查是否已经安装，如果没有，则进行安装。

3. 安装后的状态如下：1.2 oracle用户及属组安装好orarun环境包后，系统是存在oracle用户和dba组的，只是与我们规范要求的id不一样，需要进行修改。

1. 在图形界面中，以root用户登录选择菜单［yast→Security and Users→User andGroup Management］2. 在弹出的菜单中，设置过滤条件（Set Fitter）为System users或System Groups，然后对oracle用户及dba组进行修改，id为1001，oracle的主目录为/home/oracle。

Oracle 10g RAC安装文档1、建oracle用户和组：(两节点的用户ID和组ID一致)groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oraclepasswd oracleid oracle2、准备文件目录：mkdir -p /opt/oraclechown oracle.dba /opt/oracle/chmod 775 /opt/oracle/mkdir -p /oracle01chown oracle.dba /oracle01chmod 775 /oracle01chown oracle.oinstall /oracle013、设置环境变量：vi /etc/hosts127.0.0.1 localhost.localdomain localhost# Public192.168.3.11 rac1192.168.3.12 rac2#Private192.168.4.11 rac1-priv192.168.4.12 rac2-priv#Virtual192.168.3.13 rac1-vip192.168.3.14 rac2-vipvi /etc/sysctl.confkernel.shmmax = 2147483648kernel.shmmni = 4096kernel.shmall = 2097152kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=262144net.core.wmem_default=262144net.core.rmem_max=262144net.core.wmem_max=262144vi /etc/security/limits.conforacle soft nofile 65536oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 163844、配置 Hangcheck 计时器find /lib/modules -name "hangcheck-timer"echo "options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180" >> /etc/modprobe.conf echo "/sbin/modprobe hangcheck-timer" >> /etc/rc.localmodprobe hangcheck-timergrep Hangcheck /var/log/messages | tail -25、设置oracle用户环境变量vi .bash_profileexport ORACLE_BASE=/opt/oracleexport ORACLE_HOME=$ORACLE_BASE/10g/dbexport ORA_CRS_HOME=$ORACLE_BASE/10g/crsexport ORACLE_SID=db1PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH:$HOME/binexport PATH=$ORACLE_HOME/bin:/bin:/sbin:/usr/bin:/usr/ccs/bin:/usr/local/bin:/usr/ucb: $ORACLE_BASE/product/10.2.0/crs_1/bin:/etcexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:$ORACLE_HOME/oracm/lib:/usr/local/ lib:/usr/libexport ORACLE_TERM=xtermexportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/rdbms/jlib :$ORACLE_HOME/network/jlibexport THREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpexport LD_ASSUME_KERNEL=2.4.19unset USERNAME6、使用SSH为oracle用户配置等效性rac2上$ssh-keygen -t rsa$cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keysrac1上$ssh-keygen –t rsa$cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$ssh rac1 cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$ssh rac1-priv cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$ssh rac2 cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$ssh rac2-priv cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$scp /home/oracle/.ssh/authorized_keys rac2:/home/oracle/.ssh测试登录是否需要密码与时间同步 //rac1和rac2都要执行$ssh rac1 date;ssh rac2 date$ssh rac1-priv date;ssh rac2-priv date7、安装和配置ocfs安装 OCFS2把 OCFS2 文件安装到两台单处理器计算机中。

Oracle 10g for Linux系统安装说明书文件代号：CZ-XTGC-AZ-061024-05整理：郑炎平日期：2006-10-24日期：日期：修订记录目录Linux as 4 上安装oracle 10 g............................................................................................. - 3 -1、查抄内存和交换分区.................................................................................................... - 3 -2、查抄/tmp空间............................................................................................................... - 3 -3、查抄软件包.................................................................................................................... - 4 -在RHEL 4 x86_64上安装10g R2 (64-bit)需要的软件包： ............................... - 4 -在RHEL 4 x86上安装10g R2 (64-bit)需要的软件包： ..................................... - 4 -查看处置器内核：...................................................................................................... - 4 -可以用以下命令来查询：.......................................................................................... - 5 -4、查抄内核参数................................................................................................................ - 5 -5、查抄磁盘空间................................................................................................................ - 6 -6、创立oracle的用户...................................................................................................... - 6 -7、为Oracle用户设定Shell的限制.............................................................................. - 6 -8、创立oracle目录.......................................................................................................... - 7 -9、设置oracle环境变量.................................................................................................. - 7 -10、安装oracle................................................................................................................. - 8 -1)进入欢送界面:........................................................................................................ - 9 -2)指定详细目录和认证:............................................................................................ - 9 -3)弹出对话框要求执行orai脚本：........................................................................ - 9 -4)查抄产物安装的先决条件.................................................................................... - 10 -5)选择数据库配置:.................................................................................................. - 10 -6)指定命据库配置选项:.......................................................................................... - 10 -7)指定命据库存储组选项:...................................................................................... - 10 -8)指定备份和修复选项:.......................................................................................... - 10 -9)指定命据库暗码:.................................................................................................. - 10 -10)点击安装.............................................................................................................. - 10 -11)安装完成.............................................................................................................. - 11 -11、安装后查抄................................................................................................................ - 11 -12、使用Oracle数据库.................................................................................................. - 11 -设置 Oracle 环境变量：........................................................................................ - 11 -启动数据库:.............................................................................................................. - 11 -关闭数据库:.............................................................................................................. - 11 -遏制数据库................................................................................................................ - 12 -数据库办理程序：.................................................................................................... - 12 -遏制网络侦听：........................................................................................................ - 12 -关闭群集效劳进程：................................................................................................ - 12 -启动和遏制 Oracle Enterprise Manager 数据库控制： .................................. - 12 -启动和遏制 iSQL*Plus：........................................................................................ - 12 -启动和遏制监听器：................................................................................................ - 12 -启动和遏制数据库：................................................................................................ - 13 -列出 Oracle 进程：................................................................................................ - 13 -13、卸载Oracle：........................................................................................................... - 14 -Linux as 4 上安装oracle 10 g1、查抄内存和交换分区查抄物理内存grep MemTotal /proc/meminfo查抄交换分区grep SwapTotal /proc/meminfo可以创立一个temporary swap文件已增加系统temporary swap 空间su - rootdd if=/dev/zero of=tmpswap bs=1k count=900000chmod 600 tmpswapmkswap tmpswapswapon tmpswap可以用以下命令来撤销temporary swapsu - rootswapoff tmpswaprm tmpswap2、查抄/tmp空间依照Oracle的文档，安装oracle的OUI界面需要400MB的/tmp空间$df /tmp假设没有足够的交换tmp空间，可以在其他的文件系统中创立一个tmp目录su - rootmkdir /<AnotherFilesystem>/tmpchown root.root /<AnotherFilesystem>/tmpchmod 1777 /<AnotherFilesystem>/tmpexport TEMP=/<AnotherFilesystem>export TMPDIR=/<AnotherFilesystem>当你安装好oracle后可以删掉增加的tmp空间su - rootrmdir /<AnotherFilesystem>/tmpunset TEMPunset TMPDIR3、查抄软件包安装oracle 10g之前需要查抄系统的RPM包。

安装步骤:一:检查环境,在root下,(第一步可以省略检查物理内存:#grep MemTotal /proc/meminfo 检查交换空间:#grep SwapTotal /proc/meminfo 检查/tmp目录:#df –k /tmp检查磁盘空闲空间:#df –k确认系统架构:#grep “model name” /proc/cpuinfo 二:配置安装环境#rpm -qa | grep binutils#rpm -qa | grep compat-db#rpm -qa | grep compat-libstdc++#rpm -qa | grep control-center#rpm -qa | grep gcc#rpm -qa | grep gcc-c++#rpm -qa | grep glibc#rpm -qa | grep glibc-common#rpm -qa | grep libstdc++#rpm -qa | grep libstdc++-devel#rpm -qa | grep make#rpm -qa | grep ksh#rpm -qa | grep sysstat#rpm -qa | grep setarch#rpm -qa | grep libaio-devel#rpm -qa | grep libXp如果软件已经安装,系统会给出版本:例如binutils-2.17.50.0.6-9.e15如果软件没有安装,系统会提示:binutils is not installed安装该软件的方法:#yum search binutils查找到binutils.i386#yum install binutils.i386开始安装三:修改内核参数执行# vi /etc/sysctl.conf 按i进入编辑模式,将下列内容加入该文件kernel.shmall = 2097152kernel.shmmax = 536870912 #不大于最大内存kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65500net.core.rmem_default=1048576net.core.rmem_max=1048576net.core.wmem_default=262144net.core.wmem_max=262144编辑完成之后按ESC,:wq存盘退出, 重新加载并验证参数是否正确,运行下面命令: #sysctl –p设置Shell执行# vi /etc/security/limits.conf调用现在:* soft nproc 2074* hard nproc 16384* soft nofile 1024* hard nofile 65536编辑完成之后按ESC,:wq存盘退出执行#vi /etc/pam.d/login 将下列内容加入该文件session required /lib/security/pam_limits.sosession required pam_limits.so编辑完成之后按ESC,:wq存盘退出创建相关目录、用户、组1:创建Inventory组和dba组# groupadd oinstall# groupadd dba2:创建Oracle 用户并设置密码# useradd -g oinstall –g dba –m oracle# passwd oracle3:创建数据库软件目录和数据库存放目录#mkdir /opt/ora10g#mkdir /opt/ora10g/product#mkdir /opt/ora10g/oradata4:更改目录属主为Oracle所有#chown –R oracle:oinstall /opt/ora10g四:配置Oracle用户环境变量切换到oracle用户#su – oracle$vi .bash_profile 编辑.bash_profile文件,增加下列内容export TMP=/tmp;export TMPDIR=$TMP;export ORACLE_BASE=/opt/ora10gexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORACLE_SID=jssbookexport ORACLE_TERM=xtermexport PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/X11R6/lib64/exportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdb ms/jlib export LD_ASSUME_KERNEL=2.6.9export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"umask 022if [ $USER = "oracle" ];thenif [ $SHELL = "/bin/ksh" ];thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi编辑完成之后按ESC,:wq存盘退出验证方式:source .bash_profile五:版本修订如在redhat-5以上版本安装oracle的时候,需要将文件 '/etc/redhat-release'的内容由Red Hat Enterprise Linux Server release 5 (Tikanga 修改为Red Hat Enterprise Linux Server release 4 (Tikanga 六:执行安装:最好是重新登录到Oracle用户下$ unzip 10201_database_linux32.zip进入安装目录:执行runInstaller进行安装$ cd ./database$ ./runInstaller开始进入图形安装界面:1:选择高级安装2:企业版3:指定安装路径 opt\ora10g\product\10.2.0\db_14:检查安装环境:如果检查到未通过项目,看看提示信息,分析下未通过原因,如果不影响项目安装和数据库运行,直接进入下一步;5:仅安装数据库软件6:安装7:文件复制8:系统提示Root身份执行两个脚本新开一个终端:$ su – root# /opt/ora10g/oraInventory/orainstRoot.sh# /opt/ora10g/product/10.2.0/db_1/root.sh然后返回安装窗口,单击Ok按钮确认即可。