Discovering Oracle Databases during a discovery run can be achieved by two different methods. The default method requires knowledge of the ports that TNSListeners is listening to, for probing hosts for indication of a potential Oracle Database and credentials of type Windows resp. SSH, for authentication as privileged users to the Databases’ host systems. The credentials are used for reading the configuration by remote execution, resp. WMI query. Such users need at least permissions to read /etc/oratab on a Linux / unix-like host systems and to query Win32_Process by WMI on a Windows host system.
The advanced Oracle Database discovery option, named Use Remote-Execution based Oracle discovery in the wizard does not need knowledge on the TNSListeners’ ports for discovery. This method also needs credentials of a privileged user to perform remote execution. The users for Linux / unix-like host systems should have permissions for reading environment variables, files in the Databases’ home directories like listener.ora, tnsnames.ora, and sqlnet.ora, the files /var/opt/oracle/oratab, /etc/oratab, .oratab and to execute lsnrctl. The users for Windows like host systems should have permissions for reading environment variables, files in the Databases’ home directories like listener.ora, tnsnames.ora, and sqlnet.ora, to execute lsnrctl and to query the registry HKLM.
|
Be aware: In order to use the Oracle discovery on Windows the java.exe on the target machine needs to be located in a subfolder of the paths that are mentioned in the PATH variable! |
|
Tip: The advanced Oracle Database discovery option can also be run on specific devices from within the Devices list, by the context menu option Oracle Discovery. |
The discovery is able to discover database connections on its own, but this feature is still very limited and requires a user with sufficient privileges to read certain configuration files on a unix-like host or to query running processes by WMI on a Windows host. Adding connections manually is also an option that is worth considering.
More information:
•Settings for Oracle Zero-Touch Scan