Oracle9.2.0.4 RAC 三节点参数设置

节点1,2,3   tnsnames.ora 设置


-----------------------------------------------------------------------------------  


LISTENERS_INTEL =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
  )

LISTENER_INTEL1 =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
  )


INTEL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = INTEL)
    )
  )


INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

INTEL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = INTEL)
      (INSTANCE_NAME = INTEL1)
    )
  )

INTEL2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = INTEL)
      (INSTANCE_NAME = INTEL2)
    )
  )

INTEL3 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = INTEL)
      (INSTANCE_NAME = INTEL3)
    )
  )

 

 

-----------------------------------------------------------------------------------  

 

 

-----------------------------------------------------------------------------------  


LISTENERS_INTEL =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
  )

LISTENER_INTEL2 =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
  )


INTEL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = INTEL)
    )
  )


INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

INTEL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = INTEL)
      (INSTANCE_NAME = INTEL1)
    )
  )

INTEL2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = INTEL)
      (INSTANCE_NAME = INTEL2)
    )
  )

INTEL3 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = INTEL)
      (INSTANCE_NAME = INTEL3)
    )
  )

 

 

-----------------------------------------------------------------------------------  

 


-----------------------------------------------------------------------------------  


LISTENERS_INTEL =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
  )

LISTENER_INTEL3 =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
  )


INTEL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = INTEL)
    )
  )


INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

INTEL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = INTEL)
      (INSTANCE_NAME = INTEL1)
    )
  )

INTEL2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node2)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = INTEL)
      (INSTANCE_NAME = INTEL2)
    )
  )

INTEL3 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dmdii-node3)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = INTEL)
      (INSTANCE_NAME = INTEL3)
    )
  )

 

-----------------------------------------------------------------------------------  


节点1,2,3参数一致 :

 

*.background_dump_dest='/u01/product/admin/intel/bdump'
*.cluster_database_instances=3
*.cluster_database=true
*.compatible='9.2.0.0.0'
*.control_files='/ocfs_ctrl_redo/intel/control01.ctl','/ocfs_ctrl_redo/intel/control02.ctl','/ocfs_ctrl_redo/intel/control03.ctl'
*.core_dump_dest='/u01/product/admin/intel/cdump'
*.cursor_sharing='EXACT'
*.db_block_size=8192
*.db_cache_size=1073741824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_files=1000
*.db_name='intel'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=intelXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
intel1.instance_name='intel1'
intel2.instance_name='intel2'
intel3.instance_name='intel3'
intel1.instance_number=1
intel2.instance_number=2
intel3.instance_number=3
*.java_pool_size=31457280
*.job_queue_processes=36
*.large_pool_size=20971520
intel1.local_listener='LISTENER_INTEL1'
intel2.local_listener='LISTENER_INTEL2'
intel3.local_listener='LISTENER_INTEL3'
intel1.log_archive_dest_1='LOCATION=/ocfs_arch1/intel/'
intel2.log_archive_dest_1='LOCATION=/ocfs_arch2/intel/'
intel3.log_archive_dest_1='LOCATION=/ocfs_arch2/intel/'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.open_cursors=4000
*.optimizer_index_cost_adj=30
*.optimizer_mode='rule'
*.pga_aggregate_target=314572800
*.processes=1015
*.query_rewrite_enabled='FALSE'
intel1.remote_listener='LISTENERS_INTEL'
intel2.remote_listener='LISTENERS_INTEL'
intel3.remote_listener='LISTENERS_INTEL'
*.remote_login_passwordfile='exclusive'
*.resource_limit=TRUE
*.service_names='intel'
*.session_cached_cursors=20
*.shared_pool_size=419430400
*.sort_area_size=2097152
*.star_transformation_enabled='FALSE'
intel1.thread=1
intel2.thread=2
intel3.thread=3

*.timed_statistics=TRUE
*.trace_enabled=false
*.undo_management='AUTO'
*.undo_retention=10800
intel1.undo_tablespace='UNDOTBS1'
intel2.undo_tablespace='UNDOTBS2'
intel3.undo_tablespace='UNDOTBS3'
*.user_dump_dest='/u01/product/admin/intel/udump'

 

-------------------------------------

节点1 监听设置 ,2,3节点类似 。

# LISTENER.ORA Network Configuration File: /u01/product/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.148)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.4.98)(PORT = 1521)) 
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/product/oracle)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (ORACLE_HOME = /u01/product/oracle)
      (SID_NAME = intel1)
    )
  )

 

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

转载于:http://blog.itpub.net/35489/viewspace-586458/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值