[Python] django.db.utils.DatabaseError: DPY-4027: no configuration directory to search for...

Discussão em 'Python' iniciado por Stack, Fevereiro 17, 2025.

  1. Stack

    Stack Membro Participativo

    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:

    # tnsnames.ora Network Configuration File: C:\app\HP\product\21c\homes\OraDB21Home1\NETWORK\ADMIN\tnsnames.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:

    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:

    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?

    Continue reading...

Compartilhe esta Página