Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • chk_space_SID.ksh Linux/Unix
  • Find_planinfo.sql Oracle
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • Export Oracle data and Compress at same time Oracle
  • V$INSTANCE of Oracle in MYSQL MYSQL
  • Insert cause enqueue locks Oracle
  • Sending SQLPLUS output in HTML format Oracle
  • Wait.sql Oracle
  • oracle_env_10g_CADEV Linux/Unix
  • DBMS_UTILITY PACKAGE Oracle
  • Jai Shree Ram Oracle
  • Locktree.sql Oracle
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • Goldengate document from Porus Oracle
  • Vivek Tuning for Row Locks. Oracle

How to connect to Oracle Database with Wallet with Python.

Posted on 21-Mar-2025 By Admin No Comments on How to connect to Oracle Database with Wallet with Python.

To connect Python to Oracle Database using an Oracle Wallet, you can use the cx_Oracle or oracledb library with Oracle Client libraries (like Oracle Instant Client). Oracle Wallet simplifies secure connections by storing credentials and SSL certificates.


βœ… Steps to Connect Python to Oracle using Oracle Wallet


Step 1: Install Required Python Package

pip install oracledb
  • Prefer oracledb (official Oracle-supported replacement for cx_Oracle).
  • Compatible with Oracle Wallet and works in both thin and thick modes.

Step 2: Install Oracle Instant Client

  • Download from Oracle Instant Client Downloads
  • Extract it to a known location (e.g., C:\oracle\instantclient_19_11 or /opt/oracle/instantclient_19_11)
  • Add the path to your system environment:

Linux/macOS:

export LD_LIBRARY_PATH=/path/to/instantclient:$LD_LIBRARY_PATH

Windows (Command Prompt):

set PATH=C:\oracle\instantclient_19_11;%PATH%

Step 3: Create or Use an Oracle Wallet

  • Oracle Wallet typically resides under:
    network/admin folder inside the Oracle Client path.
  • Your folder should contain:
    • sqlnet.ora
    • tnsnames.ora
    • cwallet.sso

Example sqlnet.ora:

WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /path/to/wallet)))
SQLNET.WALLET_OVERRIDE = TRUE
SSL_SERVER_DN_MATCH = yes

Example tnsnames.ora:

MYDB_ALIAS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCPS)(HOST = your_host)(PORT = 2484))
    (CONNECT_DATA = (SERVICE_NAME = your_service))
    (SECURITY = (SSL_SERVER_CERT_DN = "CN=your_cert"))
  )

Step 4: Python Code to Connect

import oracledb

# Optional: Switch to thick mode to use Oracle Wallet
oracledb.init_oracle_client(lib_dir="/path/to/instantclient")

# Use tns alias defined in tnsnames.ora
conn = oracledb.connect(dsn="MYDB_ALIAS")

# Use the connection
cursor = conn.cursor()
cursor.execute("SELECT * FROM dual")
for row in cursor:
    print(row)

cursor.close()
conn.close()

βœ… If the wallet contains credentials, you don’t need to provide user and password.


πŸ§ͺ Quick Checklist

ItemRequiredExample
Oracle Instant Clientβœ…instantclient_19_11
Oracle Wallet filesβœ…cwallet.sso, sqlnet.ora, etc.
tnsnames.ora entryβœ…MYDB_ALIAS = ...
Python library (oracledb)βœ…pip install oracledb
init_oracle_client()βœ…For thick mode

Would you like help writing a sample sqlnet.ora and tnsnames.ora for your setup? Or are you facing a specific error?

Oracle, Python/PySpark

Post navigation

Previous Post: JSON/XML Types in Oracle
Next Post: SQL Tracker by SID sqltrackerbysid.sql

Related Posts

  • JSON/XML Types in Oracle Oracle
  • Oracle 11g Environment Setup Oracle
  • V$ROLLSTAT status is Full Oracle
  • Explain Plan Output 2 Oracle
  • USE_NL and INDEX hints example Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • Absolute file number and relative file number Oracle
  • send attachment from unix-shell script Linux/Unix
  • All About oracle password and security from metalink Oracle
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • How to start CRS manually Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme