Oracle Database Discussions

Hi

I am trying to understand the listener mechanism here. Please clear my doubts.
I have Win 7, Oracle 11g R2.

I created one local database ORCL during Oracle DB installation, EM port 1158, listener name shown in EM is "LISTENER_localhost" and its DOWN, it doesn't come UP even when I try to start it from EM. But lsnrctl utility shows me single listener named LISTENER in started state. I am NOT able to see "LISTENER_localhost" using lsnrctl utility

I created another database NEW2 using DBCA a week after first database, EM port 5500, listener name shown in EM is "LISTENER_HOME-8PFV3EF4JUK.na.localhome.net" (my laptop name) and its UP in EM. But I am NOT able to see it using lsnrctl utility.

Thing is that both databases are connecting successfully, but I am not able to notice "consistency" w.r.t. lsnrctl and ora files.

(Please answer the ones above where I have placed ???? mark )

See lsnrctl output below for these 2 listeners. None is found, but how come EM showed them as said above ????
======================================================================

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status LISTENER_HOME-8PFV3EF4JUK.na.localhome.net
TNS-01101: Could not find service name LISTENER_HOME-8PFV3EF4JUK.na.localhome.net
LSNRCTL> status LISTENER_localhost
TNS-01101: Could not find service name
LSNRCTL>

See output of status command ----> Both orcl and new2 are listed, none of above 2 listeners are listener, a listener named LISTENER is listed. From where did this come ????
===========================================================================================================

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 04-MAR-2013 11:16:16
Uptime 0 days 6 hr. 28 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File c:\oracle\app\oracle\product\11.2.0\diag\tnslsnr\HOME-8PFV3EF4JUK\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOME-8PFV3EF4JUK)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "new2" has 1 instance(s).
Instance "new2", status READY, has 2 handler(s) for this service...
Service "orcl" has 2 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>



LISTENER.ORA contents (it doesn't have NEW2, even then NEW2 is appearing in status of LISTENER above ???? )
======================================================================
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = C:\oracle\app\oracle\product\11.2.0\server)
(PROGRAM = orcl)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = HOME-8PFV3EF4JUK.na.localhome.net)(PORT = 1521))
)
)
)


TNSNAMES.ORA contents (it doesn't have NEW2)
====================================
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOME-8PFV3EF4JUK.na.localhome.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE_NAME = orcl)
)
)



In Windows services, there are "OracleOraDb11g_home1TNSListener" and 2 services one each for new2 and orcl. No reference of 2 listeners as said above.
Net manager or Netca doesn't show any of the listener's.
I am connecting from my local only using sql developer/sqlplus.

My question is:
when lsnrctl doesn't show either listener's, how they are getting connected.
listener.ora doesn't contain either of the 2 listeners, nor NEW2, how connection is happening.



Please clear the doubts.

Thanks.