Oracle10 Linux9 modify listener listening port encounter ORA-28547 error oracle10 Linux9 modify listener listening port encounter ORA-28547 error Sun Moon King Oracle DBA space http://sunmoonking.spaces.live.com [Oracle @ Oracle software] $ uname-
Linux Oracle 2.6.9-023stab033. 7-enterprise #1 SMP wed Nov 15 14:58:00 MSK 2006 i686 i686 i386 GNU/Linux
A new oracle10 is installed on readhead 9. Because only some ports are open to the outside, you need to modify the listener port. However, the following error is reported after the listener. ora and tnsnames. ora are modified successfully.[Oracle @ Oracle ~] $ Sqlplus system/wwm123 @ wwmsql * Plus: Release 10.2.0.1.0-production on Mon Jul 16 15:50:46 2007 copyright (c) 1982,200 5, Oracle. All Rights Reserved. Error:
ORA-28547: connection to server failed, probable Oracle Net admin errorenter user-Name:
And there is no problem with tnsping. you can log on normally after you change it back to 1521.[Oracle @ Oracle ~] $ Tnsping coritns Ping utility for Linux: Version 10.2.0.1.0-production on 16-jul-2007 15: 50: 50 copyright (c) 1997,200 5, 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)
Only when the content of listener. ora is changed fromSid_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) (Port = 4199 ))
(Address = (Protocol = IPC) (Key = extproc0 ))
)
)
Change
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) (Port = 4199 ))
(Address = (Protocol = IPC) (Key = extproc0 ))
)
)
This is a strange problem. This record is for reference.
