search

oracle / python-oracledb

Python driver for Oracle Database conforming to the Python DB API 2.0 specification. This is the renamed, new major release of cx_Oracle
https://oracle.github.io/python-oracledb
Other
307 stars 59 forks source link

ORA-01882: timezone region not found #280

Closed guxsun closed 2 months ago

guxsun commented 5 months ago

File "src\oracledb\impl/thin/connection.pyx", line 365, in oracledb.thin_impl.ThinConnImpl._connect_with_address File "src\oracledb\impl/thin/protocol.pyx", line 304, in oracledb.thin_impl.Protocol._connect_phase_two File "src\oracledb\impl/thin/protocol.pyx", line 415, in oracledb.thin_impl.Protocol._process_message oracledb.exceptions.OperationalError: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Help: https://docs.oracle.com/error-help/db/ora-00604/

please helpe me to slove with python3.12 to access oracle

anthony-tuininga commented 4 months ago

It would help if you answered the questions in the template! What version of Python, what version of python-oracledb, what version of the database, what platform, etc.

Nevertheless, I think I know the source of your issue: you have the environment variable ORA_SDTZ set to a value that the database does not recognize. Either clear this variable or set it to a value that the database recognizes!

cjbj commented 2 months ago

Closing - no activity.