Total Pageviews

Wednesday, 21 November 2012

Tnsping.exe issue - Entry Point Not Found

Below is the error msg when dev team tried to connect to the database server through sql-developer/Toad.

The Procedure entry point snlinAddrLocalhost could not be located in the dynamic link library oran|10.dll

Possible Reasons: Environment variables are not set properly or pointing to some other oracle home.TNS_ADMIN must be set if tnsping.exe is not able to load.

Solution: Set the correct environment variables as show below:

SET PATH=D:\oracle\product\10.2.0\db_1\bin
SET ORACLE_BASE=D:\oracle\product\10.2.0
SET ORACLE_HOME=D:\oracle\product\10.2.0\db_1
SET TNS_ADMIN=D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN

Restart the machine.