salut j'ai crée un projet djando pour lequel je souhaite relier a une base de donnée oracle :

voici ma configuration:
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
...
# Database
# https://docs.djangoproject.com/en/2.2/ref/settings/#databases
 
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.oracle',
        'NAME': 'XE',
        'USER': 'system',
        'PASSWORD': 'XXXXXXXX',
        'HOST': 'localhost',
        'PORT': '1521',
    }
}
...
mais j'obtient les erreur suivant en tentant de créer un utilisateur avec : python manage.py createsuperuser. il en est de meme avec la commande migrate

voici l'erreur que j'obtient:

(venv) C:\Users\ODOO\Documents\Djano\rp-portfolio\db>django-admin startapp cenou

(venv) C:\Users\ODOO\Documents\Djano\rp-portfolio\db>python manage.py createsuperuser

You have 17 unapplied migration(s). Your project may not work properly until you apply the migrations for app(s):
admin, auth, contenttypes, sessions.
Run 'python manage.py migrate' to apply them.
Traceback (most recent call last):
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\backends\utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\backends\oracle\base.py", line 510, in execute
return self.cursor.execute(query, self._param_generator(params))
cx_Oracle.DatabaseError: ORA-00942: table or view does not exist

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "manage.py", line 21, in <module>
main()
File "manage.py", line 17, in main
execute_from_command_line(sys.argv)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\core\management\__init__.py", line 381, in execute_from_command_line
utility.execute()
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\core\management\__init__.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\core\management\base.py", line 323, in run_from_argv
self.execute(*args, **cmd_options)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\contrib\auth\management\commands\createsuperuser.py", line 61, in execute
return super().execute(*args, **options)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\core\management\base.py", line 364, in execute
output = self.handle(*args, **options)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\contrib\auth\management\commands\createsuperuser.py", line 82, in handle
default_username = get_default_username()
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\contrib\auth\management\__init__.py", line 140, in get_default_username
auth_app.User._default_manager.get(username=default_username)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\models\manager.py", line 82, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\models\query.py", line 402, in get
num = len(clone)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\models\query.py", line 256, in __len__
self._fetch_all()
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\models\query.py", line 1242, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\models\query.py", line 55, in
__iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\models\sql\compiler.py", line
1100, in execute_sql
cursor.execute(sql, params)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\backends\utils.py", line 99, in execute
return super().execute(sql, params)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\backends\utils.py", line 67, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\backends\utils.py", line 76, in _execute_with_wrappers
return executor(sql, params, many, context)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\backends\utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\backends\utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "C:\Users\ODOO\Documents\Djano\rp-portfolio\venv\lib\site-packages\django\db\backends\oracle\base.py", line 510, in execute
return self.cursor.execute(query, self._param_generator(params))
django.db.utils.DatabaseError: ORA-00942: table or view does not exist

(venv) C:\Users\ODOO\Documents\Djano\rp-portfolio\db>
comment puis-je corriger ma connexion a oracle?
merci.