第一次用百度文库的文档分享功能。
在OEL 5上快速部署Enterprise Manager Cloud Control 12c(12.1)
在OOW 2011期间甲骨文发布了新一代的企业管理器Enterprise Manager Cloud Control 12c,这里我们来介绍如何在Oracle Enterprise Linux 5上快速部署EM 12c和其Agent。
硬件要求
安装Enterprise Manager Cloud Control 12c的硬件要求如下表,推荐至少有4GB内存
Footnote 1 ADP Manager is Application Dependency and Performance
Footnote 2 JVMD is JVM Diagnostics
Footnote 3 Default heap size is 512 MB. For higher heap size, set the size manually.
推荐在Oracle Enterprise Linux 5.7或6.1上安装EM 12c , 可以从edelivery.oracle.com 下载到这2款操作系统的安装介质。
以下演示中的主机均采用Oracle Enterprise Linux 5.7 操作系统。
以下表格列出了在Oracle Linux 6或5.x上 安装EM 12c ,所要求预装的操作系统软件包,这些软件包可以直接从OS安装DVD介质中找到:
Platform | 32-Bit Packages for 32-Bit Platform | 64-Bit Packages for 64-Bit Platform |
---|---|---|
Oracle Linux 6 |
|
In addition, install the 32-bit version as well as the 64-bit version of glibc-devel-2.5-49. |
Oracle Linux 5.xRed Hat Enterprise Linux 5.x |
|
In addition, install the 32-bit version as well as the 64-bit version of glibc-devel-2.5-49. |
更多关于OS软件要求的信息,可以直接访问EM 安装手册 <Meeting Package, Kernel Parameter, and Library Requirements>章节。
准备工作
在正式部署EM 12c 之前我们需要完成一系列的准备工作,包括:
1. 下载EM 12c(12.1) 安装介质
EM 12.1的安装介质可以从Oracle技术网络OTN上找到其下载页面,64位软件的具体下载地址:
介质包括 disk1和disk2 2个接近3GB的zip压缩包,其中em12_linux64_disk1of2.zip包含了主要的EM binary,而em12_linux64_disk2of2.zip包含了为EM扩展的插件,如支持Exadata、IBM DB2的插件等。
2. 在安装EM的Host上创建EM软件的拥有者OS账号
这里我创建oem用户来执行后续的安装操作:
groupadd -g 800 oinstall useradd -g oinstall oem
3. 解压安装介质
创建存放解压后安装介质的目录并解压上述zip包:
su - oem [oem@vrh5 tmp]$ mkdir em_cloud [oem@vrh5 tmp]$ cd em_cloud/ [oem@vrh5 em_cloud]$ unzip ../V28375-01.zip [oem@vrh5 em_cloud]$ unzip ../V28376-01.zip
4. 在EM主机上安装必要的rpm 软件包以及调整/etc/sysctl.conf中的内核参数,该步骤可以通过oracle-validated工具代劳,详见<Understand Oracle Validated Configurations>
5. 为 EM拥有者用户配置必要的ulimit 参数 , 需要修改/etc/security/limits.conf配置文件,如:
[root@vrh5 ~]# tail -10 /etc/security/limits.conf #ftp hard nproc 0 #@student - maxlogins 4 # End of file oem soft nofile 4096 oem hard nofile 4096
6. 为EM 12c配置合适的repository database以存放数据
这里可以在Metalink上的Certification Matrix中找到EM 12c已认证的数据库版本,如下图所示 11.2.0.2和11.2.0.3 均已通过该认证:
这里推荐新建一个11.2.0.2 版本的数据库作为EM Repository。
此外作为EM Repository的数据库还必须使用EM所要求的初始化参数,这些要求包括:
Check the CBO stats gathering job Disable the stats gathering job 1.Check the processes instance parameter value The processes instance parameter needs to be set to at least 300. 2.Check the session_cached_cursors instance parameter value. The session_cached_cursors instance parameter should be set to 300. Any value between 200 and 500, inclusive, will be accepted. 3.Check the job_queue_processes instance parameter value. The job_queue_processes instance parameter should be set to 20. 4.Check the shared_pool_size instance parameter value. The shared_pool_size instance parameter should be set to at least 600 megabytes or roughly one third of the sga_target size. 5. Check the redo log size. The size of the EM database instance should be 300 megabytes or greater. Generally, there should be 3 or more redo logs available of this size. 6. Ensure that the EM tablespace has at least one datafile set to autoextensible Add at least one datafile with the autoextend attribute to the EM tablespace 7.Check the open_cursors instance parameter value. The open_cursors instance parameter should be set between 300 and 400, inclusive. 8.Check the sga_target instance parameter value. The sga_target instance parameter should be set to at least 2 gigabytes, and roughly twice the size of the pga_aggregate_target setting. 9.Check for invalid objects in the EM repository Compile all invalid objects in the EM repository
可以通过以下命令满足上述的参数要求,当然参数的值还可以适当放大:
alter system set processes= 500 scope=spfile; alter system set session_cached_cursors=500 scope=spfile; alter system set shared_pool_size=650M scope=spfile; alter system set job_queue_processes=22 scope=spfile; alter database add logfile size 320M; alter system set open_cursors=350 scope=spfile; alter system set sga_target=2g scope=spfile; ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
注意EM 要求 repository database没有配置DB control ,如果有的话需要通过下列命令drop 掉:
export ORACLE_HOME= $YOUR_ORACLE_HOME export ORACLE_SID= $Repository_SID $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop
同时要求sysman 和 sysman_mds、 sysman_opss用户不存在,已创建该用户的DB 可以drop 掉:
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for Linux: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production SQL> select * from global_name; GLOBAL_NAME -------------------------------------------------------------------------------- www.askmac.cn & www.askmac.cn drop user sysman cascade; drop user sysman_mds cascade; drop user sysman_opss cascade; drop user sysman_apm cascade; drop user sysman_ro cascade; drop user mgmt_view cascade; @?/rdbms/admin/catsnmp
7. 确保能够从EM 主机顺利登录到 repository 数据库 :
[oem@vrh5 tmp]$ tnsping vrh4:1521/SBDB TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 16-OCT-2011 21:18:24 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=SBDB))(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.1.167)(PORT=1521))) OK (0 msec) [oem@vrh5 tmp]$ sqlplus sys/maclean@vrh4:1521/SBDB as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Sun Oct 16 21:18:54 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
8. 确保网络正常
这里要求EM主机必须使用statics IP 静态IP ,否则安装会出错, 且已正确在/etc/hosts或DNS配置唯一的域名解析
正式安装
我们开始正式通过OUI安装Oracle Enterprise Manager Cloud Control 12c(12.1),这里要用到图形化的界面,确保DISPLAY环境变量正确或者使用Xmanager之类的软件:
(oem)$ unset ORACLE_HOME ORACLE_BASE ORACLE_SID (oem)$ export DISPLAY=:0 (oem)$ cd /tmp/em_cloud/ 注意这里若你的EM Host拥有多个host name ,那么要使用ORACLE_HOSTNAME参数指定规范的host name 如/etc/hosts 中的信息为: 192.168.1.8 vrh5 vrh5.oracle.com 那么要选用vrh5.oracle.com 这个hostname 如果host name 中带"_"符号 可能导致安装失败 (oem)$ ./runInstaller ORACLE_HOSTNAME=vrh5.oracle.com Starting Oracle Universal Installer…
如下图OUI界面顺利启动,勾销” I wish to receive security update…”,并点击Next:
Prerequisite Checks会检测EM安装的前提条件,这里因为物理内存不足(要求3g)而出现Warning,点击Next忽略该警告
点击Yes,忽略该问题
若检测顺利,则如下图:
下一步选择create a new Enterprise Manager -> Simple ,为Middleware Home location选定一可用的空目录,注意目录的拥有者应为oem(EM 所有者用户)
选择想要安装的插件,这里我们不安装额外的插件,保持默认配置点击Next:
选择暂时不安装Exalogic Elastic Cloud Infrastructure插件, Install Later:
配置Weblogic Server,填入Weblogic和Node Manager密码及OMS instance Base Location:
配置数据库连接信息,填入repository database的连接信息:
输入 sysman用户和Agent注册使用的密码, 安装程序会自动为你提供EM所需创建表空间数据文件的位置:
选择EM 12c将要使用的端口,一般默认即可,除非这些端口有其他用途:
点击 Next后 再点击Install Now进入安装过程:
安装流程包括Copy Files、Configure Plugins Prerequisites Check、Repository Configuration、MDS Schema Configuration、OMS Configuration、Plugins Deployment and Configuration 、 Start Oracle Management Service、 Oracle Configuration Manager Repeater、Agent Configuration Assistant 、Run root scripts,总耗时在1个小时左右。
在此过程中推荐监控安装进程的日志,这些日志的位置如下:
例如: /m01/midd/oms/sysman/log/schemamanager/m_$date/m_$date.CREATE/em_repos_config.log /m01/midd/oms/sysman/log/schemamanager/m_$date/m_$date.CREATE/emschema.log /m01/midd/oms/cfgtoollogs/cfgfw/oracle.sysman.top.oms_*.log /m01/midd/oms/cfgtoollogs/omsca/*.log
em_repos_config.log记录了em repository的配置日志,在此安装过程中可能遇到如下错误:
INFO: oracle.sysman.top.oms:__________________________DUMPING PARAMETERS
INFO: oracle.sysman.top.oms:OracleHome: /m01/midd/oms
INFO: oracle.sysman.top.oms:Connect String: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=vrh4.oracle.com)(PORT=1588)))(CONNECT_DATA=(SID=SBDB)))
INFO: oracle.sysman.top.oms:SYS User: SYS
INFO: oracle.sysman.top.oms:________________________________________________________________________
INFO: oracle.sysman.top.oms:MDS Schema Creation status: RUNNING
SEVERE: oracle.sysman.top.oms:MDS Schema Creation is failed
INFO: oracle.sysman.top.oms:_______________________________________________________________________
INFO: oracle.sysman.top.oms:Starting opss Schema Creation.
INFO: oracle.sysman.top.oms:OPSS Component is already created
INFO: oracle.sysman.top.oms:_______________________________________________________________________
INFO: oracle.sysman.top.oms:Starting APM Schema Creation.
INFO: oracle.sysman.top.oms:APM Component is already created
INFO: oracle.sysman.top.oms:The plug-in MDS Schema Configuration has failed its perform method
INFO: oracle.sysman.top.oms:About to execute plug-in MDS Schema Configuration
INFO: oracle.sysman.top.oms:The plug-in MDS Schema Configuration is running
SEVERE: oracle.sysman.top.oms:MDS Schema Creation is failed 创建失败是由bug引起的
遇到该错误后,手动登录到数据库并执行以下create user命令:
create user SYSMAN_MDS identified by sysman_mds;
创建该SYSMAN_MDS用户后,回到安装界面并点击retry按钮,安装会继续下去。
OMS和Agent配置过程中的日志如下:
INFO: oracle.sysman.top.oms:The plug-in OMS Configuration is running INFO: oracle.sysman.top.oms:Internal PlugIn Class: oracle.sysman.oms.OMSConfiguration INFO: oracle.sysman.top.oms:Classpath = /m01/midd/oms/sysman/jlib/omsConfig.jar: INFO: oracle.sysman.top.oms:BaseConfiguration:invoke:Starting BaseConfiguration invoke method on an aggregate=oracle.sysman.top.oms for Action=configuration in step=5:microstep=0 INFO: oracle.sysman.top.oms:Fetcing ports from teh static ports file: /m01/midd/.gcinstall_temp/staticports.ini INFO: oracle.sysman.top.oms:COMMAND: /m01/midd/oms/bin/omsca NEW -RESPONSE_FILE /m01/midd/oms/omscarespfile -lock_console -lock_upload -CONFIGURE_REPEATER true -nostart INFO: oracle.sysman.top.oms: Check the OMS Configuration Assistant logs at: /m01/midd/oms/cfgtoollogs/omsca INFO: oracle.sysman.top.oms:Oracle Enterprise Manager 11g Release 1 Grid Control INFO: oracle.sysman.top.oms:Copyright (c) 2009, 2010, Oracle. All rights reserved. INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms:Enter Admin Server user password: Enter Admin Server user password:Doing pre requisite checks ...... INFO: oracle.sysman.top.oms:Pre requisite checks completed successfully INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms:Doing infrastructure setup ...... INFO: oracle.sysman.top.oms:Infrastructure setup of EM completed successfully. INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms:Doing pre deployment operations ...... INFO: oracle.sysman.top.oms:Pre deployment of EM completed successfully. INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms:Deploying EM ...... INFO: oracle.sysman.top.oms:Deployment of EM completed successfully. INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms:Configuring webtier ...... INFO: oracle.sysman.top.oms:Configuring webTier completed successfully. INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms:Securing OMS ...... INFO: oracle.sysman.top.oms:EM Key is secured and is backed up at /m01/midd/oms/sysman/config/emkey.ora INFO: oracle.sysman.top.oms:Adapter created successfully: emgc_USER INFO: oracle.sysman.top.oms:Adapter created successfully: emgc_GROUP INFO: oracle.sysman.top.oms:Post "Deploy and Repos Setup" operations completed successfully. INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms:Performing Post deploy operations .... INFO: oracle.sysman.top.oms:Software Library OMS shared storage is not configured, skipping metadata registration INFO: oracle.sysman.top.oms:Post deploy operations completed successfully. INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms:EM configuration completed successfully. INFO: oracle.sysman.top.oms:EM URL is:https://vrh5.oracle.com:7799/em INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms:/m01/midd/oms/install/ocm/ocmInstance.txt (No such file or directory) INFO: oracle.sysman.top.oms:Command for doing Self Update registration: /m01/midd/oms/bin/emctl register oms metadata -service SelfUpdateEntityInstance -file /m01/midd/oms/install/selfUpdate/agent_software_manifest.xml -core INFO: oracle.sysman.top.oms:Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0 INFO: oracle.sysman.top.oms:Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. INFO: oracle.sysman.top.oms:SYSMAN password: SYSMAN password: Metadata registration successful INFO: oracle.sysman.top.oms:Agent software entity instance registration to Self Update is successful. INFO: oracle.sysman.top.oms: Check the OMS Configuration Assistant logs at: /m01/midd/oms/cfgtoollogs/omsca INFO: oracle.sysman.top.oms:The plug-in OMS Configuration has successfully been performed INFO: oracle.sysman.top.oms:About to execute plug-in Plugins Deployment and Configuration INFO: oracle.sysman.top.oms:The plug-in Plugins Deployment and Configuration is running INFO: oracle.sysman.top.oms:Internal PlugIn Class: oracle.sysman.oms.PluginCA INFO: oracle.sysman.top.oms:Classpath = /m01/midd/oms/sysman/jlib/omsConfig.jar INFO: oracle.sysman.top.oms:BaseConfiguration:invoke:Starting BaseConfiguration invoke method on an aggregate=oracle.sysman.top.oms for Action=configuration in step=6:microstep=0 INFO: oracle.sysman.top.oms:Fetcing ports from teh static ports file: /m01/midd/.gcinstall_temp/staticports.ini INFO: oracle.sysman.top.oms:COMMAND: /m01/midd/oms/bin/pluginca -oracleHome /m01/midd/oms -middlewareHome /m01/midd -action deploy -plugins oracle.sysman.db=12.1.0.1.0,oracle.sysman.xa=12.1.0.1.0, oracle.sysman.emas=12.1.0.1.0,oracle.sysman.mos=12.1.0.1.0, INFO: oracle.sysman.top.oms:pluginca - Plugin Configuration Tool INFO: oracle.sysman.top.oms:Oracle Enterprise Manager 12c Release 1 Grid Control INFO: oracle.sysman.top.oms:Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. INFO: oracle.sysman.top.oms:Log file: /m01/midd/oms/cfgtoollogs/pluginca/plugin_deployment_2011-10-17_08-10-26/configplugin_deploy_2011-10-17_08-10-26.log INFO: oracle.sysman.top.oms:Trace file: /m01/midd/oms/cfgtoollogs/pluginca/plugin_deployment_2011-10-17_08-10-26/configplugin_deploy_2011-10-17_08-10-26.trc INFO: oracle.sysman.top.oms:Initializing PluginCA. INFO: oracle.sysman.top.oms:Starting Deployment INFO: oracle.sysman.top.oms:Invoking pre deploy callbacks. INFO: oracle.sysman.top.oms:OMS state could be found. It is down INFO: oracle.sysman.top.oms:Performing Midtier deconfig INFO: oracle.sysman.top.oms:Performing Midtier config INFO: oracle.sysman.top.oms:Performing Midtier update oh prop INFO: oracle.sysman.top.oms:Performing Opss config INFO: oracle.sysman.top.oms:Performing Post metadata registration INFO: oracle.sysman.top.oms:Performing Post config module INFO: oracle.sysman.top.oms:Invoking post deploy callbacks. INFO: oracle.sysman.top.oms:Completed Deployment INFO: oracle.sysman.top.oms:Checking file /m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.vt_2000_0.opar INFO: oracle.sysman.top.oms:Checking file /m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.em.ssad_2000_0.opar INFO: oracle.sysman.top.oms:Checking file /m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.empa_2000_0.opar INFO: oracle.sysman.top.oms:Checking file /m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.em.sidb_2000_0.opar INFO: oracle.sysman.top.oms:Checking file /m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.emct_2000_0.opar INFO: oracle.sysman.top.oms:Checking file /m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.em.soee_2000_0.opar INFO: oracle.sysman.top.oms:Checking file /m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.ssa_2000_0.opar INFO: oracle.sysman.top.oms:Checking file /m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.emfa_2000_0.opar INFO: oracle.sysman.top.oms:The plug-in Plugins Deployment and Configuration has successfully been performed INFO: oracle.sysman.top.oms:About to execute plug-in Start Oracle Management Service INFO: oracle.sysman.top.oms:The plug-in Start Oracle Management Service is running INFO: oracle.sysman.top.oms:Internal PlugIn Class: oracle.sysman.oms.StartOMS INFO: oracle.sysman.top.oms:Classpath = /m01/midd/oms/sysman/jlib/omsConfig.jar: INFO: oracle.sysman.top.oms:BaseConfiguration:invoke:Starting BaseConfiguration invoke method on an aggregate=oracle.sysman.top.oms for Action=configuration in step=9:microstep=0 INFO: oracle.sysman.top.oms:Fetcing ports from teh static ports file: /m01/midd/.gcinstall_temp/staticports.ini INFO: oracle.sysman.top.oms:Starting OMS ... INFO: oracle.sysman.top.oms:Executing command: /m01/midd/oms/bin/emctl start oms INFO: oracle.sysman.top.oms:Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0 INFO: oracle.sysman.top.oms:Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. INFO: oracle.sysman.top.oms:Starting WebTier... INFO: oracle.sysman.top.oms:WebTier Successfully Started INFO: oracle.sysman.top.oms:Starting Oracle Management Server... INFO: oracle.sysman.top.oms:Oracle Management Server Successfully Started INFO: oracle.sysman.top.oms:Oracle Management Server is Up INFO: oracle.sysman.top.oms:Starting of OMS is successful. INFO: oracle.sysman.top.oms:The plug-in Start Oracle Management Service has successfully been performed
OMS和Agent成功配置和启动后,会要求用户执行allroot.sh脚本
# /home/oem/oraInventory/orainstRoot.sh Changing permissions of /home/oem/oraInventory Adding read,write permissions for group,Removing read,write,execute permissions for world. Changing groupname of /home/oem/oraInventory to oinstall. The execution of the script is complete /m01/midd/oms/allroot.sh Starting to execute allroot.sh ......... Starting to execute /m01/midd/oms/root.sh ...... Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= oem ORACLE_HOME= /m01/midd/oms Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. /etc exist Creating /etc/oragchomelist file... /m01/midd/oms Finished execution of /m01/midd/oms/root.sh ...... Starting to execute /m01/midd/agent/core/12.1.0.1.0/root.sh ...... Finished product-specific root actions. /etc exist Finished execution of /m01/midd/agent/core/12.1.0.1.0/root.sh ......
打开浏览器,输入地址https://hostname:7799/em(7799默认端口)访问EM Cloud Control 12c,输入sysman的身份认证
Accept License Agreement
首次登陆EM 会显示一个OverView页面:
使用如下命令停止OMS和Agent 服务:
#!/bin/bash export OMS_HOME=/m01/midd/oms export AGENT_HOME=/m01/midd/agent/core/12.1.0.1.0 $OMS_HOME/bin/emctl stop oms -all $AGENT_HOME/bin/emctl stop agent 如 [oem@vrh5 ~]$ $OMS_HOME/bin/emctl stop oms -all Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. Stopping WebTier... WebTier Successfully Stopped Stopping Oracle Management Server... Oracle Management Server Successfully Stopped AdminServer Successfully Stopped Oracle Management Server is Down [oem@vrh5 ~]$ $AGENT_HOME/bin/emctl stop agent Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. Stopping agent ..... stopped.
使用如下命令启动OMS和Agent 服务:
#!/bin/bash export OMS_HOME=/m01/midd/oms export AGENT_HOME=/m01/midd/agent/core/12.1.0.1.0 $OMS_HOME/bin/emctl start oms $AGENT_HOME/bin/emctl start agent 如 [oem@vrh5 ~]$ $OMS_HOME/bin/emctl start oms Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. Starting WebTier... WebTier Successfully Started Starting Oracle Management Server... Oracle Management Server Successfully Started Oracle Management Server is Up [oem@vrh5 ~]$ $AGENT_HOME/bin/emctl start agent Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0 Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved. Starting agent ............................. started.
Oracle安装与操作系统用户组
Oracle软件在安装维护过程中长要和操作用户组(OS user group)打交道,从早前的只有oracle用户和dba组发展到今天11gr2中的grid用户和asm组,Oracle管理的日新月异可见一斑。
我们在单实例(single-instance)环境中常用的三个操作用户组,分别是:
oinstall用户组
oinstall 组是Oracle推荐创建的OS用户组之一,建议在系统第一次安装oracle软件产品之前创建该oinstall组,理论上该oinstall组应当拥有oracle软件产品目录(例如$CRS_HOME和$ORACLE_HOME)和oracle Inventory信息目录仓库,oracle Inventory信息目录记录了系统上安装过的oracle产品的记录。关于oracle Inventory产品信息仓库更多内容可以参考<深入理解Oracle Universal Installer (OUI)>一文。
若系统中已有安装过oracle产品软件,则现有的oracle Inventory目录的所有组必须是今后用来安装新oracle软件产品的用户的主组(primary group)。
现有的oracle Inventory拥有者组可以通过/etc/oraInst.loc位置文件了解:
inventory_loc=/u01/app/oracle/oraInventory inst_group=oinstall
若/etc/oraInst.loc(少数平台不在该位置)位置文件不存在,那么建议创建oinstall用户组,注意在RAC环境中要保持各节点上用户组的gid一致:
# /usr/sbin/groupadd -g GID oinstall
OSDBA用户组(dba)
OSDBA是我们必须要创建的一种系统DBA用户组(dba),若没有该用户组我们将无法安装数据库软件及执行管理数据库的任务。
OSOPER用户组(oper)
OSOPER是一种额外的用户组(oper),我们可以选择要不要创建该用户组,创建该用户组可以满足让os用户行使某些数据库管理权限(包括SYSOPER角色权限)的目的。注意SYSOPER的权限包括startup和shutdown,所以要小心为该用户组添加成员。
创建OSOPER用户组的方法:
# /usr/sbin/groupadd oper
综上所述在单机环境(single-instance)中oracle软件拥有者用户(常见的oracle或者orauser),因该同时是oinstall、dba、oper用户组的成员。同时该用户的主用户组必须是oinstall。
Oracle Database 11g release 2中选择Privileged Operating System Groups
而在11.2的GI/CRS环境中数据库软件拥有者用户(oracle或orauser)还必须是asmdba用户组的成员。
usermod -g oinstall -G dba,oper,asmdba [oracle|orauser] id oracle uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),701(asmdba),54324(oper)
注意OSDBA和OSOPER用户组都受到$ORACLE_HOME/rdbms/lib/config.c 源文件的影响,该文件定义了默认的 SS_DBA_GRP “dba” 和SS_OPER_GRP “oper”,该源文件内容如下:
/* Refer to the Installation and User's Guide for further information. */ /* IMPORTANT: this file needs to be in sync with rdbms/src/server/osds/config.c, specifically regarding the number of elements in the ss_dba_grp array. */ #define SS_DBA_GRP "dba" #define SS_OPER_GRP "oper" #define SS_ASM_GRP "" char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP, SS_ASM_GRP}; ~
11g release2中oracle建议独立地管理Grid Infrastructure和ASM实例,因此有必要创建更多的os用户组以满足不同的权限分配。
我们在11.2的GI中常用的ASM用户组有以下三个:
OSASM(asmadmin)用户组
如果使用ASM,那么我们必须创建osasm(asmadmin)用户组,该OSASM用户组的成员将被赋予SYSASM权限,以满足组成员管理Oracle Clusterware和Oracle ASM的权限需求。
OSDBA for ASM group(asmdba)用户组
OSDBA(asmdba)用户组的成员将被赋予读写访问ASM文件的权限。GI/CRS拥有者用户和所有oracle数据库软件的拥有者必须是该组的成员。同时所有OSDBA(dba)用户组的成员也必须是asmdba组的成员。
OSOPER for ASM(asmoper)用户组
asmoper和osoper类似都是额外的可选择创建的用户组,创建该独立的用户组以满足赋予用户一套受限的ASM实例管理权限(ASM的SYSOPER角色),该权限包括了启动和停止ASM实例,默认情况下OSASM(asmadmin)组成员将拥有所有SYSOPER的ASM管理权限。
在11.2的GI/CRS环境中一般会创建grid或griduser用户来管理GI软件和ASM实例,以如下方式创建grid用户:
useradd -g oinstall -G asmadmin,asmdba,asmoper grid id grid uid=54322(grid) gid=54321(oinstall) groups=54321(oinstall),700(asmadmin),701(asmdba),55000(asmoper)
Oracle 11g release2 Grid Infrastructure中选择Privileged Operating System Groups:
综合上述OS用户和用户组间的关系:
更多内容可以参考下文:
The OSDBA group (typically, dba)
You must create this group the first time you install Oracle Database software on the system. This group identifies operating system user accounts that have database administrative privileges (the SYSDBA privilege). If you do not create separate OSDBA, OSOPER and OSASM groups for the Oracle ASM instance, then operating system user accounts that have the SYSOPER and SYSASM privileges must be members of this group. The name used for this group in Oracle code examples is dba. If you do not designate a separate group as the OSASM group, then the OSDBA group you define is also by default the OSASM group.
To specify a group name other than the default dba group, then you must choose the Advanced installation type to install the software or start Oracle Universal Installer (OUI) as a user that is not a member of this group. In this case, OUI prompts you to specify the name of this group.
Members of the OSDBA group formerly were granted SYSASM privileges on Oracle ASM instances, including mounting and dismounting disk groups. This privileges grant is removed with Oracle Grid Infrastructure 11g release 2, if different operating system groups are designated as the OSDBA and OSASM groups. If the same group is used for both OSDBA and OSASM, then the privilege is retained.
The OSOPER group for Oracle Database (typically, oper)
This is an optional group. Create this group if you want a separate group of operating system users to have a limited set of database administrative privileges (the SYSOPER privilege). By default, members of the OSDBA group also have all privileges granted by the SYSOPER privilege.
To use the OSOPER group to create a database administrator group with fewer privileges than the default dba group, then you must choose the Advanced installation type to install the software or start OUI as a user that is not a member of the dba group. In this case, OUI prompts you to specify the name of this group. The usual name chosen for this group is oper.
The Oracle Automatic Storage Management Group (typically asmadmin)
This is a required group. Create this group as a separate group if you want to have separate administration privilege groups for Oracle ASM and Oracle Database administrators. In Oracle documentation, the operating system group whose members are granted privileges is called the OSASM group, and in code examples, where there is a group specifically created to grant this privilege, it is referred to as asmadmin.
If you have multiple databases on your system, and use multiple OSDBA groups so that you can provide separate SYSDBA privileges for each database, then you should create a separate OSASM group, and use a separate user from the database users to own the Oracle Grid Infrastructure installation (Oracle Clusterware and Oracle ASM). Oracle ASM can support multiple databases.
Members of the OSASM group can use SQL to connect to an Oracle ASM instance as SYSASM using operating system authentication. The SYSASM privileges permit mounting and dismounting disk groups, and other storage administration tasks. SYSASM privileges provide no access privileges on an RDBMS instance.
The Oracle ASM Database Administrator group (OSDBA for ASM, typically asmdba)
Members of the Oracle ASM Database Administrator group (OSDBA for ASM) are granted read and write access to files managed by Oracle ASM. The Oracle Grid Infrastructure installation owner and all Oracle Database software owners must be a member of this group, and all users with OSDBA membership on databases that have access to the files managed by Oracle ASM must be members of the OSDBA group for ASM.
Members of the Oracle ASM Operator Group (OSOPER for ASM, typically asmoper)
This is an optional group. Create this group if you want a separate group of operating system users to have a limited set of Oracle ASM instance administrative privileges (the SYSOPER for ASM privilege), including starting up and stopping the Oracle ASM instance. By default, members of the OSASM group also have all privileges granted by the SYSOPER for ASM privilege.
To use the Oracle ASM Operator group to create an ASM administrator group with fewer privileges than the default asmadmin group, then you must choose the Advanced installation type to install the software, In this case, OUI prompts you to specify the name of this group. In code examples, this group is asmoper.
An Oracle central inventory group, or oraInventory group (oinstall). Members who have the central inventory group as their primary group, are granted the OINSTALL permission to write to the oraInventory directory.
A single system privileges group that is used as the OSASM, OSDBA, OSDBA for ASM, and OSOPER for ASM group (dba), whose members are granted the SYSASM and SYSDBA privilege to administer Oracle Clusterware, Oracle ASM, and Oracle Database, and are granted SYSASM and OSOPER for ASM access to the Oracle ASM storage.
An Oracle grid installation for a cluster owner (grid), with the oraInventory group as its primary group, and with the OSASM group as the secondary group, with its Oracle base directory /u01/app/grid.
An Oracle Database owner (oracle) with the oraInventory group as its primary group, and the OSDBA group as its secondary group, with its Oracle base directory /u01/app/oracle.
/u01/app owned by grid:oinstall with 775 permissions before installation, and by root after the root.sh script is run during installation. This ownership and permissions enables OUI to create the Oracle Inventory directory, in the path /u01/app/oraInventory.
/u01 owned by grid:oinstall before installation, and by root after the root.sh script is run during installation.
/u01/app/11.2.0/grid owned by grid:oinstall with 775 permissions. These permissions are required for installation, and are changed during the installation process.
/u01/app/grid owned by grid:oinstall with 775 permissions before installation, and 755 permissions after installation.
/u01/app/oracle owned by oracle:oinstall with 775 permissions.
An Oracle central inventory group, or oraInventory group (oinstall), whose members that have this group as their primary group are granted permissions to write to the oraInventory directory.
A separate OSASM group (asmadmin), whose members are granted the SYSASM privilege to administer Oracle Clusterware and Oracle ASM.
A separate OSDBA for ASM group (asmdba), whose members include grid, oracle1 and oracle2, and who are granted access to Oracle ASM.
A separate OSOPER for ASM group (asmoper), whose members are granted limited Oracle ASM administrator privileges, including the permissions to start and stop the Oracle ASM instance.
An Oracle grid installation for a cluster owner (grid), with the oraInventory group as its primary group, and with the OSASM (asmadmin), OSDBA for ASM (asmdba) group as a secondary group.
Two separate OSDBA groups for two different databases (dba1 and dba2) to establish separate SYSDBA privileges for each database.
Two Oracle Database software owners (oracle1 and oracle2), to divide ownership of the Oracle database binaries, with the OraInventory group as their primary group, and the OSDBA group for their database (dba1 or dba2) and the OSDBA for ASM group (asmdba) as their secondary groups.
An OFA-compliant mount point /u01 owned by grid:oinstall before installation.
An Oracle base for the grid installation owner /u01/app/grid owned by grid:oinstall with 775 permissions, and changed during the installation process to 755 permissions.
An Oracle base /u01/app/oracle1 owned by oracle1:oinstall with 775 permissions.
An Oracle base /u01/app/oracle 2 owned by oracle2:oinstall with 775 permissions.
A Grid home /u01/app/11.2.0/grid owned by grid:oinstall with 775 (drwxdrwxr-x) permissions. These permissions are required for installation, and are changed during the installation process to root:oinstall with 755 permissions (drwxr-xr-x).
/u01/app/oraInventory. This path remains owned by grid:oinstall, to enable other Oracle software owners to write to the central inventory.
How to recover from root.sh on 11.2 Grid Infrastructure Failed
从10g的clusterware到11g Release2的Grid Infrastructure,Oracle往RAC这个框架里塞进了太多东西。虽然照着Step by Step Installation指南步步为营地去安装11.2.0.1的GI,但在实际执行root.sh脚本的时候,不免又要出现这样那样的错误。例如下面的一例:
[root@rh3 grid]# ./root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= maclean ORACLE_HOME= /u01/app/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. 2011-03-28 20:43:13: Parsing the host name 2011-03-28 20:43:13: Checking for super user privileges 2011-03-28 20:43:13: User has super user privileges Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params LOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Adding daemon to inittab CRS-4123: Oracle High Availability Services has been started. ohasd is starting ADVM/ACFS is not supported on oraclelinux-release-5-5.0.2
一个节点上的root.sh脚本运行居然提示说ADVM/ACFS不支持OEL 5.5,但实际上Redhat 5或者OEL 5是目前仅有的少数支持ACFS的平台(The ACFS install would be on a supported Linux release – either Oracle Enterprise Linux 5 or Red Hat 5)。
检索Metalink发现这是一个Linux平台上的Bug 9474252: ‘ACFSLOAD START’ RETURNS “ADVM/ACFS IS NOT SUPPORTED ON DHL-RELEASE-…”。
因为以上Not Supported错误信息在另外一个节点(也是Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)) 运行root.sh脚本时并未出现,那么一般只要找出2个节点间的差异就可能解决问题了:
未出错节点上release相关rpm包的情况 [maclean@rh6 tmp]$ cat /etc/issue Enterprise Linux Enterprise Linux Server release 5.5 (Carthage) Kernel \r on an \m [maclean@rh6 tmp]$ rpm -qa|grep release enterprise-release-notes-5Server-17 enterprise-release-5-0.0.22 出错节点上release相关rpm包的情况 [root@rh3 tmp]# rpm -qa | grep release oraclelinux-release-5-5.0.2 enterprise-release-5-0.0.22 enterprise-release-notes-5Server-17
以上可以看到相比起没有出错的节点,出错节点上多安装了一个名为oraclelinux-release-5-5.0.2的rpm包,我们尝试来卸载该rpm是否能解决问题,补充实际上该问题也可以通过修改/tmp/.linux_release文件的内容为enterprise-release-5-0.0.17来解决,而无需如我们这里做的卸载名为oraclelinux-release-5*的rpm软件包:
[root@rh3 install]# rpm -e oraclelinux-release-5-5.0.2 [root@rh3 grid]# ./root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= maclean ORACLE_HOME= /u01/app/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. 2011-03-28 20:57:21: Parsing the host name 2011-03-28 20:57:21: Checking for super user privileges 2011-03-28 20:57:21: User has super user privileges Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params CRS is already configured on this node for crshome=0 Cannot configure two CRS instances on the same cluster. Please deconfigure before proceeding with the configuration of new home.
再次在失败节点上运行root.sh,被提示告知需要首先deconfigure然后才能再次配置。在官方文档<Oracle Grid Infrastructure Installation Guide 11g Release 2>中介绍了如何反向配置11g release 2中的Grid Infrastructure(Deconfiguring Oracle Clusterware Without Removing Binaries):
/* 同为管理Grid Infra所以仍需要root用户来执行以下操作 */ [root@rh3 grid]# pwd /u01/app/11.2.0/grid /* 目前位于GRID_HOME目录下 */ [root@rh3 grid]# cd crs/install /* 以-deconfig选项执行一个名为rootcrs.pl的脚本 */ [root@rh3 install]# ./rootcrs.pl -deconfig 2011-03-28 21:03:05: Parsing the host name 2011-03-28 21:03:05: Checking for super user privileges 2011-03-28 21:03:05: User has super user privileges Using configuration parameter file: ./crsconfig_params VIP exists.:rh3 VIP exists.: //192.168.1.105/255.255.255.0/eth0 VIP exists.:rh6 VIP exists.: //192.168.1.103/255.255.255.0/eth0 GSD exists. ONS daemon exists. Local port 6100, remote port 6200 eONS daemon exists. Multicast port 20796, multicast IP address 234.227.83.81, listening port 2016 Please confirm that you intend to remove the VIPs rh3 (y/[n]) y ACFS-9200: Supported CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rh3' CRS-2673: Attempting to stop 'ora.crsd' on 'rh3' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rh3' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rh3' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rh3' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rh3' has completed CRS-2677: Stop of 'ora.crsd' on 'rh3' succeeded CRS-2673: Attempting to stop 'ora.mdnsd' on 'rh3' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rh3' CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rh3' CRS-2673: Attempting to stop 'ora.ctssd' on 'rh3' CRS-2673: Attempting to stop 'ora.evmd' on 'rh3' CRS-2677: Stop of 'ora.cssdmonitor' on 'rh3' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'rh3' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rh3' succeeded CRS-2677: Stop of 'ora.evmd' on 'rh3' succeeded CRS-2677: Stop of 'ora.ctssd' on 'rh3' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rh3' CRS-2677: Stop of 'ora.cssd' on 'rh3' succeeded CRS-2673: Attempting to stop 'ora.diskmon' on 'rh3' CRS-2673: Attempting to stop 'ora.gipcd' on 'rh3' CRS-2677: Stop of 'ora.gipcd' on 'rh3' succeeded CRS-2677: Stop of 'ora.diskmon' on 'rh3' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rh3' has completed CRS-4133: Oracle High Availability Services has been stopped. Successfully deconfigured Oracle clusterware stack on this node /* 如果以上deconfig操作未能成功反向配置那么可以以-FORCE选项执行rootcrs.pl脚本 */ [root@rh3 install]# ./rootcrs.pl -deconfig -force 2011-03-28 21:41:00: Parsing the host name 2011-03-28 21:41:00: Checking for super user privileges 2011-03-28 21:41:00: User has super user privileges Using configuration parameter file: ./crsconfig_params VIP exists.:rh3 VIP exists.: //192.168.1.105/255.255.255.0/eth0 VIP exists.:rh6 VIP exists.: //192.168.1.103/255.255.255.0/eth0 GSD exists. ONS daemon exists. Local port 6100, remote port 6200 eONS daemon exists. Multicast port 20796, multicast IP address 234.227.83.81, listening port 2016 ACFS-9200: Supported CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rh3' CRS-2673: Attempting to stop 'ora.crsd' on 'rh3' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rh3' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rh3' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rh3' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rh3' has completed CRS-2677: Stop of 'ora.crsd' on 'rh3' succeeded CRS-2673: Attempting to stop 'ora.mdnsd' on 'rh3' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rh3' CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rh3' CRS-2673: Attempting to stop 'ora.ctssd' on 'rh3' CRS-2673: Attempting to stop 'ora.evmd' on 'rh3' CRS-2677: Stop of 'ora.cssdmonitor' on 'rh3' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'rh3' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rh3' succeeded CRS-2677: Stop of 'ora.evmd' on 'rh3' succeeded CRS-2677: Stop of 'ora.ctssd' on 'rh3' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rh3' CRS-2677: Stop of 'ora.cssd' on 'rh3' succeeded CRS-2673: Attempting to stop 'ora.diskmon' on 'rh3' CRS-2673: Attempting to stop 'ora.gipcd' on 'rh3' CRS-2677: Stop of 'ora.gipcd' on 'rh3' succeeded CRS-2677: Stop of 'ora.diskmon' on 'rh3' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rh3' has completed CRS-4133: Oracle High Availability Services has been stopped. Successfully deconfigured Oracle clusterware stack on this node /* 所幸以上这招总是能够奏效,否则岂不是每次都要完全卸载后重新安装GI? */
顺利完成以上反向配置CRS后,就可以再次尝试运行多灾多难的root.sh了:
[root@rh3 grid]# pwd /u01/app/11.2.0/grid [root@rh3 grid]# ./root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= maclean ORACLE_HOME= /u01/app/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. 2011-03-28 21:07:29: Parsing the host name 2011-03-28 21:07:29: Checking for super user privileges 2011-03-28 21:07:29: User has super user privileges Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params LOCAL ADD MODE Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Adding daemon to inittab CRS-4123: Oracle High Availability Services has been started. ohasd is starting FATAL: Module oracleoks not found. FATAL: Module oracleadvm not found. FATAL: Module oracleacfs not found. acfsroot: ACFS-9121: Failed to detect /dev/asm/.asm_ctl_spec. acfsroot: ACFS-9310: ADVM/ACFS installation failed. acfsroot: ACFS-9311: not all components were detected after the installation. CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node rh6, number 1, and is terminating An active cluster was found during exclusive startup, restarting to join the cluster CRS-2672: Attempting to start 'ora.mdnsd' on 'rh3' CRS-2676: Start of 'ora.mdnsd' on 'rh3' succeeded CRS-2672: Attempting to start 'ora.gipcd' on 'rh3' CRS-2676: Start of 'ora.gipcd' on 'rh3' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'rh3' CRS-2676: Start of 'ora.gpnpd' on 'rh3' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rh3' CRS-2676: Start of 'ora.cssdmonitor' on 'rh3' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rh3' CRS-2672: Attempting to start 'ora.diskmon' on 'rh3' CRS-2676: Start of 'ora.diskmon' on 'rh3' succeeded CRS-2676: Start of 'ora.cssd' on 'rh3' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'rh3' CRS-2676: Start of 'ora.ctssd' on 'rh3' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rh3' CRS-2676: Start of 'ora.crsd' on 'rh3' succeeded CRS-2672: Attempting to start 'ora.evmd' on 'rh3' CRS-2676: Start of 'ora.evmd' on 'rh3' succeeded /u01/app/11.2.0/grid/bin/srvctl start vip -i rh3 ... failed Preparing packages for installation... cvuqdisk-1.0.7-1 Configure Oracle Grid Infrastructure for a Cluster ... failed Updating inventory properties for clusterware Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 5023 MB Passed The inventory pointer is located at /etc/oraInst.loc The inventory is located at /s01/oraInventory 'UpdateNodeList' was successful.
以上虽然绕过了”ADVM/ACFS is not supported”的问题,但又出现了”FATAL: Module oracleoks/oracleadvm/oracleacfs not found”,Linux下ACFS/ADVM相关加载Module无法找到的问题,查了下metalink发现这是GI 11.2.0.2中2个被确认的bug 10252497或bug 10266447,而实际我所安装的是11.2.0.1版本的GI…….. 好了,所幸我目前的环境是使用NFS的存储,所以如ADVM/ACFS这些存储选项的问题可以忽略不计,准备在11.2.0.2上再测试下。
不得不说11.2.0.1版本GI的安装存在太多的问题,以至于Oracle Support不得不撰写了不少相关故障诊断的文档,例如:<Troubleshooting 11.2 Grid Infastructure Installation Root.sh Issues [ID 1053970.1]>,<How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation [ID 942166.1]>。目前为止还没体验过11.2.0.2的GI,希望它不像上一个版本那么糟糕!
Unix平台上OUI启动常见问题
Oracle Universal Installer是一种基于Java的图形界面应用程序,OUI为Oracle软件的安装、管理提供了统一的接口。在Unix平台上安装Oracle database software时,因为实际操作系统的差异,往往会出现OUI无法正常启动的问题,在这里我列出几种常见的启动问题和解决方案。
1.Itanium Montecito processors引起的JRE问题:在安腾平台上执行runInstaller启动OUI时会出现Java HotSpot错误如下:
An unexpected error has been detected by HotSpot Virtual Machine:
SIGILL (0x4) at pc=0x2000000000039a4070 pid=11459 tid=2305843009213968960
原因是9iR2,10gR1/R2自带的JRE在Montecito处理器相关的操作系统如Windows/Linux Itanium上存在Bug,该Bug在SUN JDK版本1.4.2_11(b02)中得到修复;如果遇到以上问题,那么可以follow 以下Metalink文档:
How To Install Oracle RDBMS Software On Itanium Servers With Montecito Processors [ID 400227.1]
How To Identify A Server Which Has Itanium2 (Montecito, Montvale, Tukwila….) Processors Installed [ID 401332.1]
2.DISPLAY显示环境变量设置不当导致图形界面无法显示,可以通过安装例如Xmanager的软件解决;也可以follow以下Metalink文档:
FAQ: X Server Testing and Troubleshooting [ID 153960.1]
3.临时目录/tmp空间应至少有400MB空间,且Oracle software安装用户对该目录有读写权限;在无奈之下可以通过修改用户的临时目录环境必变量$TMP来workaround:
Unable To Start OUI: not enough room in /tmp [ID 339657.1]
How To Set Temporary Space Directory [ID 177902.1]
4.必要时以”-debug”调试选项来调用OUI,通过阅读详细的OUI bootstrap引导流程日志以确认和保证以下2点:
- 在JRE解压阶段没有出现错误
- 在调用java命令启动OUI java图形界面阶段没有出现错误
如以下DEBUG示例:
[maclean@rh8 database]$ cd database [maclean@rh8 database]$ ./runInstaller -debug > debug.log Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-03-17_03-12-17PM. Please wait ...Archive: ../stage/Components/oracle.jdk/1.5.0.1.1/1/DataFiles/lib.jar inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/lib/dt.jar inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/lib/htmlconverter.jar inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/lib/ir.idl inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/lib/jconsole.jar inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/lib/orb.idl inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/lib/sa-jdi.jar inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/lib/tools.jar Archive: ../stage/Components/oracle.jdk/1.5.0.1.1/1/DataFiles/jre.jar EMPTY_DIR inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/jre/CHANGES inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/jre/COPYRIGHT inflating: /tmp/OraInstall2011-03-17_03-12-17PM/jdk/jre/LICENSE .................. LD_LIBRARY_PATH environment variable : ------------------------------------------------------- Total args: 22 Command line argument array elements ... Arg:0:/tmp/OraInstall2011-03-17_03-12-17PM/jdk/jre/bin/java: Arg:1:-Doracle.installer.library_loc=/tmp/OraInstall2011-03-17_03-12-17PM/oui/lib/linux: Arg:2:-Doracle.installer.oui_loc=/tmp/OraInstall2011-03-17_03-12-17PM/oui: Arg:3:-Doracle.installer.bootstrap=TRUE: Arg:4:-Doracle.installer.startup_location=/home/maclean/Downloads/database/install: Arg:5:-Doracle.installer.jre_loc=/tmp/OraInstall2011-03-17_03-12-17PM/jdk/jre: Arg:6:-Doracle.installer.nlsEnabled="TRUE": Arg:7:-Doracle.installer.prereqConfigLoc= : Arg:8:-Doracle.installer.unixVersion=2.6.35.11-83.fc14.i686: Arg:9:-mx150m: Arg:10:-cp: Arg:11:/tmp/OraInstall2011-03-17_03-12-17PM::/tmp/OraInstall2011-03-17_03-12-17PM/ext/jlib/orai18n-mapping.jar:/tmp/OraInstall2011-03-17_03-12-17PM/ext/jlib/orai18n-utility.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/OraInstaller.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/oneclick.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/xmlparserv2.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/share.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/OraInstallerNet.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/emCfg.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/OraPrereq.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/jsch.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/ssh.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/remoteinterfaces.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/http_client.jar:../stage/Components/oracle.swd.opatch/11.1.0.6.0/1/DataFiles/jlib/opatch.jar:../stage/Components/oracle.swd.opatch/11.1.0.6.0/1/DataFiles/jlib/opatchactions.jar:../stage/Components/oracle.swd.opatch/11.1.0.6.0/1/DataFiles/jlib/opatchprereq.jar:../stage/Components/oracle.swd.opatch/11.1.0.6.0/1/DataFiles/jlib/opatchutil.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstImages.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp_de.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp_es.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp_fr.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp_it.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp_ja.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp_ko.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp_pt_BR.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp_zh_CN.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/InstHelp_zh_TW.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/oracle_ice.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/help4.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/help4-nls.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/ewt3.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/ewt3-swingaccess.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/ewt3-nls.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/swingaccess.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/classes12.jar::/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/jewt4.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/jewt4-nls.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/orai18n-collation.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/orai18n-mapping.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/ojmisc.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/xml.jar:/tmp/OraInstall2011-03-17_03-12-17PM/oui/jlib/srvm.jar: Arg:12:oracle.sysman.oii.oiic.OiicInstaller: Arg:13:-scratchPath: Arg:14:/tmp/OraInstall2011-03-17_03-12-17PM: Arg:15:-sourceLoc: Arg:16:/home/maclean/Downloads/database/install/../stage/products.xml: Arg:17:-sourceType: Arg:18:network: Arg:19:-timestamp: Arg:20:2011-03-17_03-12-07PM: Arg:21:-debug: ------------------------------------------------------- Initializing Java Virtual Machine from /tmp/OraInstall2011-03-17_03-12-07PM/jdk/jre/bin/java. Please wait... [maclean@rh8 database]$ Oracle Universal Installer, Version 11.1.0.6.0 Production Copyright (C) 1999, 2007, Oracle. All rights reserved.
若以上JRE解压顺利完成但OUI仍无法启动图形欢迎界面(一般来说由java命令失败引起),那么很有可能是安装工具自带的JRE在目标系统上无法正常工作。建议客户自行安装目标系统上最新可用的JDK软件,并使用runInstaller的”-jreloc”选项以workaround。
5.为了进一步确认JRE的问题,我们可能需要将安装介质中自带的JRE手动解压出来并测试其java命令的可用性;可以通过如下流程测试:
/* 首先通过oraparam.ini配置文件了解介质自带JRE jar包所在路径 */ [maclean@rh8 tmp]$ cat database/install/oraparam.ini |grep JRE_LOCATION JRE_LOCATION=../stage/Components/oracle.swd.jre/1.4.2.8.0/1/DataFiles [maclean@rh8 tmp]$ ls database/stage/Components/oracle.swd.jre/1.4.2.8.0/1/DataFiles/ filegroup1.jar filegroup2.jar filegroup3.jar filegroup4.jar filegroup5.jar [maclean@rh8 tmp]$ mkdir /tmp/jre_test [maclean@rh8 tmp]$ cp database/stage/Components/oracle.swd.jre/1.4.2.8.0/1/DataFiles/*.jar /tmp/jre_test [maclean@rh8 tmp]$ cd /tmp/jre_test [maclean@rh8 jre_test]$ unzip filegroup1.jar Archive: filegroup1.jar inflating: jre/1.4.2/bin/ControlPanel inflating: jre/1.4.2/bin/java inflating: jre/1.4.2/bin/java_vm inflating: jre/1.4.2/bin/keytool inflating: jre/1.4.2/bin/kinit inflating: jre/1.4.2/bin/klist inflating: jre/1.4.2/bin/ktab inflating: jre/1.4.2/bin/orbd inflating: jre/1.4.2/bin/policytool inflating: jre/1.4.2/bin/rmid inflating: jre/1.4.2/bin/rmiregistry inflating: jre/1.4.2/bin/servertool inflating: jre/1.4.2/bin/tnameserv /* 使用unzip命令依次解压copy过来的jar文件,会出现jre目录 */ [maclean@rh8 jre_test]$ ls filegroup1.jar filegroup2.jar filegroup3.jar filegroup4.jar filegroup5.jar jre [maclean@rh8 jre_test]$ cd jre/1.4.2/bin [maclean@rh8 bin]$ chmod u+x java [maclean@rh8 bin]$ ./java -version java version "1.4.2_08" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_08-b03) Java HotSpot(TM) Client VM (build 1.4.2_08-b03, mixed mode) /* 可以看到在我们的场景中java命令运行正常 */
若以上测试的最后结果中java命令出错则说明Oracle安装介质自带的JRE存在问题,这可能是个例,在安装介质传输过程中出现网络错误所导致的文件损坏可能引起以上问题;可以通过checksum等方式验证安装介质包/ISO文件无误。若经过验证发现安装介质没有损坏,那么很有可能是自带JRE在目标操作系统上无法正常运行,用户可以到java.sun.com网站去下载指定平台最新可用的JDK软件,在成功安装后JDK后再次尝试以”-jreloc”选项启动runInstaller程序,命令示例如下:
./runInstaller -debug -jreLoc <JRE Install Home>
11gr1 installation failed on Fedora 14 with libnnz11.so could not read symbols
尝试把桌面迁移到Fedora 14上,在安装11g r1数据库软件时遭遇了libnnz11.so: could not read symbols: Invalid operation错误,OUI部分日志如下:
INFO: gcc -o /u01/app/maclean/product/11.1.0/db_1/sysman/lib/emdctl -L/u01/app/maclean/product/11.1.0/db_1/lib/ -L/u01/app/maclean/product/11.1.0/db_1/sysman/lib/ -L/u01/app/maclean/product/11.1.0/db_1/lib/stubs/ `cat /u01/app/maclean/product/11.1.0/db_1/lib/sysliblist` -Wl,-rpath,/u01/app/maclean/product/11.1.0/db_1/lib -lm `cat /u01/app/maclean/product/11.1.0/db_1/lib/sysliblist` -ldl -lm -L/u01/app/maclean/product/11.1.0/db_1/lib /u01/app/maclean/product/11.1.0/db_1/sysman/lib//s0nmectl.o -lnmectl - INFO: lclntsh -L/u01/app/maclean/product/11.1.0/db_1/lib -L/u01/app/maclean/product/11.1.0/db_1/sysman/lib/ -lnmemso -lcore11 -Wl,-rpath,/u01/app/maclean/product/11.1.0/db_1/lib/:/u01/app/maclean/product/11.1.0/db_1/sysman/lib/:/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386/client:/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386 -L/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386/client -L/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386 -z lazyload -ljava -ljvm -lverify -z nolazyload -Wl,-rp INFO: ath,/u01/app/maclean/product/11.1.0/db_1/lib/:/u01/app/maclean/product/11.1.0/db_1/sysman/lib/:/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386/client:/u01/app/maclean/product/11.1.0/db_1/jdk/jre/lib/i386 -Wl,--allow-shlib-undefined `cat /u01/app/maclean/product/11.1.0/db_1/lib/sysliblist` -ldl -lm INFO: /usr/bin/ld: /u01/app/maclean/product/11.1.0/db_1/sysman/lib//libnmectl.a(nmectlt.o): undefined reference to symbol 'B_DestroyKeyObject' /usr/bin/ld: note: 'B_DestroyKeyObject' is defined in DSO /u01/app/maclean/product/11.1.0/db_1/lib/libnnz11.so so try adding it to the linker command line /u01/app/maclean/product/11.1.0/db_1/lib/libnnz11.so: could not read symbols: Invalid operation INFO: collect2: ld returned 1 exit status INFO: make[1]: *** [/u01/app/maclean/product/11.1.0/db_1/sysman/lib/emdctl] Error 1 INFO: make[1]: Leaving directory `/u01/app/maclean/product/11.1.0/db_1/sysman/lib' INFO: make: *** [emdctl] Error 2 INFO: End output from spawned process. INFO: ---------------------------------- INFO: Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target 'agent tclexec' of makefile '/u01/app/maclean/product/11.1.0/db_1/sysman/lib/ins_emagent.mk'. See '/u01/oraInventory/logs/installActions2011-03-15_09-59-46PM.log' for details. Exception Severity: 1
google了一下网上的解决方法,需要手动修改make文件ins_emagent.mk,该文件位于$ORACLE_HOME/sysman/lib/ins_emagent.mk,找出该文件中的以下部分并修改:
$(SYSMANBIN)emdctl: $(MK_EMAGENT_NMECTL) 修改为 $(SYSMANBIN)emdctl: $(MK_EMAGENT_NMECTL) -lnnz11 之后重新编译该agent部分模块: make -f ins_emagent.mk "agent"
oracle安装介质及补丁集下载地址补全版
Oracle 8i For AIX/Linux/Unix/Windows的安装介质 OR CDROM目前在Oracle官网或者edelivery上已经没有下载了:
0-For AIX/0-64/Oracle/Oracle817CD1.nrg 0-For AIX/0-64/Oracle/Oracle817CD2.nrg 0-For AIX/0-64/Oracle/Oracle_816.nrg oracle817 for unix.ISO #oracle817_for_Intel UNIX (DGUX Intel,SCO UnixWare,Solaris Intel).ISO p2376472_8174_AIX p2376472_8174_AIX64.zip p2376472_8174_AIX.zip linux81701.tar
有不少学习研究Oracle的朋友,苦于没有metalink账号无法下载补丁集等软件;网上曾有总结过安装介质和补丁集的下载地址的文章,可以使用迅雷或快车等软件下载到介质,针对最新的11g release 2和未辑录的平台相关补丁集,进行了一定的补全。
这里共享的链接来自于oracle官方网站,仅供研究和非商业用途之用。
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows XP 2003/Windows Server 2003 (64-bit)
http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk2.zip
Oracle9i Database Release 2 Enterprise/Standard Edition for Intel Linux
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk1.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk2.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk3.cpio.gz
Oracle9i Database Release 2 (9.2.0.4) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk1.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk2.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk3.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX – Based 4.3.3 Systems (64-bit)
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk1.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk2.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk3.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk4.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX- Based 5L Systems
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-01.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-02.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-03.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-04.zip
Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (32-bit)
http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk1.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk2.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk3.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (64-bit)
http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk1.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk2.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk3.cpio.gz
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (x64)
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_database.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_client.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_clusterware.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_clusterware_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux_x86_64.cpio.gz
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for AIX5L
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_database.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_client.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_cluster.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_gateways.cpio.gz
Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86)
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_database_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_client_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_clusterware_solx86.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (x86-64)
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_database_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_client_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_clusterware_solx86_64.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for HP-UX PA-RISC
http://download.oracle.com/otn/hp/oracle10g/10201/10201_database.zip
http://download.oracle.com/otn/hp/oracle10g/10201/10201_clusterware.zip
http://download.oracle.com/otn/hp/oracle10g/10201/10201_client.zip
Oracle Database 10g Release 2 (10.2.0.1) Enterprise/Standard Edition for HP-UX Itanium
http://download.oracle.com/otn/hp/oracle10g/10201/itanium/10gr2_database_hpi.zip
http://download.oracle.com/otn/hp/oracle10g/10201/itanium/10gr2_client_hpi.zip
http://download.oracle.com/otn/hp/oracle10g/10201/itanium/10gr2_clusterware_hpi.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (SPARC) (64-bit)
http://download.oracle.com/otn/solaris/oracle10g/10201/sol64/10gr2_db_sol.cpio.gz
http://download.oracle.com/otn/solaris/oracle10g/10201/sol64/10gr2_client_sol.cpio.gz
http://download.oracle.com/otn/solaris/oracle10g/10201/sol64/10gr2_cluster_sol.cpio.gz
Oracle Database 10g Release 2 (10.2.0.4.0) for MAC OS X on Intel x86-64
http://download.oracle.com/otn/mac/oracle10g/10204/x86_64/db.zip
http://download.oracle.com/otn/mac/oracle10g/10204/x86_64/client.zip
Oracle Database 10g Release 2 (10.2.0.4.0) Enterprise/Standard Edition for Microsoft Windows Vista x64 and Microsoft Windows Server 2008 x64
http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_db.zip
http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_client.zip
http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_crs.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (64-bit)
http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_2of2.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_client.zip
no grid
Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_client.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_client.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Solaris Operating System (SPARC) (64-bit)
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_database_1of2.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_database_2of2.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_client.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_client32.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Solaris Operating System (x86-64)
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x64_11gR2_database_1of2.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x64_11gR2_database_2of2.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x64_11gR2_client.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x86_11gR2_client.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for HP-UX Itanium
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_database_1of2.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_database_2of2.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_client.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_client32.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for HP-UX PA-RISC (64-bit)
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc64_11gR2_database_1of2.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc64_11gR2_database_2of2.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc64_11gR2_client.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc32_11gR2_client.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for AIX (PPC64)
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc64_11gR2_database_1of2.zip
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc64_11gR2_database_2of2.zip
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc64_11gR2_client.zip
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc32_11gR2_client.zip
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc64_11gR2_grid.zip
以下为9208,10203,10204在使用较广泛平台上补丁集:
ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HP64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HPUX-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-x86-64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_MVS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT64.zip
oracle 10.2.0.3 patch
ftp://updates.oracle.com/5337014/p5337014_10203_AIX5L.zip
ftp://updates.oracle.com/5337014/p5337014_10203_HPUX-IA64.zip
ftp://updates.oracle.com/5337014/p5337014_10203_LINUX.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Linux-x86-64.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Linux-x86.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Win32.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Win64.zip
oracle 10.2.0.4 patch:
ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_LINUX.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solarisx86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris86-64.zip
10.2.0.5各平台的补丁可以从官方地址下载
Building a RAC Test Environment on VMWare For Free
•VMWare Orientation
•Importance of prerequisite checking
•Configuring node #1
•Cloning (VM) node #1
•Installing Clusterware
•Installing ASM and Database
•Creating Database
•Common Challenges and Issues
VMWare Orientation
•Desktop Products
–VMWare Workstation: “Full” product, $
–VMWare Player: Free, no creation, just use
•Server Products
–VMWare Infrastructure (ESX Server): $$$,
robust, clustering capable, OS replacement
–VMWare VirtualCenter: $$, management
tool for whole environment, Windows
–VMWare Server: free, limited, on top of OS