情况描述:数据库重启后,用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)
就可以登录,
plsql连接数据库ora-28547 oracle net 管理错误
原文:http://zhaihx.blog.51cto.com/8992155/1691891