Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Universal DiscoveryContent Pack 26.00 (CP26)

Use > Discovery Modules > Database > Oracle Real Application Cluster (RAC) Discovery > Oracle RAC Topology by Shell Job

Oracle RAC Topology by Shell Job

This section includes details about the job.

Discovery Mechanism

This job:

Connects to the remote host by Shell.
Checks for the ORACLE_HOME environment variable.
If it is not defined, the job uses the OracleHome value from the job adapter.
Enumerates configured database service names using the command srvctl config database.
Enumerates sids and hosts on which the service is available using the command srvctl status database –d <service_name>.
Retrieves RAC parameters such as Service Name and Nodes from the $ORACLE_HOME/network/admin/tnsnames.ora file.
Checks if this RAC instance is running, by parsing the lsnrctl status output.

Note Nodes are cited in the tnsnames.ora file by their internal IP or by their internal domain name. If the domain name appears, DFM resolves it.
Retrieves the full list of Listened IPs from the input query, for all listeners matching the query.
Parses this attribute's values from the list of listened IPs, to retrieve the Host Primary Domain name that corresponds to the MAC address. This is needed since the RAC CI's name key attribute must consist of a list of all the node domain names separated by the colon symbol (:).
Looks up the full node name in the build table sorted by IP address. The result is the Host Primary Domain name for each node.

At this stage, the following information is available: the RAC Service Name, the fully qualified domain names of all the RAC nodes, and a RAC instances count.
Creates the RAC CI.

Trigger Query

Node Name	Condition
Node	None
Oracle TNS Listener	NOT Listened IPs Is null
Process	None
IpAddress	NOT IP Probe Name Is null
Shell	NOT Reference to the credentials dictionary entry Is null

Adapter

This job uses the Oracle_RAC_Topology_by_Shell adapter.

Triggered CI Data

Adapter Parameters

OracleHomes

Used when no ORACLE_HOME environment variable is defined. This value must be the same as the parameter in the Oracle Listeners by Shell job.