patternMinor
bash: sqlplus: command not found
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 ?
This following is error message:
$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1This following is error message:
$ sqlplus
bash: sqlplus: command not foundSolution
Edit your Unix
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
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_PATHYou'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_PATHContext
StackExchange Database Administrators Q#112702, answer score: 3
Revisions (0)
No revisions yet.