OracleRAC转换为单实例 - 数据库编程

OS：redhat 5.8
DB:Oracle RAC 10.2.0.5.0（raw devices）

背景：由于存储IO瓶颈，客户voting disk磁盘写入速度为几kb每秒，导致两节点宕机。只要启动crs就宕机，由于白天业务需要正常运行。所以将rac临时转换为单实例用

总体步骤：
1、创建pfile
2、relink oracle
3、pfile启动数据库

4、配置VIP

rac转换为单机：

1、创建pfile

[oracle@zbdba1 bin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Feb 9 21:21:14 2015

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 pfile from spfile;


修改pfile:
[oracle@zbdba1 dbs]$ cat initzhdb1.ora
zhdb1.__db_cache_size=150994944
zhdb2.__db_cache_size=155189248
zhdb1.__java_pool_size=4194304
zhdb2.__java_pool_size=4194304
zhdb1.__large_pool_size=4194304
zhdb2.__large_pool_size=4194304
zhdb1.__shared_pool_size=117440512
zhdb2.__shared_pool_size=113246208
zhdb1.__streams_pool_size=0
zhdb2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/zhdb/adump'
*.background_dump_dest='/u01/app/oracle/admin/zhdb/bdump'
*.cluster_database=false
*.compatible='10.2.0.5.0'
*.control_files='/dev/raw/raw20','/dev/raw/raw21'
*.core_dump_dest='/u01/app/oracle/admin/zhdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='zhdb'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=zhdbXDB)'
zhdb2.instance_number=2
zhdb1.instance_number=1
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/u01/app/oracle/arch'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='AMERICAN'
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_listener='LISTENERS_ZHDB'
*.remote_login_passwordfile='exclusive'
*.sga_target=283115520
zhdb2.thread=2
zhdb1.thread=1
*.undo_management='AUTO'
zhdb1.undo_tablespace='UNDOTBS1'
zhdb2.undo_tablespace='UNDOTBS2'
*.user_dump_dest='/u01/app/oracle/admin/zhdb/udump'

[root@zbdba1 database]# crsctl stop crs
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

[root@zbdba2 database]# crsctl stop crs
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

2、relink oracle

[oracle@zbdba1 ~]$ cd $ORACLE_HOME/rdbms/lib


[oracle@zbdba1 lib]$ make -f ins_rdbms.mk rac_off 
rm -f /u01/app/oracle/product/10.2.0/db_1/lib/libskgxp10.so
cp /u01/app/oracle/product/10.2.0/db_1/lib//libskgxpd.so /u01/app/oracle/product/10.2.0/db_1/lib/libskgxp10.so
rm -f /u01/app/oracle/product/10.2.0/db_1/lib/libskgxn2.so
cp /u01/app/oracle/product/10.2.0/db_1/lib//libskgxns.so \
              /u01/app/oracle/product/10.2.0/db_1/lib/libskgxn2.so
/usr/bin/ar d /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/libknlopt.a kcsm.o
/usr/bin/ar cr /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/ksnkcs.o


[oracle@zbdba1 lib]$ make -f ins_rdbms.mk ioracle
chmod 755 /u01/app/oracle/product/10.2.0/db_1/bin

- Linking Oracle
rm -f /u01/app/ora

OracleRAC转换为单实例(一)