Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

oci_connect(): Error while trying to retrieve text for error ORA-12154

Question

Views

Comments

User_9PCZ2 Rank 1 - Community Starter

Mar 29, 2021 5:32AM in Oracle Business Intelligence Applications

Hi All

I am trying to make a oracle connection and am getting the below error. Am using easy connect string

oci_connect(): Error while trying to retrieve text for error ORA-12154

and tried to change the connection as mentioned in the forum as '//host:port/service_name'

then the error code changes and give : oci_connect(): Error while trying to retrieve text for error ORA-28547.

I have set the environment variables ORACLE_HOME, LD_LIBRARY_PATH AND TNS_ADMIN.

Please Help!!!!!!