OraFAQ Forum: Client Tools » SQL PLUS Crashes

Home » Other » Client Tools » SQL PLUS Crashes (10g)

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

SQL PLUS Crashes [message #533758]

Thu, 01 December 2011 04:43

stefanp
Messages: 6
Registered: December 2011

Junior Member

I don't know what really happens but SQL PLUS crashes every time i introduce my user and my password. I am certain that the user and password is good. It doesn't let me introduce the password for 3 times in a row and then to crash. It just simple crashes if i put once my data.

Yesterday it worked. it\s just so simply arbitrary. I don't have any idea why today is happening this to me . It\s because i have win 7? It worked better on win xp, i mean it doesn't crashed so often but it still crashed.

i use the user scott and the password ***** that i have just set it out when i\ve installed oracle. or i use "system" and the password *****. the scott user and system are unlocked.

please help me, i really need to open sql plus
i\m new to this thing..

Report message to a moderator

Re: SQL PLUS Crashes [message #533759 is a reply to message #533758]

Thu, 01 December 2011 04:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you copy/paste the whole session?

Report message to a moderator

Re: SQL PLUS Crashes [message #533761 is a reply to message #533758]

Thu, 01 December 2011 04:46

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Can you copy paste it?

Not getting how it crashes - you mean the dos/cmd window hangs up?

Report message to a moderator

Re: SQL PLUS Crashes [message #533765 is a reply to message #533758]

Thu, 01 December 2011 04:52

stefanp
Messages: 6
Registered: December 2011

Junior Member

well yes the window crashes, the dos/cmd window crashess, or whatever you want to call it.

i don't understand what to copy/paste ? it just doesn't let me in.

Report message to a moderator

Re: SQL PLUS Crashes [message #533768 is a reply to message #533758]

Thu, 01 December 2011 04:53

stefanp
Messages: 6
Registered: December 2011

Junior Member

i think i can put a print screen.. would it be better ?

Report message to a moderator

Re: SQL PLUS Crashes [message #533771 is a reply to message #533758]

Thu, 01 December 2011 04:57

stefanp
Messages: 6
Registered: December 2011

Junior Member

i uploaded the image.

Attachment: sql plus.jpg
(Size: 250.58KB, Downloaded 2339 times)

Report message to a moderator

Re: SQL PLUS Crashes [message #533780 is a reply to message #533771]

Thu, 01 December 2011 05:07

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Your image does not show any "crash".

Open a CMD box, start SQL*Plus until it crashes and copy and paste what's inside the window IN TEXT and inside the post, no attached image or file.

Regards
Michel

Report message to a moderator

Re: SQL PLUS Crashes [message #533785 is a reply to message #533780]

Thu, 01 December 2011 05:17

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

That's sqlplusw.exe - sql*plus is different.

Report message to a moderator

Re: SQL PLUS Crashes [message #533786 is a reply to message #533758]

Thu, 01 December 2011 05:23

stefanp
Messages: 6
Registered: December 2011

Junior Member

well i ran it into cmd and it says smth like this

i can\t copy paste but i\ll reproduce :

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

Report message to a moderator

Re: SQL PLUS Crashes [message #533795 is a reply to message #533786]

Thu, 01 December 2011 05:41

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.google.com/search?hl=en&source=hp&q=oracle+Unable+to+initialize+Oracle+call+interface

Regards
Michel

Report message to a moderator

Re: SQL PLUS Crashes [message #533805 is a reply to message #533758]

Thu, 01 December 2011 06:19

stefanp
Messages: 6
Registered: December 2011

Junior Member

I solved it. It had something to do with windows security. I run it in administrator and i get no errors now. I don't understand why it doesn't run in administrator by default. Anyway thanks a lot.

Report message to a moderator