Table of Contents 1 Overview.1 1.1 OpenLink ODBC Driver (Single-Tier Edition) Introduction.1 1.1.1 About ODBC.1 1.1.2 How ODBC Works.1 1.1.3 What You Can Do With ODBC.1 1.2 Using ODBC on a PC.2 1.3 Finding Further Information About ODBC & Utilities.5 2 New Features in OpenLink UDA.7 2.1 New Features in OpenLink UDA v6.0.7 2.2 New Features in OpenLink UDA v5.2.7 3 OpenLink ODBC Driver (Single-Tier Edition) System Requirements and Basic Instructions.9 3.1 Installing OpenLink Single-Tier Drivers for ODBC.9 3.2 System Requirements.9 3.2.1 Software Requirements.9 3.2.2 Hardware Requirements.9 3.3 Downloading OpenLink Single-Tier Drivers for ODBC.10 4 OpenLink ODBC Driver (Single-Tier Edition) Installation.11 4.1 OpenLink License Manager Usage Notes.11 4.1.1 Background.11 4.1.2 Single-Tier.11 4.1.3 Multi-Tier.11 4.1.4 How to stop/start the OpenLink License Manager.11 4.1.5 Environment Variables.12 4.1.6 OpenLink License Manager Networking Considerations.12 4.2 Windows (32-bit).12 4.3 Windows (64-bit).18 4.4 UNIX & Linux.23 4.5 Mac OS X.24 4.6 Product Licensing.31 4.6.1 Initial License.31 4.6.2 How to apply the License.31 4.6.3 Upgrading the License.31 4.7 Oracle Connection Pooling Support.33 4.7.1 What it is.33 4.7.2 Benefits.34 4.7.3 How it Works.34 4.7.4 The OpenLink Perspective: what you do to use it.35 4.8 Oracle 10g Instant Client: Connection String Formats.35 4.8.1 OpenLink Single-Tier Connections using Instant Client.35 4.8.1.1 Defining a DSN using the OpenLink Single Tier DSN Configuration Wizard.36 4.8.2 Oracle Instant Client Related Links.37 4.9 Oracle Real Application Cluster (RAC) / TAF Support.37 4.9.1 What it is.37 4.9.2 What you have to do to use it.38 4.9.2.1 Configuration.38 4.9.2.2 Programmatic Considerations.39 4.9.3 Related Links.40 5 OpenLink ODBC Driver (Single-Tier Edition) Configuration.41 5.1 Windows Data Source Configuration.41 5.1.1 Creating ODBC Data Sources.41 5.1.1.1 Windows ODBC Data Sources.41 5.1.1.2 Data Source Tab.42 OpenLink ODBC Driver (Lite Edition) Documentation Reason: Unable to execute statement: Statement: "Select TO_CHAR(MAX(cast(("AUDSYS"."UNIFIED_AUDIT_TRAIL"."EVENT_TIMESTAMP" at local) as date)),'yyyy-mm-dd hh24:mi:ss') FROM "AUDSYS".OpenLink ODBC Driver (Lite Edition) Documentation OpenLink Software, 2015 Probably I need to customize collector xml, anyone have statement for 18c which works?Įrror finding any new events.
Reason: Unable to execute statement: Statement: "Select TO_CHAR(MAX(cast(("AUDSYS"."UNIFIED_AUDIT_TRAIL"."EVENT_TIMESTAMP" at local) as date)),'yyyy-mm-dd hh24:mi:ss') FROM "AUDSYS"."UNIFIED_AUDIT_TRAIL"" Reason: state: 53 error-code: 140166257705902 description: ORA-00942: table or view does not exist
Error: Unable to execute statement: Statement: "Select TO_CHAR(MAX(cast(("AUDSYS"."UNIFIED_AUDIT_TRAIL"."EVENT_TIMESTAMP" at local) as date)),'yyyy-mm-dd hh24:mi:ss') FROM "AUDSYS"."UNIFIED_AUDIT_TRAIL"" Reason: state: 53 error-code: 140166257705902 description: ORA-00942: table or view does not existĮrror finding any new events. Solved " missing or invalid option" with but now I have another isssue as below:Īn error occurred collecting ODBC events using query tag ORACLE_Unified_Auditing.