[Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME toyour Oracle software directory

[Michael Mraka]

Wolf, Christian wrote:
% %%Wolf, Christian wrote:
% %% Hi!
% %% 
% %% If i enter "sqlplus" i get following error.
% %% What is my mistake?
% %% 
% %% [root at berlxspw01 ~]# sqlplus
% %% 
% %% 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
% 
% %This is XE server's sqlplus which needs ORACLE_HOME set.
% %Fix your PATH and run sqlplus from /usr/bin (instantclient's one); no
% %ORACLE_HOME is necessary.
% 
% At first i fix my path and run sqlplus and same error
% [root at berlxspw01 /]# cd /usr/lib/
% [root at berlxspw01 lib]# sqlplus
% 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
% 
% Then I make ls -l
% [root at berlxspw01 bin]# ls -l /usr/bin/sqlplus
% lrwxrwxrwx 1 root root 43  5. Feb 09:52 /usr/bin/sqlplus -> /usr/lib/oracle/10.2.0.4/client/bin/sqlplus
% 
% 
% At the end i go to the path und try sqlplus again:
% [root at berlxspw01 bin]# cd /usr/lib/oracle/10.2.0.4/client/bin/
% [root at berlxspw01 bin]# sqlplus
% 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

[root at xen35 ~]# type sqlplus
sqlplus is /usr/bin/sqlplus
[root at xen35 ~]# set |grep ORACLE
[root at xen35 ~]# sqlplus 

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 5 14:52:40 2009
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


[root at xen35 ~]# export PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:$PATH
[root at xen35 ~]# type sqlplus
sqlplus is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus
[root at xen35 ~]# sqlplus
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

[root at xen35 ~]# export
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[root at xen35 ~]# sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 5 14:54:53 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.


--
Michael Mráka
Satellite Engineering, Red Hat