# aWX support Oracle Database with the existing code

**URL:** <https://forum.ansible.com/t/awx-support-oracle-database-with-the-existing-code/30511>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [June 7, 2019, 7:52am UTC](https://forum.ansible.com/t/awx-support-oracle-database-with-the-existing-code/30511 "2019-06-07T07:52:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ragesh\_R\_pillai](https://avatars.discourse-cdn.com/v4/letter/r/ecccb3/32.png) [@Ragesh\_R\_pillai](https://forum.ansible.com/u/Ragesh_R_pillai)\
**Post date:** [June 7, 2019, 7:52am UTC](https://forum.ansible.com/t/awx-support-oracle-database-with-the-existing-code/30511/1 "2019-06-07T07:52:03Z")

</div>

I know awx application itsself work only in postgres environment.

I need to complete the oracle integration part as a part of my development activity.

Can some one please help me on this?  
Steps followed

Trying to migrate from Postgres database to Oracle database with the existing code. we replaced the variables and the connections from postgres sql to Oracle in Dockerfile.j2 under templates and in settings.py. I found  
there is a very notable amount of Postgres-specific ORM code in awx, as well as usage of postgres-specific features (such as advisory locks) that simply won’t work with oracle due to implementation discrepancies between the two

What all the other files we need to change to make it work with oracle

Synchronizing apps without migrations

File “/usr/bin/awx-manage”, line 11, in   
load\_entry\_point(‘awx==4.0.0’, ‘console\_scripts’, ‘awx-manage’)()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/ **init**.py”, line 140, in manage  
execute\_from\_command\_line(sys.argv)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/ **init**.py”, line 364, in execute\_from\_command\_line  
utility.execute()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/ **init**.py”, line 356, in execute  
self.fetch\_command(subcommand).run\_from\_argv(self.argv)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 283, in run\_from\_argv  
self.execute(\*args, \*\*cmd\_options)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 330, in execute  
output = self.handle(\*args, \*\*options)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/management/commands/run\_dispatcher.py”, line 121, in handle  
reaper.reap()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/dispatch/reaper.py”, line 36, in reap  
me = instance or [Instance.objects.me](http://Instance.objects.me)()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/managers.py”, line 114, in me  
if node.exists():  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 673, in exists  
return self.query.has\_results(using=self.db)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/query.py”, line 517, in has\_results  
return compiler.has\_results()  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 858, in has\_results  
return bool(self.execute\_sql(SINGLE))  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 899, in execute\_sql  
raise original\_exception  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 889, in execute\_sql  
cursor.execute(sql, params)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/utils.py”, line 64, in execute  
return self.cursor.execute(sql, params)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py”, line 94, in **exit**  
six.reraise(dj\_exc\_type, dj\_exc\_value, traceback)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/utils/six.py”, line 685, in reraise  
raise value.with\_traceback(tb)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/utils.py”, line 64, in execute  
return self.cursor.execute(sql, params)  
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/oracle/base.py”, line 497, in execute  
return self.cursor.execute(query, self.\_param\_generator(params))  
django.db.utils.DatabaseError: ORA-00942: table or view does not exist  
2019-06-07 06:47:54,072 INFO exited: dispatcher (exit status 1; not expected)  
2019-06-07 06:47:55,075 INFO spawned: ‘dispatcher’ with pid 244  
Can some one please help me on this?