Questions tagged [instantclient]

The Oracle Instant Client is an easy to install client for Oracle Databases utilizing the Oracle Call Interface (OCI)

145 questions
1
vote
0 answers

Very slow connection to distant oracle DB using OCI and instant client

I have a Zend 1.1 Application, which became very slow when migrated to the production local network. The application is hosted on a Virtual Server and through OCI and Instant Client connects to a distant Oracle schema on the same network. To avoid…
1
vote
1 answer

Python and oracle 32bit and 64bit instaclient on same machine

I have both wamp and python on a single machine. For very specific reasons PHP needs to use the 64bit version of oracles instaclient and python needs to use the 32bit version. My Path variable points to the 64bit version. This is obviously no good…
PrestonDocks
  • 4,851
  • 9
  • 47
  • 82
1
vote
0 answers

Test connection failed because of an error in initializing provider (instant client)

I am Getting this error message: Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle…
1
vote
0 answers

java.lang.NoClassDefFoundError: oracle/security/pki/OraclePKIProvider with sqlplus instantclient

I am trying to upgrade CNM (comptel) application.While installing one .jar project (Please excuse I am not from java\linux camp) i got this error: java.lang.NoClassDefFoundError: oracle/security/pki/OraclePKIProvider with sqlplus instantclient in…
user3792812
  • 155
  • 1
  • 4
  • 13
1
vote
0 answers

Broken query results with oracle instant client over occi

I am writing an occi based MFC Win32 application and wanted to deploy it with the oracle instant client in version 11.2. The whole software works fine with the full client. With the instant client, the same queries work as well - but in some cases…
Hans Huckebein
  • 147
  • 1
  • 7
1
vote
2 answers

Oracle InstantClient ODBC connection fails in DbProviderFactory when the ODBC Test Connect succeeds

Installed the InstantCLient 11.2.0.4 Basic Lite and ODBC packages Set up the ORACLE_HOME and TNS_ADMIN environment variables and added the path for the installation to the Path environment variable Created my tnsnames.ora file in that location Set…
1
vote
1 answer

Enabling both OCI8 and ldap in php 5.5.0 (Solaris 10) / How to add OCI8 dynamically

Using the following configure statement: ./configure --prefix=/home/a2r/www/PHP-5.5.0 --with-apxs2=/home/a2r/apache/bin/apxs --enable-ftp --with-curl --with-zlib --with-gd --with-ldap --with-mm --with-pgsql --with-jpeg-dir=/home/a2r/www…
Greg
  • 284
  • 6
  • 23
1
vote
1 answer

Error using DBD::Oracle with instantclient 11.2

I Want to use perl module DBD::Oracle on Mac OS X 10.8. I installed DBI through CPAN. Downloaded the Oracle instant client 11.2 (basic, sqlplus and jdk). Extracted it to /usr/local/oracle. $ ls /usr/local/oracle/instantclient_11_2/ BASIC_README …
Jonas Anseeuw
  • 3,590
  • 5
  • 22
  • 23
1
vote
0 answers

command line oci OCIEnvNlsCreate() failed

I'm getting PHP Warning: oci_connect(): OCIEnvNlsCreate() failed. when i'm trying to execute php.exe "c:\xampp\htdocs\test.php" from command line.... But if i browse it by (localhost/test || ip/test) browser it works.... Same code and instandclint…
farness
  • 369
  • 2
  • 11
0
votes
2 answers

cx_Oracle + oracle instance client 11g hang up

next code works correct with instant client 10g, but hang up when using oracle instant client 11g, hangs on pool.release(conN), import time print '---------------------------------' import cx_Oracle print…
Andrey Koltsov
  • 1,956
  • 6
  • 24
  • 43
0
votes
1 answer

how to install oracle instantclient to connect multiple remote databases from local machine/environment in windows?

Install Oracle (instantclient) sqlplus client in our local Windows machine with connect report database without login into linux server. I Tested with Oracle "instantclient_21_10" version
Rajesh
  • 562
  • 1
  • 10
  • 26
0
votes
0 answers

Error: DPI-1072: the Oracle Client library version is unsupported in nodejs

I'm trying to connect to the external oracle database using nodejs. Have installed basic package oracle instantclient_19_8 for macOS. Followed this article:…
0
votes
1 answer

Alternative connection string options for Oracle Instant Client?

We have installed "Oracle Instant Client" and using below connectionstring in our .Net application which is throwing error"oraoledb.oracle.1 provider not found" provider=OraOLEDB.Oracle;Server=databaseserver;Data Source=databasename;User…
0
votes
0 answers

Alphine Linux - Oracle Instant Client 11.2.0.4.0 canonicalize_file_name: symbol not found

I am trying to create an alphine image in which I will run .NET 7 REST API that connects Oracle Database. But I am constantly in trouble with symbols. I have researched a lot of source and i changed my Docker File like that: #Runtime Image For…
Unseen
  • 13
  • 5
0
votes
1 answer

VS2017 building app shows error LNK1181 cannot open input file 'C:\instantclient_19_3\sdk\lib\msvc\oraocci19d.lib

I am using VS 2017 for a legacy MFC app. I have Oracle 19.13.0 installed and I downloaded intantclient_19_18 SDK Package (instantclient-sdk-windows.x64-19.18.0.0.0dbru.zip from…
pixel
  • 9,653
  • 16
  • 82
  • 149