sqlplus:command not found-------- help :(

[DnD_1]

Hi all,

I instaleld the Oracle 9i in our HP UX yesterday, and tried to run the command sqlplus, but i got this error

$ sqlplus
sh: sqlplus: not found.

the path

$ echo $PATH
/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/ipf/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/usr/bin/X11:/opt/resmon/bin:/usr/contrib/kwdb/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/graphics/common/bin:/usr/sbin/diag/contrib:/opt/sfm/bin:/opt/upgrade/bin:/opt/sec_mgmt/bastille/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/mozilla:/opt/perl/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/gwlm/bin:/usr/contrib/bin/X11:/opt/ignite/bin:/opt/swa/bin

$ echo $ORACLE_HOME

and the environment,

$ env | grep -i oracle
LOGNAME=oracle
HOME=/home/oracle

during installation, i set the ORACLE_HOME variable in /opt/oracle...

Please, any one help ?

[Kenan Erdey · Accepted solution]

hi,

sqlplus is in your $ORACLE_HOME/bin directory. check it's in your path.

Kenan.

[Pete Randall]

Your PATH contains no references to oracle at all. You need to add the appropriate locations into your PATH and set all the other appropriate environment variables as well.


Pete

[DnD_1]

aah thanks !!!

i run the ./sqlplus in bin...but it prompt for the username and password ? i didnt set it yet thought..

[DnD_1]

wondering how to set the path ?

sorry, i just learn oracle 2 days ago :(

[DnD_1]

oh yeah, i managed to login as sysdba , followed the instructions from the guide.

but when i issue STARTUP

it prompt up sltln:environment variable cannot be evaluated..

do i need to set the environment var ? how to do that ? pls someone teach me :D

[Steven E. Protter]

Shalom,

A closer look at the ORACLE installation guide would have avoided some of this.

It tells you about the PATH and what variables need to be set to make sqlplus work correctly.

SEP

[DnD_1]

i tried to follow the first configuring new database, and i really have this error.. ;(

$ ./oraenv
ORACLE_SID = [oracle] ? CG
./oraenv[65]: dbhome: not found.
ORACLE_HOME = [] ? /opt/oracle
./oraenv[104]: Syntax error at line 104 :

and when i do the db startup,

Connected.
SQL> STARTUP
ORA-07217: sltln: environment variable cannot be evaluated.

help :(

[Yogeeraj_1]

hi,

try the following:
export ORACLE_HOME=/
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=


then try to run your sqlplus commands.

what do you get now? what other environment variable have you set?

revert!
kind regards
yogeeraj

[DnD_1]

hi,

i cant access to the server right now..

but if the command is working, where should i add the command ? which file ?

sorry for those question, i just starting to learn oracle 2 days ago :D