Infrastructure Software

You can find it in your ORACLE_HOME\bin Further: it´s easy to set your enviroment variables in your profile.

By the way: with which user do you have start sqlplus? (with oracle or another user?)

Regards,
B

I use root account

oracle OS user should have all needed environment variables set within its profile, .bash_profile if you use bash.

You shouldn't run sqlplus as root, you should do it as oracle user instead.

If you, for any reason, need to do it as root, then you could run the oracle's profile before, e.g.

# . <oracle's home directory>/.bash_profile
# sqlplus .........

ok, now I use oracle to login, when I run ./sqlplus in bin directory it said the
following:

bash-3.00$./sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may nedd to set ORACLE_HOME to your Oracle software directory

I use oracle XE for Compiere, when I run RUN_ImportCompiere.sh it said:

..............
...............
...............
sqlplus haha/haha@xe @/pot/Compiere2/utils/oracle/AfterImport.sql
oracle/ImportCompiere.sh: line 46: sqlplus: command not found

Seems that you need some environment variable settings. What's the content of oracle's .bash_profile ?

Sorry, where can find the .bash_profile on oracle user ?

Thanks

Sorry, I type ls -la cannot see the .bash_profile

Then create it with this line :

source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh

logout oracle, logon again and retry.

You mean manual create the .bash_profile and then create this sourace line into
.bash_profile?


Thanks !

Yes, use any editor (vi ?), insert that line and save the file. Or you can also do (as oracle user) :

$ cd
$ echo "source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" > .bash_profile

then logout oracle and logon again.

sqlplus command not found

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

do you have this file on your system ? if so, what's its content ?

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export NLS_LANG
PATH=$ORACLE_HOME/bin:$PATH
export PATH
if [ $?LD_LIBRARY_PATH ]
then
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=$ORACLE_HOME/lib
fi
export LD_LIBRARY_PATH

That's correct, so it should work, if you didn't make any mistake....

Try it at command line :

$ source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
$ sqlplus .......

Enter user-name

I think it correctly

ok.... I enter a mistake .... so now I can use the sqlplus command


Thanks you very much !!!!!!!

Hi!
Run this on your system:

find / -name sqlplus -print

On the output of this command you should have some lines telling you where are the sqlplus command.
By example, imagine that the output has something like this:
/u01/app/oracle/product/database/bin/sqlplus
Then, execute this:

ORACLE_HOME=/u01/app/oracle/product/database
export ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin
export PATH

Then try to run sqlplus again.
Tell me if this worked for you.

Greetings!

HeCSa.

Thank you for this topic!