OraFAQ Forum: Client Tools » Sqlplus not found Message file sp1<lang>.msb not found

Home » Other » Client Tools » Sqlplus not found Message file sp1<lang>.msb not found (oracle 10g, linux rhel 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sqlplus not found Message file sp1<lang>.msb not found [message #441190]

Fri, 29 January 2010 06:25

zeelombe
Messages: 7
Registered: January 2010
Location: LUSAKA ZAMBIA

Junior Member

hi, people i need help resolving this problem

bash: sqlplus: command not found
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 install oracle 10gR and the process was successful i could do everything. the problem started when i install Zend Core for oracle, the install of zend was successful but i now can't start sqlplus.

what cani do

regards

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441191 is a reply to message #441190]

Fri, 29 January 2010 06:29

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

You may need to set ORACLE_HOME to your Oracle software directory

Did you do that?

Regards
Michel

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441192 is a reply to message #441190]

Fri, 29 January 2010 06:30

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

From Oracle FAQ

Quote:

Sometimes when SQL*Plus is run, you see the error:
Message file sp1<Lang>.msb not found
Error 6 initializing SQL*Plus

This occurs when SQL*Plus was unable to find a message file during program initialization. The most common cause is that ORACLE_HOME has not been set. This prevents the message files being found and SQL*Plus would be unable to display error messages or text required for normal operation. Other causes are when the message file is corrupt or cannot be read.

Make sure that all the environment variables or registry entries needed to run SQL*Plus are set. The variables are platform specific but may include ORACLE_HOME, ORACLE_SID, NLS_LANG, ORA_NLS33, and LD_LIBRARY_PATH.

Also check that the file sp1XX.msb is present in the $ORACLE_HOME/sqlplus/mesg or %ORACLE_HOME%\sqlplus\mesg directory. The "XX" stands for the country prefix associated with your NLS_LANG environment variable. SQL*Plus reads only one of the sp1XX.msb files. For example sp1ja.msb is read if NLS_LANG is JAPANESE_JAPAN.JA16EUC. If NLS_LANG is not set, then the default (English language) sp1us.msb is used. Check that the appropriate file is of non-zero size and that the file permissions allow you to read it. Note the ".msb" files are binary. The contents may be meaningless when viewed or printed. If you are unsure which language file is being used, try unsetting NLS_LANG and run SQL*Plus to verify it can read the sp1us.msb file.

The error message has changed in SQL*Plus Release 9.0.1 to be more informative:
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

Modified: 28-MAR-04 Ref #: ID-4828

sriram

Smile

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441194 is a reply to message #441191]

Fri, 29 January 2010 06:46

zeelombe
Messages: 7
Registered: January 2010
Location: LUSAKA ZAMBIA

Junior Member

yes i have but still am getting the same problem

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441195 is a reply to message #441194]

Fri, 29 January 2010 06:48

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Prove it.

Post the output of

set

and of

ls $ORACLE_HOME/sqlplus/mesg

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441198 is a reply to message #441194]

Fri, 29 January 2010 06:59

zeelombe
Messages: 7
Registered: January 2010
Location: LUSAKA ZAMBIA

Junior Member

@nz01 ~]$ ls $ORACLE_HOME/sqlplus/mesg
cpyus.msb cpyus.msg sp1us.msb sp1us.msg sp2us.msb sp2us.msg

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441202 is a reply to message #441198]

Fri, 29 January 2010 07:04

zeelombe
Messages: 7
Registered: January 2010
Location: LUSAKA ZAMBIA

Junior Member

the other fact is that am new to linux so i may not know all the required commands to check some setting so please i would appreciate if you could be indicating the full commands as u help.

so how do u check the nls_lang

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441208 is a reply to message #441202]

Fri, 29 January 2010 07:27

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

That you would do with the "set" command I already mentioned.

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441209 is a reply to message #441202]

Fri, 29 January 2010 07:34

zeelombe
Messages: 7
Registered: January 2010
Location: LUSAKA ZAMBIA

Junior Member

@nz01 ~]$ set
BASH=/bin/bash
BASH_ARGC=()
BASH_ARGV=()
BASH_LINENO=()
BASH_SOURCE=()
BASH_VERSINFO=([0]="3" [1]="2" [2]="25" [3]="1" [4]="release" [5]="i686-redhat-linux-gnu")
BASH_VERSION='3.2.25(1)-release'
COLORS=/etc/DIR_COLORS.xterm
COLORTERM=gnome-terminal
COLUMNS=80
CVS_RSH=ssh
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-XNce5vJATG,guid=5b9aeea9d48229fa410352004b6288e8
DESKTOP_SESSION=default
DESKTOP_STARTUP_ID=
DIRSTACK=()
DISPLAY=:0.0
EUID=500
GDMSESSION=default
GDM_XSERVER_LOCATION=local
GNOME_DESKTOP_SESSION_ID=Default
GNOME_KEYRING_SOCKET=/tmp/keyring-MIqtFI/socket
GROUPS=()
GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
G_BROKEN_FILENAMES=1
HISTFILE=/home/oracle/.bash_history
HISTFILESIZE=1000
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=nz01
HOSTTYPE=i686
IFS=$' \t\n'
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=:/lib:/home/oracle/oracle/product/10.2.0/db_1/lib:/home/oracle/oracle/product/10.2.0/db_1/lib
LESSOPEN='|/usr/bin/lesspipe.sh %s'
LINES=24
LOGNAME=valdba
LS_COLORS='no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32 :*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:* .zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00 ;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:'
MACHTYPE=i686-redhat-linux-gnu
MAIL=/var/spool/mail/valdba
MAILCHECK=60
OPTERR=1
OPTIND=1
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
ORACLE_SID=valdb
OSTYPE=linux-gnu
PATH=/home/oracle/oracle/product/10.2.0/db_1/bin:/home/oracle/oracle/product/10.2.0/db_1/bin:/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/b in:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin
PIPESTATUS=([0]="0")
PPID=13041
PROMPT_COMMAND='echo -ne "\033]0;${USER}@${HOSTNAME%%.*}:${PWD/#$HOME/~}"; echo -ne "\007"'
PS1='[\u@\h \W]\$ '
PS2='> '
PS4='+ '
PWD=/home/oracle
QTDIR=/usr/lib/qt-3.3
QTINC=/usr/lib/qt-3.3/include
QTLIB=/usr/lib/qt-3.3/lib
SESSION_MANAGER=local/nz01:/tmp/.ICE-unix/3414
SHELL=/bin/bash
SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments:monitor
SHLVL=2
SSH_AGENT_PID=3460
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-OBMGEV3414/agent.3414
TERM=xterm
UID=500
USER=valdba
USERNAME=valdba
WINDOWID=23090256
XAUTHORITY=/tmp/.gdm90RE7U
_=/home/oracle/oracle/product/10.2.0/db_1/sqlplus/mesg
consoletype=pty
qt_prefix=/usr/lib/qt-3.3

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441210 is a reply to message #441202]

