日期:2014-05-16 浏览次数:20580 次
oracle和grid用户下$ORACLE_HOME/bin/oracle的权限是否为"-rwsr-s--x"且属于oinstall组:
[oracle@rtest bin]$ ls -ltr $ORACLE_HOME/bin/oracle
-r-xrws--x 1 oracle asmadmin 232399473 Jun 20 08:38 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
[grid@rtest bin]$ ls -ltr $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 203972955 Oct 23 11:25 /u01/app/grid/product/11.2.0/grid/bin/oracle
2、更改组合权限,grid用户的配置是正确,接下来更改oracle用户的组合权限
[oracle@rtest bin]$ chown oracle:oinstall $ORACLE_HOME/bin/oracle
[oracle@rtest bin]$ ls -ltr $ORACLE_HOME/bin/oracle
-rwxr-x--x 1 oracle oinstall 232399473 Jun 20 08:38 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
[oracle@rtest bin]$ chmod 6751 $ORACLE_HOME/bin/oracle
[oracle@rtest bin]$ ls -ltr $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 232399473 Jun 20 08:38 /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
3、分别查看oracle和grid用户的环境变量设置,分别添加export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
首先来添加oracle用户:
[oracle@rtest ~]$ 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
ORACLE_BASE=/u01/app/oracle
ORACLE_SID=test0924
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_SID ORACLE_HOME PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
stty erase ^h
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
其次来添加grid用户的:
[grid@rtest ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/grid/product/11.2.0/grid
export ORACLE_SID=+ASM
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
PATH=$ORACLE_HOME/bin:$PATH
export PATH
再安装时即可以安装成功
[grid@rtest bin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE rtest
ora....ER.lsnr ora....er.type ONLINE ONLINE rtest
ora....VERY.dg ora....up.type ONLINE ONLINE rtest
ora.asm ora.asm.type O