平台: OEL 5.7 + Oracle11.2.0.3.0
通过dbca方式, 在基于ASM存储建库时, 如有有类似如下错误:
ORA-12547: TNS:lost contact
CRS-5017: The resource action "ora.seven.db start" encountered the following error:
ORA-12547: TNS:lost contact
CRS-2674: Start of 'ora.seven.db' on 'cmcc' failed
ORA-12547: TNS:lost contact
先oerr
[oracle@cmcc ~]$ oerr ora 12547
12547, 00000, "TNS:lost contact"
// *Cause: Partner has unexpectedly gone away, usually during process
// startup.
// *Action: Investigate partner application for abnormal termination. On an
// Interchange, this can happen if the machine is overloaded.
12547, 00000, "TNS:lost contact"
// *Cause: Partner has unexpectedly gone away, usually during process
// startup.
// *Action: Investigate partner application for abnormal termination. On an
// Interchange, this can happen if the machine is overloaded.
在网上搜索资料整理后知道原因在$ORACLE_HOME/bin/oracle文件的权限和属主问题：
oracle和grid用户下$ORACLE_HOME/bin/oracle的权限应为"-rwsr-s--x"且属于oinstall组:（发现oracle用户下的$ORACLE_HOME/bin/oracle 文件属组在创建数据库时莫名变更为asmadmin且权限也被更改为“-r-xr-s--x”）
[oracle@cmcc bin]$ ls -ltr $ORACLE_HOME/bin/oracle
-rwxrwsr-x 1 oracle asmadmin 173515991 Dec 17 12:28 /s01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/oracle
[grid@cmcc bin]$ ls -ltr $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 152462814 Dec 17 10:46 /g01/grid/app/grid/product/11.2.0/grid/bin/oracle
更改oracle文件为oinstall组：
chmod 6751 $ORACLE_HOME/bin/oracle
chown oracle:oinstall $ORACLE_HOME/bin/oracle
重新安装，OK，安装database成功；
--------------------------------------------------------------------------------------------
版权所有，转载请注明作者及原文链接，否则追究法律责任!
QQ: 584307876
作者: Seven
原文链接: http://blog.csdn.net/sunjiapeng/article/details/8313998
邮箱: seven_ginna@foxmail.com