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 28.00 (CP28)

Use > Discovery Modules > Database > Oracle Database Server Discovery > How to Discover Oracle Data Guard

How to Discover Oracle Data Guard

This section includes:

Discovery Mechanism

In general, Oracle Data Guard contains one primary database and more than one standby database.

In the Oracle Connection by Shell job, Data Flow Probe connects to both primary database and standby database with the Shell protocol, and then log in to Oracle with SQL*Plus.

Universal Discovery parses Oracle primary database SID and standby database service name from Shell command line, queries the Data Guard configuration information through SQL*Plus, and report back Oracle Data Guard CI and the connected databases.

Discovery Steps

This task includes the following steps:

Prerequisites - Set up protocol credentials
The Oracle Data Guard discovery uses the Shell protocol to connect to the target server and run Shell commands. This discovery uses the Generic DB protocol (SQL) for the SQL*Plus connection.
- If the Shell account is in the Oracle DBA group in OS, define a Shell protocol (SSH Protocol or NTCMD).
- If the Shell account is NOT in the Oracle DBA group in OS, define a Shell protocol (SSH Protocol or NTCMD) and Generic DB Protocol (SQL). The SQL account should have the privilege to run SQL*Plus.
Note When using the Generic DB Protocol (SQL), the Shell account should have the privilege to run SQL*Plus.

For credential information, see Supported Protocols.
Run the discovery
Activate the following jobs in the listed order:
1. Range IPs by ICMP
2. Host Connection by Shell
3. Host Applications by Shell
4. Oracle Connection by Shell
For details on running jobs, see "Module/Job-Based Discovery" in the Data Flow Management section of the UCMDB Help.

Send Help Center feedback