General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
DnD_1
Regular Advisor

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

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 ?
9 REPLIES
Kenan Erdey
Honored Contributor
Solution

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

hi,

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

Kenan.
Computers have lots of memory but no imagination
Pete Randall
Outstanding Contributor

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

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

Pete
DnD_1
Regular Advisor

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

aah thanks !!!

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

DnD_1
Regular Advisor

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

wondering how to set the path ?

sorry, i just learn oracle 2 days ago :(
DnD_1
Regular Advisor

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

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
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
DnD_1
Regular Advisor

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

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
Honored Contributor

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

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

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
DnD_1
Regular Advisor

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

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