--- sourceDocument: Xanadu IT Operations Management sourceDocumentLink: https://www.servicenow.com/docs/r/xanadu/it-operations-management Release : - xanadu ft:locale : - en-US ft:publication_title : - Xanadu IT Operations Management ft:clusterId : - itom bundleId : - itom workflow : - Technology --- # Oracle GLAS data collection # Oracle Global License Advisory Services (GLAS) data collection using patterns {#ariaid-title1} * Release version: Xanadu * * Updated January 30, 2025 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 7 minutes to read The ServiceNow Discovery application uses the Oracle verified GLAS Data Collection pattern to discover Oracle GLAS data. This data includes discovered Oracle Database, Middleware, and Java configuration items. The Oracle GLAS Data Collection pattern is an extension of the following patterns: * Oracle Database on UNIX and Windows patterns * Oracle Middleware on Linux for the following patterns: * Oracle Tuxedo * WebLogic * Linux {#oracle-glas-discovery__ul_p3d_y3y_ptb} * Oracle Java on Java installation pattern {#oracle-glas-discovery__ul_n5h_sn5_4tb} The Oracle Database and Middleware patterns execute the pattern extensions, and the data collected is stored in the ServiceNow tables for GLAS data. The Oracle GLAS Data Collection Database pattern can be used on the ServiceNow AI Platform beginning with the Paris release. The Oracle GLAS Data Collection Middleware pattern can be used on the ServiceNow AI Platform beginning with the Rome release. The Oracle Java pattern can be used on the ServiceNow AI Platform beginning with the Washington DC release. For details on how to view and download the collected Oracle GLAS data, see [Download Oracle Global License Advisory Services (GLAS) data](https://www.servicenow.com/docs/Gq3~d8RB9ZwAAyn2u6Bgsw "Download Oracle GLAS data in CSV format to get detailed information on patterns and configuration items. You can also download reports for Oracle Database, Middleware, Oracle Java, VM, and vCenter hardware information."). ## Request apps on the Store {#oracle-glas-discovery__id_z4l_ysx_rcc} Visit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the [ServiceNow Store version history release notes](https://www.servicenow.com/docs/bundle/store-release-notes/page/release-notes/store/sn-store-release-notes.html).{#oracle-glas-discovery__inline-send-to-store} To learn about the supported versions of Oracle, refer to [Detailed information on products discovered by ITOM Visibility](https://www.servicenow.com/docs/bUs_ywRDdbWt5fTaFPLVzw "Discovery and Service Mapping can discover a wide range of operating systems and applications."). ## Prerequisites {#oracle-glas-discovery__section_lsq_pjy_ptb} Install the Data Collection for Oracle Global Licensing and Advisory Services store app : Navigate to System DefinitionPlugins and install the Data Collection for Oracle Global Licensing and Advisory Services app. * The minimum version for Database collection is 1.4.0 * The minimum version for Middleware collection is 1.7.1 * The minimum version for Java collection is 1.8.4 {#oracle-glas-discovery__ul_emn_ztf_qtb} Note: The Data Collection for Oracle Global Licensing and Advisory Services app requires the Discovery (com.snc.discovery) plugin to work correctly. Verify the following applications are installed : * Discovery and Service Mapping Patterns * CMDB CI Class Models {#oracle-glas-discovery__ul_ugp_ms5_4tb} Verify operating system privileges : Verify that your Windows or UNIX user can write temporary files under /tmp. : Verify that you can run the following operating system commands: * ls * cat * ps {#oracle-glas-discovery__ul_wxv_1kd_v4b} Create operating system credentials : Verify that you have the following credentials for your operating system, and then create credentials for them on the ServiceNow AI Platform: * UNIX credentials using SSH. For more information, see [SSH credentials](https://www.servicenow.com/docs/access?context=r_SSHCredentialsForm&version=xanadu&pubname=xanadu-platform-security&ft:locale=en-US). * Windows credentials using PowerShell/WMI. For more information, see [Windows credentials](https://www.servicenow.com/docs/access?context=r_WindowsCredentialsForm&version=xanadu&pubname=xanadu-platform-security&ft:locale=en-US). Note: PowerShell and WMI credentials are required only for Database collection. {#oracle-glas-discovery__ul_lg2_hdr_v4b} Verify the following Oracle privileges : Verify that you have applicative credentials for the Oracle instance (cmdb_ci_db_ora_instance) that have the following privileges: * Read permissions on the tnsnames.ora file. * Permissions to execute the sqlplus command. * (For middleware collection) Sudo permissions to run the following command: `sudo su - oracle -c "$ORACLE_INSTANCE/bin/opmnctl status"` {#oracle-glas-discovery__ul_qv5_kld_v4b} : Verify you have the user name and password for the relevant Oracle Database, with read permissions on the following tables: |-|-|-| | DBA_ADVISOR_TASKS | DBA_USERS | SYS.MODEL$ | | DBA_CPU_USAGE_STATISTICS | DMSYS.DM$MODEL | SYS.REGISTRY$HISTORY | | DBA_ENCRYPTED_COLUMNS | DMSYS.DM$OBJECT | SYSMAN.MGMT_INV_CONTAINER | | DBA_FEATURE_USAGE_STATISTICS | DMSYS.DM$P_MODEL | SYSMAN.MGMT_LICENSES | | DBA_FLASHBACK_ARCHIVE_TABLES | DVSYS.DBA_DV_REALM | SYSMAN.MGMT_LICENSE_DEFINITIONS | | DBA_INDEXES | GV$IM_SEGMENTS | SYSMAN.MGMT_TARGETS | | DBA_LOBS | GV$INSTANCE | SYSMAN.MGMT_VERSIONS | | DBA_LOB_PARTITIONS | GV$PARAMETER | V$ARCHIVE_DEST_STATUS | | DBA_LOB_SUBPARTITIONS | MDSYS.SDO_FEATURE_USAGE | V$BLOCK_CHANGE_TRACKING | | DBA_OBJECTS | MDSYS.SDO_GEOM_METADATA_TABLE | V$CONTAINERS | | DBA_RECYCLEBIN | MGMT$TARGET | V$DATABASE | | DBA_REGISTRY | ODM.ODM_MINING_MODEL | V$DATAGUARD_CONFIG | | DBA_SQLSET | ODM_DOCUMENT | V$LICENSE | | DBA_SQLSET_REFERENCES | ODM_RECORD | V$OPTION | | DBA_SQL_PROFILES | REDACTION_POLICIES | V$PARAMETER | | DBA_TABLES | SCHEMA_VERSION_REGISTRY | V$VERSION | | DBA_TABLESPACES | SYS.CDC_CHANGE_SETS$ | dba_aws | | DBA_TAB_PARTITIONS | SYS.CDC_CHANGE_TABLES$ | | | DBA_TAB_SUBPARTITIONS | SYS.DBA_MINING_MODELS | | [ ] {#oracle-glas-discovery__table_ixr_1rz_5tb} Create applicative credentials for Oracle Instance : Create applicative credentials on the ServiceNow AI Platform. For more information, see [Applicative credentials](https://www.servicenow.com/docs/access?context=applicative-creds&version=xanadu&pubname=xanadu-platform-security&ft:locale=en-US). For virtual machines: Verify virtual machine credentials : For virtual machines, verify you have the relevant credentials to collect hardware data for machines hosted on the following virtual providers: * VMware * Nutanix * IBM * Hyper-V {#oracle-glas-discovery__ul_z34_5t5_s2c} ## Database CI relationships {#oracle-glas-discovery__section_rwc_sjx_54b} {#oracle-glas-discovery__table_jtg_dtm_pu832__entry__3} | CI | Relationship/Reference | CI | |-|-|-| | cmdb_ci_orcl_vsession | Contains::Contained By | cmdb_ci_db_ora_instance | | cmdb_ci_ora_lms_detail | Contains::Contained By | cmdb_ci_db_ora_instance | | cmdb_ci_ora_lms_overview | Contains::Contained By | cmdb_ci_db_ora_instance | | cmdb_ci_orcl_options | Contains::Contained By | cmdb_ci_db_ora_instance | | cmdb_ci_orcl_dba_users | Contains::Contained By | cmdb_ci_db_ora_instance | | cmdb_ci_orcl_vlicense | Contains::Contained By | cmdb_ci_db_ora_instance | [ ] {#oracle-glas-discovery__table_jtg_dtm_pu832} ## Tuxedo middleware extension {#oracle-glas-discovery__section_prb_j3g_qtb} Tuxedo license configuration and log files collected: * \*_InstallLog.log * \*ubbc\* * bdmconfig\* * comps.xml * dmconfig\* * JSconfig.xml * lic.txt * registry.xml * tuxconfig\* * tuxwsvr.ini {#oracle-glas-discovery__ul_sdv_vss_5tb} Note: The asterisk represents one or more characters in the file name. Processes collected: * BBL * DBBL * GWWS * JSH * JSL * TMJAVASVR * TMMETADATA {#oracle-glas-discovery__ul_czh_q3g_qtb} ## WebLogic middleware extension {#oracle-glas-discovery__section_hj2_t3g_qtb} Files collected: * beahomelist * biee-domain.xml * cluster.properties * comps.xml * config.xml * domain-registry.xml * opmn.xml * portalconfig.xml * pthome.xml * registry.xml * server.xml * sessions.xml * setupinfo.txt {#oracle-glas-discovery__ul_r4s_b5s_5tb} WebLogic processes and files collected for the following middleware products: * WebLogic * OAS * SOA * OBI * WebCenter * FormsReports {#oracle-glas-discovery__ul_i2x_w3g_qtb} {#oracle-glas-discovery__table_ghk_xgt_5tb__entry__3} | WebLogic | OAS ||||| OBI | |-|:-:|-|-|-|-|-| | startWebLogic | httpd | f90 | iooomgrrmi | r30rbe32 | rwrqm60 | nqsserver | | java | apache | frmweb | javaw | r30rqm32 | rwrqm | sawserver | | startWLS | java | ifbld60 | java | r30run32 | rwrun60 | coreapplication_obijh1 | | nodemanager | opmn | ifbld90 | jre | r30sxc32 | rwserver | nqscheduler | | beasvc | dis3 | ifcgi60 | oad | r30sxu32 | rwsxc60 | nqsclustercontroller | | beasvc64 | dis4 | ifcmp60 | odisrv | rwbld60 | rwsxu60 | essbase | | beasvcX64 | dis51pr | ifcmp90 | ofcguard | rwbuilder | vdeserver | essvr | | oraclesvc | dis51ws | ifctrl60 | oidrepld | rwcgi60 | webcachea | essbasestudio | | opmn | dis51 | ifdbg60 | oidmon | rwcli60 | webcached | hyperion | | wlsvc | dwfde61 | ifrun60 | oidldapd | rwcon60 | webcache | | | wlsvc64 | f45des | ifsrv60 | opmn | rwconverter | | | | wlsvcX64 | f45run | ifwdb60 | r30cli32 | rwisv60 | | | | jmc | f50dbg32 | ifweb60 | r30con32 | rwmts60 | | | | httpd | f50run32 | ifweb90 | r30isv32 | rwqmu60 | | | | jrmc | f60 | imapds | r30qmu32 | rwrbe60 | | | [Table 1. Processes] {#oracle-glas-discovery__table_ghk_xgt_5tb} ## Middleware CI relationships {#oracle-glas-discovery__section_fs5_wcg_qtb} {#oracle-glas-discovery__table_gs5_wcg_qtb__entry__3} | CI | Relationship/Reference | CI | |-|-|-| | cmdb_ci_ora_lms_overview | Contains::Contained by | cmdb_ci_linux_server | | cmdb_ci_config_file_tracked | Contains::Contained by | cmdb_ci_linux_server | [ ] {#oracle-glas-discovery__table_gs5_wcg_qtb} These relationships are created by a containment rule that describes the valid objects that the Linux CIs can contain. ## Properties installed with the Middleware data collection application {#oracle-glas-discovery__section_ddc_3m5_qtb} To access the installed application properties, navigate to AllSystem PropertiesAll Properties. You must have the admin role to modify these properties.{#oracle-glas-discovery__table_mgs_qm5_qtb__entry__3} | System property | Default value | Description | |-|-|-| | sn_itom_oracleglas.isMaskingIp | true | Determines whether to mask the IP Address in Oracle middleware tracked files by replacing the value with "text_removed." | | sn_itom_oracleglas.isMaskingUserName | true | Determines whether to mask the user name in Oracle middleware tracked files by replacing the value with "text_removed." | | sn_itom_oracleglas.isMaskingPort | true | Determines whether to mask the port in Oracle middleware tracked files by replacing the value with "text_removed." | [ ] {#oracle-glas-discovery__table_mgs_qm5_qtb} ## Control GLAS data collection {#oracle-glas-discovery__section_fsb_cvl_sbc} The following MID Server property controls the GLAS data collection: sn_itom_oracleglas.disable_glas_data_collection The property is set to False by default. Note: In Data Collection for Oracle Global Licensing and Advisory Services versions earlier than 1.10.2, the property name is sn_itom_pattern.disable_glas_data_collection. ## Oracle Java process discovery {#oracle-glas-discovery__section_csz_4hb_fdc} ITOM Visibility can discover Java-running processes in your infrastructure, allowing you to comply with Oracle licensing agreements and prepare for GLAS Audits. You can perform the discovery using the Java Installation pattern (IP-based) or Agent Client Collector with application patterns. In the pattern flow, the Java processes are discovered by Application Dependency Mapping (ADM). When the processes are discovered, the Java Installation pattern triggers and collects the data. For information about privileged user access, see [KB1705845](https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1705845). If you are on a family release earlier than Yokohama, you must download the update set from the Knowledge Base article and follow the instructions for applying it. For more information about Agent Client Collector with patterns, see [Application patterns for the Agent Client Collector](https://www.servicenow.com/docs/ncWwcj1V7ksiEH9xgtfjfg "Application patterns gather details on the applications that run on the Agent Client Collector (ACC) host. Application patterns are supported only for servers, and are triggered after the Agent Client Collector host Discovery is complete."). Data collected : {#oracle-glas-discovery__table_dqf_31c_fdc__entry__2} | Field | Description | |-|-| | Name | Name of the record. For example: Java@hostname | | Physical Machine Name | Name of the host CI | | Machine Type | Either Server(S) or Desktop(D) | | Java Publisher/Runtime Vendor | Java Vendor name | | Operating System | Operating system in which the java is run | | Environment Type | Production or Development or QA environment | | Java Release/Version/Build | Java Version | | Installation Path | Absolute installation path of the java binary | | Installation Date (DateTime) | The date and time of the java binary file created on the filesystem | | Release File (Y / N) | Indicates if a release.md file exists in the installation | | Processor Make/Model | Processor model name | | Sockets (Integer) | Number of CPU sockets | | Cores (Integer) | Number of CPU cores | | V6 and earlier | Indicates if you have a 6 or earlier java version | | Open Source | Indicates if you have an open-source java installation | | Unlock Commercial features | Indicates if you have the commercial features (like JFR) enabled | | Mission Control | Indicates if the mission control plugin is enabled | | AMC Agent | Indicates if the AMC agent plugin is enabled | | Usage Tracker | Indicates if the Usage Tracker feature is enabled | | Virtual Machine Object ID | Object ID of the Virtual machine instance | | PID | Running process PID | | IP Address | IP address of the host/VM | | First Discovered | The date of the first discovery | | Most recent discovery | The date of the most recent discovery | | Discovery Source | The discovery method. | | Application | Reference to the \[cmdb_ci_appl\] table | | Software installation | Reference to the \[cmdb_sam_sw_install\] table | | Java evidence | Reference to the \[cmdb_ora_java_evidence\] table | | Host | Reference to the \[cmdb_ci\] table | [Table 2. Java Audit \[ora_java_audit\]] {#oracle-glas-discovery__table_dqf_31c_fdc} Java Evidence \[ora_java_evidence\] : {#oracle-glas-discovery__table_ghb_pdc_fdc__entry__2} | Field | Description | |-|-| | Running process | Reference to the \[cmdb_running_process\] table | | Host CI | Reference to the \[cmdb_ci_computer\] table | | File information | Provides a reference to the \[cmdb_file_information\] table. Relevant only for file-based discovery (FBD); in pattern-based discovery, this field remains empty. | [ ] {#oracle-glas-discovery__table_ghb_pdc_fdc} Download the Oracle GLAS report in the Discovery Admin Workspace. For more information, see [Download Oracle Global License Advisory Services (GLAS) data](https://www.servicenow.com/docs/Gq3~d8RB9ZwAAyn2u6Bgsw "Download Oracle GLAS data in CSV format to get detailed information on patterns and configuration items. You can also download reports for Oracle Database, Middleware, Oracle Java, VM, and vCenter hardware information."). ## Oracle GLAS Data Collection {#oracle-glas-discovery__section_o5c_fyf_qtb} After Discovery finishes discovering the components of your database or middleware deployment, you can view the relevant statistics in the Oracle GLAS Data Collection. Starting with Data Collection for Oracle Global Licensing and Advisory Services version 1.8.0, the Oracle GLAS Data Collection dashboard has been deprecated. After upgrading to Discovery Admin Workspace version 1.3.1 (August 2024 store), you can navigate to WorkspacesDiscovery Admin WorkspaceInsights to view and access the Oracle GLAS Data Collection. *[\>]: and then