laravel-oci8 icon indicating copy to clipboard operation
laravel-oci8 copied to clipboard

I get ORA-12543: TNS:destination host unreachable after upgrading from 8 to 9 version when using DB::connection

Open marvelousvts opened this issue 3 years ago • 0 comments

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

marvelousvts avatar Jun 17 '22 16:06 marvelousvts