接続先の変更
tnsnames.oraを編集する
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. HONTYAN = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.21.65.20)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = souko) ) ) SOUKO = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) # (ADDRESS = (PROTOCOL = TCP)(HOST = 999.999.999.999)(PORT = 1521)) #ここを変える ) (CONNECT_DATA = (SID = SOUKO) (GLOBAL_NAME = SOUKO) ) )
Webの場合はIISなどの再起動をする