LoginSignup
0
1

More than 5 years have passed since last update.

Laravel/LumenでOracle10gに繋ぐとORA-02248が出る

Last updated at Posted at 2018-11-06

経緯

以下を参考にしてドライバ導入
https://qiita.com/ono-soic/items/8ede45e9ce0d902da0c1

エラーでる

(2/2) QueryException
Error Code : 2248
Error Message : ORA-02248: ALTER SESSIONのオプションが無効です。
Position : 231
Statement : ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = > 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' > NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' EDITION = ora$base
Bindings :

これかな? と思ったけど
https://ameblo.jp/archive-redo-blog/entry-10035717316.html

違った

これでした
https://qiita.com/sowd/items/f7849afb5fc1c30cd2f9

vender/yajra/laravel-oci8/src/config/oracle.php
return [
    'oracle' => [
        'driver'         => 'oracle',
        'tns'            => env('DB_TNS', ''),
        'host'           => env('DB_HOST', '192.168.0.0'),
        'port'           => env('DB_PORT', '1521'),
        'database'       => env('DB_DATABASE', 'hoge'),
        'username'       => env('DB_USERNAME', 'fuga'),
        'password'       => env('DB_PASSWORD', 'poyo'),
        'charset'        => env('DB_CHARSET', 'AL32UTF8'),
        'prefix'         => env('DB_PREFIX', ''),
        'prefix_schema'  => env('DB_SCHEMA_PREFIX', ''),
        //'edition'        => env('DB_EDITION', 'ora$base'),
        'server_version' => env('DB_SERVER_VERSION', '10g'),
    ],
];

まとめ

EDITION は Oracle11g からの機能なので Oracle10g にはありません

0
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
1