| Error 6 initializing SQL*Plus [message #596761] |
Thu, 26 September 2013 04:10  |
shekhar.salunkhe
Messages: 154
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  |
John Watson
Messages: 8964
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> |
|
|
|
| Re: Error 6 initializing SQL*Plus [message #596773 is a reply to message #596762] |
Thu, 26 September 2013 05:13 |
shekhar.salunkhe
Messages: 154
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 |
John Watson
Messages: 8964
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 #596791 is a reply to message #596782] |
Thu, 26 September 2013 06:01 |
John Watson
Messages: 8964
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 #596815 is a reply to message #596803] |
Thu, 26 September 2013 07:59 |
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
