Title
ORA-28547 when trying to sqlplus to a database

Date
2010-01-18

Summary
When trying to sqlplus into a database, I received the following error: 
    C:\oracle\ora92>sqlplus scott/tiger@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 17 18:29:40 2010
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error
SQLNET.AUTHENTICATION_SERVICES was configured correctly in sqlnet.ora file and did not have any issues: 
    SQLNET.AUTHENTICATION_SERVICES = (NONE)
The listener.log file showed a successful connection: 
    17-JAN-2010 17:38:46 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=E:\oracle\ora92\bin\sqlplus.exe)
(HOST=sawftclient)(USER=administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=4757)) * establish * orcl * 0
Details
1. In my case, the listener had a password, so I had to first shut it down: 
    lsnrctl

LSNRCTL> set current_listener listener_mylistener
Current Listener is listener_mylistener

LSNRCTL> set password
Password:
The command completed successfully

LSNRCTL> stop
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(port=1521))
The command completed successfully
2. I commented out the following line in the listener.ora: 
    SID_LIST_LISTENER_orcl =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_NAME = orcl)
      (SID_NAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/product/9.2.0)
#      (PROGRAM = extproc)
    )
  )
3. I restarted the listener: 
    LSNRCTL> start
Starting /u01/app/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/9.2.0/network/log/listener_orcl.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(port=1521))
STATUS of the LISTENER
------------------------
Alias                     listener_mylistener
Version                   TNSLSNR for Solaris: Version 9.2.0.8.0 - Production
Start Date                17-JAN-2010 18:47:14
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/9.2.0/network/log/listener_orcl.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Applicable Versions
Oracle Database 9i (9.2.0.8)
Ahmed Aboulnaga
.com .com