HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

bash: sqlplus: command not found

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
foundcommandsqlplusnotbash

Problem

I have installed oracle correctly and also set ORACLE_HOME correctly on server,still sqlplus command is not working in my PC while it is working in others PC. I think I missed out some important step can you tell me what should I do ?

$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1


This following is error message:

$ sqlplus
bash: sqlplus: command not found

Solution

Edit your Unix bash config file ~/.bashrc or ~/.profile, and add the following to it:

export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH


You'll need to open a new shell to see the changes take effect.

That will modify the setting for just the current user. If you want to make the changes applicable to all users system-wide, put the above lines in /etc/profile or /etc/bashrc.

Code Snippets

export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Context

StackExchange Database Administrators Q#112702, answer score: 3

Revisions (0)

No revisions yet.