Fri, 29 January 2010 07:36

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

See this....

UNIXForDBAs.....

http://unix-commands.blogspot.com/

Online man pages of unix/linux

sriram Smile

Smile

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441219 is a reply to message #441210]

Fri, 29 January 2010 09:18

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Also, the cause of the error then is that your NLS_LANG variable is not set (since it isn't shown in the output of the set command)

Since you only have the US language files, you have to set it to American, for example with:

export NLS_LANG=American_America.we8iso8859p15

The code page after the dot might depend on the codepages installed on the system and on the codepage the database is in, though.

[Updated on: Fri, 29 January 2010 09:19]

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441426 is a reply to message #441219]

Mon, 01 February 2010 01:58

zeelombe
Messages: 7
Registered: January 2010
Location: LUSAKA ZAMBIA

Junior Member

hello, i tried the setting the nls_lang as advised but to no avail. any new ideas

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441434 is a reply to message #441190]

Mon, 01 February 2010 02:13

zeelombe
Messages: 7
Registered: January 2010
Location: LUSAKA ZAMBIA

Junior Member

actually after doing the "export NLS_LANG=American_America.WE8ISO8859P15" the error that i am getting is NLS initiation error

Error 5 initializing SQL*Plus
NLS initialization error

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #441507 is a reply to message #441434]

Mon, 01 February 2010 09:19

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

That can happen when NLS_LANG is set to something completely wrong.

Maybe try other languages / character sets. And have a look at the NLS_LANG FAQ.

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #594162 is a reply to message #441190]

Sat, 24 August 2013 02:36

niladri.banerjee
Messages: 2
Registered: August 2013
Location: India

Junior Member

Just set ORACLE_HOME

Right Click on My Computers > Properties > Advanced System Settings > Go to Advanced Tab > Environment Variables > New >

Variable Name ORACLE_HOME
Path = Path where you installed oracle -> For eg : C:\oracle

You should be good to go.. !!!

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #594172 is a reply to message #594162]

Sat, 24 August 2013 08:13

Littlefoot
Messages: 21782
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Niladri, apart from the fact that this discussion originally took place more than 3.5 years ago (so it is rather unbelievable that the OP didn't fix it yet), he said that he uses Linux RHEL 5 operating system. I doubt that one can follow what you instructed (right click on this and that, set path to C:\oracle) - terms you used are valid for MS Windows (which version? Is it 7?), not Linux.

Therefore, welcome to OraFAQ Forum; when you choose to participate another discussion, try to pick a newer one, and try to post valid information for the situation described.

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #594174 is a reply to message #594172]

Sat, 24 August 2013 10:23

niladri.banerjee
Messages: 2
Registered: August 2013
Location: India

Junior Member

Yes Both of you are correct..I overlooked the first statement When I saw the following

bash: sqlplus: command not found
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 missed the "bash: sqlplus: command not found" part of it. I was getting following message in Windows...

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.

But when it is Windows, the answer I posted is 100% correct (of course you can verify if I said anything wrong and let me know in case I am) but what I said does not hold true for Linux.. Agreed !!!

And I don't think it is a harm to post information in old forums if you find any information. If it is useful or not useful is subjected to discretion of the people whom it is addressed and the subject matter...

Thanks...

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #594175 is a reply to message #594174]

Sat, 24 August 2013 10:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

niladri.banerjee ,

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Sqlplus not found Message file sp1<lang>.msb not found [message #594178 is a reply to message #594174]

Sun, 25 August 2013 02:20

Littlefoot
Messages: 21782
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

niladri.banerjee

And I don't think it is a harm to post information in old forums if you find any information.

I don't see any problem in this either. Everything you said in your first message is valid as far as MS Windows is concerned, but - as you know, you missed the operating system.

If you posted some information that regards setting ORACLE_HOME on Linux, that would be fine.

OK then, everything seems to be clear to both (all) of us. I hope you'll enjoy your stay here!

Report message to a moderator

Previous Topic:	SQL*Plus not SPOOLing
Next Topic:	Sql developer not working constantly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 01:23:46 CDT 2023