oracle9.2/Linux rac 动态加入新节点(4)

添加实例

 

l         在rac3上修改listener.ora

[oracle@rac3 ~]$ vi /u01/oracle/product/9.2/network/admin/listener.ora

# LISTENER.ORA.RAC1 Network Configuration File: /u01/oracle/product/9.2/network/admin/listener.ora.rac1

# Generated by Oracle configuration tools.

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = rac3)(PORT = 1521))

      )

    )

  )

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/oracle/product/9.2)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (ORACLE_HOME = /u01/oracle/product/9.2)

      (SID_NAME = rac1)

    )

    (SID_DESC =

      (ORACLE_HOME = /u01/oracle/product/9.2)

      (SID_NAME = rac2)

    )

    (SID_DESC =

      (ORACLE_HOME = /u01/oracle/product/9.2)

      (SID_NAME = rac3)

    )

  )

　　注：要加入红色部分，否则

[oracle@rac1 dbs]$ srvctl start instance -d test -i rac3

PRKP-1011 : Failed to get all the listeners associated with instance rac3 on noderac3

l         在rac3上修改tnsnames.ora

加入下面两行

LISTENER_RAC3 =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac3)(PORT = 1521))

 

l         3.5修改初始化参数文件

　在rac3上修改初始化参数文件加入以下内容

rac3.instance_name=RAC3

rac3.instance_number=3

rac3.local_listener=LISTENER_RAC3

rac3.thread=3

rac3.undo_tablespace=UNDOTBS3

 

l         在rac1上设置redo线程

SQL> alter database add logfile thread 3 group 5　('/u01/oracle/oradata/test/redolog3_1') size 10485760 ;

SQL> alter database add logfile thread 3 group 6　('/u01/oracle/oradata/test/redolog3_2') size 10485760 ;

SQL> alter database enable thread 3;

l         在rac1上创建undo 表空间

SQL> create undo tablespace undotbs3 datafile '/u01/oracle/oradata/test/undotbs03' size 40m;

l         添加新的节点并启动服务

[oracle@rac3 ~]$ srvctl add instance -d test -i rac3 -n rac3

[oracle@rac3 ~]$ srvctl start instance -d test -i rac3

注意事项：

在用DBCA添加实例时，在如下界面时不能点下一步，未找到原因，建议用命令方式添加实例。

删除实例

删除实例时，可按如下步骤操作

SQL> drop tablespace undotbs3;

SQL> alter database disable thread 3;

SQL> alter database drop logfile group 6;

SQL> alter database drop logfile group 5;

[oracle@rac3 ~]$ srvctl remove instance -d test -i rac3

如果需要添加多个实例，按如上步骤，逐个添加。

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

转载于:http://blog.itpub.net/104152/viewspace-201784/