Configuring Oracle Extproc Listener for Native ST_Geometry SQL Queries
Enabling direct SQL manipulation of Esri ST_Geometry types in Oracle requires precise configuration of the external procedure (extproc) listener. This guide outlines the necessary steps to establish a stable connection between the Oracle database and the spatial processing libraries.
1. Storage Format and Version Compatibility
Before configurin ...
Posted on Thu, 18 Jun 2026 17:41:40 +0000 by Mzor
Deploying Oracle Database 11g Release 2 on CentOS Linux Systems
System Preparation and Kernel Tuning
Establish dedicated system accounts and directory structures before initiating the deployment. Use a privileged terminal session to execute the following group and user provisioning commands:
groupadd dbadmin_grp
groupadd dboper_grp
useradd -g dbadmin_grp -G dboper_grp -m odbsvc
passwd odbsvc
id odbsvc
Desi ...
Posted on Thu, 04 Jun 2026 16:19:30 +0000 by anikin
Working with Oracle Databases in Python Using cx_Oracle
cx_Oracle is a Python extension module that enables Python applications to interact directly with Oracle Database. It provides a comprehensive set of APIs that let developers build scripts and applications to establish database connections, run SQL queries and commands, process result sets, and manage database transactions, making interactions ...
Posted on Mon, 25 May 2026 23:05:56 +0000 by aeonsky