oracle10 linux9 修改listener监听端口遇到ORA-28547错误

来源：互联网发布：软通java面试题编辑：程序博客网时间：2024/06/16 18:37

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

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

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 = EXTPROC0))
    )
)
      改为
SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
(SID_DESC =
      (SID_NAME = wwm)
      (ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
    )

)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 4199))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
)

问题才得以解决，好奇怪的问题。记录于此以供查阅。