11gR2 syaasm連線錯誤

warehouse發表於2012-10-20

需要在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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章