情况描述:数据库重启后,用plsql无法连接上提示连接数据库ora-28547 oracle net 管理错误,百度发现,情况和我的情况有点不一样,在此仅提供参考,


SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

     (GLOBAL_DBNAME= AHTT)

      (SID_NAME = ahtt)

      (ORACLE_HOME = /oracle/product/11.2.0/db_1)

     # (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=/home/arcsde/sdeexe100/lib/libst_shapelib.so:/home/arcsde/sdeexe100/lib/libst_raster_ora.so")

      (SID_DESC =

        (ORACLE_HOME = /oracle/product/11.2.0/db_1)

        (SID_NAME = ahtt)

      )

    )

  )


(SID_NAME = PLSExtProc)

改成(SID_NAME = ahtt)

就可以登录,