This posting is about mostly desktops and this oracle message. I want to talk about server class machines running a dtexec that are throwing this error message. In one case it meant that an installed oracle client instance on a server machine was no longer there, and it had been there for a long time. On the client side we found recently 1/2023 that certain versions of the oracle client 32 bit don't run on a laptop with AMD chips. Downgrading to a lower version of the oracle client 19.x fixed the problem.
When trying to use an Oracle APM 2.0 monitor I receive the error "Unexpected error occurred. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I'll assume this is something I need to install on the Orion server.
download oracle client software version 8.1.7
Issue Description: While trying to connect or execute any queries on Oracle database server by using UiPath.Database.Activities might encounter the following error : "System.data.oracleclient requires oracle client software version 8.1.7 or greater".
If you intend to colocate optional Oracle configuration files such as tnsnames.ora, sqlnet.ora, ldap.ora, or oraaccess.xml with Oracle Instant Client, then move these files to the /usr/lib/oracle/21/client64/lib/network/admin subdirectory.
This document contains instructions for downloading the most current fix packs and interim fixes from Fix Central. You can download the IBM Spectrum Protect server and client, IBM Spectrum Protect for SAN, and the Operations Center. The IBM Spectrum Protect for SAN (storage agent) product is packaged with the server.
The .NET Framework Data Provider for Oracle (OracleClient) enables data access to Oracle data sources through Oracle client connectivity software. The data provider supports Oracle client software version 8.1.7 or a later version. The data provider supports both local and distributed transactions. For more information, see Transactions and Concurrency.
To connect to Oracle, you will also need to install the Oracle client software on the machine where you have installed the on-premises data gateway. Specifically, the Oracle Database connection requires the installation of the 64-bit Oracle Data Provider for .NET. You can use the following link to download and install the Oracle client:
Now we need to customize the database configuration a bit. Whilestill logged on as oracle, editthe database initialization script (run when the db loads). Thescripts are kept in $ORACLE_HOME/dbs and the name of the scriptis usually initSID.ora where SID is the SID of your database.Assuming your $ORACLE_HOMEmatches our default of /ora8/m01/app/oracle/product/8.1.7, thefollowing will open the file for editing.
The Microsoft Oracle .NET data provider accesses an Oracle databaseusing the Oracle Call Interface (OCI) through Oracle clientconnectivity software. The provider can access Oracle 7.3.4 or laterand requires Oracle 8i Release 3 (8.1.7) orlater client software. The classes are located in theSystem.Data.OracleClient namespace. An example ofa connection string using integrated security is shown in thefollowing snippet:
In order to use OCI driver, you should have an Oracle client installed. You should have installedOracle8i(8.1.7) client from cd, and download the suitable JDBC/OCIdriver(Oracle8i 8.1.7.1 JDBC/OCI Driver) from otn.oracle.com.
2ff7e9595c
Kommentare