D:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
tnsnames.ora
bksvr =//显示的本地名称
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.248)(PORT = 1521))//远程IP和端口
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bksvr)//远程实例名
)
)
查看监听状态、
d:>lsnrctl
LSNRCTL> status
或者
LSNRCTL> start
推荐:http://www.blogjava.net/onewalkingman/articles/335977.html