And why you get the error is that Oracle 12 does have new identity column
(generates primary keys without explicit trigger) which was taken into use
in Django. Oracle 11g doesn't have it and thus you get pretty strange
errors when you try to create tables that don't have valid 11g SQL syntax.
On Sun, Apr 28, 2019 at 12:59 PM Jani Tiainen <rede...@gmail.com> wrote:
> Hi.
>
> Django 2.2 supports Oracle 12.1+. Oracle 11g support was dropped with
> Django 2.0. If you want to use Oracle 11g (which is out of support anyway
> from Oracle) you either need to downgrade to Django 1.11 and cx_Oracle 6.4.1
>
> I really suggest you to update at least latest Oracle 12.2 which is still
> supported by Oracle.
>
> la 27. huhtik. 2019 klo 22.56 tossouwisdom <tossouwis...@gmail.com>
> kirjoitti:
>
>> Django 2.2.2
>> Cx_oracle 7.2
>> base Oracle 11g
>>
>> When I run the django migrate commande, i have error
>> django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the
>> django_migrations table (ORA-00907: missing right parenthesis)
>>
>> Operations to perform:
>> Apply all migrations: admin, auth, contenttypes, sessions
>> Running migrations:
>> Traceback (most recent call last):
>> File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line
>> 82, in _execute
>> return self.cursor.execute(sql)
>> File "C:\Python37-32\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-00907: missing right parenthesis
>>
>> The above exception was the direct cause of the following exception:
>>
>> Traceback (most recent call last):
>> File "C:\Python37-32\lib\site-packages\django\db\migrations\recorder.py",
>> line 67, in ensure_schema
>> editor.create_model(self.Migration)
>> File "C:\Python37-32\lib\site-packages\django\db\backends\base\schema.py",
>> line 307, in create_model
>> self.execute(sql, params or None)
>> File "C:\Python37-32\lib\site-packages\django\db\backends\base\schema.py",
>> line 137, in execute
>> cursor.execute(sql, params)
>> File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line
>> 99, in execute
>> return super().execute(sql, params)
>> File "C:\Python37-32\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:\Python37-32\lib\site-packages\django\db\backends\utils.py", line
>> 76, in _execute_with_wrappers
>> return executor(sql, params, many, context)
>> File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line
>> 84, in _execute
>> return self.cursor.execute(sql, params)
>> File "C:\Python37-32\lib\site-packages\django\db\utils.py", line 89, in
>> __exit__
>> raise dj_exc_value.with_traceback(traceback) from exc_value
>> File "C:\Python37-32\lib\site-packages\django\db\backends\utils.py", line
>> 82, in _execute
>> return self.cursor.execute(sql)
>> File "C:\Python37-32\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-00907: missing right parenthesis
>>
>> During handling of the above exception, another exception occurred:
>>
>> 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:\Python37-32\lib\site-packages\django\core\management\__init__.py", line
>> 381, in execute_from_command_line
>> utility.execute()
>> File
>> "C:\Python37-32\lib\site-packages\django\core\management\__init__.py", line
>> 375, in execute
>> self.fetch_command(subcommand).run_from_argv(self.argv)
>> File "C:\Python37-32\lib\site-packages\django\core\management\base.py",
>> line 323, in run_from_argv
>> self.execute(*args, **cmd_options)
>> File "C:\Python37-32\lib\site-packages\django\core\management\base.py",
>> line 364, in execute
>> output = self.handle(*args, **options)
>> File "C:\Python37-32\lib\site-packages\django\core\management\base.py",
>> line 83, in wrapped
>> res = handle_func(*args, **kwargs)
>> File
>> "C:\Python37-32\lib\site-packages\django\core\management\commands\migrate.py",
>> line 234, in handle
>> fake_initial=fake_initial,
>> File "C:\Python37-32\lib\site-packages\django\db\migrations\executor.py",
>> line 91, in migrate
>> self.recorder.ensure_schema()
>> File "C:\Python37-32\lib\site-packages\django\db\migrations\recorder.py",
>> line 69, in ensure_schema
>> raise MigrationSchemaMissing("Unable to create the django_migrations
>> table (%s)" % exc)
>> django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the
>> django_migrations table (ORA-00907: missing right parenthesis)
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to django-users+unsubscr...@googlegroups.com.
>> To post to this group, send email to django-users@googlegroups.com.
>> Visit this group at https://groups.google.com/group/django-users.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/dac2cda6-2543-4664-aea5-025473ecc3e5%40googlegroups.com
>> <https://groups.google.com/d/msgid/django-users/dac2cda6-2543-4664-aea5-025473ecc3e5%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
--
Jani Tiainen
Software wizard
https://blog.jani.tiainen.cc/
Always open for short term jobs or contracts to work with Django.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAHn91odqLWmxEwRshytHMk_moDV_DjbegFHXpTezJuSQ_0%3DvPw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
