首先安装oracle11g服务器端(x64), 备注:记住用户名和密码,可将SCOTT解锁
再安装ODTwithODAC1120320_32bit 将C:\oracleClient\product\11.2.0\client_1\Network\Admin\Sample 的tnsnames复制到admin目录下,更改
或重写文件内容
bmsdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
运行 PLSQL Developer,输入用户名密码,即可对服务器的数据库进行操作