求解:ora-28547:连接服务器失败,可能是 Oracle Net 管理失败

碧水幽幽泉 2010-02-26 09:50:24
刚刚在登录数据库的时候出现:
ora-28547:连接服务器失败,可能是 Oracle Net 管理失败

请求达人帮忙分析原因!谢谢!
...全文
8785 8 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
niulei 2011-12-14
  • 打赏
  • 举报
回复
我也碰到了,现在还没用搞好,郁闷
jun641021941 2010-05-01
  • 打赏
  • 举报
回复
顶下,我刚刚也是现在这样的问题现在还没搞好,

登陆oracle数据库时出现,“ORA-28547:连接服务器失败,可能是Oracle Net管理错误”。
Jaons 2010-04-29
  • 打赏
  • 举报
回复
给楼主看下我的设置:
我在服务器端设置了listener.ora,,也设置了tnsnames.ora ,,就是说从服务器端自己tnsping自己是能通的,,但是我从服务器端如下登陆,就登陆不了,提示错误和楼主的一样。。SID是prod, ,

listener.ora设置如下:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = prod)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

tnsnames.ora 设置如下:

prod =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prod)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

经tnsping测试,能ping通。。但是登录时出现问题了,
[oracle@redhat ~]$ sqlplus scott/tiger@prod

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 29 17:36:31 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error


后来将listener.ora的这一行注释掉,就行了,, (PROGRAM = extproc)
修改为:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = prod)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
# (PROGRAM = extproc)
)
)


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)


在服务器端登陆:
[oracle@redhat ~]$ sqlplus scott/tiger@prod

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 29 18:01:38 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning and Data Mining options

SQL>

在客户端登陆:
C:\Documents and Settings\Administrator>sqlplus scott/tiger@prod

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 4月 29 16:44:59 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning and Data Mining options

SQL>


碧水幽幽泉 2010-02-26
  • 打赏
  • 举报
回复


数据库的连接是时好时坏(有时出现ora-28547:连接服务器失败,可能是 Oracle Net 管理失败 ).
请教下原因(除去网络不稳定外),谢谢!
在线等!
碧水幽幽泉 2010-02-26
  • 打赏
  • 举报
回复
linux服务器上的tnsnames.ora文件信息:
NST1_HTTP.SITE=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux.site)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux.site)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
)

请教下该怎么改?


碧水幽幽泉 2010-02-26
  • 打赏
  • 举报
回复
在服务器上的tnsname.ora文件中去掉 PROGRAM = extproc 就行了吗?
共享to未来 2010-02-26
  • 打赏
  • 举报
回复
客户端版本是10.2.0.1.0 32位, 服务器是9.2.0.4.0 64位。客户端连接服务器报ORA-28547: 连接服务器失败, 可能是 Oracle Net 管理错误。
状况如下:

C:\>sqlplus "sys/oracle@vm9i as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 1月 7 13:41:20 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-28547: 连接服务器失败, 可能是 Oracle Net 管理错误

请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝

请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝

SP2-0157: 在 3 次尝试之后无法连接到 ORACLE, 退出 SQL*Plus


而本地登录报ORA-03113错误。

[oracle@PENG admin]$ sqlplus system/oracle@vm9i
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 7 09:16:08 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-03113: end-of-file on communication channel

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

本地操作系统认证登录却没问题

[oracle@PENG admin]$ sqlplus "sys/oracle@vm9i as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 7 09:19:12 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL>



[oracle@PENG admin]$ tnsping vm9i
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 07-JAN-2010 09:19:38
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.222)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = dbtest) (INSTANCE_NAME = dbtest)))
OK (10 msec)


最后检查了一下监听程序的配置文件 发现多了 (PROGRAM = extproc)
[oracle@PENG admin]$ vi listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = dbtest)
(ORACLE_HOME = /u01/app/oracle)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.222)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

手工配置监听的时候,从上面COPY下来的 就后面的那个没去掉。去掉 (PROGRAM = extproc)
保存退出。

本地登录:
[oracle@PENG ~]$ sqlplus system/oracle@vm9i
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 7 09:24:59 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL>

客户端登陆:
C:\>sqlplus admin/admin@vm9i
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 1月 7 14:12:25 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.

连接到:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL>
sorry0481 2010-02-26
  • 打赏
  • 举报
回复
帮顶吧,我刚刚也碰到了,重新登录就可以了,时好时坏。。。

17,382

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