OraFAQ Forum: Client Tools » can not open sqlplus

Home » SQL & PL/SQL » Client Tools » can not open sqlplus

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can not open sqlplus [message #565728]

Thu, 06 September 2012 07:34

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.....

Report message to a moderator

Re: can not open sqlplus [message #565729 is a reply to message #565728]

Thu, 06 September 2012 07:36

cookiemonster
Messages: 13895
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.

Report message to a moderator

Re: can not open sqlplus [message #565734 is a reply to message #565729]

Thu, 06 September 2012 07:52

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.....

Report message to a moderator

Re: can not open sqlplus [message #565737 is a reply to message #565734]

Thu, 06 September 2012 08:01

Michel Cadot
Messages: 67640
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

Report message to a moderator

Re: can not open sqlplus [message #565758 is a reply to message #565737]

Thu, 06 September 2012 10:13

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks sir.......

Report message to a moderator

Re: can not open sqlplus [message #565766 is a reply to message #565758]

Thu, 06 September 2012 10:40

Littlefoot
Messages: 21647
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).

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 16 15:26:21 CST 2021