Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've installed Oracle XE 11.2 on Fedora 18 but have trouble starting SQLPlus. It quits with the following error:

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

All of the environment variables are properly set (copied from installation guide)

# ~/.zshrc
ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe # It is in fact installed there
ORACLE_SID=XE
NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
PATH=$ORACLE_HOME/bin:$PATH

NLS_LANG is AMERICAN_AMERICA.AL32UTF8. As far as I understand Oracle ignores system language related variables but here they are anyway:

LC_CTYPE=en_US.UTF-8
LANG=en_US.UTF-8

Any suggestions?

share|improve this question
    
did you export the variables, e.g. 'export ORACLE_HOME' –  miracle173 Aug 6 '13 at 5:35
    
It is probably a permissions problem. Does the user you are trying to execute SQL*Plus as have permissions on the directories on $ORACLE_HOME? Easiest fix is to add the user to the dba group. –  Phil Aug 6 '13 at 18:46

2 Answers 2

This error usually occurs if you are executing sqlplus as a different user (other than the one which installed Oracle software), due to permission issues

Check Oracle Note: 356850.1

share|improve this answer

Try adding:

export LD_LIBRARY_PATH==/u01/app/oracle/product/11.2.0/xe/lib

Otherwise check to see if you can access the lib directory above.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.