使用oracle远程连接数据库

要使用oracle远程连接数据库，需要在oracle安装目录下
如：oracle\product\10.2.0\db_1\NETWORK\ADMIN
找到这个文件：tnsnames.ora。
打开，看看吧：

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

这时再添加一个远程连接的host,port即可使用sqlplus连接喽

ORCL2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.117)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

ok!
启动相关服务后，在cmd启动sqlplus,如：sqlplus ycspzx/ycspzx@orcl2(登陆orcl2的用户名和密码)
当cmd出现连接到：...即成功！
如图：


当然我们也可以启动oracle 自带的sqlplus，效果是等效！
如图：