1.tnsnames.ora配置:
# tnsnames.ora Network Configuration File: D:oracleproduct10.2.0db_2
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
scework140 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.140)(PORT = 1521))
(CONNECT_DATA =
(SID = scework)
(SERVER = DEDICATED)
)
)
SERPENT140 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.140)(PORT = 1521))
(CONNECT_DATA =
(SID = SERPENT)
(SERVER = DEDICATED)
)
)
2.工具---首选项--
3.环境变量: