DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones AWS Cloud
by AWS Developer Relations
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones
AWS Cloud
by AWS Developer Relations
Building Scalable Real-Time Apps with AstraDB and Vaadin
Register Now

Trending

  • Design Patterns for Microservices: Ambassador, Anti-Corruption Layer, and Backends for Frontends
  • Microservices Decoded: Unraveling the Benefits, Challenges, and Best Practices for APIs
  • Observability Architecture: Financial Payments Introduction
  • Top 10 Pillars of Zero Trust Networks

Trending

  • Design Patterns for Microservices: Ambassador, Anti-Corruption Layer, and Backends for Frontends
  • Microservices Decoded: Unraveling the Benefits, Challenges, and Best Practices for APIs
  • Observability Architecture: Financial Payments Introduction
  • Top 10 Pillars of Zero Trust Networks
  1. DZone
  2. Data Engineering
  3. Databases
  4. Configuring Zato for High-Performance Oracle Database Connections

Configuring Zato for High-Performance Oracle Database Connections

If you need to configure Zato for Oracle DB connections and you want to ensure the highest performance possible, this post goes through the process step-by-step.

Dariusz Suchojad user avatar by
Dariusz Suchojad
·
Nov. 21, 19 · Tutorial
Like (2)
Save
Tweet
Share
11.47K Views

Join the DZone community and get the full member experience.

Join For Free

Squiggly connected lights on rooftop

Oracle Database Connections

If you need to configure Zato for Oracle DB connections and you want to ensure the highest performance possible, this post goes through the process step-by-step. Read on for details.

You might also be interested in:  Reading Data From Oracle Database With Apache Spark

Overview

Note that Zato 3.1+ is required. The tasks involved are:

  • Installing Zato
  • Installing an Oracle client
  • Installing cx_Oracle
  • Greenifying the Oracle client
  • Starting servers
  • Creating database connection definitions
  • Confirming the installation

Installing Zato

  • Choose your preferred operating system and follow the general installation instructions — Oracle DB connections will work the same no matter the system Zato runs on
  • Create a Zato environment with as many servers as required. Again, there are no Oracle-specific steps at this point yet.

Installing an Oracle Client

  • Download an Oracle client and install it on all the systems with Zato servers
  • Add the client's installation path to LD_LIBRARY_PATH. For instance, if the client is installed to /opt/zato/instantclient_19_3, add the following to ~/.bashrc:
  export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/zato/instantclient_19_3


Installing cx_Oracle

  • cx_Oracle is a Python driver for Oracle DB, it can be installed using pip, as user zato, on each Linux instance that Zato servers use:
  $ cd /opt/zato/current
  $ ./code/bin/pip install cx_Oracle


Greenifying the Oracle Client

  • This step is crucial for achieving the highest performance of SQL queries
  • For each Zato server installed, open its server.conf file and find stanza [greenify]
  • If there is no such stanza in server.conf, create it yourself
  • Modify the stanza to greenify the libclntsh.so library — this is a library that the Oracle client ships with. For instance, if the client's installation path is /opt/zato/instantclient_19_3, the full path to the library is /opt/zato/instantclient_19_3/libclntsh.so
  • The stanza should read as below, assuming the installation path as above:
  [greenify]
  /opt/zato/instantclient_19_3/libclntsh.so=True


  • Note that entries in this stanza are followed by =True, which is a signal to Zato that a particular library should be processed

Starting Servers

  • Start Zato servers
  • For each, make sure that an entry such as below is saved in server logs
  INFO - Greenified library `/opt/zato/instantclient_19_3/libclntsh.so.19.1`


Creating Database Connection Definitions

  • Go to web-admin and create a new Oracle DB connection via Connections -> Outgoing -> SQL, as below:

Create a new SQL connection

  • Update the newly created connection's password by clicking Change password
  • Click Ping to confirm the connectivity to the remote server
  • This concludes the process, the connection is ready for use in Zato services now

Further Reading

Database Operations on Cassandra and Oracle Using Apache Spark

Connect Oracle SQL Developer to Amazon Redshift

Database connection Oracle Database

Opinions expressed by DZone contributors are their own.

Trending

  • Design Patterns for Microservices: Ambassador, Anti-Corruption Layer, and Backends for Frontends
  • Microservices Decoded: Unraveling the Benefits, Challenges, and Best Practices for APIs
  • Observability Architecture: Financial Payments Introduction
  • Top 10 Pillars of Zero Trust Networks

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com

Let's be friends: