1、安装Oracle客户端
2、修改app/oracle/product/10.2.0/server/NETWORK/ADMIN下的tnsnames.ora文件如下面的红体字
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 你的ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
3、在PLSQL Developer中,Tools下的preferences中配置
Oracle Home (emply is autodetect)
OCI library (empty is autodetect)
4、在命令行下测试 sqlplus 用户名@XE
5、在PLSQL Developer测试