*目次 [#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