IT技术互动交流平台

oracle 10g rac环境升级到10.2.0.5

作者:一起走过的日子  来源:IT165收集  发布日期:2016-11-15 19:53:37

  升级oracle rac环境,以前是oracle 是10.2.0.1版本,现在要10.2.0.5的版本.首先必须安装oracle cluster集群软件,然后下载oracle 10.2.0.5软件包进行打补丁.

 

oracle cluster安装地址:

oracle 10.2.0.5下载地址:

 

1.查看当前的crs版本(两个节点都看一下)

[oracle@rac10g01 ~]$ crsctl query crs softwareversion

CRS software version on node [rac10g01] is [10.2.0.1.0]

[oracle@rac10g01 ~]$ crsctl query crs activeversion

CRS active version on the cluster is [10.2.0.1.0]

[oracle@rac10g01 ~]$

 

2.安装升级软件包

[oracle@rac10g01 ~]$ unzip p8202632_10205_Linux-x86-64.zip

[oracle@rac10g01 ~]$ cd Disk1/

[oracle@rac10g01 Disk1]$ ll

total 188

drwxr-xr-x   4 oracle oinstall   4096 Apr 29  2010 install

-rwxr-xr-x   1 oracle oinstall 171131 Apr 29  2010 patch_note.htm

drwxr-xr-x   2 oracle oinstall   4096 Apr 29  2010 response

-rwxr-xr-x   1 oracle oinstall   3927 Apr 29  2010 runInstaller

drwxr-xr-x  11 oracle oinstall   4096 Apr 29  2010 stage

[oracle@rac10g01 Disk1]$ ./runInstaller

wKioL1gqycLC4LdnAACI1H0rwBM202.png-wh_50

wKiom1gqycPhfEhtAACY9r-_7nY843.png-wh_50

wKioL1gqycSBDaqYAACU_v_aZtg592.png-wh_50

wKiom1gqycXiQbkMAACjBP1WAIM296.png-wh_50

wKiom1gqycWjMKUaAAB0Vs0XRds615.png-wh_50

wKioL1gqycaCB9VkAAD-7fj0_Z4894.png-wh_50

wKioL1gqyceygBytAAB6S6do8pQ201.png-wh_50

在两个节点先要关闭crs服务,再执行root102.sh脚本

rac10g01节点:

[root@rac10g01 ~]# /u01/oracle/product/10.2.0.1/crs_1/bin/crsctl stop crs

Stopping resources.

Error while stopping resources. Possible cause: CRSD is down.

Stopping CSSD.

Unable to communicate with the CSS daemon.

[root@rac10g01 ~]# sh /u01/oracle/product/10.2.0.1/crs_1/install/root102.sh

Creating pre-patch directory for saving pre-patch clusterware files

Completed patching clusterware files to /u01/oracle/product/10.2.0.1/crs_1

Relinking some shared libraries.

Relinking of patched files is complete.

WARNING: directory '/u01/oracle/product/10.2.0.1' is not owned by root

WARNING: directory '/u01/oracle/product' is not owned by root

WARNING: directory '/u01/oracle' is not owned by root

WARNING: directory '/u01' is not owned by root

Preparing to recopy patched init and RC scripts.

Recopying init and RC scripts.

Startup will be queued to init within 30 seconds.

/etc/profile: line 61: ulimit: open files: cannot modify limit: Operation not permitted

Starting up the CRS daemons.

Waiting for the patched CRS daemons to start.

  This may take a while on some systems.

.

10205 patch successfully applied.

clscfg: EXISTING configuration version 3 detected.

clscfg: version 3 is 10G Release 2.

Successfully deleted 1 values from OCR.

Successfully deleted 1 keys from OCR.

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node <nodenumber>: <nodename> <private interconnect name> <hostname>

node 1: rac10g01 rac10g01-priv rac10g01

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

clscfg -upgrade completed successfully

Creating '/u01/oracle/product/10.2.0.1/crs_1/install/paramfile.crs' with data used for CRS conf iguration

