*目次 [#g5ddaa36]
#contents
*TNSNAMES一覧 [#c2ae1e51]
|システム|病院コード|病院|系|スキーマ|TNSNAMES|備考|
|PrimeKarte|H000|デモ機|社内系|SBS|EPOCH|SBSデモ機構築用|
|〃|〃|〃|〃|〃|BSN|BSNデモ機構築用|
|〃|H002|静岡市立|本系|SBS|PK_SHIZUOKA_2015|Oracle RAC|
|〃|〃|〃|テスト系|TEST|PK_SHIZUOKA_2015_TEST||
|〃|〃|〃|社内系|SBS002A|EMPEROR||
|〃|H011|清水厚生|本系|SBS|PK_SHIMIZUKOSEI||
|〃|〃|〃|テスト系|TEST|PK_SHIMIZUKOSEI_TEST||
|〃|〃|〃|社内系|SBS011|EMPEROR_SBS||
|〃|H012|焼津|本系|SBS|PK_YAIZU|Oracle RAC|
|〃|〃|〃|本系1|〃|PK_YAIZU_01|優先ノード1|
|〃|〃|〃|本系2|〃|PK_YAIZU_02|優先ノード2|
|〃|〃|〃|テスト系|TEST|PK_YAIZU_TEST||
|〃|〃|〃|参照系|SBS|PK_YAIZU_SANSHO|3F|
|〃|〃|〃|社内系|SBS012|EMPEROR_SBS||
|〃|H013|静岡厚生|本系|SBS|PK_SHIZUOKAKOSEI||
|〃|〃|〃|テスト系|TEST|PK_SHIZUOKAKOSEI_TEST||
|〃|〃|〃|社内系|SBS013|EMPEROR_SBS||
|〃|H014|中伊豆|本系|SBS|PK_NAKAIZU||
|〃|〃|〃|テスト系|TEST|PK_NAKAIZU_TEST||
|〃|〃|〃|社内系|SBS014|EMPEROR_SBS||
|〃|H018|菊川|本系|SBS|PK_KIKUGAWA_2016|Oracle RAC|
|〃|〃|〃|本系1|〃|PK_KIKUGAWA_2016_01|優先ノード1|
|〃|〃|〃|本系2|〃|PK_KIKUGAWA_2016_02|優先ノード2|
|〃|〃|〃|テスト系|TEST|PK_KIKUGAWA_2016_TEST||
|〃|〃|〃|社内系|SBS018A|EMPEROR||
|〃|H019|湖西|本系|SBS|PK_KOSAI_2015||
|〃|〃|〃|テスト系|TEST|PK_KOSAI_2015_TEST||
|〃|〃|〃|社内系|SBS019A|EMPEROR||
|〃|H021|遠州|本系|SBS|PK_ENSHU|Oracle RAC|
|〃|〃|〃|本系1|〃|PK_ENSHU_01|優先ノード1|
|〃|〃|〃|本系2|〃|PK_ENSHU_02|優先ノード2|
|〃|〃|〃|テスト系|TEST|PK_ENSHU_TEST||
|〃|〃|〃|社内系|SBS021|EMPEROR_SBS||
|〃|H025|沼津|本系|SBS|PK_NUMAZU_2017|Oracle RAC|
|〃|〃|〃|本系1|〃|PK_NUMAZU_2017_01|優先ノード1|
|〃|〃|〃|本系2|〃|PK_NUMAZU_2017_02|優先ノード2|
|〃|〃|〃|テスト系|TEST|PK_NUMAZU_2017_TEST||
|〃|〃|〃|社内系|SBS025A|EMPEROR||
|〃|H028|医療C|本系|SBS|PK_IRYOC|Oracle RAC|
|〃|〃|〃|本系1|〃|PK_IRYOC_01|優先ノード1|
|〃|〃|〃|本系2|〃|PK_IRYOC_02|優先ノード2|
|〃|〃|〃|テスト系|TEST|PK_IRYOC_TEST||
|〃|〃|〃|社内系|SBS028|EMPEROR_SBS||
|〃|H029|てんかん|本系|SBS|PK_TENKAN_2017||
|〃|〃|〃|テスト系|TEST|PK_TENKAN_2017_TEST||
|〃|〃|〃|社内系|SBS029A|EMPEROR||
|〃|H032|天竜|本系|SBS|PK_TENRYU_2013||
|〃|〃|〃|テスト系|TEST|PK_TENRYU_2013_TEST||
|〃|〃|〃|社内系|SBS032|EMPEROR_SBS||
|〃|H051|富士整形|本系|SBS|PK_WATANABE||
|〃|〃|〃|テスト系|TEST|〃||
|〃|〃|〃|本系2014|SBS|PK_WATANABE_2014||
|〃|〃|〃|テスト系2014|TEST|PK_WATANABE_2014_TEST||
|〃|〃|〃|社内系|SBS051|EMPEROR_SBS||
|〃|H055|岡村|本系|SBS|PK_OKAMURA_2013||
|〃|〃|〃|テスト系|TEST|PK_OKAMURA_2013_TEST||
|〃|〃|〃|社内系|SBS055|EMPEROR_SBS||
|〃|H056|北斗わかば|本系|SBS|PK_HOKUTO||
|〃|〃|〃|テスト系|TEST|〃||
|〃|〃|〃|社内系|SBS056|EMPEROR_SBS||
|〃|H057|浜松北|本系|SBS|PK_HAMAMATSU_KITA||
|〃|〃|〃|テスト系|TEST|〃||
|〃|〃|〃|社内系|SBS057|EMPEROR_SBS||
|〃|H058|三島|本系|SBS|PK_MISHIMA||
|〃|〃|〃|テスト系|TEST|〃||
|〃|〃|〃|社内系|SBS058|EMPEROR_SBS||
|〃|H059|西脇|本系|SBS|PK_NISHIWAKI_2017||
|〃|〃|〃|テスト系|TEST|PK_NISHIWAKI_2017_TEST||
|〃|〃|〃|社内系|SBS059|EMPEROR_SBS||
|〃|H060|R&O|本系|SBS|PK_RANDO||
|〃|〃|〃|テスト系|TEST|〃||
|〃|〃|〃|社内系|SBS060|EMPEROR_SBS||
|〃|H065|豊田えいせい|本系|SBS|PK_TOYODA||
|〃|〃|〃|テスト系|TEST|PK_TOYODA_TEST||
|〃|〃|〃|社内系|SBS065|EMPEROR||
|〃|H067|横浜第一|本系|SBS|PK_YOKOICHI||
|〃|〃|〃|テスト系|TEST|PK_YOKOICHI_TEST||
|〃|〃|〃|社内系|SBS067|EMPEROR||
|〃|H068|吉祥寺あさひ|本系|SBS|PK_KICHIA||
|〃|〃|〃|テスト系|TEST|PK_KICHIA_TEST||
|〃|〃|〃|社内系|SBS068|EMPEROR||
|〃|H069|伊豆日赤|本系|SBS|PK_IZURC||
|〃|〃|〃|テスト系|TEST|PK_IZURC_TEST||
|〃|〃|〃|社内系|SBS069|EMPEROR||
|〃|H075|掛川東|本系|SBS|PK_KAKEGAWA||
|〃|〃|〃|テスト系|TEST|PK_KAKEGAWA_TEST||
|〃|〃|〃|社内系|SBS075|EMPEROR||
|〃|H076|浜松南|本系|SBS|PK_HAMAMATSUMINAMI||
|〃|〃|〃|テスト系|TEST|PK_HAMAMATSUMINAMI_TEST||
|〃|〃|〃|社内系|SBS076|EMPEROR||
|〃|H079|東名裾野|本系|SBS|PK_SUSONO||
|〃|〃|〃|テスト系|TEST|PK_SUSONO_TEST||
|〃|〃|〃|社内系|SBS079|EMPEROR||
|〃|H201|岡波|本系|SBS|PK_OKANAMI_2016||
|〃|〃|〃|テスト系|TEST|PK_OKANAMI_TEST||
|〃|〃|〃|社内系|SBS201|EMPEROR_SBS||


*TNSNAMES詳細 [#r2d28224]

 EPOCH =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.2.35)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = epoch)
    )
  )

 BSN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.2.35)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = bsn)
    )
  )

 EMPEROR_SBS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = EMPEROR01B)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.emperor01b.h000)
    )
  )

 EMPEROR_OTHER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = EMPEROR01B)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = itec.emperor01b.h000)
    )
  )

 EMPEROR =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.2.34)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.emperor.h000)
    )
  )

  PK_SHIZUOKA_2015 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.157)(PORT = 1522))
    (LOAD_BALANCE =yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_node02.SRVH002DB00A.h002)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_SHIZUOKA_2015_TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.144)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh002test01a.h002)
    )
  )

  PK_SHIMIZUKOSEI =
  (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.111.20.73)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro.srvh011db00.h011)
   )
  )

  PK_SHIMIZUKOSEI_TEST =
  (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.111.20.34)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = test)
   )
  )

  PK_YAIZU =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH012DB01-vip)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH012DB02-vip)(PORT = 1522))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_balance.SRVH012DB00.h012)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_YAIZU_01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH012DB01-vip)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH012DB02-vip)(PORT = 1522))
    (LOAD_BALANCE =yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_node01.SRVH012DB00.h012)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_YAIZU_02 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH012DB02-vip)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH012DB01-vip)(PORT = 1522))
    (LOAD_BALANCE =yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_node02.SRVH012DB00.h012)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_YAIZU_TEST =
  (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.171.54)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = test)
   )
  )

  PK_YAIZU_SANSHO =
  (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.171.42)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = sansho)
   )
  )

 PK_SHIZUOKAKOSEI =
  (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.113.20.73)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro.srvh013db00.h013)
   )
  )

 PK_SHIZUOKAKOSEI_TEST =
  (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.113.20.34)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = test)
   )
  )

 PK_NAKAIZU =
  (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.114.20.73)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro.srvh014db00.h014)
   )
  )

  PK_NAKAIZU_TEST =
  (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.114.20.34)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = test)
   )
  )

 PK_KIKUGAWA_2016_01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.18.3.35)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro_node01.SRVH018DB00A.h018)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
  
 PK_KIKUGAWA_2016_02 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.18.3.35)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro_node02.SRVH018DB00A.h018)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
  
 PK_KIKUGAWA_2016 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.18.3.35)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro_balance.SRVH018DB00A.h018)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_KIKUGAWA_TEST =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.18.2.54)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = test)
   )
 )

 PK_KOSAI_2015 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.20.23)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh019db01.h019)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_KOSAI_2015_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.20.24)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh019test01.h019)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_ENSHU =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH021DB01-vip)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH021DB02-vip)(PORT = 1522))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_balance.SRVH021DB00.h021)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_ENSHU_01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH021DB01-vip)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH021DB02-vip)(PORT = 1522))
    (LOAD_BALANCE =yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_node01.SRVH021DB00.h021)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_ENSHU_02 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH021DB02-vip)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH021DB01-vip)(PORT = 1522))
    (LOAD_BALANCE =yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_node02.SRVH021DB00.h021)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_ENSHU_TEST =
 (DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.121.20.167)(PORT = 1521))
  )
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = test)
  )
 )

  PK_NUMAZU_2017 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.25.1.35)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro_balance.SRVH025DB00A.h025)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
  
  PK_NUMAZU_2017_01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.25.1.35)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro_node01.SRVH025DB00A.h025)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
  
  PK_NUMAZU_2017_02 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.25.1.35)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro_node02.SRVH025DB00A.h025)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
  
  PK_NUMAZU_2017_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.25.1.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.VMH025TEST01A.h025)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_IRYOC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH028DB01-vip)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH028DB02-vip)(PORT = 1522))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_balance.SRVH028DB00.h028)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_IRYOC_01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH028DB01-vip)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH028DB02-vip)(PORT = 1522))
    (LOAD_BALANCE =yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_node01.SRVH028DB00.h028)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_IRYOC_02 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH028DB02-vip)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH028DB01-vip)(PORT = 1522))
    (LOAD_BALANCE =yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toro_node02.SRVH028DB00.h028)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_IRYOC_TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.57.2.54)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
  )

  PK_TENKAN_2017 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.100.31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh029db01a.h029)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_TENKAN_2017_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.100.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh029test01a.h029)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_TENRYU_2013 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.32.20.31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh032db01.h032)
    )
  )

  PK_TENRYU_2013_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.32.20.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh032test01.h032)
    )
  )

  PK_WATANABE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.40.31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.srvh051db00.h051)
    )
  )

  PK_WATANABE_2014 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.40.32)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh051db01a.h051)
    )
  )

  PK_WATANABE_2014_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.40.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh051test01a.h051)
    )
  )

  PK_OKAMURA_2013 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.131)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh055db01a.h055)
    )
  )

  PK_OKAMURA_2013_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.167)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )

  PK_HOKUTO =
   (DESCRIPTION =
      (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.20.31)(PORT = 1521))
      )
      (CONNECT_DATA =
         (SERVICE_NAME = toro.srvh056db00.h056)
      )
   )

  PK_HAMAMATSU_KITA =
   (DESCRIPTION =
      (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = 10.157.2.31)(PORT = 1521))
      )
      (CONNECT_DATA =
         (SERVICE_NAME = toro.srvh057db00.h057)
      )
   )

  PK_MISHIMA =
   (DESCRIPTION =
      (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.20.31)(PORT = 1521))
      )
      (CONNECT_DATA =
         (SERVICE_NAME = toro.srvh058db00.h058)
      )
   )

 PK_NISHIWAKI_2017_SBS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.159.20.24)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh059db01a.h059)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_NISHIWAKI_2017_IN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 128.0.159.24)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh059db01a.h059)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_NISHIWAKI_2017_TEST_SBS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.159.20.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh059test01a.h059)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_NISHIWAKI_2017_TEST_IN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 128.0.159.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh059test01a.h059)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_RANDO =
   (DESCRIPTION =
      (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = 10.160.20.31)(PORT = 1521))
      )
      (CONNECT_DATA =
         (SERVICE_NAME = toro.srvh060db00.h060)
      )
   )

  PK_TOYODA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.165.2.31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh065db01.h065)
    )
  )

  PK_TOYODA_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.165.2.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )

  PK_YOKOICHI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = VMH067DB01)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh067db01.h067)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_YOKOICHI_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = VMH067TEST01)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh067test01.h067)
    )
  )

  PK_KICHIA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = VMH068DB01)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh068db01.h068)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  KICHIA_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = VMH068TEST01)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh068test01.h068)
    )
  )

 PK_IZURC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.169.100.31)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh069db01.h069)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_IZURC_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.169.100.54)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh069test01.h069)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_KAKEHIGA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.75.2.31)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh075db01.h075)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_KAKEHIGA_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.75.2.54)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh075test01.h075)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_HAMAMATSUMINAMI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.184.10.31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh076db01.h076)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

 PK_HAMAMATSUMINAMI_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.184.10.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh076test01.h076)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_SUSONO =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.79.2.53)(PORT = 1521))
 #現地
 #      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.53)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.vmh079db01.h079)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  PK_SUSONO_TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.79.2.54)(PORT = 1521))
 #現地
 #      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test.vmh079test01.h079)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

  H032SSMIX =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.32.20.73)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ssmix.srvh032ssmix01.h032)
    )
  )
  
  PK_OKANAMI_2016 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.201.0.32)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = toro.srvh201db12.h201)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )



*HOSTS [#cd51a61e]

  10.19.20.33     SRVH019DB01-vip.order.kosai           SRVH019DB01-vip
  10.19.20.34     SRVH019DB02-vip.order.kosai           SRVH019DB02-vip
  10.18.2.33     SRVH018DB01-vip.karte.kikugawa           SRVH018DB01-vip
  10.18.2.34     SRVH018DB02-vip.karte.kikugawa           SRVH018DB02-vip
  10.57.2.33     SRVH028DB01-vip.karte.shizuokamc           SRVH028DB01-vip
  10.57.2.34     SRVH028DB02-vip.karte.shizuokamc           SRVH028DB02-vip
  10.5.171.33     SRVH012DB01-vip.karte.yaizu           SRVH012DB01-vip
  10.5.171.34     SRVH012DB02-vip.karte.yaizu           SRVH012DB02-vip
  10.121.20.153     SRVH021DB01-vip.karte.enshu           SRVH021DB01-vip
  10.121.20.154     SRVH021DB02-vip.karte.enshu           SRVH021DB02-vip


トップ   編集 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS