配置oracle关联plsql

在oracle的安装目录中找到

\app\user\product\11.1.0\db_1\NETWORK\ADMIN

在文件tnsnames中加入

 

10.40.16.106 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.40.16.106)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = mdspdb)
      (SERVER = DEDICATED)
    )
  )

即可