1. 从http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html下载几个压缩包,解压到一个目录, d:/oracleclient
instantclient-basic-win32-10.1.0.2.zip : 这是最核心的包instantclient-jdbc-win32-10.1.0.2.zip: 包含JDBC Driver的包instantclient-sqlplus-win32-10.1.0.2.zip: 最简单的SQLPLUS包 2.配置tnsnames.ora 如下格式(必须在主目录如D:/oracleclient下network/admin下)oracledata = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.58)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = oracledata) ) )3.下载并安装PL.SQL.Developer配置应用 配置tools->preferences->connection Oracle Home=D:/oracleclient OCI library=D:/oracleclient/oci.dll4.再次打开plsql则会在database中有oracledata 选项输入用户名密码就可以登陆
oseica