Home » Infrastructure » Linux » cannot run the "sqlplus" (merged)
cannot run the "sqlplus" (merged) [message #128912] Thu, 21 July 2005 03:47 Go to next message
artsx
Messages: 21
Registered: June 2005
Location: Armenia
Junior Member

####################################
[oracle@ora1 ~]$ sqlplus
bash: sqlplus: command not found
[oracle@ora1 ~]$
####################################

how can I run it?

and other utilities of oracle?
I'm new in linux and in oracle...

plz help, e-mail me : u@freenet.am
Re: cannot run the "sqlplus" [message #128968 is a reply to message #128912] Thu, 21 July 2005 07:14 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

Append the PATh variable and add $ORACLE_HOME/bin directory to it

Regds
Girish
Re: cannot run the "sqlplus" [message #129198 is a reply to message #128968] Fri, 22 July 2005 07:40 Go to previous messageGo to next message
artsx
Messages: 21
Registered: June 2005
Location: Armenia
Junior Member

how to add it, can you tell me or show me an example adding it?
Re: cannot run the "sqlplus" [message #129280 is a reply to message #129198] Sat, 23 July 2005 01:40 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi


echo $PATH

PATH=$PATH:$ORACLE_HOME/bin

export $PATH

Regds
Girish
Re: cannot run the "sqlplus" [message #202156 is a reply to message #129280] Wed, 08 November 2006 07:27 Go to previous messageGo to next message
sivasiva2k
Messages: 7
Registered: June 2005
Junior Member
Hi Girish,
I tried the procedure which you have provided to start the sqlplus, But still I am having the same problem of command not found. Can you please help me.

[oracle@tkumar db_1]$ echo $PATH

[oracle@tkumar db_1]$ PATH=$PATH:$ORACLE_HOME/bin
[oracle@tkumar db_1]$ export $PATH
bash: export: `:/bin': not a valid identifier
[oracle@tkumar db_1]$ pwd
/u01/app/oracle/product/10.2.0/db_1
[oracle@tkumar db_1]$ sqlplus
bash: sqlplus: command not found

I have installed the Orale 10gR2, in Redhat Linux 4 AS. I am able to log-in using the isqlplus and em.

Any help would be appreciated

Waiting for your reply.

Re: cannot run the "sqlplus" [message #202181 is a reply to message #202156] Wed, 08 November 2006 10:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Thats right.
Quote:
[oracle@tkumar db_1]$ PATH=$PATH:$ORACLE_HOME/bin

But you have not yet defined ORACLE_HOME!.

First define ORACLE_HOME and then include it in PATH.
export ORACLE_HOME=/this/this/that
export PATH=$PATH:$ORACLE_HOME/bin

Re: cannot run the "sqlplus" [message #202226 is a reply to message #128912] Wed, 08 November 2006 17:57 Go to previous messageGo to next message
sivasiva2k
Messages: 7
Registered: June 2005
Junior Member
Hi Mahesh,
Yes it works. Thanks for your immediate response.

I am herewith posting my command sequence, so that it will be helpful for the newbies like me.

But still,
oracle@tkumar db_1]$ export $PATH
bash: export: `/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/tkumar/bin:/bin:/u01/app/oracle/product/10.2.0/db_1/bin': not a valid identifier

export command is with error message even if sqlplus works? - Is that OK??


MyCommand:

[oracle@tkumar db_1]$ pwd
/u01/app/oracle/product/10.2.0/db_1
[oracle@tkumar db_1]$ ls
admin diagnostics ldap opmn root.sh
assistants flash_recovery_area lib oracore root.sh.old
bin has log oraInst.loc slax
cdata hs md ord sqlj
cfgtoollogs install mesg oui sqlplus
clone install.platform mgw owm srvm
config inventory network perl sysman
crs javavm nls plsql tkumar.com_emsbp
css jdbc oc4j precomp uix
ctx jdk odbc racg wwg
dbs jlib olap rdbms xdk
demo jre OPatch relnotes
[oracle@tkumar db_1]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
[oracle@tkumar db_1]$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/tkumar/bin:/bin
[oracle@tkumar db_1]$ PATH=$PATH:$ORACLE_HOME/bin
[oracle@tkumar db_1]$ export $PATH
bash: export: `/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/tkumar/bin:/bin:/u01/app/oracle/product/10.2.0/db_1/bin': not a valid identifier
[oracle@tkumar db_1]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 9 07:47:45 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: scott
Re: cannot run the "sqlplus" [message #202237 is a reply to message #202226] Wed, 08 November 2006 19:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
export myvariable=someting #correct
echo $myvariable #correct
export $myvariable=someting #wrong.
Re: cannot run the "sqlplus" [message #202684 is a reply to message #202237] Fri, 10 November 2006 23:32 Go to previous messageGo to next message
sivasiva2k
Messages: 7
Registered: June 2005
Junior Member
Yes,
it works without any error message.
Thanks
Re: cannot run the "sqlplus" [message #272100 is a reply to message #202226] Thu, 04 October 2007 01:08 Go to previous messageGo to next message
andrewskir
Messages: 6
Registered: October 2007
Junior Member
Hey i tried with ur steps but still i am not able to execute the command. this is the steps followed

bash-2.05b$ export ORACLE_HOME=/SLOTS/slot02/oracle/db/tech_st/10.2.0/dbs
bash-2.05b$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oemora/EM/ems/oui/install
bash-2.05b$ PATH=$PATH:$ORACLE_HOME/bin
bash-2.05b$ export $PATH
bash: export: `/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oemora/EM/ems/oui/install:/SLOTS/slot02/oracle/db/tech_st/10.2.0 /dbs/bin': not a valid identifier
bash-2.05b$ sqlplus
bash: sqlplus: command not found

can anyone give suggestion whats wrong in this?
Not able to execute sqlplus command in linux [message #272101 is a reply to message #128912] Thu, 04 October 2007 01:11 Go to previous messageGo to next message
andrewskir
Messages: 6
Registered: October 2007
Junior Member
few days back i tried with command 'sqlplus' at that time it was fine but when i tried after some days, its not working. i dont know what is the reason? so can anyone help me how to setup 'sqlplus command' in the linux box
Re: Not able to execute sqlplus command in linux [message #272118 is a reply to message #272101] Thu, 04 October 2007 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post "env|egrep '(ORA|PATH|TNS|LIB)'|sort"
Post "which sqlplus"

Regards
Michel
Re: cannot run the "sqlplus" [message #272120 is a reply to message #272100] Thu, 04 October 2007 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See answer in the topic you created for this.

Regards
Michel
Re: cannot run the "sqlplus" [message #272181 is a reply to message #272120] Thu, 04 October 2007 03:28 Go to previous messageGo to next message
andrewskir
Messages: 6
Registered: October 2007
Junior Member
now i can able to execute SQLPLUS Command. But for every login i need to follow the above steps.Is there anyway to set that value as global?
Re: cannot run the "sqlplus" [message #272188 is a reply to message #272181] Thu, 04 October 2007 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which steps? Setting environment variables?

Regards
Michel
Re: cannot run the "sqlplus" [message #272191 is a reply to message #272188] Thu, 04 October 2007 03:45 Go to previous messageGo to next message
andrewskir
Messages: 6
Registered: October 2007
Junior Member
yep
Re: cannot run the "sqlplus" [message #272194 is a reply to message #272191] Thu, 04 October 2007 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put them in your .profile or the like.

Regards
Michel
Re: cannot run the "sqlplus" [message #272199 is a reply to message #272194] Thu, 04 October 2007 03:55 Go to previous messageGo to next message
andrewskir
Messages: 6
Registered: October 2007
Junior Member
i am not able to find the .profile file even by using ls -al, then how to?
Re: cannot run the "sqlplus" [message #272222 is a reply to message #272199] Thu, 04 October 2007 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
it depends on your shell.
.profile, .bash_profile, .csh, .sh, ....
If you don't have any, then create it in your home directory.

Regards
Michel


Re: cannot run the "sqlplus" [message #272411 is a reply to message #272222] Fri, 05 October 2007 00:03 Go to previous message
andrewskir
Messages: 6
Registered: October 2007
Junior Member
Thanks man its working now, thanks for kind suggestion.
Previous Topic: Linux Setting For Oracle 9i
Next Topic: TOAD on linux
Goto Forum:
  


Current Time: Thu Mar 28 07:25:00 CDT 2024