路径: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN 格式:
9i的位置;D:\oracle\ora92\network\admin
红色为oracle Home
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = ws-i-zyma-01)
(PORT = 1521)
)
)(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = keirin.localhost)
)
)
Local.DB 登录时DNS名?
Host:数据库服务器IP
ADDRESS :服务器的地址
PROTOCOL :使用的协议,这里是 TCP 的
PORT :服务器的监听端口号
SERVICE_NAME :服务器服务名称 数据库SID名字
tnsnames.ora要和listener.ora对应
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = keirin.localhost)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = keirin)
)
)
SERVICE_NAME 的配置要和listener.ora中的GLOBAL_DBNAME 值相等。
参考:http://dbajun.iteye.com/blog/142220