Oracle先装客户端再装服务端，需配置

# listener.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.


#这段是安装后默认出来的配置
#要改成下面那段
#SID_LIST_LISTENER =
#  (SID_LIST =
#    (SID_DESC =
#      (SID_NAME = CLRExtProc)
#     (ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
#      (PROGRAM = extproc)
#      (ENVS = "EXTPROC_DLLS=ONLY:F:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
#    )
#  )
 


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = hejfORCL)
      (ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = hejfORCL)
    )
    (SID_DESC =
      (PROGRAM = extproc)
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
    )
  )
 




  


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.72.14.72)(PORT = 1521))
    )
  )


ADR_BASE_LISTENER = F:\app\Administrator