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

TNSNAMES一覧 †

システム	病院コード	病院	系	スキーマ	TNSNAMES
PrimeKarte	H000	ＳＢＳ	社内系	SBS***	DXTORO
〃	H002	静岡市立	本系	SBS	PK_SHIZUOKA
〃	〃	〃	テスト系	TEST	PK_SHIZUOKA_TEST
〃	H005	榛原	本系	SBS	PK_HAIBARA
〃	〃	〃	テスト系	TEST	PK_HAIBARA_TEST
〃	H018	菊川	本系	SBS	PK_KIKUGAWA
〃	〃	〃	テスト系	TEST	PK_KIKUGAWA_TEST
〃	H019	湖西	本系	SBS	PK_KOSAI
〃	〃	〃	テスト系	PRAC	PK_KOSAI_TEST
〃	H025	沼津	本系	SBS	PK_NUMAZU
〃	〃	〃	テスト系	TEST	PK_NUMAZU_TEST
〃	H028	医療Ｃ	本系	SBS	PK_IRYOC
〃	〃	〃	テスト系	TEST	PK_IRYOC_TEST
〃	H051	渡辺	本系	SBS	PK_WATANABE
〃	〃	〃	テスト系	TEST	〃
〃	H055	岡村	本系	SBS	PK_OKAMURA
〃	〃	〃	テスト系	TEST	〃
〃	H057	浜松北	本系	SBS	PK_HAMAMATSU_KITA
〃	〃	〃	テスト系	TEST	〃
〃	H058	三島	本系	SBS	PK_MISHIMA
〃	〃	〃	テスト系	TEST	〃
〃	H059	西脇	本系	SBS	PK_NISHIWAKI
〃	〃	〃	テスト系	TEST	〃
〃	H201	岡波	本系	SBS	PK_OKANAMI
〃	〃	〃	テスト系	TEST	PK_OKANAMI_TEST

↑

TNSNAMES詳細 †

 DXTORO =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = endeavor)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = toro.endeavor.palace)
   )
 )

 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_HAIBARA =
 (DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.210.33)(PORT = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.210.34)(PORT = 1522))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = toro_balance.srvh005db00.h005)
   )
 )

 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_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_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_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_WATANABE =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.151.40.31)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = toro.srvh051db00.h051)
   )
 )

 PK_OKAMURA =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.31)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = toro.srvh055db00.h055)
   )
 )

 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_OKANAMI =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.201.0.31)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = toro.srvh201db00.h201)
   )
 )