首先可以在cancel的情况下不登陆pl/sql
这个可以在PL/SQL Developer-->帮助-->支持信息-->信息的tab页中找到TNS File。
这个参数配置的就是你使用的tnsnames.ora
其中可以在Info下找到你设置的tnsnames.ora的路径!
如何设置tnsnames路径呢?
在环境变量里面设置TNS_ADMIN项,值为路径,例如D:\oracle10g\NETWORK\ADMIN就是你在Info的TNS File下看到的路径
一般tnsnames.ora的内容如下:
# tnsnames.ora Network Configuration File: D:\app\pampus\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ServiceORCL224=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.224)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ServiceORCL5=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)