SQLPLUS NOT FOUND [message #310594] |
Tue, 01 April 2008 14:40 |
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 |
|
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 #310708 is a reply to message #310604] |
Wed, 02 April 2008 02:40 |
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 |
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 |
|
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
|
|
|
|