The Oracle Instant Client is an easy to install client for Oracle Databases utilizing the Oracle Call Interface (OCI)
Questions tagged [instantclient]
145 questions
0
votes
0 answers
XAMPP OCI will not enable despite all options
To mimic my university's set up on my personal PC, I am using oracle 12c Database, XAMPP 7.1.12. and Instantclient 12.2.
my database 12c is confirmed working (can use SQLPlus to create db etc). My XAMPP server is reachable when running and phpinfo…
Xray25
- 115
- 13
0
votes
0 answers
Crystal Reports 2020 Oracle Instantclient 21.9 and crdb_oracle.dll not found
I'm getting the classic error:
The database connector: 'crdb_oracle.dll' could not be loaded. The correct version of the database client for this database type might not be installed.
I know I've installed the 64 bit Oracle ODBC (Instant client…
Rob Clarke
- 167
- 1
- 1
- 7
0
votes
1 answer
Is it possible to install both 32 and 64-bit Oracle Instant Client for cx_Oracle?
I have been using 32 bit Python 3.6 and connecting to an oracle database by using the 32 bit oracle instant client.
My current project requires me to use a 64 bit python 3.8 as I need to use different libraries. This means using oracle instant…
Chowder
- 96
- 1
- 7
0
votes
0 answers
SQLLDR in instantclient_21_9 cannot run
I'm a Window user and I have a problem with Oracle SQLLDR.
Whenever I run SQLLDR in CMD, it shows Errors: The code execution cannot proceed because xxx.dll was not found. It pops up several times for some xxx.dll files missing.
I have both…
Viet Anh Nguyen
- 13
- 4
0
votes
0 answers
How to connect to an Oracle database installed on a Windows 11 virtual machine (Parallels) using a computer with Apple Silicon (M1)?
Since Oracle Database cannot be installed on Apple Silicon, I decided to take a workaround, but now I do not understand how to connect to the Oracle Database, which I installed on a Windows 11 virtual machine through Parallels.
I understand that…
Malkhaz
- 1
- 1
0
votes
0 answers
Oracle in Instantclient_21_7 crashing upon test connection
I am having trouble setting up Oracle in Instantclient_21_7. I tried to add it as a user dsn and test connection, upon clicking test connection, it just crash, no error message or whatsoever. i enabled logging and it always shows as below.
odbcad32 …
user20009791
- 9
- 1
0
votes
1 answer
Extract data from Oracle Database with Pandas without Oracle Instant Client
I'm trying to connect to an Oracle Database using pandas + sqlalchemy using this code:
from sqlalchemy.engine import create_engine
import pandas as pd
DIALECT = 'oracle'
SQL_DRIVER = 'cx_oracle'
USERNAME = 'USER'
PASSWORD = 'PASS'
HOST =…
Rafa.Rugamas
- 87
- 1
- 3
- 9
0
votes
0 answers
Oracle instantclient connection on a linux server
I am new at deployments and dockerfiles. I am having issues connecting to the oracledb in nodejs. I used the prebuilt instantclient image from docker and setting the LD_LIBRARY_PATH to the lib folder with all the files. Here's the dockerfile:
FROM…
Nick Ghuman
- 36
- 4
0
votes
2 answers
How to identify Oracle Instant Client in a Django project?
I try to link an external Oracle database on which I have read-only privileges to my Django project and then only send it raw SQL queries.
So I first created a second table in my project settings (because I still need the default…
lewis32
- 35
- 1
- 6
0
votes
1 answer
Provide run time environment variable path (e.g. LD_LIBRARY_PATH) to third party dependency in bazel
In the code base I am working with we use the oracle instant client library as a third party dependency in Bazel as follows:
cc_library(
name = "instant_client_basiclite",
srcs = glob(["*.so*"]),
visibility =…
user2672165
- 2,986
- 19
- 27
0
votes
0 answers
How to deploy Node.js application with Oracle Instant client on Pivotal Cloud Foundry
I want to deploy my Node.js application to a Linux box with least possible manual command runs. I want to deploy it to Pivotal Cloud Foundry (PCF).
My application needs to connect to Oracle DB for which I am using node-oracledb and Oracle instant…
Namrata Kumari
- 158
- 1
- 13
0
votes
1 answer
Unable to connect Oracle DB through Nodejs API deployed in Google App Engine
Can anyone help me to connect oracle DB through Nodejs api deployed in Google App Engine .
I referred this link to connect to DB .But it is not working.
Same code worked fine in local, where I refer oracle instant client from a local folder.
Below…
Janaki Narayanan
- 523
- 6
- 24
0
votes
1 answer
Oracle Instant Client failing on Ubuntu-based agent despite correct TNS_ADMIN path
I am attempting to perform an SQL query using oracle-instantclient-basic-21.5 through an Ubuntu 20.04.3 agent hosted by Azure Devops. The query itself (which reads: python query_data) works when I am running it on my own machine with specs:
Windows…
0
votes
0 answers
SQL*Plus screen size causes column heading alignment issue
When the SQL*Plus column headings line exceeds the PowerShell screen buffer size (in this case) by 4 or more, the window wraps the column heading line with the incorrect number of spaces.
This causes the column heading to not align with the…
Alex Bartsmon
- 471
- 4
- 9
0
votes
1 answer
MacOS Python Oracle TCPS connection with Oracle instant client - ORA-29024: Certificate validation failure
I am attempting to connect to an Oracle Database using Python cx_Oracle package and Oracle instantclient_19_8. I keep getting this error - OORA-29024: Certificate validation failure.
I downloaded and installed Oracle InstantClient_19_8.
Within the…
acvbasql
- 109
- 1
- 2
- 15