Home » Other » Client Tools » can not open sqlplus
can not open sqlplus [message #565728] Thu, 06 September 2012 07:34 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello experts,
when i try to connect with sqlplus or toad then i get an error


Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

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

C:\Users>



and i want to tell what i do before it-
my all files were be converted in .FLT then i shorted out this problem
after that when i tried to connect with sqlplus or toad then i get above error.
and i have restarted my system but throwing same error.


i am using oracle 11.2.0.1 on windows7

thanks in advance.....
Re: can not open sqlplus [message #565729 is a reply to message #565728] Thu, 06 September 2012 07:36 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
neetesh87 wrote on Thu, 06 September 2012 13:34

my all files were be converted in .FLT then i shorted out this problem


I have no idea what that means.
Re: can not open sqlplus [message #565734 is a reply to message #565729] Thu, 06 September 2012 07:52 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks sir to response,
sir i want to know that what is the cause of this error

" Unable to initialize Oracle call interface "

and how to short out it.

thanks.....
Re: can not open sqlplus [message #565737 is a reply to message #565734] Thu, 06 September 2012 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

Regards
Michel
Re: can not open sqlplus [message #565758 is a reply to message #565737] Thu, 06 September 2012 10:13 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks sir.......
Re: can not open sqlplus [message #565766 is a reply to message #565758] Thu, 06 September 2012 10:40 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Seriously, what does it mean: "all files were converted to .FLT"? What is .FLT? Who converted all files to it? Why?

As far as I understood, everything worked fine until that moment (i.e. you could connect to the database using SQL*Plus).
Previous Topic: Toad out of memory
Next Topic: V$SESSION doesn't show sql_id of statement ran from PL\SQL Developer tool
Goto Forum:
  


Current Time: Thu Mar 28 07:59:52 CDT 2024