oracle 升级10.2.0.1到10.2.0.5

转载 2016年10月20日 16:48:21

升级数据字典,解决ORA-01092: Oracle instance terminated. Disconnection forced问题。

在Oracle 实例关闭的情况下,Oracle 软件从10.2.0.1 升级到 10.2.0.5 之后,存在的数据库也要升级。

此时启动实例会报错 ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> alter database open;
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


第一步,通过startup upgrade启动实例

SQL> startup upgrade;
ORACLE instance started.
Total System Global Area  322961408 bytes
Fixed Size              2095992 bytes
Variable Size                100664456 bytes
Database Buffers      213909504 bytes
Redo Buffers                6291456 bytes
Database mounted.
Database opened.


 

第二步,升级数据字典和实例等。

SQL>@ORACLE_HOME\rdbms\admin\catupgrd.sql


整个过程需要15分钟至30分钟左右

升级完毕显示如下:

Oracle Database 10.2 Upgrade Status Utility          09-11-2014 21:48:21

Component                                Status        Version  HH:MM:SS

Oracle Database Server                    VALID      10.2.0.5.0  00:15:41

JServer JAVA Virtual Machine              VALID      10.2.0.5.0  00:06:46

Oracle XDK                                VALID      10.2.0.5.0  00:00:51

Oracle Database Java Packages            VALID      10.2.0.5.0  00:00:45

Oracle Text                              VALID      10.2.0.5.0  00:01:07

Oracle XML Database                      VALID      10.2.0.5.0  00:03:26

Oracle Workspace Manager                  VALID      10.2.0.5.0  00:01:21

Oracle Data Mining                        VALID      10.2.0.5.0  00:00:39

OLAP Analytic Workspace                   VALID      10.2.0.5.0  00:00:48

OLAP Catalog                              VALID      10.2.0.5.0  00:02:01

Oracle OLAP API                          VALID      10.2.0.5.0  00:02:01

Oracle interMedia                        VALID      10.2.0.5.0  00:06:35

Spatial                                  VALID      10.2.0.5.0  00:04:50

Oracle Expression Filter                  VALID      10.2.0.5.0  00:00:30

Oracle Enterprise Manager                VALID      10.2.0.5.0  00:02:59

Oracle Rule Manager                      VALID      10.2.0.5.0  00:00:18

.

Total Upgrade Time: 00:53:47

DOC>#######################################################################

DOC>#######################################################################

DOC>

DOC>  The above PL/SQL lists the SERVER components in the upgraded

DOC>  database, along with their current version and status.

DOC>

DOC>  Please review the status and version columns and look for

DOC>  any errors in the spool log file.  If there are errors in the spool

DOC>  file, or any components are not VALID or not the current version,

DOC>  consult the Oracle Database Upgrade Guide for troubleshooting

DOC>  recommendations.

DOC>

DOC>  Next shutdown immediate, restart for normal operation, and then

DOC>  run utlrp.sql to recompile any invalid application objects.

DOC>

DOC>#######################################################################

DOC>#######################################################################

DOC>#

 

第三步,shutdown 实例。Startup实例

第四步,再次编译无效的应用对象

SQL> @?/rdbms/admin/utlrp.sql

TIMESTAMP

--------------------------------------------------------------------------------

COMP_TIMESTAMP UTLRP_BGN  2014-09-11 21:52:02

DOC>  The following PL/SQL block invokes UTL_RECOMP to recompile invalid

DOC>  objects in the database. Recompilation time is proportional to the

DOC>  number of invalid objects in the database, so this command may take

DOC>  a long time to execute on a database with a large number of invalid

DOC>  objects.

DOC>

DOC>  Use the following queries to track recompilation progress:

DOC>

DOC>  1. Query returning the number of invalid objects remaining. This

DOC>      number should decrease with time.

DOC>        SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);

DOC>

DOC>  2. Query returning the number of objects compiled so far. This number

DOC>      should increase with time.

DOC>        SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;

DOC>

DOC>  This script automatically chooses serial or parallel recompilation

DOC>   based on the number of CPUs available (parameter cpu_count) multiplied

DOC>  by the number of threads per CPU (parameter parallel_threads_per_cpu).

DOC>  On RAC, this number is added across all RAC nodes.

DOC>

DOC>  UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel

DOC>  recompilation. Jobs are created without instance affinity so that they

DOC>  can migrate across RAC nodes. Use the following queries to verify

DOC>  whether UTL_RECOMP jobs are being created and run correctly:

DOC>

DOC>  1. Query showing jobs created by UTL_RECOMP

DOC>        SELECT job_name FROM dba_scheduler_jobs

DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC>

DOC>  2. Query showing UTL_RECOMP jobs that are running

DOC>        SELECT job_name FROM dba_scheduler_running_jobs

DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC>#

 

TIMESTAMP

--------------------------------------------------------------------------------

COMP_TIMESTAMP UTLRP_END  2014-09-11 21:53:40

DOC> The following query reports the number of objects that have compiled

DOC> with errors (objects that compile with errors have status set to 3 in

DOC> obj$). If the number is higher than expected, please examine the error

DOC> messages reported with each object (using SHOW ERRORS) to see if they

DOC> point to system misconfiguration or resource constraints that must be

DOC> fixed before attempting to recompile these objects.

DOC>#

 

OBJECTS WITH ERRORS

-------------------

                  0

DOC> The following query reports the number of errors caught during

DOC> recompilation. If this number is non-zero, please query the error

DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors

DOC> are due to misconfiguration or resource constraints that must be

DOC> fixed before objects can compile successfully.

DOC>#

 

ERRORS DURING RECOMPILATION

---------------------------

                          0

SQL>

Oracle 从10.2.0.1升级到10.2.0.5

1、环境介绍 我们已经在RedHat 6.5上成功安装Oracle 10gR2,版本号为10.2.0.1。 [oracle@SimpleLinux ~]$ uname -r 2....
  • dba_monkey
  • dba_monkey
  • 2017年03月08日 13:39
  • 375

探索Oracle之数据库升级二 11.2.0.3升级到11.2.0.4完整步骤

探索Oracle之数据库升级二  11.2.0.3 升级到11.2.0.4完整步骤   说明:         这篇文章主要是记录下单实例环境下Oracle 11.2.0.1 升级到11.2.0.3的...
  • wuweilong
  • wuweilong
  • 2014年11月30日 21:35
  • 25074

Oracle升级_oracle 10g版本由 10.2.0.1.0升级为10.2.0.4.0(即CPU升级)

CPU升级_ oracle 10g版本由 10.2.0.1.0升级为10.2.0.4.0 实验环境: 虚拟机软件 Vbox 4.2.12 实验系统 Linux RedHat ...
  • huangyanlong
  • huangyanlong
  • 2014年08月06日 14:15
  • 2156

Oracle 10.2.0.1 升级到 10.2.0.4

数据库升级并不难,只要遵循其步骤,一般问题不大。但是升级失败的情况也是屡见不鲜,尤其是生产数据库的升级,搞不定的时候甚至要创建SR……...
  • robinson_0612
  • robinson_0612
  • 2011年05月05日 14:44
  • 17594

安装10.2.0.5升级包

环境OEL5.9 x86_64 oracle10g 10.2.0.1 x86_64 把升级包p8202632_10205_Linux-x86-64.zip传入服务器并解压,如下。 [...
  • aio_o
  • aio_o
  • 2013年06月19日 11:37
  • 777

10GR2两节点RAC搭建及升级至10.2.0.5

一、安装环境简介: 1、安装vbox最新版本,可在oracle官网上下载http://www.oracle.com/technetwork/server-storage/virtualbox/dow...
  • u013428681
  • u013428681
  • 2014年06月11日 16:03
  • 886

10g数据库从10.2.0.4升级到10.2.0.5

下面是10g数据库从10.2.0.4 升级到10.2.0.5 然后打patch 13923855的步骤。 一、将数据库版本从10.2.0.4 升级到 10.2.0.5 1、升级前检查 con...
  • gltyi99
  • gltyi99
  • 2014年03月26日 16:11
  • 553

Oracle GoldenGate学习之--AIX系统安装配置

Oracle GoldenGate学习之--AIX 系统安装配置系统环境操作系统:AIX5.3-09DB Soft:  Oracle 10gR2如下图所示:650) this.width=650;" ...
  • lqx0405
  • lqx0405
  • 2015年03月31日 12:07
  • 2078

oracle各个版本的exp/imp兼容性

oracle各个版本的exp/imp兼容性
  • makang110
  • makang110
  • 2016年12月23日 13:37
  • 925

Oracle 10.2.0.5又出现了undo 表空间使用率不断增长

一,问题描述: 早晨点检双节点ORACLE 10.2.0.5 RAC数据库发现undo(AUM模式)表空间在不断扩展: 时间:2011/07/07 07:50 Undo表空间使用情况: (un...
  • lt53130640688
  • lt53130640688
  • 2015年12月08日 16:17
  • 405
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:oracle 升级10.2.0.1到10.2.0.5
举报原因:
原因补充:

(最多只允许输入30个字)