上午给一台应用服务器配置oracle客户端,复制oracle客户端压缩包并解压,配置环境变量后,测试可用就甩给维护人员了,下午收到通知sqlplus用不了!用不了!用不了!
登陆服务器
-bash-4.1$ id
uid=701(oracle) gid=700(dba) groups=700(dba)
-bash-4.1$
-bash-4.1$
-bash-4.1$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
#export ORACLE_PATH=$ORACLE_BASE/common/oracle/aql:.:$ORACLE_HOME/rdbms/admin
export PATH=$ORACLE_HOME/bin/:$PATH
export TEMP=/tmp
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
-bash-4.1$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 10 15:12:57 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL>
可以用啊,没有问题,与维护人员一番沟通后,了解到业务账号配置了相关环境变量,sqlplus就是无响应。
切换账号一窥究竟
-bash-4.1$ id
uid=701(masaike) gid=700(masaike) groups=700