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.dll
4.再次打开plsql则会在database中有oracledata 选项输入用户名密码就可以登陆

                                                                                                                       oseica
 

发表于 @ 2007年02月08日 15:22:00|评论(loading...)