Skip to content
YajraBox

Laravel Oci8

Installation

This guide walks you through installing and configuring Laravel-OCI8 in your Laravel or Lumen application.

Server Requirements

Before you begin, ensure your environment meets these requirements:

  • PHP: 8.3 or higher
  • OCI8 Extension: The PHP OCI8 extension must be installed and enabled
  • Oracle Client Libraries: Oracle Instant Client (or equivalent) must be available on your system

Verifying OCI8 Extension

You can verify the OCI8 extension is installed by running:

php -m | grep oci8

If you don't see oci8 in the output, you'll need to install the OCI8 extension with your Oracle client libraries.

Installing Laravel-OCI8

Laravel-OCI8 is distributed as a Composer package. Run the following command in your project root to install the latest stable version:

composer require yajra/laravel-oci8:"^13"

Note: The ^13.0 constraint ensures you receive version 13.x of the package while remaining compatible with future minor versions. You can view more details on Packagist.

Configuration

Laravel-OCI8 supports both Laravel and Lumen frameworks. Choose the setup that matches your application.

Laravel

Laravel-OCI8 supports auto-discovery in Laravel 11+ and will automatically register the service provider. For Laravel 10 and below, add the service provider manually:

  1. Register the Service Provider (Laravel 10 and below)

    Open config/app.php and add the service provider to the providers array:

    'providers' => [
        // ...
        Yajra\Oci8\Oci8ServiceProvider::class,
    ],

    For Laravel 11+, the service provider is automatically discovered. If you need to register it manually, add it to bootstrap/providers.php:

    Application::configure(basePath: dirname(__DIR__))
        ->withProviders([
            // ...
            Yajra\Oci8\Oci8ServiceProvider::class,
        ])
        ->withExceptions();

  2. Publish Configuration (Optional)

    After registering the provider, you can publish the configuration file to customize settings:

    php artisan vendor:publish --tag=oracle

    This creates a configuration file at config/oracle.php where you can configure your Oracle connection details.

Lumen

  1. Register the Service Provider

    Open bootstrap/app.php and register the service provider:

    $app->register(Yajra\Oci8\Oci8ServiceProvider::class);

  2. Enable Facades and Eloquent

    Ensure the following calls are uncommented in your bootstrap/app.php file:

    $app->withFacades();
    $app->withEloquent();

  3. Register Oracle Connection

    Add your Oracle database configuration to the database.connections array in config/database.php:

    'connections' => [
        'oracle' => [
            'driver' => 'oracle',
            'host' => env('DB_HOST', ''),
            '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', ''),
        ],
    ],

Next Steps

Edit this page on GitHub