The Oracle Instant Client is an easy to install client for Oracle Databases utilizing the Oracle Call Interface (OCI)
Questions tagged [instantclient]
145 questions
1
vote
1 answer
Where is the Oracle Instant Client timezone file located?
I've installed Oracle instant client Version 19.8.0.0.0 on my macOS (Big Sur version 11.5.1) using instructions from the oracle site.
I want to change the time zone settings using ORA_TZFILE file but where do I locate the oracore\zoneinfo\…

Dante
- 537
- 2
- 4
- 18
1
vote
1 answer
"libnnz19.so: cannot open shared object file: No such file or directory
I have installed cx_oracle(python3) and instant client 21_1 inside a container. When I try to first time I got this error
Cannot locate a 64-bit Oracle Client library: "/python-
env/instantclient_21_1/lib/libclntsh.so:
So I have created lib under…

Mammu yedukondalu
- 136
- 2
- 14
1
vote
1 answer
docker + oracle instant client : encoding problem
I use this image:
image: sflyr/sqlplus:latest
and this script (gitlab-ci):
script:
- |
/instantclient_11_2/sqlplus login/pwd@//myserveur.prod:1521/sid.mysid<

Tyvain
- 2,640
- 6
- 36
- 70
1
vote
2 answers
Is it possible to have a 32 bit ODBC connection on Windows 10 without a tnsnames.ora file?
I have a VBA (Excel) macro that connects to and queries an Oracle database. Running under Windows 7, the following connection string works:
Driver={Microsoft ODBC for Oracle};…

zlinedavid89
- 43
- 5
1
vote
1 answer
64-bit Oracle Client library cannot be loaded in mac
I have created a sample Python script for Oracle Database connectivity for running queries for Database testing, I have ran the same script on Windows and its running fine but while running on Mac, its showing me this exception again and…

Taimoor Pasha
- 192
- 2
- 3
- 16
1
vote
1 answer
What is the Instant Client MACOSX default username/password
I have installed SQL Plus and Instantclient on MacOSX and I have been trying to connect to the server using the given client, however, all the default password combinations I am trying aren't working. If someone uses it, can you please share the…

Akash Purandare
- 65
- 1
- 9
1
vote
2 answers
macOS High Sierra: find Oracle Instant client installation and its version
How can I find Oracle Instant Client installation on macOS High Sierra and check its version ?
All the search gave nothing.
Nevertheless, when I run sqlplus in the Terminal, it displays the following:
SQL*Plus: Release 12.1.0.2.0 Production on Wed…

belgoros
- 3,590
- 7
- 38
- 76
1
vote
1 answer
cx_Oracle.DatabaseError: ORA-12541: TNS:no listener
I want to learn how to work with an Oracle Database using Python. If I understand correctly, you can use Oracle Instant Client to connect to an Oracle Database remotely, but I cannot connect. I suspect the issue is that I don't know what arguments…

Digispec
- 11
- 1
- 4
1
vote
0 answers
fatal error: oci.h: No such file or directory
go version go1.8.1 windows/amd64
when I tried go get for oracle library
go get -v gopkg.in/rana/ora.v4
output:
**gopkg.in/rana/ora.v4
# gopkg.in/rana/ora.v4
F:\CODING\src\gopkg.in\rana\ora.v4\bndBfile.go:9:10: fatal error: oci.h: No such file or…

user8499218
- 73
- 1
- 8
1
vote
0 answers
Oracle Instant Client v12 - how to use without installation with asp.net?
Currently we have Oracle Client installed on our server VMs but we'd like to use Oracle Instant Client on Azure Service Fabric (without installation). I managed to get it work with version 11 but with v12 I'm still getting below error (far from…

kopieczek.dev
- 706
- 8
- 26
1
vote
1 answer
Cant connect PHP(XAMPP) to Oracle using OCI8
Thanks for all the help in advance. I cannot connect my PHP to ORACLE using OCI8. The specs of softwares that i use are
Windows 10 Version: Home 64-bit
XAMPP Version: 5.6.24
PHP Version - 5.6.24
PHP Script framework - ZEnd Framework
ORACLE - XE…

Unni
- 41
- 2
1
vote
1 answer
Accessing Oracle Wallet using Oracle sqlplus Instant client
I've configured Oracle wallet successfully in my Linux server(Linux 2.6.32-642.4.2.el6.x86_64 GNU/Linux).
When I try to execute the below command using Database connection string, it works perfect.
$/sqlplus /@TESTDB
SQL*Plus: Release 11.2.0.3.0…

Vinoth Karthick
- 905
- 9
- 27
1
vote
0 answers
Oracle Instant client in visual studio setup project
I have a Visual Studio solution with mixed C# / C++ projects in it.
The created software is using ODBC connection to Oracle DB.
I need to create a new Setup Project inside this solution which will work as single click setup kit.
The easiest I found…

Monya
- 29
- 3
1
vote
1 answer
Oracle client in not installed or it cannot be loaded. OCIDLL cannot be loaded
How it is possible that after installing Oracle11g Express and instantclient_12_1 that EMS SQL Manager for Oracle cannot load relevant library:
Oracle client in not installed or it cannot be loaded. OCIDLL cannot be loaded.
Solved:
Switching to…

J.Olufsen
- 13,415
- 44
- 120
- 185
1
vote
1 answer
Ubuntu 16.04 LTS and Oracle Instant Client - C++ linking error
I'm not sure if the problem is more suitable for StackOverflow or AskUbuntu, but I will ask.
I have two virtual machines. On one Ubuntu 14.04 LTS and the other Ubuntu 16.04 LST. On both installed Oracle Instant Client 12.1 in the following…

ArkadiuszG
- 21
- 5