Thursday, February 17, 2011

[PL/SQL Developer got problem to log in]

[Error
PL/SQL Developer: plsqldev.exe - Entry Point Not Found


The procedure entry point snlinAddrLocalhost could not be located in the dynamic link library oranl10.dll


[Caused]
a) multiple oracle clients installed
b) ORACLE_HOME has been changed


e.g. :
current ORACLE_HOME for pl/sql developer is 
ORACLE_HOME=C:\DevSuiteHome_1


but, in the global env (windows platform), it has been set as =
ORACLE_HOME=C:\oracle\product\10.2.0\client_1 


[Solution] 
Cancel the log in process, you will enter pl/sql developer without log in as any user in any databases.


Now, go to Tools > Preferences


Oracle > Connection > Oracle Home (select same oracle client as what Windows environment have)


Then Click OK, close and open the pl/sql developer again.


You should have no problem to log in after that.

No comments:

Post a Comment