You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

Laravel 8连接Oracle数据库遇ORA-12170超时错误求助

Laravel 8 + PHP 7.4连接Oracle数据库时持续出现ORA-12170超时错误

尝试将基于PHP 7.4的Laravel 8项目连接至Oracle测试数据库,已完成listener.ora、tnsnames.ora文件配置,并更新.env文件填入测试库凭据,但运行php artisan serve时持续报错:ORA-12170: TNS:Connect timeout occurred。

现有配置信息

Instant Client配置(目录:/opt/oracle/instantclient_21_13)

tnsnames.ora内容:

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.70.236.30)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = UWBSDBPROD)
    )
  )

listener.ora内容:

LISTENER =
  (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=tcp)(HOST=10.70.236.30)(PORT=1521))
    (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))  
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.70.236.30)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UWBSDBPROD)
    )
  )

Laravel .env配置:

DB_CONNECTION=oracle
DB_HOST=10.70.236.30
DB_PORT=1521
DB_DATABASE=database
DB_USERNAME=whatsappdb
DB_PASSWORD=whatsapp
DB_CHARSET=utf8
DB_COLLATION=utf8
DB_DEBUG=true

已尝试多日仍未找到解决办法,恳请协助排查该问题。

内容的提问来源于stack exchange,提问作者Vikram Vishvakarma

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.06.27 01:55:06