covier
asked on
message file SP1<lang>.msb not found wehn attempting to access oracle database
Some users trying to access a remote oracle database via sqlplus get the error "message file SP1<lang>.msb not found". Some users have no problem accessing the same database from the same machine? What could be wrong and how can it be solved?
hi
Try to change the permissions(using regedt32) on the registry entry under HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE to 'Full Control' for everyone. (Make sure you tell it to replace the permission on all subkeys.)
I hope this helps. it is probably something to do with permission to find the message files location or permissions on the file itself.
regards
Try to change the permissions(using regedt32) on the registry entry under HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE to 'Full Control' for everyone. (Make sure you tell it to replace the permission on all subkeys.)
I hope this helps. it is probably something to do with permission to find the message files location or permissions on the file itself.
regards
The Oracle_HOME parameter is not set for specific users. Please set the necessary oracle home environment variable.
eg.
ORACLE_HOME=c:\oracle\ora8 1
eg.
ORACLE_HOME=c:\oracle\ora8
Cause
- PLUS_DFLT environment variable is not set correctly.
Fix
1. Start > cmd > regedit
2. Go to HKEY_LOCAL_MACHINE -> SOFTWARE -> Oracle
3. Go to the HOME for the new sqlplus PLUS80 executable
4. Go to View --> New --> String Value
5. Type PLUS_DFLT <enter>
6. Double-click on PLUS_DFLT and enter PLUS80
- PLUS_DFLT environment variable is not set correctly.
Fix
1. Start > cmd > regedit
2. Go to HKEY_LOCAL_MACHINE -> SOFTWARE -> Oracle
3. Go to the HOME for the new sqlplus PLUS80 executable
4. Go to View --> New --> String Value
5. Type PLUS_DFLT <enter>
6. Double-click on PLUS_DFLT and enter PLUS80
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
there is a related question to your problem, take a look , its's all about your ENVIRONMENT variable.The question is in the middle of the page, and the answer.