OraFAQ Forum: SQL & PL/SQL » sqlplus can't start

Home » SQL & PL/SQL » SQL & PL/SQL » sqlplus can't start (oracle 10.2.0.2 , window2003)

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

sqlplus can't start [message #313024]

Thu, 10 April 2008 07:19

wenjr
Messages: 2
Registered: April 2008

Junior Member

Hi All,

When i run "sqlplus /nolog" in the command mode on my oracle server,it appear following error message.

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

When i use another window machine and run sqlplus, i can logon oracle server successfully.

Does anyone have any idea about this issue?

[Updated on: Thu, 10 April 2008 07:22]

Report message to a moderator

Re: sqlplus can't start [message #313027 is a reply to message #313024]

Thu, 10 April 2008 07:25

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Have a trawl through some of the sites here

Report message to a moderator

Re: sqlplus can't start [message #313646 is a reply to message #313024]

Mon, 14 April 2008 00:54

wenjr
Messages: 2
Registered: April 2008

Junior Member

Hi,
I solve this problem.
The reason that i can't run sqlplus is that the program can't find the oraociei10.dll.
So i copy the file to the path which define the environment variable PATH and i can run.

Report message to a moderator

Re: sqlplus can't start [message #313669 is a reply to message #313646]

Mon, 14 April 2008 02:01

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Thanks for getting back to us with the resolution.

Report message to a moderator

Previous Topic:	Update Hangs shared memory cannot be read!!!
Next Topic:	Index performance in Loading Target during ETL process

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 06:16:43 CDT 2025