Forum Stats

  • 3,741,519 Users
  • 2,248,443 Discussions
  • 7,861,847 Comments

Discussions

Oracle Enterprise Manager Does not show Listener

SanjayRs
SanjayRs Member Posts: 3,024
edited Mar 27, 2009 11:28AM in General Database Discussions
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

Answers

  • 289595
    289595 Member Posts: 843
    Please see if the following helps:

    https://students.kiv.zcu.cz/doc/oracle/network.102/b14212/listenercfg.htm (Look for 'Oracle Enterprise Manager')
  • 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
    SanjayRs Member Posts: 3,024
    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
    oradba Member Posts: 10,214
    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
    SanjayRs Member Posts: 3,024
    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
This discussion has been closed.