Questions tagged [oracleclient]

Oracle Instant Client enables applications to connect to a local or remote Oracle Database for development and production deployment.

Oracle Instant Client enables applications to connect to a local or remote Oracle Database for development and production deployment. The Instant Client libraries provide the necessary network connectivity, as well as basic and high end data features, to make full use of Oracle Database. It underlies the Oracle APIs of popular languages and environments including Node.js, Python and PHP, as well as providing access for OCI, OCCI, JDBC, ODBC and ProC applications. Tools included in Instant Client, such as SQLPlus and Oracle Data Pump, provide quick and convenient data access.

Site: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

235 questions
171
votes
27 answers

The provider is not compatible with the version of Oracle client

I'm trying to use the Oracle ODP.NET 11g (11.1.0.6.20) Instant Client on my ASP.net project as a Data Provider but when I run the aspx page I get a "The provider is not compatible with the version of Oracle client" error message. Any help would be…
EverTheLearner
  • 7,040
  • 16
  • 57
  • 72
84
votes
2 answers

Oracle SQL Developer - Query results window with grid missing

I've just made the switch from MS sql server to Oracle. The query tool I am using is Oracle SQL Developer. The problem I am having is that I cannot get the query results window to stick around. The query results window being the Grid view for the…
Jody
  • 8,021
  • 4
  • 26
  • 29
55
votes
9 answers

How to know installed Oracle Client is 32 bit or 64 bit?

OS: Windows 2008 Server R2 Oracle Client: 11.2 Many Thanks
aiyagaze
  • 884
  • 2
  • 8
  • 14
38
votes
7 answers

Does ODP.NET require Oracle Client installation

I have to connect Oracle 11g DB from .NET code. For that purpose I installed ODP.NET bur after reading some forum posts I recognized that I need Oracle Client installation too. Is that true? I see that the Oracle Client has a size of ca. 2GB!!! Do I…
llasarov
  • 2,064
  • 5
  • 27
  • 40
33
votes
16 answers

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Please suggest a solution for solving this issue?? While giving the command: sqlplus /nolog the error that occurred: sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
Priyanka U
  • 443
  • 1
  • 5
  • 8
33
votes
12 answers

Oracle client installation error - path too long

I'm trying to install Oracle 11g Release 2 (client). But it gives an error like that : Environment variable: "PATH" - This test checks whether the length of the environment variable "PATH" does not exceed the recommended length. Expected…
kamal
  • 1,093
  • 6
  • 19
  • 34
27
votes
3 answers

[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/easysoft/oracle/InstantClient112/lib/libsqora.so' : file not found

I am trying to acces oracle from linux server. I am using unixODBC. When i try to acces oracle using isql and i get error that driver manager can't open libsqora.so.12.1. odbc.ini [NAME] Application Attributes = T Attributes = W …
user3521305
  • 391
  • 1
  • 4
  • 6
24
votes
8 answers

The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception

I have developed an application that uses Oracle Data Provider for .NET. I copy the application file (.exe) and ODP library (Oracle.DataAccess.dll) on another computer that Oracle client and ODP.NET are NOT installed on. When I run the application,…
Sambath Prum
  • 1,858
  • 9
  • 25
  • 33
23
votes
11 answers

BadImageFormatException while using Oracle Client 64 bit and Visual Studio 2010!

One of our dev team member got an error Attempt to load oracle client libraries threw BadImageFormatException It seems This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. But it was me who…
18
votes
4 answers

PL/SQL developer with oracle 32-bit/64-bit client

I have Oracle 64-bit client installed to run with my weblogic application. I learnt that pl-sql developer doesn't work with oracle 64-bit client so now i have both 32-bit and 64-bit clients installed on my machine and my ORACLE_HOME variable points…
Adithya
  • 2,923
  • 5
  • 33
  • 47
16
votes
8 answers

Error System.Data.OracleClient requires Oracle client software version 8.1.7 or greater when installs setup

I have made a desktop app Setup that connects with remote Oracle 10g Database. When I install Setup on remote machine and run my application then I get following error: system.data.oracleclient requires oracle client software version 8.1.7 or…
Volatil3
  • 14,253
  • 38
  • 134
  • 263
14
votes
2 answers

Oracle connection string without tnsnames.ora file

I am using the .NET framework with the System.Data.OracleClient namespace. I have the oracle 11 client installed on my computer. I do not want to use the tnsnames.ora file to store connection information. Could someone please tell me what the…
410
  • 3,170
  • 8
  • 32
  • 36
14
votes
6 answers

System.Data.OracleClient namespace discontinued?

I just read this article today about how Microsoft decided to remove the System.Data.OrcaleClient namespace from .NET 4.0 library. I used this as my primary tool for working with Oracle databases. When I decide to upgrade my applications from the…
Michael Kniskern
  • 24,792
  • 68
  • 164
  • 231
13
votes
5 answers

Install oracle client in docker container

I am using alpine linux as a base image, and I need to install an oracle client native library. I believe you can download from here: https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html it looks like I have to login to download,…
user5047085
12
votes
9 answers

How can I mock/fake/stub sealed OracleException with no public constructor?

In my tests I need to test what happens when an OracleException is thrown (due to a stored procedure failure). I am trying to setup Rhino Mocks to Expect.Call(....).Throw(new OracleException()); For whatever reason however, OracleException seems…
George Mauer
  • 117,483
  • 131
  • 382
  • 612
1
2 3
15 16