How do I troubleshoot Discovery_Oracle problems? (NETIQKB53484)

  • 7753484
  • 02-Feb-2007
  • 27-Jan-2011

Environment

NetIQ AppManager 6.x

Discovery_Oracle Knowledge Script

Oracle RDBMS ServerManaged Object
Oracle 8i
Oracle 9i
Oracle 10g Release 1

Situation

How do I troubleshoot Discovery_Oracle problems?

What information do I send Technical Support to determine the problem with my Discovery_Oracle Knowledge Script?

How do I understand where the Discovery_Oracle Knowledge Script failed?

Resolution

To troubleshoot Discovery_Oracle failures:

  1. Ensure the latest Oracle Windows module is on the agent by right-clicking qorcla4.dll in the %\Netiq\AppManager\bin folder and select Version > File Version. It should say 6.1.41.
  2. Take a screen shot of the Version tab and send it to Support.
  3. Manually run:

    ckoracle 'setup 'user <Oracle user> -password <Oracle user's password> -netiqms <Hostname of NetIQ MS> -netiqmc <local hostname> -debug > ckSetup.log
  4. Stop the agent, create a DWORD registry value under [HKEY_LOCAL_MACHINE\Software\NetIQ\AppManager\4.0\netiqmc\Tracing] called 'TraceMOorcl', set it to '16', and restart the agent.
  5. Ensure the ?ServerName? registry value under [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<Oracle Home name $ Oracle instance name>] matches a service name entry in the tnsnames.ora file (work with your Oracle DBA to confirm if necessary).
  6. Export the registry key [HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI] to a text file.
  7. Delete file C:\Program Files\NetIQ\Temp\netiq_debug\qorcla.txt if it exists.
  8. Run a new Discovery_Oracle script.
  9. Send Support the following information:
    1. Agent Server Name
    2. NetIQ Management Server Name
    3. AppManager Agent Version
    4. The following files: C:\Program Files\NetIQ\Temp\netiq_debug\qorcla.txt, ckSetup.log from step 2, and the registry export from step 4.

Additional Information

Formerly known as NETIQKB53484