修改tnsnames.ora文件:在CONNECT_DATA 中加入(server = dedicated)
例:
sh2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 192.168.0.132)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (server = dedicated) (SID = sh2)
    )
  )