![\"DLL](\"http:\/\/content.n4stack.io\/wp-content\/uploads\/2018\/07\/DLL-issues_Oracle-on-Windows-1.png\")
<\/p>\n[et_pb_section bb_built=”1″ fullwidth=”off” specialty=”off”][et_pb_row][et_pb_column type=”4_4″][et_pb_text _builder_version=”3.12.2″ header_6_text_color=”#e02b20″ header_5_text_color=”#e02b20″]<\/p>\n
Recently I encountered a DLL issue when trying to log in to Oracle on Windows. It’s an issue i’ve not encountered before and it took a little while to figure out so I thought i’d share my solution with you below…<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”3.9″ text_font_size=”20px” text_text_color=”#e05206″]<\/p>\n
THE SCENARIO<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”3.9″]<\/p>\n
You log in, set your ORACLE_SID and ORACLE_HOME and then try to run SQLPLUS. What you get is this:<\/p>\n
<\/p>\n
What’s going on here then? The file exists in the ORACLE_HOME as expected but yet it can’t seem to find said file.<\/p>\n
Simple solution here… your PATH variable is pointing at an incorrect ORACLE_HOME. The likely cause of this is that you are running more than one Oracle DB on the box with different homes and the PATH hasn’t been updated with the new ORACLE_HOME. This results in a binary mismatch between the ORACLE_HOME and SQLPLUS.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”3.9″ text_font_size=”20px” text_text_color=”#e05206″]<\/p>\n
THE SOLUTION<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”3.9″]<\/p>\n
Either run SQLPLUS using the full ORACLE_HOME path like:<\/p>\n
%ORACLE_HOME%\/bin\/sqlplus<\/em><\/p>\n Or, change the PATH and put ORACLE_HOME at the start.<\/p>\n Hopefully you haven’t encountered this DLL missing error when working with Oracle on Windows but, if you have, I hope this helped!<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row][et_pb_column type=”4_4″][et_pb_divider _builder_version=”3.9″ background_color=”#e05206″ color=”#e05206″ height=”5px” max_width=”50%” module_alignment=”center” \/][\/et_pb_column][\/et_pb_row][et_pb_row][et_pb_column type=”4_4″][et_pb_team_member name=”Kate Gawron” position=”Database Consultant” image_url=”http:\/\/content.n4stack.io\/wp-content\/uploads\/2018\/07\/KATE-GAWRON.png” _builder_version=”3.9″ saved_tabs=”all” global_module=”53225″]<\/p>\n Kate spends most of her time working with Oracle databases and products, but dabbles in MySQL and SQL Server when the need arises.<\/p>\n She enjoys researching and testing new solutions to see how they could benefit our projects, often testing to destruction!<\/p>\n