Setting CRS configuration values in /u01/oracle/product/10.2.0.1/crs_1/install/paramfile.crs

[root@rac10g01 ~]#

 

rac10g02节点:

[root@rac10g02 ~]# /u01/oracle/product/10.2.0.1/crs_1/bin/crsctl stop crs

Stopping resources.

Error while stopping resources. Possible cause: CRSD is down.

Stopping CSSD.

Unable to communicate with the CSS daemon.

[root@rac10g02 ~]# sh /u01/oracle/product/10.2.0.1/crs_1/install/root102.sh

Creating pre-patch directory for saving pre-patch clusterware files

Completed patching clusterware files to /u01/oracle/product/10.2.0.1/crs_1

Relinking some shared libraries.

Relinking of patched files is complete.

WARNING: directory '/u01/oracle/product/10.2.0.1' is not owned by root

WARNING: directory '/u01/oracle/product' is not owned by root

WARNING: directory '/u01/oracle' is not owned by root

WARNING: directory '/u01' is not owned by root

Preparing to recopy patched init and RC scripts.

Recopying init and RC scripts.

Startup will be queued to init within 30 seconds.

/etc/profile: line 61: ulimit: open files: cannot modify limit: Operation not permitted

Starting up the CRS daemons.

Waiting for the patched CRS daemons to start.

  This may take a while on some systems.

.

10205 patch successfully applied.

clscfg: EXISTING configuration version 3 detected.

clscfg: version 3 is 10G Release 2.

Successfully deleted 1 values from OCR.

Successfully deleted 1 keys from OCR.

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node <nodenumber>: <nodename> <private interconnect name> <hostname>

node 2: rac10g02 rac10g02-priv rac10g02

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

clscfg -upgrade completed successfully

Creating '/u01/oracle/product/10.2.0.1/crs_1/install/paramfile.crs' with data used for CRS configuration

Setting CRS configuration values in /u01/oracle/product/10.2.0.1/crs_1/install/paramfile.crs

[root@rac10g02 ~]#

脚本执行完了后点退出

wKioL1gqzXziUa4pAABu1oZzoNQ287.png-wh_50

 

3.验证crs的版本

[oracle@rac10g01 ~]$ crsctl query crs softwareversion

CRS software version on node [rac10g01] is [10.2.0.5.0]

[oracle@rac10g01 ~]$ crsctl query crs activeversion

CRS active version on the cluster is [10.2.0.5.0]

[oracle@rac10g01 ~]$

 

4.验证crs各个服务的状态

[oracle@rac10g01 ~]$ crs_stat -t

Name           Type           Target    State     Host

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

ora....g01.gsd application    ONLINE    ONLINE    rac10g01

ora....g01.ons application    ONLINE    ONLINE    rac10g01

ora....g01.vip application    ONLINE    ONLINE    rac10g01

ora....g02.gsd application    ONLINE    ONLINE    rac10g02

ora....g02.ons application    ONLINE    ONLINE    rac10g02

ora....g02.vip application    ONLINE    ONLINE    rac10g02

[oracle@rac10g01 ~]$

 

5.检查oracle database的版本信息

[oracle@rac10g02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 15 17:42:35 2016

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

Connected to an idle instance.

SQL> exit

Disconnected

[oracle@rac10g02 ~]$

 

6.升级oracle数据库软件

      目前的oracle database是10.2.0.1的版本,下载10.2.0.5的补丁包进行升级.前提是先安装好10.2.0.1的版本.

[oracle@rac10g01 ~]$ cd Disk1/

[oracle@rac10g01 Disk1]$ ./runInstaller

wKiom1gq2bzQoih6AACJqBbPdVU615.png-wh_50

wKioL1gq2b2j_D4vAACaiJWtrcQ701.png-wh_50

wKiom1gq2b6BfPJpAACJ4-67R9M757.png-wh_50

wKioL1gq2b-jI6wAAACUcIuAvCA261.png-wh_50

wKiom1gq2cCjCLdkAACf8nadwTY776.png-wh_50

wKiom1gq2cGzyyAzAAB1BrNWolk714.png-wh_50

wKiom1gq21STDc52AAECR8wQUmw997.png-wh_50

wKiom1gq3fjRL6XrAAAvuJhS_1c934.png-wh_50

rac10g01节点:

[root@rac10g01 ~]# sh /u01/oracle/product/10.2.0.1/db_1/root.sh

Running Oracle 10g root.sh script...

 

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/oracle/product/10.2.0.1/db_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]: y

   Copying dbhome to /usr/local/bin ...

