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?
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:
- 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.
- Take a screen shot of the Version tab and send it to Support.
- Manually run:
ckoracle 'setup 'user <Oracle user> -password <Oracle user's password> -netiqms <Hostname of NetIQ MS> -netiqmc <local hostname> -debug > ckSetup.log - 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.
- 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).
- Export the registry key [HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI] to a text file.
- Delete file C:\Program Files\NetIQ\Temp\netiq_debug\qorcla.txt if it exists.
- Run a new Discovery_Oracle script.
- Send Support the following information:
- Agent Server Name
- NetIQ Management Server Name
- AppManager Agent Version
- 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