需要在grid用户的.bash_profile下增加
ORACLE_HOME=$GRID_HOME就可以连接上
[@more@][root@xys ~]# su - grid
[grid@xys ~]$ sqlplus / as sysasm
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
[grid@xys ~]$ vi .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
GRID_BASE=/opt/grid
GRID_HOME=$GRID_BASE/product/11.2.0/grid
ORACLE_SID=+ASM
ORACLE_HOME=$GRID_HOME
export GRID_BASE GRID_HOME ORACLE_SID ORACLE_HOME
PATH=$GRID_HOME/bin:$PATH
".bash_profile" 24L, 370C written
[grid@xys ~]$ exit
logout
[root@xys ~]# su - grid
[grid@xys ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 28 07:38:49 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1059641/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1059641/