Bo's Oracle Station

查看: 3801|回复: 0

剩余课程

[复制链接]

75

主题

115

帖子

2772

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
2772
发表于 2018-11-23 08:52:02 | 显示全部楼层 |阅读模式
课程第59次(2018-11-23星期五)

课程第60次(2018-11-24星期六上午)
  1. [root@station25 ~]# uname -a
  2. Linux station25.example.com 3.8.13-118.11.2.el6uek.x86_64 #2 SMP Wed Sep 21 11:37:57 PDT 2016 x86_64 x86_64 x86_64 GNU/Linux
  3. [root@station25 ~]# su - grid
  4. [grid@station25 ~]$ asmcmd
  5. ASMCMD> lsdg
  6. State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
  7. MOUNTED  NORMAL  N         512   4096  1048576     39344    14186             4918            4634              0             Y  DATA/
  8. MOUNTED  EXTERN  N         512   4096  1048576     14754     5329                0            5329              0             N  FRA/
  9. ASMCMD> lsdsk -G data
  10. Path
  11. ORCL:RACDISK1
  12. ORCL:RACDISK2
  13. ORCL:RACDISK3
  14. ORCL:RACDISK4
  15. ORCL:RACDISK5
  16. ORCL:RACDISK6
  17. ORCL:RACDISK7
  18. ORCL:RACDISK8
  19. ASMCMD> lsdsk -G fra
  20. Path
  21. ORCL:RACDISK10
  22. ORCL:RACDISK11
  23. ORCL:RACDISK9
  24. ASMCMD> exit
  25. [grid@station25 ~]$ exit
  26. logout
  27. [root@station25 ~]# lsmod | grep oracleasm
  28. oracleasm              53591  1
  29. [root@station25 ~]# su - gri
  30. su: 用户gri 不存在
  31. [root@station25 ~]# su - grid
  32. \[grid@station25 ~]$ asmcmd dsget
  33. parameter:
  34. profile:
  35. [grid@station25 ~]$ crsctl stop crs
  36. CRS-4563: Insufficient user privileges.

  37. CRS-4000: Command Stop failed, or completed with errors.
  38. [grid@station25 ~]$ exit
  39. logout
  40. [root@station25 ~]# . oraenv
  41. ORACLE_SID = [root] ? +ASM1
  42. The Oracle base has been set to /u01/app/grid
  43. [root@station25 ~]# crsctl stop crs
  44. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'station25'
  45. CRS-2673: Attempting to stop 'ora.crsd' on 'station25'
  46. CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'station25'
  47. CRS-2673: Attempting to stop 'ora.c02orcl.db' on 'station25'
  48. CRS-2673: Attempting to stop 'ora.mgmtdb' on 'station25'
  49. CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'station25'
  50. CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'station25'
  51. CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'station25'
  52. CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'station25'
  53. CRS-2673: Attempting to stop 'ora.oc4j' on 'station25'
  54. CRS-2673: Attempting to stop 'ora.cvu' on 'station25'
  55. CRS-2677: Stop of 'ora.cvu' on 'station25' succeeded
  56. CRS-2672: Attempting to start 'ora.cvu' on 'station26'
  57. CRS-2676: Start of 'ora.cvu' on 'station26' succeeded
  58. CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'station25' succeeded
  59. CRS-2673: Attempting to stop 'ora.scan2.vip' on 'station25'
  60. CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'station25' succeeded
  61. CRS-2673: Attempting to stop 'ora.scan1.vip' on 'station25'
  62. CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'station25' succeeded
  63. CRS-2673: Attempting to stop 'ora.station25.vip' on 'station25'
  64. CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'station25' succeeded
  65. CRS-2673: Attempting to stop 'ora.scan3.vip' on 'station25'
  66. CRS-2677: Stop of 'ora.scan2.vip' on 'station25' succeeded
  67. CRS-2672: Attempting to start 'ora.scan2.vip' on 'station26'
  68. CRS-2677: Stop of 'ora.scan3.vip' on 'station25' succeeded
  69. CRS-2672: Attempting to start 'ora.scan3.vip' on 'station26'
  70. CRS-2677: Stop of 'ora.scan1.vip' on 'station25' succeeded
  71. CRS-2672: Attempting to start 'ora.scan1.vip' on 'station26'
  72. CRS-2676: Start of 'ora.scan2.vip' on 'station26' succeeded
  73. CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'station26'
  74. CRS-2677: Stop of 'ora.station25.vip' on 'station25' succeeded
  75. CRS-2672: Attempting to start 'ora.station25.vip' on 'station26'
  76. CRS-2676: Start of 'ora.scan3.vip' on 'station26' succeeded
  77. CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'station26'
  78. CRS-2676: Start of 'ora.scan1.vip' on 'station26' succeeded
  79. CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'station26'
  80. CRS-2677: Stop of 'ora.mgmtdb' on 'station25' succeeded
  81. CRS-2677: Stop of 'ora.c02orcl.db' on 'station25' succeeded
  82. CRS-2673: Attempting to stop 'ora.FRA.dg' on 'station25'
  83. CRS-2673: Attempting to stop 'ora.DATA.dg' on 'station25'
  84. CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'station25'
  85. CRS-2676: Start of 'ora.station25.vip' on 'station26' succeeded
  86. CRS-2677: Stop of 'ora.DATA.dg' on 'station25' succeeded
  87. CRS-2677: Stop of 'ora.MGMTLSNR' on 'station25' succeeded
  88. CRS-2672: Attempting to start 'ora.MGMTLSNR' on 'station26'
  89. CRS-2677: Stop of 'ora.FRA.dg' on 'station25' succeeded
  90. CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'station26' succeeded
  91. CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'station26' succeeded
  92. CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'station26' succeeded
  93. CRS-2676: Start of 'ora.MGMTLSNR' on 'station26' succeeded
  94. CRS-2672: Attempting to start 'ora.mgmtdb' on 'station26'
  95. CRS-2677: Stop of 'ora.oc4j' on 'station25' succeeded
  96. CRS-2672: Attempting to start 'ora.oc4j' on 'station26'
  97. CRS-2676: Start of 'ora.oc4j' on 'station26' succeeded
  98. CRS-2676: Start of 'ora.mgmtdb' on 'station26' succeeded
  99. CRS-2673: Attempting to stop 'ora.asm' on 'station25'
  100. CRS-2677: Stop of 'ora.asm' on 'station25' succeeded
  101. CRS-2673: Attempting to stop 'ora.ons' on 'station25'
  102. CRS-5014: Agent "ORAAGENT" timed out starting process "/u01/app/12.1.0/grid/opmn/bin/onsctli" for action "stop": details at "(:CLSN00009:)" in "/u01/app/grid/diag/crs/station25/crs/trace/crsd_oraagent_grid.trc"
  103. CRS-5017: The resource action "ora.ons stop" encountered the following error:
  104. (:CLSN00009:)Command Aborted. For details refer to "(:CLSN00108:)" in "/u01/app/grid/diag/crs/station25/crs/trace/crsd_oraagent_grid.trc".
  105. CRS-2675: Stop of 'ora.ons' on 'station25' failed
  106. CRS-2679: Attempting to clean 'ora.ons' on 'station25'
  107. CRS-2681: Clean of 'ora.ons' on 'station25' succeeded
  108. CRS-2673: Attempting to stop 'ora.net1.network' on 'station25'
  109. CRS-2677: Stop of 'ora.net1.network' on 'station25' succeeded
  110. CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'station25' has completed
  111. CRS-2677: Stop of 'ora.crsd' on 'station25' succeeded
  112. CRS-2673: Attempting to stop 'ora.storage' on 'station25'
  113. CRS-2673: Attempting to stop 'ora.mdnsd' on 'station25'
  114. CRS-2673: Attempting to stop 'ora.gpnpd' on 'station25'
  115. CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'station25'
  116. CRS-2677: Stop of 'ora.storage' on 'station25' succeeded
  117. CRS-2677: Stop of 'ora.drivers.acfs' on 'station25' succeeded
  118. CRS-2673: Attempting to stop 'ora.crf' on 'station25'
  119. CRS-2673: Attempting to stop 'ora.ctssd' on 'station25'
  120. CRS-2673: Attempting to stop 'ora.evmd' on 'station25'
  121. CRS-2673: Attempting to stop 'ora.asm' on 'station25'
  122. CRS-2677: Stop of 'ora.mdnsd' on 'station25' succeeded
  123. CRS-2677: Stop of 'ora.evmd' on 'station25' succeeded
  124. CRS-2677: Stop of 'ora.ctssd' on 'station25' succeeded
  125. CRS-2677: Stop of 'ora.gpnpd' on 'station25' succeeded
  126. CRS-2677: Stop of 'ora.crf' on 'station25' succeeded
  127. CRS-2677: Stop of 'ora.asm' on 'station25' succeeded
  128. CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'station25'
  129. CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'station25' succeeded
  130. CRS-2673: Attempting to stop 'ora.cssd' on 'station25'
  131. CRS-2677: Stop of 'ora.cssd' on 'station25' succeeded
  132. CRS-2673: Attempting to stop 'ora.gipcd' on 'station25'
  133. CRS-2677: Stop of 'ora.gipcd' on 'station25' succeeded
  134. CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'station25' has completed
  135. CRS-4133: Oracle High Availability Services has been stopped.
  136. [root@station25 ~]# asmcmd
  137. Connected to an idle instance.
  138. ASMCMD> afd_configure


  139. AFD-627: AFD distribution files found.
  140. AFD-636: Installing requested AFD software.
  141. AFD-637: Loading installed AFD drivers.
  142. AFD-9321: Creating udev for AFD.
  143. AFD-9323: Creating module dependencies - this may take some time.
  144. AFD-9154: Loading 'oracleafd.ko' driver.
  145. AFD-649: Verifying AFD devices.
  146. AFD-9156: Detecting control device '/dev/oracleafd/admin'.
  147. AFD-638: AFD installation correctness verified.
  148. Modifying resource dependencies - this may take some time.
  149. ASMCMD> ASMCMD> ASMCMD> afd_state
  150. ASMCMD-9526: The AFD state is 'LOADED' and filtering is 'DEFAULT' on host 'station25.example.com'
  151. ASMCMD> exit
  152. [root@station25 ~]# crsctl start crs -wait
  153. CRS-4123: Starting Oracle High Availability Services-managed resources
  154. CRS-2672: Attempting to start 'ora.mdnsd' on 'station25'
  155. CRS-2672: Attempting to start 'ora.evmd' on 'station25'
  156. CRS-2676: Start of 'ora.mdnsd' on 'station25' succeeded
  157. CRS-2676: Start of 'ora.evmd' on 'station25' succeeded
  158. CRS-2672: Attempting to start 'ora.gpnpd' on 'station25'
  159. CRS-2676: Start of 'ora.gpnpd' on 'station25' succeeded
  160. CRS-2672: Attempting to start 'ora.gipcd' on 'station25'
  161. CRS-2676: Start of 'ora.gipcd' on 'station25' succeeded
  162. CRS-2672: Attempting to start 'ora.cssdmonitor' on 'station25'
  163. CRS-2676: Start of 'ora.cssdmonitor' on 'station25' succeeded
  164. CRS-2672: Attempting to start 'ora.cssd' on 'station25'
  165. CRS-2672: Attempting to start 'ora.diskmon' on 'station25'
  166. CRS-2676: Start of 'ora.diskmon' on 'station25' succeeded
  167. CRS-2676: Start of 'ora.cssd' on 'station25' succeeded
  168. CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'station25'
  169. CRS-2672: Attempting to start 'ora.ctssd' on 'station25'
  170. CRS-2676: Start of 'ora.ctssd' on 'station25' succeeded
  171. CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'station25' succeeded
  172. CRS-2672: Attempting to start 'ora.asm' on 'station25'
  173. CRS-2676: Start of 'ora.asm' on 'station25' succeeded
  174. CRS-2672: Attempting to start 'ora.storage' on 'station25'
  175. CRS-2676: Start of 'ora.storage' on 'station25' succeeded
  176. CRS-2672: Attempting to start 'ora.crf' on 'station25'
  177. CRS-2676: Start of 'ora.crf' on 'station25' succeeded
  178. CRS-2672: Attempting to start 'ora.crsd' on 'station25'
  179. CRS-2676: Start of 'ora.crsd' on 'station25' succeeded
  180. CRS-6017: Processing resource auto-start for servers: station25
  181. CRS-2672: Attempting to start 'ora.net1.network' on 'station25'
  182. CRS-2676: Start of 'ora.net1.network' on 'station25' succeeded
  183. CRS-2672: Attempting to start 'ora.ons' on 'station25'
  184. CRS-2673: Attempting to stop 'ora.station25.vip' on 'station26'
  185. CRS-2677: Stop of 'ora.station25.vip' on 'station26' succeeded
  186. CRS-2672: Attempting to start 'ora.station25.vip' on 'station25'
  187. CRS-2676: Start of 'ora.station25.vip' on 'station25' succeeded
  188. CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'station25'
  189. CRS-2676: Start of 'ora.ons' on 'station25' succeeded
  190. CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'station26'
  191. CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'station26' succeeded
  192. CRS-2673: Attempting to stop 'ora.scan1.vip' on 'station26'
  193. CRS-2677: Stop of 'ora.scan1.vip' on 'station26' succeeded
  194. CRS-2672: Attempting to start 'ora.scan1.vip' on 'station25'
  195. CRS-2676: Start of 'ora.scan1.vip' on 'station25' succeeded
  196. CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'station25'
  197. CRS-2676: Start of 'ora.LISTENER.lsnr' on 'station25' succeeded
  198. CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'station25' succeeded
  199. CRS-2672: Attempting to start 'ora.c02orcl.db' on 'station25'
  200. CRS-2676: Start of 'ora.c02orcl.db' on 'station25' succeeded
  201. CRS-6016: Resource auto-start has completed for server station25
  202. CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
  203. CRS-4123: Oracle High Availability Services has been started.
  204. [root@station25 ~]# su - grid
  205. [grid@station25 ~]$ asmcmd afd_dsget
  206. AFD discovery string:
  207. [grid@station25 ~]$ asmcmd afd_scan
  208. [grid@station25 ~]$
