1、找到客户端网络配置文件tnsnames.ora,在Oracle 11.2版本中,该文件位于Administrator/product/11.2.0/dbhome_2/NETWORK/ADMIN文件夹中
2、使用记事本打开该文件,可以发现里面是类似下面的内容:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
3、在后面换行编辑网络服务名MYDB(