ITPub博客

首页 > 数据库 > Oracle > 【upgrade】oracle10.2.0.1.0升级10.2.0.5.0 for linux

【upgrade】oracle10.2.0.1.0升级10.2.0.5.0 for linux

原创 Oracle 作者:yhdmy 时间:2014-01-02 22:40:00 0 删除 编辑


Oracle upgrade  version: 10.2.0.1.0à10.2.0.5.0   for  Oracle Linux Server release 6.4

 

1.         检查数据库状态与版本信息:

[oracle@sam ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 27 15:40:46 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

  

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and D

SQL> select * from v$version;

 BANNER

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

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

PL/SQL Release 10.2.0.1.0 - Production

CORE    10.2.0.1.0      Production

TNS for Linux: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 – Production

SQL> select open_mode from v$database;

 OPEN_MODE

----------

READ WRITE

 

2.         关闭数据库:

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

 

3.         对数据库软件进行备份

tar -zcvf /10g/app/oracle/product/10.2.0/dbhome_1.tar /10g/app/oracle/product/10.2.0/*

 

4.         安装 Oracle 10.2.0.5.0 软件:

[oracle@test Disk1]$ ./runInstaller

Starting Oracle Universal Installer...

 Checking installer requirements...

 Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11

                                      Passed

 

 All installer requirements met.

 

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-12-27_03-51-42PM. Please wait ...[oracle@test Disk1]$ Oracle Universal Installer, Version 10.2.0.5.0 Production

Copyright (C) 1999, 2010, Oracle. All rights reserved.

 



 


 

此报错处理方法,有程序未关闭,重启动再安装不出现此报错。

 

 

 


 

5.         执行root.sh脚本(用户root执行):

[root@test ~]# /10g/app/oracle/product/10.2.0/dbhome_1/root.sh

Running Oracle 10g root.sh script...

 

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /10g/app/oracle/product/10.2.0/dbhome_1

 

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.

[root@test ~]#

  


 

6.         升级数据字典:

[oracle@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 27 17:50:44 2013

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

 

SQL> startup upgrade;

ORACLE instance started.

 

Total System Global Area  419430400 bytes

Fixed Size                  2096728 bytes

Variable Size             121635240 bytes

Database Buffers          289406976 bytes

Redo Buffers                6291456 bytes

Database mounted.

Database opened.

SQL> spool /tmp/upgrade.log    

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

..........日志略过,完成后可以查看/tmp/upgrade.log日志文件

 

SQL> select instance_name,status from v$instance;

 

INSTANCE_NAME    STATUS

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

OCM10G           OPEN MIGRATE

 

7.         重新启动到OPEN状态并检查版本信息:

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

 

SQL> startup

ORACLE instance started.

 

Total System Global Area  419430400 bytes

Fixed Size                  2096728 bytes

Variable Size             171966888 bytes

Database Buffers          239075328 bytes

Redo Buffers                6291456 bytes

Database mounted.

Database opened.

SQL> select instance_name,status from v$instance;

 

INSTANCE_NAME    STATUS

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

OCM10G           OPEN

 

SQL> select * from v$version;

 

BANNER

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

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

PL/SQL Release 10.2.0.5.0 - Production

CORE    10.2.0.5.0      Production

TNS for Linux: Version 10.2.0.5.0 - Production

NLSRTL Version 10.2.0.5.0 - Production

SQL>

到此升级到此结束,后继还将分享OPatch打补丁方法。


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26148431/viewspace-1066641/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾就职于铁道科学研究院,太极计算机公司,合力中税。负责过国家电网数据库部署、迁移、升级、灾备等实施规划工作。大唐发电厂、北京市公安局数据库运维及优化工作。现任工场高级DBA岗位,负责oracle、mysql数据库相关工作。拥有Oracle技术10g/11g的 OCP与OCM认证,Oracle YEP成员,OCM联盟成员。

注册时间:2013-04-22

  • 博文量
    107
  • 访问量
    1614535