Stack Overflow
Stack Overflow

Questions tagged [instantclient]

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

145 questions
37
votes
4 answers

How to install Oracle Instant Client on a Mac?

How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the file. I now have the following files under…
Ben
  • 519
  • 1
  • 7
  • 14
9
votes
3 answers

installing Oracle Instantclient on Mac OS/X without setting environment variables?

Oracle's instructions specify setting DYLD_LIBRARY_PATH. This makes my application dependent on random users' configuration and is very troublesome to set up. How can I avoid having to set any environment…
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
7
votes
3 answers

Fatal error: Call to undefined function oci_connect()

I have the next lines uncommented (in my php.ini): extension=php_oracle.dll extension=php_oci8.dll And I downloaded this file instantclient-basiclite-nt-11.2.0.2.0.zip and unzipped and put that on drive D... I am using Windows XP I set environment…
afsane
  • 1,889
  • 6
  • 25
  • 40
7
votes
4 answers

Oracle ORA-01805 on Oracle 11g database

Our Oracle 10g database was recently upgraded to 11g. The database is running on a Windows Server 2003 X64 machine. In SQL queries from a .NET application that access a table that has a TIMESTAMP (6) WITH TIME ZONE data columns, I am getting the…
Stealth Rabbi
  • 10,156
  • 22
  • 100
  • 176
7
votes
1 answer

How does one enable the OCI8 PHP extension, using the Oracle Instant Client, in Ubuntu 18.04 LTS with PHP-FPM and NGINX?

I'm using the latest PHP packages available from https://launchpad.net/~ondrej/+archive/ubuntu/php . When I build and install the OCI8 extension, everything appears to be in order, but despite enabling the extension in the PHP-FPM configuration, its…
Ben Johnson
  • 2,507
  • 3
  • 29
  • 29
5
votes
3 answers

Oracle: what is the "instantclient" connection string format?

and how does it differ from the regular connection string?
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
5
votes
6 answers

installing Oracle Instantclient on Linux without setting environment variables?

Oracle's instructions specify setting LD_LIBRARY_PATH. This makes my application dependent on random users' configuration and is very troublesome to set up. How can I avoid having to set any environment variables? related note for OS/X: installing…
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
5
votes
3 answers

ORA-12705: Cannot access NLS data files or invalid environment specified

I just installed the Oracle instant client on my laptop, and get this when I try to connect via ODBC in C#. The machine has had 9.2 and 10.2 installed in the past. Why does this error appear? In my connection string, can I tell it to ignore the…
Daniel Williams
  • 8,912
  • 15
  • 68
  • 107
5
votes
4 answers

Unable to connect SQLState=08004 [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified in ms odbc administrator

I want to add two service names in one tnsnames.ora file and getting error in below 2 image in "Microsoft ODBC Driver Configuration".
sandhiya
  • 133
  • 2
  • 3
  • 17
5
votes
4 answers

How to install oracle instantclient and pdo_oci on ubuntu machine?

I need to install PDO_OCI in ubuntu machine, there is no default package that I could install with apt-get. There are a lot of tutorials showing how to do it, but when I follow them, I have problems related to compilation (configure, make,...) Here…
skonsoft
  • 1,786
  • 5
  • 22
  • 43
4
votes
0 answers

Installing oci8 driver: (pecl install oci8) Oracle Instant Client SDK header files not found (Mac OSX High Sierra)

I need to install the oci8 driver for MacOSX (High Sierra). However, whenever I run the command pecl install oci8, I get asked. Please provide the path to the ORACLE_HOME directory. Use 'instantclient,/path/to/instant/client/lib' if you're…
user11150354
4
votes
0 answers

Connecting to Oracle RDS from Lambda Function in AWS

I am trying to connect to my Oracle engine based RDS from lambda function and perform simple select queries.I have done the following: Downloaded instantclient-sdk-linux.x64-18.3.0.0.0dbru.zip and…
Ausaf
  • 143
  • 1
  • 8
4
votes
3 answers

How to download and setup sqlplus for running sql commands?

I am sorry, for bugging you all with a very silly question probably, but I just started learning data base management system, and today I attempted my first sql class where I had to login by providing my login details and learned some introductory…
Demietra95
  • 246
  • 1
  • 2
  • 10
4
votes
1 answer

Excel VBA connect to remote Oracle DB with InstantClient

I am trying to use Excel (mainly 2003, for more user compatibility) to connect to a remote Oracle DB. I would like to run a .sql script and return the dataset to a worksheet. I am on a Windows 7 64bit machine. I do not know the specs of the Oracle…
agent provocateur
  • 824
  • 3
  • 19
  • 39
4
votes
3 answers

Oracle instant client with C# windows forms application

I have been looking for this for long time , I have developed Windows Forms App using C # that have to connect Oracle database, this app will be used on many PCs using windows XP and windows 7 After long research i have found that i need to use…
Ahmed Gaber
  • 707
  • 1
  • 10
  • 27
1
2 3
…
9 10