Oracle Database 21c Easy Connect Plus

“Configurable Database Connection Syntax for applications using Oracle Database”

Our technical brief on using the Easy Connect Plus syntax has been updated.

Connecting to Oracle Database typically requires some credentials and a connection string. The“Easy Connect” connection string syntax when using Oracle client libraries 19c or later (and connecting to Oracle Database 11.2 or later) has been significantly enhanced. This improvement further avoids the need for external configuration files.

Easy Connect Plus can be used in JDBC, C-based Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), and .NET applications. It is also usable in applications and drivers built on OCI, such as the Oracle Database drivers for Python, Node.js, PHP, Ruby, and Go.

Connection strings in Oracle applications are typically one of:

• An Easy Connect string like myhost:1521/myservicename
• A Connect Descriptor string like (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myservicename)))
• A Net Service Name from a local tnsnames.ora file or external naming service that maps to a connect descriptor

The Easy Connect syntax is now richer. You can do fun things like:

tcps://myhost:1521/myservicename?wallet_location=/opt/oracle&https_proxy=www-proxy.mycompany.com&https_proxy_port=80

The Easy Connect syntax makes application deployment easier by removing the need for external tnsnames.ora and sqlnet.ora configuration files in more common cases.

Check out the Oracle Database 21c Easy Connect Plus technical brief for details.