# This file contains the syntax information for
# the entries to be put in any tnsnames.ora file
# The entries in this file are need based.
～
# The following is the general syntax for any entry in
# a tnsnames.ora file. There could be several such entries
# tailored to the user's needs.
# -- 開発環境 ------------------------------------------------------------------
# 開発環境ロードバランサ任せ
AAADB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.20.xx.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.20.xx.2)(PORT = 1521))
(FAILOVER = ON)
(LOAD_BALANCE = ON)
)
(CONNECT_DATA =
(SERVICE_NAME = aaadb)
(SERVER=DEDICATED)
)
)
# 開発環境１ノード優先
AAADB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.20.xx.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.20.xx.2)(PORT = 1521))
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
)
(CONNECT_DATA =
(SERVICE_NAME = aaadb)
(SERVER=DEDICATED)
)
)
# 開発環境２ノード優先
AAADB2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.20.xx.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.20.xx.1)(PORT = 1521))
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
)
(CONNECT_DATA =
(SERVICE_NAME = aaadb)
(SERVER=DEDICATED)
)
)
# -- ステージング環境 ------------------------------------------------------------------
# ステージング環境
AAADB_ST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.22)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aaadb)
)
)
# ステージング2環境
AAADB_ST2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.23)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aaadb)
)
)
# -- 本番環境 ------------------------------------------------------------------
# 本番環境ロードバランサ任せ
AAADB_REAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.2)(PORT = 1521))
(FAILOVER = ON)
(LOAD_BALANCE = ON)
)
(CONNECT_DATA =
(SERVICE_NAME = aaadb)
(SERVER=DEDICATED)
)
)
# 本番環境１ノード優先
AAADB1_REAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.2)(PORT = 1521))
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
)
(CONNECT_DATA =
(SERVICE_NAME = aaadb)
(SERVER=DEDICATED)
)
)
# 本番環境２ノード優先
AAADB2_REAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.1)(PORT = 1521))
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
)
(CONNECT_DATA =
(SERVICE_NAME = aaadb)
(SERVER=DEDICATED)
)
)
## 内部環境
BBB_AAADB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.xx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aaadb)
)
)
