- Oracle Client Software Version 8.1 7 Or Greater Free Download 64-bit
- Oracle Client Software Version 8.1 7 Or Greater free. download full
- Oracle Client Software Version 8.1 7 Or Greater Free Download Windows 10
- Oracle Client Software Version 8.1 7 Or Greater Free Download Windows 7
Find answers to OracleClient requires Oracle client software version 8.1.7 or greater from the expert community at Experts Exchange. The Oracle client software you use depends on which version of Power BI Desktop you've installed: 32-bit or 64-bit. It also depends on your version of Oracle server. Here are the supported Oracle version. I'm trying to install Oracle 8.1.7.3 client on a 64bit Windows Server 2008, without success. Best result I got so far is 'installed' client and provider, but unable to run the config tools, or use the provider. I installed the same client on a 32bit version of Win Server 2008 and it worked with few minor tweaks. Re: download oracle 8.1.7 client from oracle 546144 Nov 15, 2006 11:32 AM ( in response to 445547 ) hey guys,i want to download oracle 8.1.7,but i could not find it.Do i need to have a licence to download this? Or it is free.
-->![Version Version](/uploads/1/1/3/6/113629805/190225259.jpg)
Using the Oracle Database connector, you create organizational workflows that use data in your existing database. This connector can connect to an on-premises Oracle Database, or an Azure virtual machine with Oracle Database installed. With this connector, you can:
- Build your workflow by adding a new customer to a customers database, or updating an order in an orders database.
- Use actions to get a row of data, insert a new row, and even delete. For example, when a record is created in Dynamics CRM Online (a trigger), then insert a row in an Oracle Database (an action).
This connector doesn't support the following items:
- Views
- Any table with composite keys
- Nested object types in tables
- Database functions with non-scalar values
This article shows you how to use the Oracle Database connector in a logic app.
Prerequisites
- Supported Oracle versions:
- Oracle 9 and later
- Oracle client software 8.1.7 and later
- Install the on-premises data gateway. Connect to on-premises data from logic apps lists the steps. The gateway is required to connect to an on-premises Oracle Database, or an Azure VM with Oracle DB installed.NoteThe on-premises data gateway acts as a bridge, and provides a secure data transfer between on-premises data (data that is not in the cloud) and your logic apps. The same gateway can be used with multiple services, and multiple data sources. So, you may only need to install the gateway once.
- Install the Oracle Client on the machine where you installed the on-premises data gateway. Be sure to install the 64-bit Oracle Data Provider for .NET from Oracle:TipIf the Oracle client is not installed, an error occurs when you try to create or use the connection. See the common errors in this article.
Add the connector
Important
This connector does not have any triggers. It has only actions. So when you create your logic app, add another trigger to start your logic app, such as Schedule - Recurrence, or Request / Response - Response.
- In the Azure portal, create a blank logic app.
- At the start of your logic app, select the Request / Response - Request trigger:
- Select Save. When you save, a request URL is automatically generated.
- Select New step, and select Add an action. Type in
oracle
to see the available actions:TipThis is also the quickest way to see the triggers and actions available for any connector. Type in part of the connector name, such asoracle
. The designer lists any triggers and any actions. - Select one of the actions, such as Oracle Database - Get row. Select Connect via on-premises data gateway. Enter the Oracle server name, authentication method, username, password, and select the gateway:
- Once connected, select a table from the list, and enter the row ID to your table. You need to know the identifier to the table. If you don't know, contact your Oracle DB administrator, and get the output from
select * from yourTableName
. This gives you the identifiable information you need to proceed.In the following example, job data is being returned from a Human Resources database: - In this next step, you can use any of the other connectors to build your workflow. If you want to test getting data from Oracle, then send yourself an email with the Oracle data using one of the send email connectors, such as Office 365 Outlook. Use the dynamic tokens from the Oracle table to build the
Subject
andBody
of your email: - Save your logic app, and then select Run. Close the designer, and look at the runs history for the status. If it fails, select the failed message row. The designer opens, and shows you which step failed, and also shows the error information. If it succeeds, then you should receive an email with the information you added.
Workflow ideas
- You want to monitor the #oracle hashtag, and put the tweets in a database so they can be queried, and used within other applications. In a logic app, add the
Twitter - When a new tweet is posted
trigger, and enter the #oracle hashtag. Then, add theOracle Database - Insert row
action, and select your table: - Messages are sent to a Service Bus queue. You want to get these messages, and put them in a database. In a logic app, add the
Service Bus - when a message is received in a queue
trigger, and select the queue. Then, add theOracle Database - Insert row
action, and select your table:
Common errors
Error: Cannot reach the Gateway
Cause: The on-premises data gateway is not able to connect to the cloud.
Mitigation: Make sure your gateway is running on the on-premises machine where you installed it, and that it can connect to the internet. We recommend not installing the gateway on a computer that may be turned off or sleep. You can also restart the on-premises data gateway service (PBIEgwService).
Error: The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. See https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider.
Cause: The Oracle client SDK is not installed on the machine where the on-premises data gateway is running.
Resolution: Download and install the Oracle client SDK on the same computer as the on-premises data gateway.
Error: Table '[Tablename]' does not define any key columns
Cause: The table does not have any primary key.
Resolution: The Oracle Database connector requires that a table with a primary key column be used.
Connector-specific details
View any triggers and actions defined in the swagger, and also see any limits in the connector details.
Get some help
The Microsoft Q&A question page for Azure Logic Apps is a great place to ask questions, answer questions, and see what other Logic Apps users are doing.
You can help improve Logic Apps and connectors by voting and submitting your ideas at https://aka.ms/logicapps-wish.
Next steps
Create a logic app, and explore the available connectors in Logic Apps at APIs list.
Last updated on OCTOBER 30, 2019
Applies to:
Oracle WebCenter Forms Recognition - Version 11.1.1.8.0 to 11.1.1.9.0 [Release 11g]Information in this document applies to any platform.
Oracle Client Software Version 8.1 7 Or Greater Free Download 64-bit
Symptoms
Receiving the below error when attempting to connect to the Web Verifier /login.aspx page:
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
The stack trace that shows up in the trace.log is:
2015-07-02 08:20:30,899 [9] ERROR Brainware.Verifier.WebClient.Global [(null)] - The underlying provider failed on Open.
[PID=8108|UID=?|MEM PH/V=70,072k/445,580k|MEM_ALL_PH OCC/AV=2,281,796k/1,912,052k|MEM_ALL_V OCC/AV=445,580k/3,748,596k|HNDL=704]
System.Data.EntityException: The underlying provider failed on Open. ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
at System.Data.OracleClient.OCI.DetermineClientVersion()
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at EFOracleProvider.EFOracleConnection.Open() in <path>dNETrelsrcEFOracleProviderEFOracleConnection.cs:line 144
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.b__1[TResult](IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
at Brainware.System.DAL.DA.ModuleDA.GetByNameAndIsDeleted(String moduleName, Boolean isDeleted) in F:Build55CedardNETrelsrcSystem.DALDAModuleDA.cs:line 42
at Brainware.System.Controllers.Module.ModuleController.get_CurrentModuleId() in <path>dNETrelsrcSystem.ControllersModuleModuleController.cs:line 33
at Brainware.Verifier.WebClient.Global.Application_End(Object sender, EventArgs e) in <path>dNETrelsrcVerifier.WebClientGlobal.asax.cs:line 169
[END APPLICATION AT 2015-07-02 08:20:31,180]
System.Data.EntityException: The underlying provider failed on Open. ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
at System.Data.OracleClient.OCI.DetermineClientVersion()
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at EFOracleProvider.EFOracleConnection.Open() in <path>dNETrelsrcEFOracleProviderEFOracleConnection.cs:line 144
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.b__1[TResult](IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
at Brainware.System.DAL.DA.ModuleDA.GetByNameAndIsDeleted(String moduleName, Boolean isDeleted) in F:Build55CedardNETrelsrcSystem.DALDAModuleDA.cs:line 42
at Brainware.System.Controllers.Module.ModuleController.get_CurrentModuleId() in <path>dNETrelsrcSystem.ControllersModuleModuleController.cs:line 33
at Brainware.Verifier.WebClient.Global.Application_End(Object sender, EventArgs e) in <path>dNETrelsrcVerifier.WebClientGlobal.asax.cs:line 169
[END APPLICATION AT 2015-07-02 08:20:31,180]
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
Don't have a My Oracle Support account? Click to get started! |
Symptoms |
Changes |
Oracle Client Software Version 8.1 7 Or Greater free. download full
Cause |
Oracle Client Software Version 8.1 7 Or Greater Free Download Windows 10
Solution |