本地机器上安装了xshell,想连接服务器的Oracle数据库,有一种很简单的办法!直接修改 ~ 目录下的.bash_profile配置即可!
(1)首先用xshell登录到服务器,切换到~目录:cd ~
(2)输入命令:vim .bash_profile
(3)打开.bash_profile文件后,添加以下环境路径配置即可:
# .bash_profile
2
3 # Get the aliases and functions
4 if [ -f ~/.bashrc ]; then
5 . ~/.bashrc
6 fi
7
8 # User specific environment and startup programs
9
10 PATH=$PATH:$HOME/bin
11
12 export PATH
13
14 ORACLE_SID=satpdb; export ORACLE_SID
15 ORACLE_BASE=/opt/app/oracle; export ORACLE_BASE
16 ORACLE_HOME=/opt/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME
17 PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin; export PATH
18 iLD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
19
20 PATH=$PATH:$HOME/bin