在本地配置tnsname打开C:\oracle\ora92\network\ADMIN\tnsnames.ora 加入如下参数。ora =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.99)(PORT = 1521))    )    (CONNECT_DATA =      http://www.mamicode.com/(SERVICE_NAME = ora)>注：（192.168.1.99=所要访问oracle数据库IP地址 ora=所要访问数据库名称）然后打开CMD，输入 sqlplus user/password@ora 就可以了。（user=用户名，password=密码）plsql也一样

cmd远程连接数据库