topic Re: sqlplus:command not found-------- help :( in Operating System - HP-UX

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

DnD_1 — Thu, 19 Jun 2008 11:01:27 GMT

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 ?

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

Kenan Erdey — Thu, 19 Jun 2008 11:09:07 GMT

hi,

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

Kenan.

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

Pete Randall — Thu, 19 Jun 2008 11:19:41 GMT

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

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

DnD_1 — Thu, 19 Jun 2008 11:21:48 GMT

aah thanks !!!

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

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

DnD_1 — Thu, 19 Jun 2008 11:22:34 GMT

wondering how to set the path ?

sorry, i just learn oracle 2 days ago :(

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

DnD_1 — Thu, 19 Jun 2008 11:26:32 GMT

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

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

Steven E. Protter — Thu, 19 Jun 2008 11:27:04 GMT

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

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

DnD_1 — Thu, 19 Jun 2008 12:05:08 GMT

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 :(

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

Yogeeraj_1 — Thu, 19 Jun 2008 16:41:37 GMT

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

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

DnD_1 — Thu, 19 Jun 2008 17:31:42 GMT

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