Preparing the database
At this point, you should have an Oracle Database running on a server or inside a Docker container. We can proceed by making sure the Tuxedo application can access the database. To be able to connect to a remote Oracle Database, we have to install the following Oracle Database client libraries:
sudo yum -y install oracle-instantclient19.9-basic sudo yum -y install oracle-instantclient19.9-devel sudo yum -y install oracle-instantclient19.9-sqlplus
Once the libraries have been successfully installed, we can install the cx_Oracle
library for accessing the database from Python as follows:
sudo pip3 install cx_oracle
We have everything ready for writing the code now but we need to do some preparations inside the database as well. If you already have a database user you want to use for the application, skip all commands until step 3. Otherwise, let's create a new database user as follows:
- We need a regular database user for our application...