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

客户端版本是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>

在服务器上的tnsname.ora文件中去掉 PROGRAM = extproc 就行了吗？

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)
    )
  )
)  请教下该怎么改?

   数据库的连接是时好时坏(有时出现ora-28547:连接服务器失败，可能是 Oracle Net 管理失败 ).
   请教下原因(除去网络不稳定外)，谢谢！
   在线等！

给楼主看下我的设置：
我在服务器端设置了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@prodSQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 29 17:36:31 2010Copyright (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@prodSQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 29 18:01:38 2010Copyright (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 optionsSQL> 在客户端登陆：
C:\Documents and Settings\Administrator>sqlplus scott/tiger@prodSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 4月 29 16:44:59 2010Copyright (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 optionsSQL>

顶下，我刚刚也是现在这样的问题现在还没搞好，登陆oracle数据库时出现,“ORA-28547:连接服务器失败,可能是Oracle Net管理错误”。

调试易

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

解决方案 »