UNABLE OT DISCOVER NODES IN OEM CONSOLE [message #290305] |
Fri, 28 December 2007 05:46 |
pankajkmeena
Messages: 46 Registered: September 2007
|
Member |
|
|
i am unable to DISCOVER NODES IN OEM CONSOLE both manually and automatic refresh
All required services are running ( file attached)
details of listerner file
# LISTENER.ORA Network Configuration File: f:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DXP1BSBN13122)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = f:\oracle\ora92)
(PROGRAM = extproc)
)
)
TRACE_LEVEL_LISTENER = NONE
details of tnsnames.ora file
# TNSNAMES.ORA Network Configuration File: f:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
PROD1_P =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.13.145)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PROD1)
)
)
BKUP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BKUP1)
)
)
[Edited by DreamzZ] [Image Inserted into Message body]
-
Attachment: services.bmp
(Size: 314.10KB, Downloaded 2533 times)
[Updated on: Fri, 28 December 2007 10:14] by Moderator Report message to a moderator
|
|
|
|
|
Re: UNABLE OT DISCOVER NODES IN OEM CONSOLE [message #290443 is a reply to message #290432] |
Fri, 28 December 2007 23:18 |
pankajkmeena
Messages: 46 Registered: September 2007
|
Member |
|
|
i am trying to discover local node's database however listener and HTTP server are discovered automatically.
At the same time I am able to discover one of my remote databse sucessfully alongwith listener and HTTP server.
i am attaching OEM screenshot
Listener status
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 29-DEC-2007 10:42:52
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=DXP1BSBN13122)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
Start Date 29-DEC-2007 10:34:12
Uptime 0 days 0 hr. 8 min. 40 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File f:\oracle\ora92\network\admin\listener.ora
Listener Log File f:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DXP1BSBN13122.tcs.co.in)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "BKUP1" has 1 instance(s).
Instance "BKUP1", status READY, 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 "PROD1" has 1 instance(s).
Instance "PROD1", status READY, has 1 handler(s) for this service...
The command completed successfully
[Updated on: Fri, 28 December 2007 23:48] by Moderator Report message to a moderator
|
|
|
Re: UNABLE OT DISCOVER NODES IN OEM CONSOLE [message #290533 is a reply to message #290443] |
Sat, 29 December 2007 09:24 |
|
ebrian
Messages: 2794 Registered: April 2006
|
Senior Member |
|
|
You may want to try to enter a fully qualified hostname in your listener.ora file. You may also need to enter this into your snmp_rw.ora file.
If this doesn't seem to solve your problem, you can try to add an entry into your listener.ora file for the database itself.
|
|
|