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
Oracle Database Topology by SQL Adapter
This section includes details about the adapter.
Oracle database topology by SQL
Oracle
Name |
Value |
---|---|
credentialsId | ${SOURCE.credentials_id} |
ip_address | ${SOURCE.application_ip} |
port | ${SOURCE.application_port:NA} |
sid | ${SOURCE.name:NA} |
-
SQL_Dis_Oracle.py
- Composition
- Containment
- DB Client
- DB Data File
- DB Job
- DB Link Object
- DB Scheduler Job
- DB Snapshot
- DB Tablespace
- DB User
- DBA Object
- DB_Archive File
- DB_Control-File
- DB_Re-do File
- DB_Re-do File group
- Dependency
- IpAddress
- IpServiceEndpoint
- Membership
- Node
- Oracle
- Oracle CDB
- Oracle PDB
- Oracle RAC
- Oracle Schema
- Oracle Service Name
- Oracle TNS Listener
- Ownership
- Process
- Realization
- Resource
- Usage
- comprehensiveDiscovery. If false, the DBA Object, DB Job and DB User are not retrieved. The default value is false. If the parameter is set to false, changing other parameters has no effect on the discovery process (DBA Objects are not discovered).
-
discoverDbLinks. If true, DB links are discovered. The default value is true.
- discoverFunctions. If false, functions are not retrieved. The default value is false.
- discoverPackageBody. If false, package bodies are not retrieved. The default value is false.
- discoverPackages. If false, packages are not retrieved. The default value is false.
- discoverProcedures. If false, procedures are not retrieved. The default value is false.
- discoverReportPageSize. The maximum amount of query result objects that can be sent in one bulk. The default value is 1,000.
- discoverTables. If false, tables are not retrieved. The default value is false.
- discoveryDBClients. If true, DB clients are retrieved. The default value is true.
- discoveryUsers. If true, database users are retrieved. If false, database user discovery is controlled by the comprehensiveDiscovery parameter.
- excludeSysUser.If false, system default users are included. The default value is false.