oracle数据库地址改变最直接的办法:
打开安装目录 (我的是安装在E盘)
E:/app/Administrator/product/11.1.0/client_4/network/admin
主要是新建两个监听文件 ,文本内容复制下来如下:
一个是:tnsnames.ora
# tnsnames.ora Network Configuration File: F:/app/Administrator/product/11.1.0/client_1/NETWORK/ADMIN/tnsnames.ora
# Generated by Oracle configuration tools.
erpdb=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-nas1.db.17zsy.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = erpdb)
)
)
红色部分为数据库IP地址
粉色部分数据库名称
另一个是:
listener.ora
# listener.ora Network Configuration File: F:/app/Administrator/product/11.1.0/client_1/NETWORK/ADMIN/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = erpdb)
(SID_NAME = erpdb)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.92.5)(PORT = 1521))
)
红色部分为本机IP地址
粉色部分数据库名称