The file 'oraenv' already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying oraenv to /usr/local/bin ...

The file 'coraenv' already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying coraenv to /usr/local/bin ...

 

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@rac10g01 ~]#

 

rac10g02节点:

[root@rac10g02 ~]# sh /u01/oracle/product/10.2.0.1/db_1/root.sh

Running Oracle 10g root.sh script...

 

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/oracle/product/10.2.0.1/db_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]: y

   Copying dbhome to /usr/local/bin ...

The file 'oraenv' already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying oraenv to /usr/local/bin ...

The file 'coraenv' already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying coraenv to /usr/local/bin ...

 

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@rac10g02 ~]#

wKiom1gq3nbyl8tjAABrRSWBC8Q077.png-wh_50

wKioL1gq3nbQmabDAABspJgCiGo227.png-wh_50

 

7.验证oracle database的版本

[oracle@rac10g01 Disk1]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 15 18:09:09 2016

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

Connected to an idle instance.

SQL>

 

8.创建数据库

[root@rac10g01 ~]# xhost +

access control disabled, clients can connect from any host

[root@rac10g01 ~]# su - oracle

[oracle@rac10g01 ~]$ dbca

wKioL1gq4wmzYrOoAADflT7yuS0970.png-wh_50

wKiom1gq4wqxPvbvAADgtGGE-1o148.png-wh_50

wKiom1gq4wuwCJWBAACqt9KUjds265.png-wh_50

wKioL1gq4wzR9P0mAAC-6Tr7koI247.png-wh_50

wKiom1gq4w2walZXAADFOaVlPbY024.png-wh_50

wKioL1gq4w7SC54VAADUUdufUa8084.png-wh_50

wKiom1gq4w6gPjkoAADB29vy1YM471.png-wh_50

wKioL1gq4w-T9b7JAADTiOOnOVs173.png-wh_50

wKiom1gq4xCAuq-kAADX_ms0VB4273.png-wh_50

wKioL1gq4xWTRpD_AADaY65AdIE139.png-wh_50

wKiom1gq4xnTzlVsAADGCrm7E5U675.png-wh_50

QTAzRGlETUljOTQ0LnBuZy13aF81MA==" src="http://www.it165.net/uploadfile/files/2016/1115/20161115191733318.png" title="41.png" />

wKioL1gq4xrgfvQbAABKslY1EcQ641.png-wh_50

wKioL1gq5B2j52fUAADUOHxbAJE472.png-wh_50

wKiom1gq5B7DydNYAADNNFSC_i0981.png-wh_50

wKioL1gq5B6SMQxFAADS3fSCU6A892.png-wh_50

wKiom1gq5B-Dey6fAACoapMuhTw773.png-wh_50

wKiom1gq5CCimDP1AABHa5OxPj8207.png-wh_50

wKioL1gq5CCigrRQAABAp2Oo3jI999.png-wh_50

wKiom1gq5CGS1MHmAADx7s8l-a4681.png-wh_50

wKioL1gq5CHz6dbuAABVaputsSU437.png-wh_50

wKioL1gq5CLw6JZpAADXgpX0HOc614.png-wh_50

wKiom1gq5CKyyb4xAAA_HQv7g6Q826.png-wh_50

 

Tag标签: 环境  
  • 专题推荐

About IT165 - 广告服务 - 隐私声明 - 版权申明 - 免责条款 - 网站地图 - 网友投稿 - 联系方式
本站内容来自于互联网,仅供用于网络技术学习,学习中请遵循相关法律法规