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
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…
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};…
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…
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…
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…