Home » SQL & PL/SQL » Client Tools » SQL PLUS Crashes (10g)
SQL PLUS Crashes [message #533758] Thu, 01 December 2011 04:43 Go to next message
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..
Re: SQL PLUS Crashes [message #533759 is a reply to message #533758] Thu, 01 December 2011 04:46 Go to previous messageGo to next message
Littlefoot
Messages: 19469
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you copy/paste the whole session?
Re: SQL PLUS Crashes [message #533761 is a reply to message #533758] Thu, 01 December 2011 04:46 Go to previous messageGo to next message
Roachcoach
Messages: 1194
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?
Re: SQL PLUS Crashes [message #533765 is a reply to message #533758] Thu, 01 December 2011 04:52 Go to previous messageGo to next message
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.
Re: SQL PLUS Crashes [message #533768 is a reply to message #533758] Thu, 01 December 2011 04:53 Go to previous messageGo to next message
stefanp
Messages: 6
Registered: December 2011
Junior Member
i think i can put a print screen.. would it be better ?
Re: SQL PLUS Crashes [message #533771 is a reply to message #533758] Thu, 01 December 2011 04:57 Go to previous messageGo to next message
stefanp
Messages: 6
Registered: December 2011
Junior Member
i uploaded the image.
  • Attachment: sql plus.jpg
    (Size: 250.58KB, Downloaded 257 times)
Re: SQL PLUS Crashes [message #533780 is a reply to message #533771] Thu, 01 December 2011 05:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58847
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: SQL PLUS Crashes [message #533785 is a reply to message #533780] Thu, 01 December 2011 05:17 Go to previous messageGo to next message
Roachcoach
Messages: 1194
Registered: May 2010
Location: UK
Senior Member
That's sqlplusw.exe - sql*plus is different.
Re: SQL PLUS Crashes [message #533786 is a reply to message #533758] Thu, 01 December 2011 05:23 Go to previous messageGo to next message
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
Re: SQL PLUS Crashes [message #533795 is a reply to message #533786] Thu, 01 December 2011 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 58847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&source=hp&q=oracle+Unable+to+initialize+Oracle+call+interface

Regards
Michel

Re: SQL PLUS Crashes [message #533805 is a reply to message #533758] Thu, 01 December 2011 06:19 Go to previous messageGo to next message
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.
Re: SQL PLUS Crashes [message #533807 is a reply to message #533805] Thu, 01 December 2011 06:45 Go to previous messageGo to next message
Roachcoach
Messages: 1194
Registered: May 2010
Location: UK
Senior Member
Win7 doesnt run much as admin by default iirc.
icon14.gif  Re: SQL PLUS Crashes [message #592338 is a reply to message #533805] Tue, 06 August 2013 10:55 Go to previous message
asitha
Messages: 4
Registered: December 2007
Location: Colombo - Sri Lanka
Junior Member
This is very helpful. Thanks

/Asitha
Previous Topic: DATA EXPORT To EXCEL
Next Topic: SQL*Plus not SPOOLing
Goto Forum:
  


Current Time: Wed Aug 20 23:25:25 CDT 2014

Total time taken to generate the page: 0.12410 seconds