复制代码

  1. [root@station25 ~]# fdisk -l

  2. Disk /dev/vda: 61.2 GB, 61203283968 bytes
  3. 16 heads, 63 sectors/track, 118588 cylinders
  4. Units = cylinders of 1008 * 512 = 516096 bytes
  5. Sector size (logical/physical): 512 bytes / 512 bytes
  6. I/O size (minimum/optimal): 512 bytes / 512 bytes
  7. Disk identifier: 0x0007cec8

  8.    Device Boot      Start         End      Blocks   Id  System
  9. /dev/vda1   *           3         612      307200   83  Linux
  10. Partition 1 does not end on cylinder boundary.
  11. /dev/vda2             612      103825    52019200   8e  Linux LVM
  12. Partition 2 does not end on cylinder boundary.
  13. /dev/vda3          103825      112147     4194304   82  Linux swap / Solaris
  14. Partition 3 does not end on cylinder boundary.

  15. Disk /dev/mapper/RAC12crhel6-root: 53.2 GB, 53183774720 bytes
  16. 255 heads, 63 sectors/track, 6465 cylinders
  17. Units = cylinders of 16065 * 512 = 8225280 bytes
  18. Sector size (logical/physical): 512 bytes / 512 bytes
  19. I/O size (minimum/optimal): 512 bytes / 512 bytes
  20. Disk identifier: 0x00000000


  21. Disk /dev/sda: 56.7 GB, 56740544512 bytes
  22. 255 heads, 63 sectors/track, 6898 cylinders
  23. Units = cylinders of 16065 * 512 = 8225280 bytes
  24. Sector size (logical/physical): 512 bytes / 512 bytes
  25. I/O size (minimum/optimal): 512 bytes / 512 bytes
  26. Disk identifier: 0x38a4f1ee

  27.    Device Boot      Start         End      Blocks   Id  System
  28. /dev/sda1               1           1        8001   83  Linux
  29. /dev/sda2               2        6898    55400152+   5  Extended
  30. /dev/sda5               2         628     5036346   83  Linux
  31. /dev/sda6             629        1255     5036346   83  Linux
  32. /dev/sda7            1256        1882     5036346   83  Linux
  33. /dev/sda8            1883        2509     5036346   83  Linux
  34. /dev/sda9            2510        3136     5036346   83  Linux
  35. /dev/sda10           3137        3763     5036346   83  Linux
  36. /dev/sda11           3764        4390     5036346   83  Linux
  37. /dev/sda12           4391        5017     5036346   83  Linux
  38. /dev/sda13           5018        5644     5036346   83  Linux
  39. /dev/sda14           5645        6271     5036346   83  Linux
  40. /dev/sda15           6272        6898     5036346   83  Linux
  41. [root@station25 ~]# su - grid
  42. [grid@station25 ~]$ asmcmd afd_dsset '/dev/sda*'
  43. [grid@station25 ~]$ asmcmd afd_dsget
  44. AFD discovery string: '/dev/sda*'
  45. [grid@station25 ~]$ asmcmd afd_scan
  46. [grid@station25 ~]$ asmcmd afd_dsget
  47. AFD discovery string: '/dev/sda*'
  48. [grid@station25 ~]$
复制代码
ASMFD对应于操作系统盘:
  1. [root@station23 disks]# ls
  2. RACDISK1  RACDISK10  RACDISK11  RACDISK2  RACDISK3  RACDISK4  RACDISK5  RACDISK6  RACDISK7  RACDISK8  RACDISK9
  3. [root@station23 disks]# vim RACDISK1
  4. [root@station23 disks]# cat RACDISK1
  5. /dev/sda5
  6. [root@station23 disks]# pwd
  7. /dev/oracleafd/disks
复制代码





回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-21 18:41 , Processed in 0.036483 second(s), 24 queries .

快速回复 返回顶部 返回列表