Solution: ora-28547: failed to connect to the server, may be an Oracle Net management failure

The Client Version is 10.2.0.1.0 32-bit, and the server is 9.2.0.4.0 64-bit. Client Connection server reported ORA-28547: Connection server failed, may be an Oracle Net management error.

The status is as follows:

C: \> sqlplus "sys/Oracle @ vm9i as sysdba"
SQL * Plus: Release 10.2.0.1.0-production on Thursday January 7 13:41:20 2010
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Error:
ORA-28547: failed to connect to the server, possibly an Oracle Net management error

Enter the User Name:
Error:
ORA-01017: invalid username/password; login denied

Enter the User Name:
Error:
ORA-01017: invalid username/password; login denied

SP2-0157: Unable to connect to Oracle after 3 attempts, exit SQL * Plus


While local login reported ORA-03113 error.

[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,200 2, 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

Login via local operating system authentication is normal

[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,200 2, Oracle Corporation. All rights reserved.

Connected:
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)

Finally, I checked the configuration file of the listener and found that there were too many (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 ))
)
)

When you manually configure the listener, the one copied above is not removed. Remove (program = EXTPROC)
Save and exit.

Local Logon:
[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,200 2, Oracle Corporation. All rights reserved.

Connected:
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>

Client Login:
C: \> sqlplus admin/admin @ vm9i
SQL * Plus: Release 10.2.0.1.0-Production on Thursday January 7 14:12:25 2010
Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect:
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>