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

Discussion:

Wolf, Christian

2009-02-05 10:29:35 UTC

Hi!

If i enter "sqlplus" i get following error.

What is my mistake?

[***@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

Gruß

Christian

Meier, Daniel (EXT)

2009-02-05 10:34:03 UTC

Permalink

Do you have a tnsnames.ora file?

You also need to configure the tns names entry for your database. Place the following into /etc/tnsnames.ora:
XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xe)
)
)

________________________________
From: spacewalk-list-***@redhat.com [mailto:spacewalk-list-***@redhat.com] On Behalf Of Wolf, Christian
Sent: Donnerstag, 5. Februar 2009 11:30
To: spacewalk-***@redhat.com
Subject: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Hi!
If i enter "sqlplus" i get following error.
What is my mistake?

[***@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

Gruß
Christian

Wolf, Christian

2009-02-05 10:37:22 UTC

Permalink

Yes i did.

I did all the thinks like in wiki.

Additional Info:

I activate SELinux.

Gruß

Christian

________________________________

From: spacewalk-list-***@redhat.com [mailto:spacewalk-list-***@redhat.com] On Behalf Of Meier, Daniel (EXT)
Sent: Thursday, February 05, 2009 11:34 AM
To: 'spacewalk-***@redhat.com'
Subject: RE: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME toyour Oracle software directory

Do you have a tnsnames.ora file?

You also need to configure the tns names entry for your database. Place the following into /etc/tnsnames.ora:
XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xe)
)
)

________________________________

From: spacewalk-list-***@redhat.com [mailto:spacewalk-list-***@redhat.com] On Behalf Of Wolf, Christian
Sent: Donnerstag, 5. Februar 2009 11:30
To: spacewalk-***@redhat.com
Subject: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Hi!

If i enter "sqlplus" i get following error.

What is my mistake?

