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

[Wolf, Christian]

Hi!
I hope thats ok:
[root at berlxspw01 Desktop]# cd /usr/bin/
[root at berlxspw01 bin]# sqlplus spacewalk/spacewalk at xe
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 5 16:22:42 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> quit

Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
[root at berlxspw01 /]# sqlplus spacewalk/spacewalk at xe
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 5 16:22:54 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> quit

[root at berlxspw01 /]# type sqlplus
sqlplus is hashed (/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus)

[root at berlxspw01 /]# ./sqlplus
-bash: ./sqlplus: Datei oder Verzeichnis nicht gefunden
[root at berlxspw01 /]#

Gruß
Christian 


On Thu, Feb 05, 2009 at 02:46:40PM +0100, Wolf, Christian wrote:
> 
> 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

Are you aware that being chdir'ed to a directory does *not* mean you
are running program from that directory? You'd have to have dot in
your PATH, which I hope you do not have, as you are working as root.

You'd have to do ./sqlplus here to invoke
/usr/lib/oracle/10.2.0.4/client/bin/sqlplus. Or just use the full
path.

You should use type sqlplus to check what sqlplus you run.

-- 
Jan Pazdziora
Satellite Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list