OSqlEdit
http://www.hi-ho.ne.jp/a_ogawa/osqledit/index.htm
接続設定
OSqlEditのtnsnames.oraの場所
osqledit_9フォルダ直下にtnsnames.oraファイルがあります。
tnsnames.oraのtsn設定例
# 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.xx.xx.x)(PORT = xxxx))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.xx.xx.x)(PORT = xxxx))
(FAILOVER = ON)
(LOAD_BALANCE = ON)
)
(CONNECT_DATA =
(SERVICE_NAME = aaadb)
(SERVER=DEDICATED)
)
)
# 開発環境１ノード優先
AAADB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.xx.xx.x)(PORT = xxxx))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.xx.xx.x)(PORT = xxxx))
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
)
(CONNECT_DATA =
(SERVICE_NAME = aaadb)
(SERVER=DEDICATED)
)
)
# 開発環境２ノード優先
AAADB2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.xx.xx.x)(PORT = xxxx))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.20.xx.x)(PORT = xxxx))
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
)
(CONNECT_DATA =
(SERVICE_NAME = aaadb)
(SERVER=DEDICATED)
)
)
