節點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 = )
    )
)

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 = )
    )
)

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 = )
    )
)

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)
    )
)

Oracle9.2.0.4 RAC 三節點引數設定

相關文章