Skip to content

cx_Oracle 6.1. Using oracle wallet with SessionPool  #134

@mill9r

Description

@mill9r

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions