hots文件配置ip 数据库配置tnsnames.ora

tnsnames.ora

D:\Program Files (x86)\PLSQL Developer\instantclient_12_1\network\admin\tnsnames.ora

eg:
orcl140 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.140 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBDATA )
)
)


开发验收库
DEVCheck =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.59)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dev59)
)
)


hots文件修改配置信息：
C:\Windows\System32\drivers\etc\hots


# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
192.168.1.221 hobo2
192.168.1.220 hobo1
192.168.1.222 hobo3
#test
#192.168.1.193 www.msweb.com
#192.168.1.172 www.ams.com
#192.168.1.173 www.mmsweb.com
#192.168.1.152 www.mmsweb.com
#192.168.1.151 www.amsweb.com
#192.168.1.150 www.msweb.com

#192.168.1.175 www.pmsweb.com
192.168.1.165 pftp.dinpay.com

#development
#192.168.1.173 cdn.dinpay.com
#192.168.1.173 www.mmsweb.com
#192.168.1.172 www.amsweb.com
#192.168.1.150 www.msweb.com

#192.168.1.194 images.dinpay.com
#192.168.1.225 www.dd4.com
#192.168.1.27 local.dd4.com

192.168.3.152 paychannel.dinpay.com
192.168.3.152 www.mmsweb.com
192.168.3.152 download.dinpay.com
192.168.3.152 cdn.dinpay.com
192.168.3.151 www.amsweb.com
192.168.3.150 www.msweb.com
192.168.1.152 images.dinpay.com

192.168.3.165 pub.dinpay.vad
192.168.3.165 dubbo.dinpay.vad
192.168.3.165 demo.dinpay.vad
192.168.3.165 push.dinpay.vad
192.168.3.165 pay.dinpay.vad
192.168.3.165 cdnpay.dinpay.vad
192.168.3.165 idva.dinpay.vad

91.213.30.151 accounts.google.com
91.213.30.151 www.google.com.hk

# 验收环境
#http://192.168.3.154:7080/IPPTestDemo/
192.168.3.154 pay.dinpay.com
192.168.3.154 ipay.dinpay.com
192.168.3.154 bank.dinpay.com
192.168.3.154 ibank.dinpay.com
192.168.3.154 cdnpay.dinpay.com
192.168.3.154 query.dinpay.com
192.168.3.154 transfer.dinpay.com

192.168.3.152 paychannel.dinpay.com
192.168.3.152 www.mmsweb.com
192.168.3.152 download.dinpay.com
192.168.3.152 cdn.dinpay.com
192.168.3.151 www.amsweb.com
192.168.3.150 www.msweb.com

# 开发验收3网段
#192.168.3.154 pay.dinpay.com
#192.168.3.154 ipay.dinpay.com
#192.168.3.154 bank.dinpay.com
#192.168.3.154 ibank.dinpay.com
#192.168.3.154 cdnpay.dinpay.com
#192.168.3.154 query.dinpay.com
#192.168.3.154 transfer.dinpay.com
#192.168.3.154 api.dinpay.com
#192.168.3.152 paychannel.dinpay.com
#192.168.3.152 www.mmsweb.com
#192.168.3.152 download.dinpay.com
#192.168.3.152 cdn.dinpay.com
#192.168.3.151 www.amsweb.com
#192.168.3.150 www.msweb.com //总后台测试环境
#192.168.3.153 cash.ddbill.com
#192.168.3.153 cdn.ddbill.com
#192.168.3.153. mobile.ddbill.com
# test/Test123adkpps