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 Database Servers- Lightweight

How to Discover Oracle Database Servers- Lightweight

This task describes how to discover Oracle databases using a lightweight method of discovery. This discovery adds a valid credentials ID to the CMDB. You can then use this CI to fully discover the database.

This task includes the following steps:

Prerequisite - Set up protocol credentials

Oracle Database Server discovery uses the Generic DB Protocol (SQL).

For credential information, see Supported Protocols.
Prerequisite - Verify user on Oracle database server

Run the Databases TCP Ports job to verify the port used by the Oracle Database Server.
Run the discovery
Activate the following jobs in the listed order:
1. Databases TCP Ports
2. Oracle Database Connection by SQL- Lightweight
3. Oracle Topology by SQL
  
  Note Due to the large amount of data reported by the Oracle Topology by SQL job, topology data is sent in chunks. Chunk size (the number of objects in a chunk) is regulated by the discoverReportPageSize job parameter. The default value is 1,000 objects in one chunk.
For details on running jobs, see "Module/Job-Based Discovery" in the Data Flow Management section of the UCMDB Help.

Send Help Center feedback