Home » RDBMS Server » Server Administration » SQLPLUS NOT FOUND ( oracle 10gR2 Linux red hat es 4)
SQLPLUS NOT FOUND [message #310594] Tue, 01 April 2008 14:40 Go to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
hi all,
I installed oracle 10 g R2 on RED HAT linux ES4. Everything works fine.
I can use SQLPLUS command from the OS when login as oracle user on Linux.

The file ".bash_profile" for oracle user is :

PATH=/home/oracle/product/10.1.0/db_1/bin:$HOME/bin:/usr/bin:.:$PATH
export $PATH
unset USERNAME
ORACLE_HOME=/home/oracle/product/10.1.0/db_1
ORACLE_BASE=/home/oracle
ORABIN=/home/oracle/product/10.1.0/db_1/bin
ORACLE_SID=OCEAT
LD_LIBRARY_PATH=$ORACLE_HOME/lib
TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_BASE ORACLE_SID ORACLE_HOME ORABIN LD_LIBRARY_PATH TNS_ADMIN NLS_LANG PATH


But when login as Baldo (another linux account) I can't execute SQLPLUS command .
I get error " command not found "

the ".bash_profile" file for Baldo user is :


ORACLE_HOME=/home/oracle/product/10.1.0/db_1
PATH=$ORACLE_HOME/bin:$HOME/bin:/usr/bin:.:$PATH
export $PATH

May be I missed something in config files ?


Help thanks
Re: SQLPLUS NOT FOUND [message #310596 is a reply to message #310594] Tue, 01 April 2008 14:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>May be I missed something in config files ?
V10 oracle is not intended to be used on the local database server system by a user other than "oracle".
Default protection masks preclude it.
It will work if you use SQL*Net instead of local access.

[Updated on: Tue, 01 April 2008 14:45] by Moderator

Report message to a moderator

Re: SQLPLUS NOT FOUND [message #310602 is a reply to message #310594] Tue, 01 April 2008 14:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You missed to export ORACLE_HOME.
And you have to export PATH and not $PATH.

Regards
Michel
Re: SQLPLUS NOT FOUND [message #310604 is a reply to message #310596] Tue, 01 April 2008 14:51 Go to previous messageGo to next message
mauric
Messages: 4
Registered: March 2008
Junior Member
I agree, but you can change that.

just run this script:

$ORACLE_HOME/install/changePerm.sh

Mauric
Re: SQLPLUS NOT FOUND [message #310708 is a reply to message #310604] Wed, 02 April 2008 02:40 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

But when login as Baldo (another linux account) I can't execute SQLPLUS command .
I get error " command not found "



Of course, the is no "SQLPLUS" command, only a "sqlplus" command.

But we don't know which of the two you really uses, since you just described what you were doing.

Next time, better post the relevant parts of the session as it is, that way there is no chance of such misunderstandings.
Re: SQLPLUS NOT FOUND [message #310749 is a reply to message #310604] Wed, 02 April 2008 05:00 Go to previous messageGo to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
mauric wrote on Tue, 01 April 2008 21:51
I agree, but you can change that.

just run this script:

$ORACLE_HOME/install/changePerm.sh

Mauric


Thanks for reply.
where can I find changePerm.sh ?

there no such file in my "$ORACLE_HOME/install/" directory
Re: SQLPLUS NOT FOUND [message #310759 is a reply to message #310749] Wed, 02 April 2008 05:42 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
First check:
Michel Cadot wrote on Tue, 01 April 2008 21:50
You missed to export ORACLE_HOME.
And you have to export PATH and not $PATH.

Regards
Michel


Previous Topic: V$sysstat
Next Topic: character set conversion
Goto Forum:
  


Current Time: Wed Dec 11 23:08:48 CST 2024