求解: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>