instantclient | Easy Install of Oracle Instant Client Basic and SDK | SDK library

Sqlplus automatically exits when its' input pipe (stdin) is closed. So the only option is to do not close pipe: you can write a program that starts sqlplus and feeds it's stdin and closes it only when you want.

I don't know why do you want to leave it open in non-interactive mode. For me it's much better to pipe to file and then execute it.

Don't know will it help you, but I have a couple of workarounds how to leave it open for some time: use host command. For example the following command will leave sqlplus opened for 15 seconds:

I hope my answer will help others who is looking for a solution .

I have used both dockerfile and app.yaml for deploying in App Engine .

I referred below link for OracleDB connection .It worked like a charm in local .But When I deployed to AppEngine I was not able to map the oracle instant client folder path.

So I installed the Oracle instantclient using Dockerfile.

The cx_Oracle initialization doc points out that on Linux init_oracle_client() doesn't really do what you think it does. You must still set the system library search path to include the Oracle libraries before the Python process starts.

Do I understand correctly that the machine with Python has both the DB installed and Instant Client??

If you do want Python to use the Instant Client libraries, then set LD_LIBRARY_PATH to its location and do not set ORACLE_HOME.

If you have a full Oracle DB installation on the machine with Python, then you can delete Instant Client. You need to set ORACLE_HOME, LD_LIBRARY_PATH and whatever else is needed before starting Python - in general run source /usr/local/bin/oraenv. This should set the system library search path to include /apps/oracle/product/19.3.0/lib . A code snippet like this (untested) one may help: export ORACLE_SID=ORCLCDB;set ORAENV_ASK=NO; source /usr/local/bin/oraenv. Make sure the Python process has read access to the ORACLE_HOME directory.

The cx_Oracle installation guide discusses all this.

Looks like you have to specify the container you're connecting to. For example:

Too long for a comment, and you have a few scenarios, so here are some thoughts.

• Use Oracle's container which already has cx_Oracle? Look for the *-oracledb container on https://github.com/oracle/docker-images/pkgs/container/oraclelinux7-python

• Never set ORACLE_HOME with Instant Client.

• What are those OCI_HOME, OCI_LIB_DIR and OCI_INCLUDE_DIR variables for? They are not used by cx_Oracle install or runtime.

• With RPMs on Ubuntu I do:

All you need is Oracle Instant Client.

If your Instant Client installation is not in one of the standard paths from the RPM distributions, just set the environment variable ORACLE_HOME to the Instant Client directory (the directory that contains sdk/include), then make should succeed.

The issue comes from the fact that you're changing your base image from Alpine based to Debian based.

Debian based Linux distributions use apt as their package manager (Alpine uses apk).

That is the reason why you get apk not found. Use apt install, but also keep in mind that the package names could differ and you might need to look that up. After all, apt is a different piece of software with it's own capabilities.

Installed Instantclient-basic-windows.x64-19.3.0.0 (downloaded a year ago), changed php version from 8 to 7.4, and it worked. It took several days of a dull bulkhead of all the available options, until I found a surviving old client of Orakl. Nobody advised anything sensible on the Internet. I have been doing web development quite recently, can someone tell me how this problem should have been solved correctly? (and not fully resolved, it still does not work with the eight)

Oracle 9.0.1 is old. Like "gosh, look how many floppies this comes on" old. And it was a release that was pretty quickly desupported in favor of Oracle 9.2.

If you look at the Client/ Server Interoperability Matrix (Metalink account required), you have to go down to the extended matrix because the summary matrix doesn't even include 9.0.1 any longer. There, you'll see that the last version of the Oracle client that was compatible with a 9.0.1 database was 10.1.0. I'm pretty sure that predates the Oracle Instant Client so you'd probably need to install the full 10.1 client. You'll probably need to put in a support request to get access to versions of the client that old-- Oracle generally doesn't bother to make links to something that old available.

Assuming you do get a version of the client that is sufficiently ancient, it was certainly not certified on the version of Ubuntu or PHP you're using. It might install and work just fine. You might need to go with earlier versions of both.

I would strongly suggest going back to whatever lead to these requirements to make really, really sure that they understand the costs of supporting 20 year old software. If someone told you to build a new web site and to make sure that it was compatible with Firefox 2 (released in 2006), you'd point out that there would be pretty significant costs to trying to support a 15 year old browser doing so for very little gain-- there aren't a lot of Firefox 2 browsers left in the world. Oracle 9.0.1 is 5 years older than that and there are very, very few folks still running that version left in the world.