阿里云-云小站(无限量代金券发放中)
【腾讯云】云服务器、云数据库、COS、CDN、短信等热卖云产品特惠抢购

Oracle 10g RAC环境升级到10.2.0.5

202次阅读
没有评论

共计 10960 个字符,预计需要花费 28 分钟才能阅读完成。

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

oracle cluster 安装地址: http://www.linuxidc.com/Linux/2017-04/142939.htm
oracle database 安装地址: http://www.linuxidc.com/Linux/2017-04/142940.htm
oracle 10.2.0.5 下载地址:http://aru-llnw-dl.oracle.com/aaruna03/vol/patch26/PLATFORM/CORE/Linux-x86-64/R80102050/p8202632_10205_Linux-x86-64.zip?params=UlZPbFZSMlBFVVVyRWt1dldva3hjUTphcnU9MTI1NDA4MjQmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwMzAxODQzJnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfTGludXgteDg2LTY0LnppcCZ1c2VyaWQ9by1jbnd4NjhAbW90b3JvbGEuY29tJnNpemU9MTI0OTg1Nzg2NiZjb250ZXh0PUFAMTArSEBhYXJ1MjAzLm9yYWNsZS5jb20rUEA%40&e=1292124852&h=3e16aa21f55a3b257d06fc462b94eeeb

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

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

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

更多详情见请继续阅读下一页的精彩内容 :http://www.linuxidc.com/Linux/2017-04/142938p2.htm

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 ~]#
脚本执行完了后点退出

Oracle 10g RAC 环境升级到 10.2.0.5

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 ~]$

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

oracle cluster 安装地址: http://www.linuxidc.com/Linux/2017-04/142939.htm
oracle database 安装地址: http://www.linuxidc.com/Linux/2017-04/142940.htm
oracle 10.2.0.5 下载地址:http://aru-llnw-dl.oracle.com/aaruna03/vol/patch26/PLATFORM/CORE/Linux-x86-64/R80102050/p8202632_10205_Linux-x86-64.zip?params=UlZPbFZSMlBFVVVyRWt1dldva3hjUTphcnU9MTI1NDA4MjQmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwMzAxODQzJnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfTGludXgteDg2LTY0LnppcCZ1c2VyaWQ9by1jbnd4NjhAbW90b3JvbGEuY29tJnNpemU9MTI0OTg1Nzg2NiZjb250ZXh0PUFAMTArSEBhYXJ1MjAzLm9yYWNsZS5jb20rUEA%40&e=1292124852&h=3e16aa21f55a3b257d06fc462b94eeeb

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

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

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

更多详情见请继续阅读下一页的精彩内容 :http://www.linuxidc.com/Linux/2017-04/142938p2.htm

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

runInstaller

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

 

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

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

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

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

Oracle 10g RAC 环境升级到 10.2.0.5

8. 验证安装是否成功
rac10g01 节点:
[oracle@rac10g01 ~]$ crs_stat -t
Name          Type          Target    State    Host
————————————————————
ora.rac10g.db  application    ONLINE    ONLINE    rac10g01
ora….ac10.cs application    ONLINE    ONLINE    rac10g02
ora….0g1.srv application    ONLINE    ONLINE    rac10g01
ora….0g2.srv application    ONLINE    ONLINE    rac10g02
ora….g1.inst application    ONLINE    ONLINE    rac10g01
ora….g2.inst application    ONLINE    ONLINE    rac10g02
ora….SM1.asm application    ONLINE    ONLINE    rac10g01
ora….01.lsnr application    ONLINE    ONLINE    rac10g01
ora….g01.gsd application    ONLINE    ONLINE    rac10g01
ora….g01.ons application    ONLINE    ONLINE    rac10g01
ora….g01.vip application    ONLINE    ONLINE    rac10g01
ora….SM2.asm application    ONLINE    ONLINE    rac10g02
ora….02.lsnr application    ONLINE    ONLINE    rac10g02
ora….g02.gsd application    ONLINE    ONLINE    rac10g02
ora….g02.ons application    ONLINE    ONLINE    rac10g02
ora….g02.vip application    ONLINE    ONLINE    rac10g02
[oracle@rac10g01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 – Production on Tue Nov 15 21:53:40 2016
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> create table t (a number);
Table created.
SQL> insert into t values(1);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from t;
  A
———-
  1
SQL>

rac10g02 节点:
[oracle@rac10g02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 – Production on Tue Nov 15 21:56:06 2016
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select * from t;
  A
———-
  1
SQL>

更多 Oracle 相关信息见 Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

本文永久更新链接地址 :http://www.linuxidc.com/Linux/2017-04/142938.htm

正文完
星哥玩云-微信公众号
post-qrcode
 0
星锅
版权声明:本站原创文章,由 星锅 于2022-01-22发表,共计10960字。
转载说明:除特殊说明外本站文章皆由CC-4.0协议发布,转载请注明出处。
【腾讯云】推广者专属福利,新客户无门槛领取总价值高达2860元代金券,每种代金券限量500张,先到先得。
阿里云-最新活动爆款每日限量供应
评论(没有评论)
验证码
【腾讯云】云服务器、云数据库、COS、CDN、短信等云产品特惠热卖中