Oracle10 Linux9 修改listener監聽端口遇到ORA-28547錯誤

Oracle10 Linux9 修改listener監聽端口遇到ORA-28547錯誤

日月明王的Oracle dba空間
http://sunmoonking.spaces.live.com
 
[oracle@Oracle software]$ uname -a
Linux Oracle 2.6.9-023stab033.7-enterprise #1 SMP Wed Nov 15 14:58:00 MSK 2006 i686 i686 i386 GNU/Linux
      新裝了一個Oracle10在readhead 9上，由於只對外開放部分端口，因此需要修改listener端口，然而在成功修改listener.ora,tnsnames.ora 後報如下錯誤
[oracle@Oracle ~]$ sqlplus system/wwm123@wwm
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 16 15:50:46 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error

Enter user-name:
       而且tnsping沒有問題，再改回1521後還是可以正常登陸
[oracle@Oracle ~]$ tnsping cori
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 16-JUL-2007 15:50:50
Copyright (c) 1997, 2005, Oracle.  All rights reserved.
Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 4199))) (CONNECT_DATA = (SERVICE_NAME = wwm)))
OK (0 msec)
       只有再將listener.ora的內容由
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/Oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 4199))
      (ADDRESS = (PROTOCOL = IPC)(KEY =