Oracle 11.2.0.4 RAC $ORACLE_HOME/bin/oracle許可權不對導致無法啟動例項

fjzcau發表於2015-12-03
Oracle

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

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

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

  7. Connected to an idle instance.

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

  15. ********************************************************************************
  16. 排查：

  18. --檢查ASM例項執行情況
  19. [grid@ypdb02 ~]$ srvctl status asm -n ypdb02
  20. ASM 正在 ypdb02 上執行

  22. --磁碟DATA磁碟有沒有MOUNT
  23. [grid@ypdb02 ~]$ sqlplus / as sysdba

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

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

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

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

  35. NAME FREE_MB
  36. ------------------------------ ----------
  37. DATA_DG 404878
  38. OCR_DG 2146


  41. --檢視例項1上的oracle許可權
  42. [root@ypdb01 ~]# ll /oracle/product/11.2.0/db_1/bin/oracle
  43. -rwsr-s--x 1 oracle asmadmin 239811987 12月 2 17:54 /oracle/product/11.2.0/db_1/bin/oracle

  45. --檢視例項2上的oracle許可權，發現許可權不對。
  46. [grid@ypdb02 ~]$ ls -l $ORACLE_HOME/bin/oracle
  47. -rwxr-x--x 1 grid oinstall 209914479 12月 1 16:14 /oracle/11.2.0/grid/bin/oracle

  49. --更改許可權
  50. [grid@ypdb02 ~]$ chmod 6751 $ORACLE_HOME/bin/oracle

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


  56. --再次啟動
  57. SQL> startup
  58. ORACLE instance started.

  60. Total System Global Area 4275781632 bytes
  61. Fixed Size 2260088 bytes
  62. Variable Size 1442841480 bytes
  63. Database Buffers 2818572288 bytes
  64. Redo Buffers 12107776 bytes
  65. Database mounted.
  66. Database opened.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22661144/viewspace-1852317/，如需轉載，請註明出處，否則將追究法律責任。

相關文章