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 > How to Enable Support for Oracle Advanced Security (ASO) in Generic Database Adapter Based Integrations

How to Enable Support for Oracle Advanced Security (ASO) in Generic DB Adapter-based Integrations

To enable support for Oracle Advanced Security (ASO) in Generic DB Adapter-based integrations, do the following:

Open the adapter.conf file in the Generic DB Adapter.

In UCMDB UI, go to Data Flow Management > Adapter Management. Under the Packages root folder in the Resource pane, go to db-adapter > Configuration Files > GenericDBAdapter/META-INF/adapter.conf
Locate the following line:
```
dal.use.persistence.xml=false
```
Change the value to true as follows:
```
dal.use.persistence.xml=true
```
Click Save .
Open the persistence.xml file by clicking GenericDBAdapter/META-INF/persistence.xml.

Locate the following line:

<persistence-unit name="GenericDBAdapter"/>

Replace it with the following content:

<persistence-unit name="GenericDBAdapter">    <properties>
        <!-- added to fix:  org.hibernate.HibernateException: 'hibernate.dialect' must be set when no connection available -->
        <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>
        <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
        <property name="hibernate.connection.driver_class" value="oracle.jdbc.OracleDriver"/>
        <property name="hibernate.connection.url" value="jdbc:oracle:thin:@<oracle-host-name>:<oracle-port>:<oracle-db-sid>"/ >   
        <property name="oracle.net.encryption_client" value="REQUIRED" />
        <property name="oracle.net.encryption_types_client" value="( DES40 )" />
        <property name="oracle.net.crypto_checksum_client" value="REQUESTED" />
        <property name="oracle.net.crypto_checksum_types_client" value="MD5" />
    </properties>
</persistence-unit>

Update connection.url in the above code snippet with the proper hostname/port/SID, and also update the username and password.
Click Save .
Wait a few minutes for the probe to retrieve the latest settings.
Run test connection and check whether it works.

Send Help Center feedback