Oracle Enterprise Manager Does not show Listener

SanjayRs

In Oracle Enterprise Manager, it does not show the Listener
Oracle 10.2.0.4
Windows 2003 Server
The server has 2 database orcl and orcl1 with one listener as LISTENER

Oracle Database Home tab
------------------------------------

General
	
Status		Up
Up Since		Mar 25, 2009 11:25:59 AM EDT
Instance Name		orcl
Version		10.2.0.4.0
Host		myhost
Listener     <**this is missing **>		

View All Properties


Listener 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production
Start Date                24-MAR-2009 09:19:49
Uptime                    3 days 0 hr. 35 min. 26 sec
Trace Level               off
Security                  ON: Password or Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\oracle\product\10.2.0\db\network\admin\listener.ora

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
Services Summary...

Did you guys had this kind of issues.
This issue started after a reconfigure of the dbconsole for each database.

Thanks for you help!
Sanjay

289595

Please see if the following helps:

https://students.kiv.zcu.cz/doc/oracle/network.102/b14212/listenercfg.htm (Look for 'Oracle Enterprise Manager')

emre baransel

The listener port may be misconfigured,

You can reconfigure with

emca -config dbcontrol db

Enter the following information:
Database SID: XXX
Database Control is already configured for the database XXX
You have chosen to configure Database Control for managing the database XXX
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /oracle/product/10.2.0

Database hostname ................ xxxxx
Listener port number ................ 1521
Database SID ................ XXX
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
24.08.2008 01:58:44 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/product/10.2.0/cfgtoollogs/emca/EPA/emca_2008-08-24_01-58-01-AM.log.
24.08.2008 01:58:46 oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
24.08.2008 01:58:57 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
24.08.2008 02:00:39 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
24.08.2008 02:00:39 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://xxxxx:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at 24.08.2008 02:00:39

SanjayRs

Listener port is correct

Partial file : targets.xml 
...
		<Property NAME="Port" VALUE="1521"/>
		<Property NAME="OracleHome" VALUE="D:\oracle\product\10.2.0\db"/>
		<Property NAME="ListenerOraDir" VALUE="D:\oracle\product\10.2.0\db\network\admin"/>
...

Any other ideas

oradba

How is your listener configured? (listener.ora) . I only see an internal IPC connection, but would expect something like

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<portnumber>))) .


Werner

SanjayRs

Werner,

I have updated the first post you can see that port 1521 is also configured.

I am able to go to the listener configuration from the host or View all Properties link in Enterprise Manager to the host, then to the Targets tab.
The Target Tab show Agent, Database Instance, and listener, and I can configure save etc.

My question is on the Database home page there is not link to get to the Listener directly. It simply does show up there.

Sanjay