alter system register;

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SESTOWS47
Version                   TNSLSNR for 64-bit Windows: Version 10.2.0.3.0 - Production
Start Date                14-NOV-2007 10:31:06
Uptime                    57 days 3 hr. 37 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   E:\oracle\product\10.2.0\asm\network\admin\listener.ora
Listener Log File         E:\oracle\product\10.2.0\asm\network\log\listener_sestows47.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2.17.14.131)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2.17.14.121)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+asm1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+asm1", status BLOCKED, has 1 handler(s) for this service...
Service "DB01" has 3 instance(s).
  Instance "DB01", status READY, has 1 handler(s) for this service...

# listener.ora.sestows47 Network Configuration File: E:\oracle\product\10.2.0\asm\network\admin\listener.ora.sestows47
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_SESTOWS47 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\product\10.2.0\asm)
      (PROGRAM = extproc)
    )
  )

LISTENER_SESTOWS47 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sestons01.prg-dc.dhl.com)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 2.17.14.121)(PORT = 1521)(IP = FIRST))
    )
  )

<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:> sqlplus dbadmin/ID10T@dbx1

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 17 21:11:49 2008

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.2.0 - Production

SQL> exit
Disconnected from Oracle Database 10g Release 10.2.0.2.0 - Production
<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:> cat tnsnames.ora
dbx1=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=devdb02.example.com)(PORT=1521))(CONNECT_DATA=(SID=dbx1)))
<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:> ls -l
total 20
-rw-r--r--    1 oracle   dba            27 Jan  4 17:25 afiedt.buf
drwxr-x---    2 oracle   dba          4096 Jan  4 16:16 samples
-rw-r-----    1 oracle   dba           172 Dec 26  2003 shrept.lst
-rw-r--r--    1 oracle   dba           668 Jan 17 21:10 sqlnet.log
-rw-r--r--    1 oracle   dba           105 Jan  4 17:24 tnsnames.ora


<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:>
lsnrctl status

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 17-JAN-2008 21:44:59

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                17-JAN-2008 21:09:17
Uptime                    0 days 0 hr. 35 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Log File         /b/oracle/product/10.2.0.2/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=devdb02.example.com)(PORT=1521)))
Services Summary...
Service "dbx1.dbx1.example.com" has 1 instance(s).
  Instance "dbx1", status READY, has 1 handler(s) for this service...
Service "dbx1XDB.dbx1.example.com" has 1 instance(s).
  Instance "dbx1", status READY, has 1 handler(s) for this service...
Service "dbx1_XPT.dbx1.example.com" has 1 instance(s).
  Instance "dbx1", status READY, has 1 handler(s) for this service...
The command completed successfully
<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:>

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a SID for an instance (usually a database instance) that either
 has not yet dynamically registered with the listener or has not been
 statically configured for the listener. This may be a temporary condition
 such as after the listener has started, but before the database instance
 has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which instances are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SID parameter in the connect descriptor specifies
    an instance known by the listener.
  - Check for an event in the listener.log file.