ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle9.2.0.4 RAC 三节点参数设置

Oracle9.2.0.4 RAC 三节点参数设置

原创 Linux操作系统 作者:tolywang 时间:2009-03-10 12:00:31 0 删除 编辑

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

下一篇: 消化不良
请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13516820