Symfony4连接Oracle数据库报错：Undefined index: dbname

I’ve run into this exact issue before with Symfony 4 and Oracle, so let’s break down how to fix it. The error pops up because Doctrine’s Oracle driver isn’t correctly parsing the service name from your DATABASE_URL format. Here are the solutions that worked for me:

1. Adjust the DATABASE_URL Format #

The standard oci8 URL structure you’re using might not play nice with Doctrine’s parser. Try modifying it to include a double slash before the host:

DATABASE_URL=oci8://user:pwd@//xxx.xxx.xxx.xxx:1521/something

That double slash helps the driver distinguish the host/port section from the service name, which should populate the missing dbname index it’s looking for.

Alternatively, if you have a valid alias set up in your tnsnames.ora file (like ORCL), you can simplify the URL entirely:

DATABASE_URL=oci8://user:pwd@ORCL

Just make sure PHP can find your tnsnames.ora—you might need to set the TNS_ADMIN environment variable in your php.ini or server config to point to the directory containing the file.

2. Bypass URL Parsing with Manual Doctrine Configuration #

If adjusting the URL doesn’t work, skip the DATABASE_URL altogether and configure Doctrine directly in config/packages/doctrine.yaml. This avoids any URL parsing headaches:

doctrine:
    dbal:
        driver: oci8
        host: xxx.xxx.xxx.xxx
        port: 1521
        user: your_username
        password: your_password
        service: something # This maps to your SERVICE_NAME from tnsnames.ora
        # Use `sid: something` instead if you're connecting via SID instead of SERVICE_NAME

After saving this, clear your Symfony cache with php bin/console cache:clear and try running doctrine:database:create again.

3. Verify Driver Compatibility #

Symfony 4.0.3 is a bit older, so double-check that your Doctrine DBAL and Oracle driver versions are compatible. You can review your composer.json to ensure you’re using a version of doctrine/dbal that supports Symfony 4.0 and Oracle connections properly.

Since you can connect via native PHP, your OCI8 extension is working correctly—this is definitely a Doctrine configuration parsing issue, so the above steps should resolve it.

内容的提问来源于stack exchange，提问作者Jarda K.