TNSNAMES のバックアップ(No.14)

目次 †

目次
TNSNAMES一覧
TNSNAMES詳細
HOSTS

TNSNAMES一覧 †

システム	病院コード	病院	系	スキーマ	TNSNAMES	備考
PrimeKarte	H000	デモ機	社内系	SBS	EPOCH	SBSデモ機構築用
〃	〃	〃	〃	〃	BSN	BSNデモ機構築用
〃	H002	静岡市立	本系	SBS	PK_SHIZUOKA	PrimeCluster
〃	〃	〃	テスト系	TEST	PK_SHIZUOKA_TEST
〃	〃	〃	社内系	SBS002	SJ11057
〃	H011	清水厚生	本系	SBS	PK_SHIMIZUKOSEI
〃	〃	〃	テスト系	TEST	PK_SHIMIZUKOSEI_TEST
〃	〃	〃	社内系	SBS011	SJ11057
〃	H012	焼津	本系	SBS	PK_YAIZU	Oracle RAC
〃	〃	〃	本系1	〃	PK_YAIZU_01	優先ノード1
〃	〃	〃	本系2	〃	PK_YAIZU_02	優先ノード2
〃	〃	〃	テスト系	TEST	PK_YAIZU_TEST
〃	〃	〃	社内系	SBS012	SJ11057
〃	H013	静岡厚生	本系	SBS	PK_SHIZUOKAKOSEI
〃	〃	〃	テスト系	TEST	PK_SHIZUOKAKOSEI_TEST
〃	〃	〃	社内系	SBS013	SJ11057
〃	H014	中伊豆	本系	SBS	PK_NAKAIZU
〃	〃	〃	テスト系	TEST	PK_NAKAIZU_TEST
〃	〃	〃	社内系	SBS014	SJ11057
〃	H018	菊川	本系	SBS	PK_KIKUGAWA	Oracle RAC
〃	〃	〃	本系1	〃	PK_KIKUGAWA_01	優先ノード1
〃	〃	〃	本系2	〃	PK_KIKUGAWA_02	優先ノード2
〃	〃	〃	テスト系	TEST	PK_KIKUGAWA_TEST
〃	〃	〃	社内系	SBS018	SJ11057
〃	H019	湖西	本系	SBS	PK_KOSAI	Oracle RAC
〃	〃	〃	本系1	〃	PK_KOSAI_01	優先ノード1
〃	〃	〃	本系2	〃	PK_KOSAI_02	優先ノード2
〃	〃	〃	テスト系	PRAC	PK_KOSAI_TEST
〃	〃	〃	社内系	SBS019	SJ11057
〃	H021	遠州	本系	SBS	PK_ENSHU	Oracle RAC
〃	〃	〃	本系1	〃	PK_ENSHU_01	優先ノード1
〃	〃	〃	本系2	〃	PK_ENSHU_02	優先ノード2
〃	〃	〃	テスト系	TEST	PK_ENSHU_TEST
〃	〃	〃	社内系	SBS021	SJ11057
〃	H025	沼津	本系	SBS	PK_NUMAZU	Oracle RAC
〃	〃	〃	本系1	〃	PK_NUMAZU_01	優先ノード1
〃	〃	〃	本系2	〃	PK_NUMAZU_02	優先ノード2
〃	〃	〃	テスト系	TEST	PK_NUMAZU_TEST
〃	〃	〃	社内系	SBS025	SJ11057
〃	H028	医療Ｃ	本系	SBS	PK_IRYOC	Oracle RAC
〃	〃	〃	本系1	〃	PK_IRYOC_01	優先ノード1
〃	〃	〃	本系2	〃	PK_IRYOC_02	優先ノード2
〃	〃	〃	テスト系	TEST	PK_IRYOC_TEST
〃	〃	〃	社内系	SBS028	SJ11057
〃	H032	天竜	本系	SBS	PK_TENRYU_2013
〃	〃	〃	テスト系	TEST	PK_TENRYU_2013_TEST
〃	〃	〃	社内系	SBS032	SJ11057
〃	H051	渡辺	本系	SBS	PK_WATANABE
〃	〃	〃	テスト系	TEST	〃
〃	〃	〃	社内系	SBS051	SJ11057
〃	H055	岡村	本系	SBS	PK_OKAMURA_2013
〃	〃	〃	テスト系	TEST	PK_OKAMURA_2013_TEST
〃	〃	〃	社内系	SBS055	SJ11057
〃	H056	北斗わかば	本系	SBS	PK_HOKUTO
〃	〃	〃	テスト系	TEST	〃
〃	〃	〃	社内系	SBS056	SJ11057
〃	H057	浜松北	本系	SBS	PK_HAMAMATSU_KITA
〃	〃	〃	テスト系	TEST	〃
〃	〃	〃	社内系	SBS057	SJ11057
〃	H058	三島	本系	SBS	PK_MISHIMA
〃	〃	〃	テスト系	TEST	〃
〃	〃	〃	社内系	SBS058	SJ11057
〃	H059	西脇	本系	SBS	PK_NISHIWAKI	Oracle RAC
〃	〃	〃	本系1	〃	PK_NISHIWAKI_01	優先ノード1
〃	〃	〃	本系2	〃	PK_NISHIWAKI_02	優先ノード2
〃	〃	〃	テスト系	TEST	PK_NISHIWAKI_TEST
〃	〃	〃	社内系	SBS059	SJ11057
〃	H060	R&O	本系	SBS	PK_RANDO
〃	〃	〃	テスト系	TEST	〃
〃	〃	〃	社内系	SBS060	SJ11057
〃	H201	岡波	本系	SBS	PK_OKANAMI
〃	〃	〃	テスト系	TEST	PK_OKANAMI_TEST
〃	〃	〃	社内系	SBS201	SJ11057

