laravel-oci8
laravel-oci8 copied to clipboard
I get ORA-12543: TNS:destination host unreachable after upgrading from 8 to 9 version when using DB::connection
Summary of problem or feature request
My controller was working fine until I upgraded to Laravel 9 and yajra/laravel-oci8 version 9 While the models connect correctly to the default connection, when I try to execute an SQL query to a 2nd database (please look the snippet below) I get the error
ORA-12543: TNS:destination host unreachable
All my connection are using Oracle Databases
When I downgrade to version 8 then works again...
Code snippet of problem
$results = DB::connection($report->db)->select($sql_statement, (array) $params_with_values);
System details
- Operating System -> Linux (docker)
- PHP Version -> PHP 8.1.7
- Laravel Version -> 9.17.0
- Laravel-OCI8 Version -> 9.0.3