ITPub博客

首页 > 数据库 > Oracle > 11gR2 syaasm连接错误

11gR2 syaasm连接错误

原创 Oracle 作者:warehouse 时间:2012-10-20 22:07:29 0 删除 编辑

需要在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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    716
  • 访问量
    5088309