5 Replies Latest reply on Mar 27, 2009 3:28 PM by SanjayRs

    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
        • 1. Re: Oracle Enterprise Manager Does not show Listener
          289595
          Please see if the following helps:

          https://students.kiv.zcu.cz/doc/oracle/network.102/b14212/listenercfg.htm (Look for 'Oracle Enterprise Manager')
          • 2. Re: Oracle Enterprise Manager Does not show Listener
            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
            • 3. Re: Oracle Enterprise Manager Does not show Listener
              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
              • 4. Re: Oracle Enterprise Manager Does not show Listener
                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
                • 5. Re: Oracle Enterprise Manager Does not show Listener
                  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