Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 395 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Oracle Enterprise Manager Does not show Listener

SanjayRs
Member Posts: 3,024
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
This issue started after a reconfigure of the dbconsole for each database.
Thanks for you help!
Sanjay
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
-
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 -
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 -
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 -
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.