• Welcome
  • Supportability
    • Discovered Applications
    • Discovered Operating Systems
    • Universal Discovery IPv6 Support
    • Supported Agents
    • Universal Discovery Agent, Software Utilization Plug-In, Scanner, Scanner Scheduler, and SAI Support
    • Store and Forward Server Support
    • Supported Protocols
    • Default Ports for Supported Protocols
    • Supported Discovery Modules and Jobs
    • Supported Integrations
    • Support for HPE UCMDB Integration Service on Linux
    • Localization
  • Discovery
    • Discovery Activities
    • Discovery Modules
  • Integrations
    • HPE Product Integrations
    • Third Party Integrations
  • Reference
    • How to Define a New Port
    • How to Discover IP Addresses in Universal Discovery
    • How to Use the cpVersion Attribute to Verify Content Update
    • How to Delete Files Copied to a Remote Machine
    • How to Run HPCmd from Windows Server 2008, 2008 R2, 2012, and 2012 R2 Machines
    • Files Copied to a Remote Machine
    • Content Pack Configuration Files
    • Additional Protocol Information
    • Event Based Discovery
    • PrimaryDNSName Logic
    • Supported UNIX Shells
    • Troubleshooting and Limitations
    • Discovery and Integrations Content Guide - Support Matrix
    • Universal Data Model (UDM)
    • HPE Universal CMDB Help Center
  • All Files
test text

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.

ClosedWords and Phrases
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.
ClosedUsing Boolean Operators
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 CMDB
  • 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
Discovery > Discovery Modules > Database > Oracle Database Server Discovery > Oracle Connection by SQL Adapter

Oracle Connection by SQL Adapter

This section includes details about the adapter.

ClosedID

Oracle Connection By SQL

ClosedInput CIT

Node

ClosedInput TQL

ClosedTriggered CI Data
Name Value
application_ip ${DB.application_ip:NA}
application_port ${DB.application_port:NA}
ip_address ${IpAddress.name}
sa_ip ${SA.bound_to_ip_address:NA}
sa_port ${SA.network_port_number:NA}
sid ${DB.name:NA}
ClosedUsed Scripts
  • file_ver_lib.py
  • SQL_Connection.py
ClosedDiscovered CITs
  • Composition
  • Containment
  • IpAddress
  • IpServiceEndpoint
  • Node
  • Oracle
  • Oracle Service Name
  • Usage
ClosedParameters
  • protocolType. Default value is oracle, should not be changed.
Connect
HPE Live Network
IT Service Management blog
Documentation Forum
HPE Support and News Forum
picpicpic
Learn
HPE Software Support Online
HPE Software Support Downloads
HPE Software Education Services
Contact

Send Help Center feedback

We welcome your comments!

To open the configured email client on this computer, open an email window.

Otherwise, copy the information below to a web mail client, and send this email to cms-doc@hpe.com.


Help Topic ID:

Product:  

Topic Title:

Feedback:


 

Submit Service Request
View Service Requests
picpicpic
© 2002 - 2017 Hewlett Packard Enterprise Development LP