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 CMDB11.0

Use > Database > Deploying the Oracle Server Database > Oracle Server Configuration and Sizing Guidelines > Connecting to an Oracle Database Using Service Name

Connecting to an Oracle Database Using Service Name

Starting with version 10.32, it is possible to connect UCMDB server to an Oracle database using Service Name.

Note

This support only works with the Oracle native driver, and does not work with Data Direct drivers. By default it should be native driver. You can check the configuration in the wrapper.conf file, see the following line: wrapper.java.additional.47=-Doracle.native.driver=true.

Starting with version 10.33, to use the Oracle native driver, you may need to perform additional steps. For details, see Configuring Oracle JDBC Driver.
Currently the connection between UCMDB and Oracle RAC environment works only with Oracle native drivers.

You can enable this support using either of the following approaches:

(Recommended) Provide a value for the Service Name field in the UCMDB Server Configuration Wizard
When creating a new schema or connecting to an existing schema with the UCMDB Server Configuration Wizard, on the CMDB Schema Settings tab page, provide a value for the Service Name field.
Note
- The Service Name field is mutually exclusive with the SID field, you can only provide a value for either Service Name or SID.
- The Service Name field is only available when the Oracle native drivers are used.
Modify the dal.datamodel.service.name setting in the cmdb.conf file
1. On the UCMDB server machine, open the <UCMDB_Server>\conf\cmdb.conf file using a text editor.
2. Locate the new database context configuration dal.datamodel.service.name.
3. Provide the service name.
4. Save the file.
5. Restart the UCMDB Server.
Note The dal.datamodel.service.name setting in the cmdb.conf file has precedence over the dal.datamodel.sid setting. That is to say, if the Service Name setting is set, it will be used for database schema connection regardless of whether the SID setting is also set or not, therefore these two settings cannot be used simultaneously.

For example, if a wrong Service Name is provided, the connection will fail, even if a correct SID is provided. To use the dal.datamodel.sid setting for connection, simply leave the dal.datamodel.service.name setting blank.