Django Oracle connection as SYS should be as SYSDBA or SYSOPER

Question

I'm trying to use Oracle Database for Django. Oracle DB is active and I can connect with SQLDeveloper. But cannot connect from Django to Oracle DB. I got this error:

django.db.utils.DatabaseError: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

I use Conntection Type = Basic, Role = SYSDBA in SQLDeveloper. Where to give this parameters in Django?

My Current setting.py parameters:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.oracle',
        'NAME': 'payman',
        'USER': 'sys',
        'PASSWORD': 'ssys',
        'HOST': '172.55.79.9',
        'PORT': '1521',
    }
}

Answer 1

You need to provide this in the 'OPTIONS' to cx_oracle. I set the following while using the full DSN mode:

'OPTIONS': {
            'purity': cx_Oracle.ATTR_PURITY_SELF,
            'mode': cx_Oracle.SYSDBA
        },