I am using RHEL5 and have just copied instant client 126.96.36.199.2 from download section.
When I try to connect to sqlplus it gives me following error:
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
I checked other thread posted here, but I have set ORACLE_HOME environment variable.
what would I be missing?
Thanks in advance for help!
That error probably means that the instant client shared library was not found.
In addition to the questions Surachart Opun has asked:
- If you have locate installed, what is the output of "locate -r /sqlplus\$"
- What is in your instant client directory?
Correct me if you find a mistake in my reasoning, but to me it seems like this poster's problem is different:
He or she has an Oracle client shared library in his or her library path, else sqlplus would not start at all.
Odds are that it is the wrong Oracle client shared library...