Solved

Oracle OEM and Intelligent Agent, Cannot Discover Database or Listener

Posted on 2004-10-06
10
1,520 Views
Last Modified: 2012-05-05
We just built a new Windows 2003 server and cloned an Oracle 9i Rel2 9.0.2.5 db onto it.  The instance is up and running and I was able to discover the node. I cannot get the oem to recognize the database and listener.  We have removed and reinstalled the listener, made sure that an entry for the database is present in the listener.ora, stopped and restarted the agent, did a clean start on the agent by removing all the q files, etc iaw the oracle note.  What are we missing?

0
Comment
Question by:DonFreeman
10 Comments
 
LVL 47

Expert Comment

by:schwertner
ID: 12237675
Set the machine name in the listener.ora file
(HOST = machine) ....

Edit the tnsnames file.

Stop and start the listener:

C:>lsnrctl stop
C:>lsnrctl start

Check the connection to the listener:

C:>tnsping <connection string>

After that you will be able to connect via OEM.
0
 
LVL 1

Author Comment

by:DonFreeman
ID: 12237995
This is our entry in the listener.ora


SAVE_CONFIG_ON_STOP_LISTENER = TRUE

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dhhbgnedora111)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = NEDART)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = NEDART)
    )
    (SID_DESC =
      (PROGRAM = extproc)
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\ora92)
    )
  )

TRACE_LEVEL_LISTENER = USER

********************************************************************
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.102.100.212)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xxxxxxx)))

OK (10 msec)
*********************************************************************

I did the ping from the OMS server to the target and it succeeded.   When I discovered the node from OEM It still didn't discover the listener or the database.   What's my next step?
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12238233
Does this machine have the fixed IP? If not, You should get a fixed IP first.thats' the requirement
0
 
LVL 1

Author Comment

by:DonFreeman
ID: 12238266
Yes it has a static ip.  
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 23

Expert Comment

by:seazodiac
ID: 12238344
on the Windows server, make sure Oracle intelligent Agent is up and running...

In the OMS server, start OEM connecting to OMS server, and try discovering the node, if not, do  a manual discovery...
0
 
LVL 1

Author Comment

by:DonFreeman
ID: 12238775
Agent is up.    You don't get the option of manually discovering because the node is discovered.   Does the listener have to have a unique name in the oem list?  I'm not getting any errors but the name is just the default name.  As far as I can tell what gets displayed on the oem is what is in the services.ora file on the target.  This is a dynamic file and the entries I need are not being written there.  Beyond that there doesn't seem to be much information available about how that all takes place.
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12239832
Donfreeman:

How did you clone it?

Did you use DBCA to create an empty database and import the database?

Or you use the cold backup to clone a new database? In the latter case, your database won't show up in the Agent...
0
 
LVL 1

Author Comment

by:DonFreeman
ID: 12249578
I finally found the solution in this note on Metalink.  I don't understand exactly the explanation of how it occurred but I had to edit an Oracle supplied TCL file to make it work.  I wanted to include the answer here in case some other poor soul encounters the same problem.



Note:1016341.102
Subject:  Discovering Node Fails to Include Databases / Agent Log Shows Skipping Listener
Type:  PROBLEM
Status:  PUBLISHED
 Content Type:  TEXT/PLAIN
Creation Date:  21-JUL-1999
Last Revision Date:  26-NOV-2002
 

Environment: Oracle Intelligent Agent  Microsoft Windows NT Microsoft Windows 2000   Symptom: You have discovered a node from the EM console, but cannot see the databases.    The Agent's %ORACLE_HOME%/network/log/nmiconf.log shows:  Warning : Listener <LISTENER_name> defined in <path>\listener.ora  will be skipped because it does not have a corresponding NT service entry Warning : Skipping Oracle<Oracle_Home>TNSListener : Could not find corresponding listener definition in (<path>\listener.ora) Warning : No Listener found for SID <SID__name>. <SID_name> will be skipped     Cause: When the Agent process starts, a script is executed to locate manageable  services on the node.  The script is called nmiconf.tcl and is the primary  script for discovering databases and listeners on the server.   The new universal Installer checks for an ORACLE_HOME_NAME and an  ORACLE_HOME_PATH, both of which get stored in the registry.  The new service  name is created using the ORACLE_HOME_NAME as part of the service name which  is the text portion of the service name, between 'Oracle' and 'TNSListener'.  During the execution of "nmiconf.tcl" script, the  'proc nmiconf_getListenerOraFileVersion' uses the version portion of the  service to compare against the path name to determine if they are the same  version; since they're not, this procedure returns a 'bad' version.    Therefore, the 'proc nmiconf_findListenerNTService' fails the version  comparison, causing the error to be given and the Listener to be ignored.     Fix:   NOTE: Before beginning this workaround, please make a backup copy of the  nmiconf.tcl script.  1.  Modify the nmiconf.tcl script and find the line that includes:  proc nmiconf_findListenerNTService  2.  Then comment out the entry under the above heading that includes:           set isVersionEqual [string compare $version [lindex $listenerNTServiceDeta...etc  3.  Then add the following line right after the above commented line:                   set isVersionEqual 0  4.  Save and Close the nmiconf.tcl script  5.  Restart the Intelligent Agent    6.  Refresh the Node from within the EM Console    See also BUG:1301647 if 7.3.4 database is also installed/being discovered.    If the above steps not help, the listener.ora file may be corrupt. Try: 1. Rename/Delete the existing listener.ora 2. Create a new file using the Net8 Assistant (or Net8CA) configuration tool 3. Restart the Listener and ensure clients can connect via the listener 4. Restart the Agent.    As a last resort, the following can be attempted: 1) Stop the listener and the Agent 2) Backup the registry 3) Delete the following key from the NT registry(*):    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle<Oracle_Home>TNSListener 4) Reboot the machine (to ensure a clean start) 5) Build a new/clean listener.ora file with a proper net tool such as Net8Assistant 6) At DOS prompt, go to the Oracle Home\bin directory, and start the listener:         lsnrctl start    (It may error out at first, but will eventually start the listener, and     recreate the registry entry/service.  This may take some time.) 7) Restart the Agent   (*) Exercise extreme care when removing registry entries.       Removing incorrect entries can severely compromise your computer.
.
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12278980
Question answered by asker or dialog valuable.
Closed, 250 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now