这是针对Windows的，如果是Linux和Unix就不用这么麻烦辛苦了！

1、服务器端Sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)    
NAMES.DIRECTORY_PATH= (TNSNAMES,ONAMES,HOSTNAME)    
TRACE_LEVEL_CLIENT = 16
 
2、服务器端regedit
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME1
新建字符串名为USE_SHARED_SOCKET，值为TRUE
这一步要重启电脑,不重启电脑也可以，把explorer.exe进程结束，然后再新建一个explorer.exe
设置mts_dispatchers参数
SQL> alter system set mts_dispatchers='(PROTOCOL=TCP)(disptchers=1)';
这一步要重启电脑

3、服务器端Listener.ora
sfc =
     (DESCRIPTION_LIST =
       (DESCRIPTION =
         (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = joy_sfc_db)(PORT = 1521))
         )
       )
     )
SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
        (SID_NAME = PLSExtProc)
          (ORACLE_HOME = E:\Oracle\)
            (PROGRAM = extproc)
        )
(SID_DESC =
         (GLOBAL_DBNAME = sfc)
         (ORACLE_HOME = E:\oracle\)
            (SID_NAME = sfc)
          )
          ) 
   
###############################################################################
1、客户端Sqlnet.ora
添加NAMES.DIRECTORY_PATH= (HOSTNAME)

2、客户端Tnsname.ora
sfc =
     (DESCRIPTION =
          (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 58.251.163.164)(PORT = 1521))
          )
          (CONNECT_DATA =
              (SERVICE_NAME = sfc)
          )
      )