Today, I installed Oracle 10.2.0.1.0 on my windows 7 system, the installation was successful without any glitches but when I tried to open SQLPLUS console using command prompt then I got the following error.
C:\Users\RAJKUMAR>sqlplus /nolog
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
C:\Users\RAJKUMAR>
Solution: Such errors generally comes on Windows Vista and Windows 7 systems due to not loading of some required library files so to overcome to this error you will have to open the command prompt as Administrator then try, it will work.
Hope it will work for you............!!