SP2-0667: Message file sp1<lang>.msb not found [message #672910] |
Wed, 31 October 2018 17:20 |
|
mcdinesh.200@gmail.com
Messages: 18 Registered: March 2016
|
Junior Member |
|
|
Hi, I am getting the below errors while accessing the SQLPLUS.
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
I tried multiple scenarios changing the Oracle_home and path variables but no luck.
These are my env variables.
C:\Windows\System32>path
PATH=C:\oraclexe\app\oracle\product\11.2.0\server\bin\;C:\Windows\system32;C:\Wi
ndows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Pr
ogram Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\instantclient-basic-wi
ndows.x64-11.2.0.4.0\instantclient_11_2\;C:\Users\DINESH\AppData\Local\Programs\
Python\Python37\Scripts\;C:\Users\DINESH\AppData\Local\Programs\Python\Python37\
ORACLE_HOME:
C:\instantclient-basic-windows.x64-11.2.0.4.0\instantclient_11_2\;C:\oraclexe\app\oracle\product\11.2.0\server\;C:\oraclexe\app\oracl e\product\11.2.0\server\bin\;C:\oraclexe\app\oracle\product\11.2.0\server\bin\;C:\oraclexe\app\oracle\product\11.2.0\server\
Thanks,
Dinesh
|
|
|
|
Re: SP2-0667: Message file sp1<lang>.msb not found [message #672925 is a reply to message #672910] |
Thu, 01 November 2018 03:48 |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
When did this start happening? Oracle on Windows also populates the registry. You've got a munged install by the looks of it. You don't say which version of Oracle but I assume it is Oracle 11 XE from your OP. If so, try going through the deinstall instructions here. Follow the instructions exactly. Oracle 11 on Windows is a lot better at clearing up after itself than earlier versions. Then go through the install instructions here.
|
|
|
|
|
|
|
Re: SP2-0667: Message file sp1<lang>.msb not found [message #672949 is a reply to message #672946] |
Thu, 01 November 2018 07:54 |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
The user that you are logged in as has to be a member of the "ora_dba" Windows group. Also, copy and paste the contents of your C:\oraclexe\app\oracle\product\11.2.0\server\sqlnet.ora file here. Please use [code] tags to format any output.
|
|
|
|
|
|
|
Re: SP2-0667: Message file sp1<lang>.msb not found [message #672957 is a reply to message #672956] |
Thu, 01 November 2018 08:19 |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
You don't mention your version of Windows, but try:
Then type into the Run Dialog box. Navigate to "Local Users and Groups" -> "Groups". Is there a group called "ora_dba"? If so, open it and see what usernames are part of the group.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: SP2-0667: Message file sp1<lang>.msb not found [message #672979 is a reply to message #672978] |
Thu, 01 November 2018 09:08 |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
Quote:
ORA-01506: missing or illegal database name
Cause
You tried to execute an ALTER DATABASE command without a specified database name, and there is no value specified for the DB_NAME initialization parameter in the initialization file.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Either specify a database name in the ALTER DATABASE command or set a value for the DB_NAME parameter in the initialization file.
|
|
|
Re: SP2-0667: Message file sp1<lang>.msb not found [message #672980 is a reply to message #672977] |
Thu, 01 November 2018 09:13 |
|
mcdinesh.200@gmail.com
Messages: 18 Registered: March 2016
|
Junior Member |
|
|
c:\>echo %ORACLE_HOME%
C:\oraclexe\app\oracle\product\11.2.0\server\
c:\>echo %ORACLE_SID%
XE
c:\>path
PATH=C:\oraclexe\app\oracle\product\11.2.0\server;C:\oraclexe\app\oracle\product
\11.2.0\server\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Wi
ndows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\A
TI.ACE\Core-Static;C:\instantclient-basic-windows.x64-11.2.0.4.0\instantclient_1
1_2;C:\Users\DINESH\AppData\Local\Programs\Python\Python37\Scripts\;C:\Users\DIN
ESH\AppData\Local\Programs\Python\Python37\
[Updated on: Thu, 01 November 2018 09:16] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
Re: SP2-0667: Message file sp1<lang>.msb not found [message #672992 is a reply to message #672991] |
Thu, 01 November 2018 11:49 |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
I'm afraid that your XE install is so munged that I think you should start again. We don't know what other problems lie in store even if we fix this one. Why don't you uninstall and re-install like I recommended here? It sounds like you have inherited a load of problems created by someone else.
Is there important data you need to keep?
|
|
|
|