Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
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 |
|
|
Either word in a topic |
|
|
Topics that do not contain a specific word or phrase |
|
|
Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
A combination of search types | ( ) parentheses |
|
- Oracle Database Server Discovery
- Overview
- Supported Versions
- Topology
- How to Discover Oracle Database Servers by SQL
- How to Discover Oracle Data Guard
- How to Discover Oracle TNS Names Topology
- How to Discover Oracle Database Servers- Lightweight
- Oracle Connection by Shell Job
- Oracle Connection by Shell Adapter
- Oracle Database Connection by SQL- Lightweight Job
- Oracle Connection by SQL- Lightweight Adapter
- Oracle Database Connection by SQL Job
- Oracle Connection by SQL Adapter
- Oracle TNS Names by LDAP Job
- Oracle TNS Names by LDAP Adapter
- Oracle Topology by SQL Job
- Oracle Database Topology by SQL Adapter
- Oracle Topology by SQL- Service Name Job
- Oracle Database Topology by SQL- Service Name Adapter
- Troubleshooting and Limitations – Oracle Database Server Discovery
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:
- Range IPs by ICMP
- Host Connection by Shell
-
Host Applications by Shell
- Oracle Connection by Shell
For details on running jobs, see "Module/Job-Based Discovery" in the HPE Universal CMDB Data Flow Management Guide.