-   Notifications  You must be signed in to change notification settings 
- Fork 363
Description
I tried to use oracle wallet in my python script.
 con = cx_Oracle.connect(user='',password='',dsn="ORCL")
 it works well with oracle db 11g.
 tnsnames.ora
 ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_address)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=orcl)))
For my application i need session pool with oracle wallet:
 cx_Oracle.SessionPool(dsn='ORCL', min=1, max=20, increment=1, threaded=True, externalauth=True, user='',password='')
 As a result > cx_Oracle.DatabaseError: ORA-01017: invalid username/password; logon denied
I also tried to change tnsnames.ora and add pooled.
 ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.6.92.153)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(SERVER=POOLED)))
 As a result > cx_Oracle.DatabaseError: ORA-24429: External authentication is not supported in this mode.
Is it possible to use SessionPool with oracle wallet?