↑

TNSNAMES詳細 †

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

 SJ11057 =
 (DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SJ11057)(PORT = 1521))
  )
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = demo)
  )
)

 PK_SHIZUOKA =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.30)(PORT = 1521))
   (CONNECT_DATA =
     (SERVICE_NAME = toro.srvh002db00.h002)
   )
 )

 PK_SHIZUOKA_TEST =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.54)(PORT = 1521))
   (CONNECT_DATA =
     (SERVICE_NAME = test.srvh002test01.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_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 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH018DB01-vip)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH018DB02-vip)(PORT = 1522))
   (LOAD_BALANCE = yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_balance.srvh018db00.h018)
     (FAILOVER_MODE =
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)
     )
   )
 )

 PK_KIKUGAWA_01 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH018DB01-vip)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH018DB02-vip)(PORT = 1522))
   (LOAD_BALANCE =yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_node01.SRVH018DB00.h018)
     (FAILOVER_MODE =
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)
     )
   )
 )

 PK_KIKUGAWA_02 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH018DB02-vip)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH018DB01-vip)(PORT = 1522))
   (LOAD_BALANCE =yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_node02.SRVH018DB00.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 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.20.33)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.20.34)(PORT = 1522))
   (CONNECT_DATA =
     (SERVICE_NAME = toro_balance.srvh019db00.h019)
   )
 )

 PK_KOSAI_01 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.20.33)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.20.34)(PORT = 1522))
   (LOAD_BALANCE = on)
   (FAILOVER = on)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_node01.srvh019db00.h019)
     (FAILOVER_MODE =
       (TYPE = select)
       (METHOD = basic)
       (RETRIES = 30)
       (DELAY = 5)
     )
   )
 )

 PK_KOSAI_02 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.20.33)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.20.34)(PORT = 1522))
   (LOAD_BALANCE = on)
   (FAILOVER = on)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_node02.srvh019db00.h019)
     (FAILOVER_MODE =
       (TYPE = select)
       (METHOD = basic)
       (RETRIES = 30)
       (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 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH025DB01-vip)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH025DB02-vip)(PORT = 1522))
   (LOAD_BALANCE = yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_balance.srvh025db00.h025)
     (FAILOVER_MODE =
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)
     )
   )
 )

 PK_NUMAZU_01 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH025DB01-vip)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH025DB02-vip)(PORT = 1522))
   (LOAD_BALANCE =yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_node01.srvh025db00.h025)
     (FAILOVER_MODE =
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)
     )
   )
 )

 PK_NUMAZU_02 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH025DB02-vip)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH025DB01-vip)(PORT = 1522))
   (LOAD_BALANCE =yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_node02.srvh025db00.h025)
     (FAILOVER_MODE =
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)
     )
   )
 )

 PK_NUMAZU_TEST =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.25.101.111)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = test.vmh025test01.h025)
   )
 )

 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_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.30.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_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 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH059DB01-vip)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH059DB02-vip)(PORT = 1522))
   (LOAD_BALANCE = yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_balance.SRVH059DB00.h059)
     (FAILOVER_MODE =
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)
     )
   )
 )

 PK_NISHIWAKI_01 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH059DB01-vip)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH059DB02-vip)(PORT = 1522))
   (LOAD_BALANCE =yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_node01.SRVH059DB00.h059)
     (FAILOVER_MODE =
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)
     )
   )
 )

 PK_NISHIWAKI_02 =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH059DB02-vip)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = SRVH059DB01-vip)(PORT = 1522))
   (LOAD_BALANCE =yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = toro_node02.SRVH059DB00.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_OKANAMI =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.201.0.31)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = toro.srvh201db00.h201)
   )
 )

↑

HOSTS †

 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.25.101.33     SRVH025DB01-vip.karte.numazu           SRVH025DB01-vip
 10.25.101.34     SRVH025DB02-vip.karte.numazu           SRVH025DB02-vip
 10.159.20.31     SRVH059DB01-vip.karte.nishiwaki           SRVH059DB01-vip
 10.159.20.32     SRVH059DB02-vip.karte.nishiwaki           SRVH059DB02-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