错误“Yajra\Pdo\Oci8\Exceptions\Oci8Exception ORA-24415:缺少用户名或用户名为空。”使用Laravel5。6.

Question

我无法连接到返回此错误的数据库。在应用程序中，我必须使用两个数据库，一个mysql（正在工作）和另一个oracle。

系统信息：

• win7 x64
• 拉威尔5.6
• PHP7.1。9
• 保监处2.1。7
• 即时客户端12.1

甲骨文档案。php

return [
'oracle' => [
    'driver'         => 'oracle',
    'tns'            => env('DB_TNS', '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = dboraclescan-listener.intranet)(PORT = 1521))
                            (CONNECT_DATA =
                            (SERVER = DEDICATED)
                            (SERVICE_NAME = PROD)))'),
    'host'           => env('DB_HOST', 'dboraclescan-listener.intranet'),
    'port'           => env('DB_PORT', '1521'),
    'database'       => env('DB_DATABASE', ''),
    'username'       => env('DB_USERNAME', '****'),
    'password'       => env('DB_PASSWORD', '***'),
    'charset'        => env('DB_CHARSET', 'AL32UTF8'),
    'prefix'         => env('DB_PREFIX', ''),
    'prefix_schema'  => env('DB_SCHEMA_PREFIX', ''),
    'server_version' => env('DB_SERVER_VERSION', '11g'),
  ],
 ];

存档数据库。php

'oracle' => [
        'driver'         => 'oracle',
        'tns'            => env('DB_TNS', '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = dboraclescan-listener.intranet)(PORT = 1521))
                                (CONNECT_DATA =
                                (SERVER = DEDICATED)
                                (SERVICE_NAME = PROD)))'),
        'host'           => env('DB_HOST', 'dboraclescan-listener.intranet'),
        'port'           => env('DB_PORT', '1521'),
        'database'       => env('DB_DATABASE', 'PROD'),
        'username'       => env('DB_USERNAME', '***'),
        'password'       => env('DB_PASSWORD', '***'),
        'charset'        => env('DB_CHARSET', 'AL32UTF8'),
        'prefix'         => env('DB_PREFIX', 'ijrm'),
        'prefix_schema'  => env('DB_SCHEMA_PREFIX', ''),
        'server_version' => env('DB_SERVER_VERSION', '11g'),
    ],

我需要其他地方的配置吗？

Answer 1

谢谢Devon，我已经修改了env文件以将设置发送到数据库。php文件。

ORACLE_CONNECTION=oracle
ORACLE_HOST=dboraclescan-listener.intranet
ORACLE_PORT=1521
ORACLE_DATABASE=PROD
ORACLE_USERNAME=***
ORACLE_PASSWORD=***

存档数据库。php

'oracle' => [
            'driver'         => 'oracle',
            'host'           => env('ORACLE_HOST', ''),
            'port'           => env('ORACLE_PORT', '1521'),
            'database'       => env('ORACLE_DATABASE', ''),
            'username'       => env('ORACLE_USERNAME', ''),
            'password'       => env('ORACLE_PASSWORD', ''),
            'charset'        => env('ORACLE_CHARSET', 'AL32UTF8'),
            'prefix'         => env('ORACLE_PREFIX', ''),
            'prefix_schema'  => env('ORACLE_SCHEMA_PREFIX', ''),
            'server_version' => env('ORACLE_SERVER_VERSION', '11g'),
        ],