oracle客户端的安装

    用sqlplus写sql效率确实低,还不好修改,索性安装了一个客户端工具,好high

 

Oracle9i客户端精简版.rar,这个可以到网上下载

 

安装完成后最关键的就是连接文件的配置问题了,方法是先找到c:/oracle/ora90/network/admin

目录下的tnsnames.ora文件(具体路径看你的安装路径)

把该文件的内容修改成如下内容:

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DXS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 9.83.70.13)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dealer)
    )
  )

mpptest =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.231)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mpptest)
    )
  )

  其中 mpptest为数据库的服务名