本地远程虚拟机数据库

个人经验分享，以备下次遇到此类问题用

1.本地安装plSQL developer和instantclient

2.复制oracle数据库中的network文件到instantclient中

3.更改instantclient\NETWORK\ADMIN下listener和tnsnames以及sqlnet

4.listener：

LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.10 )(PORT = 1521))    )  )

5.sqlnet：

SQLNET.AUTHENTICATION_SERVICES= (NONE)

6.tnsnames增加一行

ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 虚拟机IP)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

7.服务器防火墙出入站规则放行1521端口

8.虚拟机防火墙出入站规则启用文件和打印机文件共享