ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle9.2/Linux rac 动态加入新节点(4)

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

原创 Linux操作系统 作者:cc59 时间:2008-03-09 00:06:12 0 删除 编辑

添加实例

 

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/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2007-12-21

  • 博文量
    132
  • 访问量
    286450