您查看的文章来源于http://www.oklinux.cn
- 安装结束:单击 Exit。
在此阶段,Oracle 集群件已经升级到 Oracle 集群件 11g,并且所有集群资源应该处于运行状态。
merlin1-> $ORA_CRS_HOME/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.devdb.db application ONLINE ONLINE merlin1
ora....b1.inst application ONLINE ONLINE merlin1
ora....b2.inst application ONLINE ONLINE merlin2
ora....SM1.asm application ONLINE ONLINE merlin1
ora....N1.lsnr application ONLINE ONLINE merlin1
ora....in1.gsd application ONLINE ONLINE merlin1
ora....in1.ons application ONLINE ONLINE merlin1
ora....in1.vip application ONLINE ONLINE merlin1
ora....SM2.asm application ONLINE ONLINE merlin2
ora....N2.lsnr application ONLINE ONLINE merlin2
ora....in2.gsd application ONLINE ONLINE merlin2
ora....in2.ons application ONLINE ONLINE merlin2
ora....in2.vip application ONLINE ONLINE merlin2
3. 安装 Oracle 数据库 11g 第 1 版软件
创建 Oracle 主目录
以 oracle 用户身份在这两个节点上创建新的 Oracle 主目录。
mkdir -p /u01/app/oracle/product/11.1.0/db_1
安装 Oracle 数据库软件
从 OTN 上下载 Oracle 数据库软件。
以 oracle 用户身份在 merlin1 上执行,
merlin1-> /stage/database/runInstaller
- 欢迎页面:单击 Next。
- 选择安装类型:
- 选择 Custom。
- 指定 Home 详细内容:
- Oracle 基目录:/u01/app/oracle。
- 名称:OraDb11g_home1
- 路径:/u01/app/oracle/product/11.1.0/db_1
- 指定硬件集群安装模式:
- 选择 Cluster Installation。
- 单击 Select All。
- 特定于产品的必要条件检查:验证总体结果成功。
- 可用产品组件:选择所有必需组件。
- 特权操作系统组:
- 数据库管理员 (OSDBA) 组:dba。
- 数据库操作员 (OSOPER) 组:oinstall。
- ASM 管理员 (OSASM) 组:dba。
- 创建数据库:
- 选择 Install database Software only。
- 摘要:单击 Install。
- 执行配置脚本:以 root 用户身份执行下面的脚本。
- 在 merlin1 上执行 /u01/app/oracle/product/11.1.0/db_1/root.sh。
- 在 merlin2 上执行 /u01/app/oracle/product/11.1.0/db_1/root.sh。
- 返回到 merlin1 的执行配置脚本屏幕,然后单击 OK。
- 安装结束:单击 Exit。
4. 升级 Oracle 数据库
数据库升级前检查
在运行数据库升级助手 (DBUA) 之前,执行数据库升级前检查(即 utlu111i.sql)以检验是否满足所有前提条件。作为升级过程的一部分,DBUA 会自动将 cluster_database 参数由 true 更改为 false。进行必要的修改后,重新执行数据库升级前检查脚本。
以 sys 用户身份连接,
SQL> spool /tmp/utlu111i.log
SQL> @/u01/app/oracle/product/11.1.0/db_1/rdbms/admin/utlu111i
Oracle Database 11.1 Pre-Upgrade Information Tool 08-13-2007 18:03:45
.
**********************************************************************
Database:
**********************************************************************
--> name:DEVDB
--> version: 10.2.0.3.0
--> compatible: 10.2.0.1.0
--> blocksize: 8192
--> platform:Linux IA (32-bit)
--> timezone file:V4
.
**********************************************************************
Tablespaces:[make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size:743 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size:315 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size:458 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size:61 MB
--> EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size:66 MB
.
**********************************************************************
Update Parameters:[Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
-- No update parameter changes are required.
.
**********************************************************************
Renamed Parameters:[Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
-- No renamed parameters found.No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters:[Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
--> "background_dump_dest" replaced by "diagnostic_dest"
--> "user_dump_dest" replaced by "diagnostic_dest"
--> "core_dump_dest" replaced by "diagnostic_dest"
.
**********************************************************************
Components:[The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Real Application Clusters [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Data Mining [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle OLAP API [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING:--> The "cluster_database" parameter is currently "TRUE" and must be
set to "FALSE" prior to running the upgrade.
WARNING:--> Database contains stale optimizer statistics.
.... Refer to the 11g Upgrade Guide for instructions to update
.... statistics prior to upgrading the database.
.... Component Schemas with stale statistics:
.... SYS
WARNING:--> Database contains schemas with objects dependent on network
packages.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
WARNING:--> EM Database Control Repository exists in the database.
.... Direct downgrade of EM Database Control is not supported.Refer to the
.... 11g Upgrade Guide for instructions to save the EM data prior to upgrade.
.
PL/SQL procedure successfully completed.
SQL> spool off
共7页: 上一页 [1] [2] 3 [4] [5] [6] [7] 下一页