This discussion is archived
0 Replies Latest reply: Jul 27, 2012 3:22 AM by 932828 RSS

SP2-1503: Unable to initialize Oracle call interface after accidently inst.

932828 Newbie
Currently Being Moderated
I have had a working 64bit Win Client (only client) and I am working with ADMIN Account.

After an accidently installation of ODBC in another oracle home I removed the second home manually
http://docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm#CIHGGGBB
and changed the path variable to the first home

tnsping works
sql developer works

but sql*plus doesn't work

it throw:

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly


after this I deinstalled the first client with the deinstall batch and reinstalled the client
but the same error orrures (with admin account)

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

tnsping works
sql developer works

I am able to recover the system by windows restore point
but it is: to take a sledgehammer to crack a nut

Is there another solution to fix the problem?

thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points