Setup Oracle Database in Laravel

-

 Laravel is a powerful PHP web application framework that is widely used for building web applications. One of the strengths of Laravel is its ability to work with various databases. In this tutorial, we will walk through the steps involved in setting up an Oracle database in a Laravel framework.

Prerequisites

Before we begin, ensure that the following requirements are met:

  • A Laravel project is set up on your machine
  • The Oracle database software is installed and running
  • The Oracle Instant Client is installed on your machine
  • Basic knowledge of Laravel and Oracle database

Step 1: Install the Oracle Driver

The first step is to install the Oracle driver for PHP. The driver can be installed using the following command:

composer require yajra/laravel-oci8

This command will install the Oracle driver and its dependencies in your Laravel project.

Step 2: Configure the Oracle Driver

Next, we need to configure the Oracle driver. To do this, open the “config/database.php” file in your Laravel project and add the following configuration for the Oracle driver:

'oracle' => [
    'driver' => 'oracle',
    'host' => env('DB_HOST', 'localhost'),
    'port' => env('DB_PORT', '1521'),
    'database' => env('DB_DATABASE', 'xe'),
    'username' => env('DB_USERNAME', 'system'),
    'password' => env('DB_PASSWORD', 'oracle'),
    'service_name' => env('DB_SERVICE_NAME', ''),
    'charset' => 'AL32UTF8',
    'prefix' => '',
],

This configuration specifies the connection parameters for the Oracle database. Ensure that the values for the host, port, database, username, and password match the values for your Oracle database. If you are using a service name, specify it in the “service_name” field.

Step 3: Configure the Environment Variables

Next, we need to configure the environment variables for the Oracle database connection. To do this, open the “.env” file in your Laravel project and add the following configuration:

DB_CONNECTION=oracle
DB_HOST=localhost
DB_PORT=1521
DB_DATABASE=xe
DB_USERNAME=system
DB_PASSWORD=oracle
DB_SERVICE_NAME=

This configuration specifies the environment variables for the Oracle database connection. Ensure that the values match the values in the “config/database.php” file.

Step 4: Test the Connection

To test the Oracle database connection, run the following command:

php artisan tinker
DB::connection()->getPdo();

This will establish a connection to the Oracle database and return the PDO object. If the connection is successful, you should see a “PDO” object returned.

Step 5: Migrate the Database

Finally, we can migrate the database using the following command:

php artisan migrate

This command will create the necessary tables in the Oracle database for your Laravel project.

Conclusion

Setting up an Oracle database in a Laravel framework is a straightforward process. In this tutorial, we walked through the steps involved in installing the Oracle driver, configuring the driver, configuring the environment variables, testing the connection, and migrating the database. With these steps, you should be able to set up an Oracle database in your Laravel project and start building your web application.

Comments

Post a Comment

Popular posts from this blog

Difference join between (+) and (-) notation

-
  I have very old application. Then I saw some store procedure using (+) or (-) notation on the query. What i want to ask are : 1. what is the difference between (+) and (-) notation ? 2. what is the difference between (the position of the notation I put on left or right) ? SELECT * FROM A, B WHERE A.column = B.column(+) and SELECT * FROM A, B WHERE A.column(+) = B.column 3. I read from forum that notation is only present for backwards compatibility because Oracle debuted it before the ANSI standard for joins. So is there any problem if I'm not change the notation to 'join' statement (ANSI standard) on my old existing query ? 4. Is it recommended or not using notation (+) (-) ? 5. How about the performance. It's good using (+) (-) notation or join notation ? and Chris said... The plus sign is Oracle syntax for an outer join. There isn't a minus operator for joins. An outer join means return all rows from one table. Also return the rows from the outer joined where th...
Read more

Oracle Data Guard Startup & Shutdown Steps

-
Image
Data Guard Shutdown Sequence Stop log apply service or MRP and shutdown the standby SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL ; SQL > SHUT IMMEDIATE ; Stop log shipping from primary and shutdown primary database SQL > ALTER SYSTEM SET log_archive_dest_state_2 = 'DEFER' ; SQL > ALTER SYSTEM SET log_archive_dest_state_3 = 'DEFER' ; SQL > SHUT Transactional ; Modes of Shutdown of the Oracle Database: Shutdown Normal Shutdown Transactional Shutdown Immediate Shutdown Abort Data Guard Startup Sequence Startup primary database and enable log shipping SQL > STARTUP ; SQL > ALTER SYSTEM SET log_archive_dest_state_2 = 'ENABLE' ; SQL > ALTER SYSTEM SET log_archive_dest_state_3 = 'ENABLE' ; Startup standby and enable log apply service or MRP SQL > startup nomount ; SQL > alter database mount standby database ; SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNE...
Read more