I am trying to connect my django application with an oracle database in vain.
I added the TNS_ADMIN environment variable but the problem persists.
Here is the content of my tnsnames.ora file:
<code># tnsnames.ora Network Configuration File: C:appHPproduct21chomesOraDB21Home1NETWORKADMINtnsnames.ora
# Generated by Oracle configuration tools.
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
</code>
<code># tnsnames.ora Network Configuration File: C:appHPproduct21chomesOraDB21Home1NETWORKADMINtnsnames.ora
# Generated by Oracle configuration tools.
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
</code>
# tnsnames.ora Network Configuration File: C:appHPproduct21chomesOraDB21Home1NETWORKADMINtnsnames.ora
# Generated by Oracle configuration tools.
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
It should be noted that I use SQL developer.
My database configuration in django:
<code>DATABASES = {
'default': {
'ENGINE': 'django.db.backends.oracle',
'NAME': os.environ.get("DB_NAME"),
'USER': os.environ.get("DB_USER"),
'HOST': os.environ.get("DB_HOST"),
'POSRT': os.environ.get("DB_PORT"),
'PASSWORD': os.environ.get("DB_PASS")
}
}
</code>
<code>DATABASES = {
'default': {
'ENGINE': 'django.db.backends.oracle',
'NAME': os.environ.get("DB_NAME"),
'USER': os.environ.get("DB_USER"),
'HOST': os.environ.get("DB_HOST"),
'POSRT': os.environ.get("DB_PORT"),
'PASSWORD': os.environ.get("DB_PASS")
}
}
</code>
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.oracle',
'NAME': os.environ.get("DB_NAME"),
'USER': os.environ.get("DB_USER"),
'HOST': os.environ.get("DB_HOST"),
'POSRT': os.environ.get("DB_PORT"),
'PASSWORD': os.environ.get("DB_PASS")
}
}
docker-compose.yml file:
<code>version: '3'
services:
backend:
container_name: bdr-backend
build:
context: .
command: >
sh -c "python manage.py makemigrations --noinput &&
python manage.py migrate --noinput &&
python manage.py runserver 0.0.0.0:8000"
ports:
- 8000:8000
volumes:
- ./backend:/backend
env_file:
- .env
environment:
- DEBUG=1
- DB_HOST=${DB_HOST}
- DB_NAME=${DB_NAME}
- DB_USER=${DB_USER}
- DB_PASS=${DB_PASS}
depends_on:
- redis
redis:
image: redis:7.0.5-alpine
container_name: redis2
expose:
- 6379
</code>
<code>version: '3'
services:
backend:
container_name: bdr-backend
build:
context: .
command: >
sh -c "python manage.py makemigrations --noinput &&
python manage.py migrate --noinput &&
python manage.py runserver 0.0.0.0:8000"
ports:
- 8000:8000
volumes:
- ./backend:/backend
env_file:
- .env
environment:
- DEBUG=1
- DB_HOST=${DB_HOST}
- DB_NAME=${DB_NAME}
- DB_USER=${DB_USER}
- DB_PASS=${DB_PASS}
depends_on:
- redis
redis:
image: redis:7.0.5-alpine
container_name: redis2
expose:
- 6379
</code>
version: '3'
services:
backend:
container_name: bdr-backend
build:
context: .
command: >
sh -c "python manage.py makemigrations --noinput &&
python manage.py migrate --noinput &&
python manage.py runserver 0.0.0.0:8000"
ports:
- 8000:8000
volumes:
- ./backend:/backend
env_file:
- .env
environment:
- DEBUG=1
- DB_HOST=${DB_HOST}
- DB_NAME=${DB_NAME}
- DB_USER=${DB_USER}
- DB_PASS=${DB_PASS}
depends_on:
- redis
redis:
image: redis:7.0.5-alpine
container_name: redis2
expose:
- 6379
I use docker docker desktop on windows 10.
How to solve this problem?