Oracle客户端配置

1、查找tnsnames.ora文件

一般情况下：路径为：\oracle\product\10.2.0\db_1\NETWORK\ADMIN 

2、配置tnsnames.ora文件

3、登陆

配置tnsnames.ora文件如下：

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

NEWVMSDEV =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.185.220.135)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = VMSDEV)

    )

  )