一:官方下载ORACEL客户端软件,
到我的资源里下载XEClient
二:在 C:/XEClient目录下新建Network文件夹,在 Network 新建Admin文件夹,
三:在Admin目录下新建名称为 tnsnames.ora 的文件,
文件内容如下:
ORCL1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.221)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XSGL)
)
)
ORCL2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 92.168.1.240 ) ( PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl2 )
)
)
//----------注意ORCL1为数据库名称
//----------注意HOST为数据库主机地址