Oracle SP2-1503 SP2-0152 on Windows 7

C:\Users\joey>sqlplus /nolog
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

I encountered this issue on my Windows 7 laptop where Oracle 10.2.03 g  and Oracle ODAC1110710beta is installed.
I was working well before then I decided to try the Enterprise Manager Grid Control 10.2.04 []
suddenly all this problem came up. I have to trash and reinstall 10.2.03 DB and then the above error came up. 😦

To work around this issue download Oracle client patch with patch number 5337014.

This can be downloaded from Metalink under Patches & Updates -> Simple Search -> Insert 5337014 in the Patch number box and choose Microsoft Windows 32-bit for the platform (appx 852 Meg!!). WTF this patch is bigger than the original 10g DB installer!


About this entry