oracle 10gR2 in Windows 7 ultimate [message #435914] |
Fri, 18 December 2009 23:01 |
abhi_shakya
Messages: 50 Registered: September 2009 Location: Nepal
|
Member |
|
|
I installed oracle 10g R2 in my laptop with win7 ultimate(32-bit).
But when i try to run sqlplus from command prompt...It retrns error..
C:\Users\abhishek>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly.
I checked the oracle folder but there is db_1 and oradata folder inside product..but no admin folder..
Listener and database service is started..
what shud i do to make it work...
please help me out...
|
|
|
Re: oracle 10gR2 in Windows 7 ultimate [message #435922 is a reply to message #435914] |
Sat, 19 December 2009 01:13 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
SP2-01503: Unable to initialize Oracle call interface\n
*Cause: Indicates a library used by SQL*Plus to communicate with
the database failed to initialize correctly.
*Action: Check that the Oracle environment or registry entries are
consistent and correct. If using the SQL*Plus Instant Client
make sure the SQL*Plus and Oracle libraries are from the
same release. Make sure you have read access to the libraries.
No error during installation?
Regards
Michel
[Updated on: Sat, 19 December 2009 01:14] Report message to a moderator
|
|
|
|
|
|
Re: oracle 10gR2 in Windows 7 ultimate [message #472903 is a reply to message #435949] |
Tue, 24 August 2010 11:46 |
MarcusZ
Messages: 1 Registered: August 2010
|
Junior Member |
|
|
To all who are looking for a solution to this....
I had the same issue above. I installed Oracle 10G R2 on my Windows 7 laptop. Though I had no issues during install I wasn't able to run sqlplus, either via the gui or through the command prompt. I didn't find anyone covering a solution for this besides installing Oracle 11.6, but I did find a solution.
Run sqlplus as administrator. I just right-clicked on the shortcut for the gui app and selected "Run as Administrator" and SQLPlus ran just fine. I'm not sure how to use this information to run it in command mode but I'm sure it's possible.
Hope this helps someone.
|
|
|
|
|