Django4.1链接Oracle 19c

Django4.1链接Oracle19c

环境

• Mac m1
• Pycahrm 2023
• Pyhon 3.9

配置

强烈推荐django文档https://docs.djangoproject.com/zh-hans/4.1/ref/databases/#oracle-notes
cx-Oracle库文档地址https://cx-oracle.readthedocs.io/en/latest/

# projectname/projectname/setting.py
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.oracle',
        'NAME': '10.44.96.60:1522/ORCLPDB',
        'USER': 'FASPSX2023',
        'PASSWORD': 'ksydgc',
		'OPTIONS': {
	        'threaded': True,
	        'use_returning_into': False
    	}
    }
}

配置数据库安装驱动

下载安装安装instant-client
https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html

修改内容

# venv/lib/python3.8/site-packages/django/db/backends/oracle/base.py
try:
    import cx_Oracle as Database

    lib_dir = "/Users/haige/Download/instantclient_19_8"
    Database.init_oracle_client(lib_dir=lib_dir)
except ImportError as e:
    raise ImproperlyConfigured("Error loading cx_Oracle module: %s" % e)