ITPub博客

首页 > 数据库 > Oracle > Oracle 11.2.0.4 RAC $ORACLE_HOME/bin/oracle权限不对导致无法启动实例

Oracle 11.2.0.4 RAC $ORACLE_HOME/bin/oracle权限不对导致无法启动实例

原创 Oracle 作者:fjzcau 时间:2015-12-03 11:43:35 0 删除 编辑

  1. [oracle@ypdb02 ~]$ sqlplus / as sysdba

  2. SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 3 11:29:29 2015

  3. Copyright (c) 1982, 2013, Oracle. All rights reserved.

  4. Connected to an idle instance.

  5. SQL> startup
  6. ORA-01078: failure in processing system parameters
  7. ORA-01565: error in identifying file '+DATA_DG/ypdb/spfileypdb.ora'
  8. ORA-17503: ksfdopn:10 Failed to open file +DATA_DG/ypdb/spfileypdb.ora
  9. ORA-12547: TNS:lost contact

  10. ********************************************************************************
  11. 排查:

  12. --检查ASM实例运行情况
  13. [grid@ypdb02 ~]$ srvctl status asm -n ypdb02
  14. ASM 正在 ypdb02 上运行

  15. --磁盘DATA磁盘有没有MOUNT
  16. [grid@ypdb02 ~]$ sqlplus / as sysdba

  17. SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 3 11:34:22 2015

  18. Copyright (c) 1982, 2013, Oracle. All rights reserved.

  19. Connected to:
  20. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  21. With the Real Application Clusters and Automatic Storage Management options

  22. SQL> select name,free_mb from v$asm_diskgroup;

  23. NAME FREE_MB
  24. ------------------------------ ----------
  25. DATA_DG 404878
  26. OCR_DG 2146


  27. --查看实例1上的oracle权限
  28. [root@ypdb01 ~]# ll /oracle/product/11.2.0/db_1/bin/oracle
  29. -rwsr-s--x 1 oracle asmadmin 239811987 12月 2 17:54 /oracle/product/11.2.0/db_1/bin/oracle

  30. --查看实例2上的oracle权限,发现权限不对。
  31. [grid@ypdb02 ~]$ ls -l $ORACLE_HOME/bin/oracle
  32. -rwxr-x--x 1 grid oinstall 209914479 12月 1 16:14 /oracle/11.2.0/grid/bin/oracle

  33. --更改权限
  34. [grid@ypdb02 ~]$ chmod 6751 $ORACLE_HOME/bin/oracle

  35. [grid@ypdb02 ~]$ ls -l $ORACLE_HOME/bin/oracle
  36. -rwsr-s--x 1 grid oinstall 209914479 12月 1 16:14 /oracle/11.2.0/grid/bin/oracle


  37. --再次启动
  38. SQL> startup
  39. ORACLE instance started.

  40. Total System Global Area 4275781632 bytes
  41. Fixed Size 2260088 bytes
  42. Variable Size 1442841480 bytes
  43. Database Buffers 2818572288 bytes
  44. Redo Buffers 12107776 bytes
  45. Database mounted.
  46. Database opened.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22661144/viewspace-1852317/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 积极的暗示
请登录后发表评论 登录
全部评论

注册时间:2011-04-03

  • 博文量
    209
  • 访问量
    490627