Home » SQL & PL/SQL » Client Tools » Error 6 initializing SQL*Plus (Windows XP)
Error 6 initializing SQL*Plus [message #596761] Thu, 26 September 2013 04:10 Go to next message
shekhar.salunkhe
Messages: 148
Registered: January 2008
Location: Pune
Senior Member
Hi All,

I have created oracle 11 XE ..
Once it is created it was running fine.
I have worked on that 2 days.

Problem is occured when I restart my machine..
I m getting below error:

Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

I have checked the forum in which it is mentioned that ORACLE_HOME is not properly set.
I tried that one alot of time.
Even now environment variable shows proper value.

Please help me out.

Thanks
Re: Error 6 initializing SQL*Plus [message #596762 is a reply to message #596761] Thu, 26 September 2013 04:17 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
Please can you show you current settings for the environment variables ORACLE_HOME and PATH? Then the command WHERE SQLPLUS, and the error? Like this:
c:\users\john>
c:\users\john>echo %ORACLE_HOME%
c:\app\oracle\product\12.1.0\dbhome_1

c:\users\john>echo %PATH%
c:\app\oracle\product\12.1.0\dbhome_1\bin;C:\app\oracle\product\12.1.0\dbhome_1\bin;C:\app\oracl
in\bin;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\
tem32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2
Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\Sony\VAIO Improvement;C:\Program Files (x86)\Sony\
am Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Managem
am Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Inte
IPT;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\
)\PuTTY;"c:\Program Files\Windows NT\Accessories";C:\Program Files (x86)\Nmap

c:\users\john>where sqlplus
c:\app\oracle\product\12.1.0\dbhome_1\BIN\sqlplus.exe
C:\app\oracle\product\11.2.0\db112\BIN\sqlplus.exe

c:\users\john>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 26 10:16:59 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

orclz>
Use a CMD prompt and SQL*Plus, copy paste the results, enclosed within [code] tags
Re: Error 6 initializing SQL*Plus [message #596773 is a reply to message #596762] Thu, 26 September 2013 05:13 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 148
Registered: January 2008
Location: Pune
Senior Member
Hi,

here is an output :

echo %ORACLE_HOME%
c:\oraclexe\app\oracle\product\11.2.0\server

echo %PATH%
c:\oraclexe\app\oracle\product\11.2.0\server\bin; c:\windows\system32; c:\windows;

where sqlplus
'where' is not recognized as an internal or external command, operable program or batchfile.

3rd command does not give an output as I am using Windows XP
Please help me out.
Re: Error 6 initializing SQL*Plus [message #596774 is a reply to message #596773] Thu, 26 September 2013 05:17 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
Come on, man. Think: how do you find a file on Windows XP? I don't know, because I know virtually nothing about Windows, but what about dir /s for example? You must learn to use your operating system.
And you must show the results of your attempted SQL*Plus connection.
And you must enclose your copy/paste within [code] tags.
Re: Error 6 initializing SQL*Plus [message #596782 is a reply to message #596774] Thu, 26 September 2013 05:38 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 148
Registered: January 2008
Location: Pune
Senior Member
sqlplus is in following path:

1) c:\oraclexe\app\oracle\product\11.2.0\server\bin
2) c:\ORANT\bin

Can u pls tel me where is the problem exactly..
Re: Error 6 initializing SQL*Plus [message #596791 is a reply to message #596782] Thu, 26 September 2013 06:01 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
Sorry, man, I have asked you twice now to use copy/paste and code tags to show the real situation. Since you haven't done that, I have no idea if what you believe to be true is in fact correct.

And now you use SMS-speak at me. All in all, not very professional.

Perhaps someone else feels able to assist.
Re: Error 6 initializing SQL*Plus [message #596803 is a reply to message #596791] Thu, 26 September 2013 07:05 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 148
Registered: January 2008
Location: Pune
Senior Member
Dear,

I can not copy/paste and code tags to show real situation as oraclexe machine is different where no internet.
sorry.

Anyway thanks.
Re: Error 6 initializing SQL*Plus [message #596815 is a reply to message #596803] Thu, 26 September 2013 07:59 Go to previous messageGo to next message
gazzag
Messages: 267
Registered: November 2010
Location: Bristol, UK
Senior Member
Don't you have a disk or a USB stick? You could cut and paste the errors into Notepad on your XE machine, save it to USB, transfer it to your internet connected PC and paste it here.
Re: Error 6 initializing SQL*Plus [message #596823 is a reply to message #596815] Thu, 26 September 2013 08:22 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 148
Registered: January 2008
Location: Pune
Senior Member
Hi,

Erorr I have shown in 1st thread.
copying again

Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Re: Error 6 initializing SQL*Plus [message #596825 is a reply to message #596823] Thu, 26 September 2013 08:33 Go to previous message
BlackSwan
Messages: 21982
Registered: January 2009
Senior Member
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Previous Topic: how to set connection property "oracle.jdbc.thinLogonCapability"
Next Topic: Excel import
Goto Forum:
  


Current Time: Fri Apr 25 01:00:14 CDT 2014

Total time taken to generate the page: 0.19841 seconds