官网下载地址:
http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html
下载instantclient-basic包,将包解压寄存到本地,本测试为D:JavaEEServerinstantclient_10_2
sqlnet.ora(位于instantclient-basic下) |
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) |
tnsnames.ora(位于instantclient-basic下) |
#neikong为oracle服务实例名,根据自己实际情况填写 neikong =
(DESCRIPTION =
(ADDRESS_LIST =
#172.16.3.153根据实际情况填写,如需修改端口号也可修改 (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.153 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = neikong )
)
) |
变量名 |
TNS_ADMIN |
变量值 |
D:JavaEEServerinstantclient_10_2 |
安装PL/SQL Developer,并配置oracle的连接参数:打开PL/SQL,Tools-->Preferences,配置Connection的Oracle Home和OCI library,以下图所示
下一篇 项目总结――MongoDB入门