UNIX for Advanced & Expert Users

Hi Friends ,
I need to connect to Oracle using sqlplus and it says that sqlplus is not found . I need to check if Oracle is running or not .is there any command to check if oracle is running ?
Please help
Thanks in advance
Veera

Your error means it cannot find the sqlplus executable. It has nothing to do with Oracle being started.

If Oracle is on your system, then ORACLE_HOME has to be defined. If it is not, get your sysadmin to put into /etc/profile

Then change your path like this in your personal profile:

Code:

export PATH=$PATH:$ORACLE_HOME/bin

After you excute you new profile, the commabnd

Code:

which sqlplus

will show a "path/to/oracle/sqlplus"

Hi Friend,
thanks a lot for your reply .it works
bye
Veera