Oracle10g RAC設定記錄

ecsrac01$cat hosts
10.134.130.177  ecsrac01
127.0.0.1       localhost

192.168.1.11    ecspri01
10.134.130.179  ecsvip01

10.134.130.178  ecsrac02
192.168.1.12    ecspri02
10.134.130.180  ecsvip02 

 

 

ecsdb2.__db_cache_size=3103784960
ecsdb1.__db_cache_size=3305111552
ecsdb1.__java_pool_size=33554432
ecsdb2.__java_pool_size=33554432
ecsdb1.__large_pool_size=16777216
ecsdb2.__large_pool_size=16777216
ecsdb2.__shared_pool_size=5419040768
ecsdb1.__shared_pool_size=5217714176
ecsdb1.__streams_pool_size=0
ecsdb2.__streams_pool_size=0
*.aq_tm_processes=1
*.audit_file_dest='/u01/product/admin/ecsdb/adump'
*.background_dump_dest='/u01/product/admin/ecsdb/bdump'
*.cluster_database_instances=2
*.cluster_database=TRUE
*.compatible='10.2.0.3.0'
*.control_files='/ocfs_data1/ecsdb/control01.ctl','/ocfs_data1/ecsdb/control02.ctl','/ocfs_data1/ecsdb/control03.ctl'
*.core_dump_dest='/u01/product/admin/ecsdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ecsdb'
*.db_recovery_file_dest='/ocfs_data1/ecsdb/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ecsdbXDB)'
ecsdb2.instance_number=2
ecsdb1.instance_number=1
*.job_queue_processes=50
*.local_listener='LOCAL_ECSDB'
*.log_archive_dest_1='LOCATION=/ocfs_data1/ecsdb/arch'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=600
*.pga_aggregate_target=538860800
*.processes=1200
*.remote_listener='LISTENERS_ECSDB'
*.remote_login_passwordfile='exclusive'
*.sessions=1325
*.sga_target=8589934592
ecsdb2.thread=2
ecsdb1.thread=1
*.undo_management='AUTO'
*.undo_retention=10800
ecsdb1.undo_tablespace='UNDOTBS1'
ecsdb2.undo_tablespace='UNDOTBS2'
*.user_dump_dest='/u01/product/admin/ecsdb/udump'
~

 

 

ecsrac01$cat listener.ora
# listener.ora.ecsrac01 Network Configuration File: /u01/product/oracle/network/admin/listener.ora.ecsrac01
# Generated by Oracle configuration tools.

LISTENER_ECSRAC01 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip01)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.134.130.177)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

 

 

 

ecsrac01$cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/product/oracle/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ECSDB2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip02)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ecsdb)
      (INSTANCE_NAME = ecsdb2)
    )
  )

ECSDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip01)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ecsdb)
      (INSTANCE_NAME = ecsdb1)
    )
  )

ECS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.134.130.170)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ecsdb)
    )
  )

ECSDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip01)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip02)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ecsdb)
     (FAILOVER_MODE =
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)
     )
    )
  )

LISTENERS_ECSDB =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip01)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip02)(PORT = 1521))
  )

LOCAL_ECSDB =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.134.130.177)(PORT = 1521))
  )