[***@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

Gruß

Christian

mark

2009-02-05 12:43:43 UTC

Permalink

Post by Meier, Daniel (EXT)
Do you have a tnsnames.ora file?

I've never needed a tnsnames.ora in /etc - I just use the std. one that's in
$ORACLE_HOME/admin/network/

mark

Michael ORourke

2009-02-05 10:54:26 UTC

Permalink

<HEAD>
<STYLE>body{font-family: Geneva,Arial,Helvetica,sans-serif;font-size:9pt;background-color: #ffffff;color: black;}</STYLE>

<META content="MSHTML 6.00.2900.3492" name=GENERATOR></HEAD>
<BODY id=compText>
"sqlplus" is looking for the ORACLE_HOME environment variable.
Try...
env | grep ORACLE_HOME
You should see something like the following:
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
I would try sourcing the login profile, like so...
. /etc/profile
then see if ORACLE_HOME gets set properly.  It looks like the following script sets Oracle's environment variables (at least on my system):  /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh   
Which should run when you login (from /etc/profile).
-Mike
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 0px; BORDER-LEFT: #0000ff 2px solid">-----Original Message----- From: "Wolf, Christian" <***@FOXMOBILE.COM> Sent: Feb 5, 2009 5:29 AM To: spacewalk-***@redhat.com Subject: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory <ZZZHTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:o="urn:schemas-microsoft-com:office:office"><ZZZHEAD><ZZZMETA content="text/html; charset=iso-8859-1" http-equiv="Content-Type"><ZZZMETA name="Generator" content="Microsoft Word 11 (filtered medium)">
<STYLE>
<ZZZ!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:ZZZlink, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
--> </STYLE> </ZZZHEAD><ZZZBODY lang=DE vlink="purple" link="blue"> <DIV class=Section1> Hi!<?xml:namespace prefix = o /><o:p></o:p> If i enter ?sqlplus? i get following error.<o:p></o:p> What is my mistake?<o:p></o:p> <o:p> </o:p> [***@berlxspw01 ~]# sqlplus<o:p></o:p> Error 6 initializing SQL*Plus<o:p></o:p> Message file sp1<lang>.msb not found<o:p></o:p>
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory<o:p></o:p>
<o:p> </o:p>
Gruß<o:p></o:p>
Christian <o:p></o:p>
<o:p> </o:p></DIV></ZZZBODY></ZZZHTML></BLOCKQUOTE></BODY>

Michael Mraka

2009-02-05 11:28:29 UTC

Permalink

Michael ORourke wrote:
% "sqlplus" is looking for the ORACLE_HOME environment variable.
%
% Try...
%
% env | grep ORACLE_HOME
%
% You should see something like the following:
%
% ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
%
% I would try sourcing the login profile, like so...
%
% . /etc/profile
%
% then see if ORACLE_HOME gets set properly. It looks like the following script
% sets Oracle's environment variables (at least on my system): /usr/lib/oracle/
% xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
%
% Which should run when you login (from /etc/profile).

Please don't mix server and client settings.
ORACLE_HOME is important only for oracle server environment not for
(instant) client.

% -Mike

--
Michael Mráka
Satellite Engineering, Red Hat

Jason Dobies

2009-02-05 14:10:26 UTC

Permalink

Post by Michael ORourke
I would try sourcing the login profile, like so...
. /etc/profile

Another option
is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh

See https://fedorahosted.org/spacewalk/wiki/OracleXeSetup

--
Jason Dobies (***@redhat.com)
RHN Satellite & Spacewalk
RHCE# 805008743336126
Freenode: jdob @ #spacewalk, #spacewalk-devel

Michael Mraka

2009-02-05 11:24:31 UTC

Permalink

Wolf, Christian wrote:
% Hi!
%
% If i enter "sqlplus" i get following error.
% What is my mistake?
%
% [***@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.

--
Michael Mráka
Satellite Engineering, Red Hat

Michael ORourke

2009-02-05 12:41:31 UTC

Permalink

----- Original Message -----
From: "Michael Mraka" <***@redhat.com>
To: <spacewalk-***@redhat.com>
Sent: Thursday, February 05, 2009 6:24 AM
Subject: Re: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME
toyour Oracle software directory

Post by Michael Mraka
% Hi!
%
% If i enter "sqlplus" i get following error.
% What is my mistake?
%
%
% 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.

Hmmmm... On my system sqlplus under /usr/bin is a symbolic link to Oracle's
sqlplus.
[***@hubble ~]# ls -l /usr/bin/sqlplus
lrwxrwxrwx 1 root root 43 Dec 10 17:00 /usr/bin/sqlplus ->
/usr/lib/oracle/10.2.0.4/client/bin/sqlplus
which seems to want ORACLE_HOME to be set. But it sounds like instantclient
doesn't require it.
So I guess it depends on your Oracle installation.
Thanks for the clarification.

Post by Michael Mraka
--
Michael Mráka
Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-list mailing list
https://www.redhat.com/mailman/listinfo/spacewalk-list

Michael Mraka

2009-02-05 13:01:10 UTC

Permalink

Michael ORourke wrote:
% >% If i enter "sqlplus" i get following error.
% >% What is my mistake?
% >%
% >% [***@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.
% >
% Hmmmm... On my system sqlplus under /usr/bin is a symbolic link to Oracle's
% sqlplus.
% [***@hubble ~]# ls -l /usr/bin/sqlplus
% lrwxrwxrwx 1 root root 43 Dec 10 17:00 /usr/bin/sqlplus ->
% /usr/lib/oracle/10.2.0.4/client/bin/sqlplus

Yes, this is the oracle instantclient I've been talking about.

% which seems to want ORACLE_HOME to be set. But it sounds like
% instantclient doesn't require it.
% So I guess it depends on your Oracle installation.
% Thanks for the clarification.

--
Michael Mráka
Satellite Engineering, Red Hat

Wolf, Christian

2009-02-05 13:46:40 UTC

Permalink

%%Wolf, Christian wrote:
%% Hi!
%%
%% If i enter "sqlplus" i get following error.
%% What is my mistake?
%%
%% [***@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
[***@berlxspw01 /]# cd /usr/lib/
[***@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
[***@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:
[***@berlxspw01 bin]# cd /usr/lib/oracle/10.2.0.4/client/bin/
[***@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

--
Michael Mráka
Satellite Engineering, Red Hat

Michael Mraka

2009-02-05 13:56:17 UTC

Permalink

Wolf, Christian wrote:
% %%Wolf, Christian wrote:
% %% Hi!
% %%
% %% If i enter "sqlplus" i get following error.
% %% What is my mistake?
% %%
% %% [***@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
% [***@berlxspw01 /]# cd /usr/lib/
% [***@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
% [***@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:
% [***@berlxspw01 bin]# cd /usr/lib/oracle/10.2.0.4/client/bin/
% [***@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

[***@xen35 ~]# type sqlplus
sqlplus is /usr/bin/sqlplus
[***@xen35 ~]# set |grep ORACLE
[***@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.

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

[***@xen35 ~]# export
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[***@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

Wolf, Christian

2009-02-05 14:19:15 UTC

Permalink

Thanks Michael
It works
[***@berlxspw01 ~]# export PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:$PATH
[root@ berlxspw01 ~]# type sqlplus
sqlplus is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus
[root@ 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

[root@ berlxspw01 ~]# export
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[root@ berlxspw01 ~]# sqlplus spacewalk/***@xe
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 5 15:16:20 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

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

SQL>

Gruß
Christian

-----Original Message-----
From: spacewalk-list-***@redhat.com [mailto:spacewalk-list-***@redhat.com] On Behalf Of Michael Mraka
Sent: Thursday, February 05, 2009 2:56 PM
To: spacewalk-***@redhat.com
Subject: Re: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME toyourOracle software directory

Wolf, Christian wrote:
% %%Wolf, Christian wrote:
% %% Hi!
% %%
% %% If i enter "sqlplus" i get following error.
% %% What is my mistake?
% %%
% %% [***@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
% [***@berlxspw01 /]# cd /usr/lib/
% [***@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
% [***@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:
% [***@berlxspw01 bin]# cd /usr/lib/oracle/10.2.0.4/client/bin/
% [***@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

[***@xen35 ~]# type sqlplus
sqlplus is /usr/bin/sqlplus
[***@xen35 ~]# set |grep ORACLE
[***@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.

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

[***@xen35 ~]# export
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[***@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

Jan Pazdziora

2009-02-05 15:18:58 UTC

Permalink

Post by Wolf, Christian
Thanks Michael
It works
sqlplus is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/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
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 5 15:16:20 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL>

And now try with PATH not set, using sqlplus from /usr/bin (pointing
to InstantClient), and without ORACLE_HOME. That's what Michael
showed you in the first half of his post.

--
Jan Pazdziora
Satellite Engineering, Red Hat

Meier, Daniel (EXT)

2009-02-05 13:50:54 UTC

Permalink

Try "su - oracle"

And then sqlplus.

-----Original Message-----
From: spacewalk-list-***@redhat.com [mailto:spacewalk-list-***@redhat.com] On Behalf Of Wolf, Christian
Sent: Donnerstag, 5. Februar 2009 14:47
To: spacewalk-***@redhat.com
Subject: RE: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME toyour Oracle software directory

%%Wolf, Christian wrote:
%% Hi!
%%
%% If i enter "sqlplus" i get following error.
%% What is my mistake?
%%
%% [***@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
[***@berlxspw01 /]# cd /usr/lib/
[***@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
[***@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:
[***@berlxspw01 bin]# cd /usr/lib/oracle/10.2.0.4/client/bin/
[***@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

--
Michael Mráka
Satellite Engineering, Red Hat

Jan Pazdziora

2009-02-05 15:22:39 UTC

Permalink

Post by Wolf, Christian
At first i fix my path and run sqlplus and same error
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
lrwxrwxrwx 1 root root 43 5. Feb 09:52 /usr/bin/sqlplus -> /usr/lib/oracle/10.2.0.4/client/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

Wolf, Christian

2009-02-05 15:26:53 UTC

Permalink

Hi!
I hope thats ok:
[***@berlxspw01 Desktop]# cd /usr/bin/
[***@berlxspw01 bin]# sqlplus spacewalk/***@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
[***@berlxspw01 /]# sqlplus spacewalk/***@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

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

[***@berlxspw01 /]# ./sqlplus
-bash: ./sqlplus: Datei oder Verzeichnis nicht gefunden
[***@berlxspw01 /]#

Gruß
Christian

--
Jan Pazdziora
Satellite Engineering, Red Hat

Jan Pazdziora

2009-02-05 18:24:08 UTC

Permalink

Post by Wolf, Christian
Hi!

You are not necessarily running /usr/bin/sqlplus here. The fact that you
are chdir'ed to a directory does *not* mean you are running program from
that directory. What command (from which directory) will be executed
depends on your PATH environment variable, not on you current directory.
My guess is that you actually execute
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus
just like you are in the next case, and you have ORACLE_HOME set.

Post by Wolf, Christian
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.
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

I assume that this works because you have ORACLE_HOME set.

Post by Wolf, Christian
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.
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> quit
sqlplus is hashed (/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus)

This shows that no matter in what directory you are,
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus
will be run. That is not correct.

Post by Wolf, Christian
-bash: ./sqlplus: Datei oder Verzeichnis nicht gefunden

This shows that there is no sqlplus in this directory.

You should:

- unset ORACLE_HOME;
- verify that /usr/bin/sqlplus points to the InstantClient sqlplus;
- try /usr/bin/sqlplus (full path) and see if it works without that
ORACLE_HOME set;
- unset /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin from
your PATH;
- run type sqlplus to verify that it shows /usr/bin/sqlplus;
- run sqlplus and see if it works without that ORACLE_HOME set.

--
Jan Pazdziora | adelton at #satellite*, #brno
Satellite Engineering, Red Hat