oracle 10g ora28547 connection to server failed problable net8 admin error

前提是你的lsnrctl tns都配制正确下的方法

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

    (SID_NAME = PLSExtProc)

      (SID_NAME = sim)

      (ORACLE_HOME = /ORACLE/u01/app/oracle)

#      (PROGRAM = extproc)

    )

##监听配制方法,照着下面的格式可以配制多个的监听#####

(SID_DESC =

    (GLOBEL_NAME = sim)

       (ORACLE_HOME = /ORACLE/u01/app/oracle)

      (SID_NAME = sim)

    )

  )

注释掉  (PROGRAM = extproc)这句，重新启动监听就好了