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
相关产品推荐
相关产品推荐

