ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rac 升级crs 升级数据库软件,升级数据库

rac 升级crs 升级数据库软件,升级数据库

原创 Linux操作系统 作者:season0891 时间:2009-04-15 23:39:38 0 删除 编辑

转自: http://space.itpub.net/html/99/231499-156324.html

 

最近在本机上重新用vmware server 1.04 搭建了一套10G RAC系统,在搭建过程把步骤基本记录下来,希望对大家有帮助。

本部分主要讲述如何升级RAC数据库

升级数据库

一般情况下,最好在创建数据库前升级软件会省去不少麻烦,我这里为了测试,选择先创建数据库再升级。

1、 如果安装了管理器和isqlplus执行如下命令停止:

emctl stop dbconsole

isqlplusctl stop

2、 停止服务和实例

oracle用户在其中一个节点执行

[oracle@rac1 ~]$ srvctl stop service -d rac

[oracle@rac1 ~]$ srvctl stop instance -d rac -i rac1,rac2

3、 停止nodeapps

两个节点以root分别执行:

节点1

[root@rac1 ~]# cd /opt/oracle/product/10.2/crs/bin/

[root@rac1 bin]# ./srvctl stop nodeapps -n rac1

 

节点2

[root@rac1 ~]# cd /opt/oracle/product/10.2/crs/bin/

[root@rac1 bin]# ./srvctl stop nodeapps -n rac2

 

4、 停止crs

在所有节点以root分别执行:

[root@rac1 bin]# ./crsctl stop crs

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

 

5、 升级数据库软件

必须在安装oracle软件的节点打运行补丁更新程序。

[root@rac1 ~]# export DISPLAY=172.25.8.131:1.0

[root@rac1 ~]# xhost +

access control disabled, clients can connect from any host

[root@rac1 ~]#

[root@rac1 ~]# su - oracle

[oracle@rac1 ~]$ cd /soft/Disk1/

[oracle@rac1 Disk1]$ ls

10203_buglist.htm install patch_note.htm response runInstaller stage

[oracle@rac1 Disk1]$ ./runInstaller

Starting Oracle Universal Installer...

 

Checking installer requirements...

 

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

                                     Passed

 

 

All installer requirements met.

 

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-01-16_06-09-15PM. Please wait ...[oracle@rac1 Disk1]$ Oracle Universal Installer, Version10.2.0.3.0 Production

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

 

在弹出的界面下一步,选择OraDb10g_home1

下一步,默认是选择了所有节点

下一步,开始升级

最后在所有节点以root执行脚本:

[root@rac1 bin]# /opt/oracle/product/10.2/database/root.sh

Running Oracle10 root.sh script...

 

The following environment variables are set as:

   ORACLE_OWNER= oracle

   ORACLE_HOME= /opt/oracle/product/10.2/database

 

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.

至此,数据库软件部分升级完成。

1) 升级数据库

 

数据库升级可以用dbua,也可以手工升级。我在这里选择手工升级的方式。

1、 启动所有节点的的crs及监听等资源

[root@rac1 bin]# /etc/init.d/init.crs start

Startup will be queued to init within 90 seconds.

 

 

[root@rac2 bin]# /etc/init.d/init.crs start

Startup will be queued to init within 90 seconds.

 

1、 在节点1修改参数

SQL> STARTUP NOMOUNT

 

SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;

 

System altered.

 

SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;

 

System altered.

 

SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;

 

System altered.

 

保证SHARED_POOL_SIZEJAVA_POOL_SIZE不小于150m。因为数据文件是共享的,所以升级的时候只需要在其中一个节点升级就行了,所以要把CLUSTER_DATABASE设成FALSE

2、 执行更新脚本

SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

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

SQL> SPOOL OFF

检查日志看有没有错误,如果没有错误,则重启数据库:

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

 

Total System Global Area 469762048 bytes

Fixed Size                 1262428 bytes

Variable Size            419433636 bytes

Database Buffers          46137344 bytes

Redo Buffers               2928640 bytes

Database mounted.

Database opened.

3、 编译无效对象

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

 

4、 修改参数

SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;

 

System altered.

 

重启数据库,升级完成。

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

请登录后发表评论 登录
全部评论

注册时间:2008-06-10

  • 博文量
    791
  • 访问量
    1931224