couldn't connect to orcale database

[amira95ibrahim]

Summary of problem or feature request

I can't connect to orcale database with laravel .It gives me this error :[ oci_connect(): ORA-12154: TNS:could not resolve the connect identifier specified] . I already connected with native php.

Code snippet of problem

I have this error: ErrorException: oci_connect(): ORA-12154: TNS:could not resolve the connect identifier specified in file C:\xampp\htdocs\OEA\vendor\jfelder\oracledb\src\Jfelder\OracleDB\OCI_PDO\OCI.php on line 96

#0 [internal function]: Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(2, 'oci_connect(): ...', 'C:\xampp\htdocs...', 96, Array) #1 C:\xampp\htdocs\OEA\vendor\jfelder\oracledb\src\Jfelder\OracleDB\OCI_PDO\OCI.php(96): oci_connect('OEAWEB', 'o1e2a3web456', 'oci:dbname=(DES...', 'AL32UTF8') #2 C:\xampp\htdocs\OEA\vendor\jfelder\oracledb\src\Jfelder\OracleDB\Connectors\OracleConnector.php(35): Jfelder\OracleDB\OCI_PDO\OCI->__construct('oci:dbname=(DES...', 'OEAWEB', 'o1e2a3web456', Array, 'AL32UTF8') #3 C:\xampp\htdocs\OEA\vendor\jfelder\oracledb\src\Jfelder\OracleDB\Connectors\OracleConnector.php(51): Jfelder\OracleDB\Connectors\OracleConnector->createConnection('oci:dbname=(DES...', Array, Array) #4 C:\xampp\htdocs\OEA\vendor\jfelder\oracledb\src\Jfelder\OracleDB\OracleDBServiceProvider.php(43): Jfelder\OracleDB\Connectors\OracleConnector->connect(Array) #5 [internal function]: Jfelder\OracleDB\OracleDBServiceProvider->Jfelder\OracleDB{closure}(Array, 'oracle') #6 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(130): call_user_func(Object(Closure), Array, 'oracle') #7 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(95): Illuminate\Database\DatabaseManager->makeConnection('oracle') #8 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(442): Illuminate\Database\DatabaseManager->connection() #9 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(261): Illuminate\Database\DatabaseManager->__call('select', Array) #10 C:\xampp\htdocs\OEA\routes\web.php(46): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #11 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Routing\Route.php(238): Illuminate\Routing\RouteFileRegistrar->{closure}() #12 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Routing\Route.php(208): Illuminate\Routing\Route->runCallable() #13 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Routing\Router.php(721): Illuminate\Routing\Route->run() #14 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #15 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #16 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #17 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #18 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #19 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #20 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #21 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #22 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest(Object(Illuminate\Http\Request), Object(Illuminate\Session\Store), Object(Closure)) #23 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #24 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #25 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #27 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #29 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Routing\Router.php(723): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #30 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Routing\Router.php(698): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #31 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Routing\Router.php(662): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #32 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Routing\Router.php(651): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #33 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(167): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #34 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request)) #35 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #36 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #39 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #42 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #44 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #45 C:\xampp\htdocs\OEA\vendor\fruitcake\laravel-cors\src\HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #46 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Fruitcake\Cors\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Http\Middleware\TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #48 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(167): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #50 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(142): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #51 C:\xampp\htdocs\OEA\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(111): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #52 C:\xampp\htdocs\OEA\public\index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #53 C:\xampp\htdocs\OEA\server.php(21): require_once('C:\xampp\htdocs...') #54 {main}

System details

• Operating System: windows
• PHP Version : 7.4.33
• Laravel Version : ^8.75
• Laravel-OCI8 Version : 2.2.0
• I am using xampp