Bo's Oracle Station

查看: 3141|回复: 4

课程第3次(2018-01-10星期一)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2018-1-10 21:48:45 | 显示全部楼层 |阅读模式
  1. 就是在执行root.sh之前执行以下命令

  2. /bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
复制代码
  1. [root@station15 ~]# su - oracle
  2. [oracle@station15 ~]$ . oraenv
  3. ORACLE_SID = [oracle] ? +ASM
  4. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
  5. [oracle@station15 ~]$ crs_stat -t
  6. Name           Type           Target    State     Host        
  7. ------------------------------------------------------------
  8. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station15   
  9. ora.asm        ora.asm.type   ONLINE    OFFLINE               
  10. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station15   
  11. ora.diskmon    ora....on.type ONLINE    ONLINE    station15   
复制代码
  1. [root@station15 ~]# fdisk -l /dev/vda

  2. Disk /dev/vda: 131.0 GB, 130996502528 bytes
  3. 255 heads, 63 sectors/track, 15926 cylinders
  4. Units = cylinders of 16065 * 512 = 8225280 bytes
  5. Sector size (logical/physical): 512 bytes / 512 bytes
  6. I/O size (minimum/optimal): 512 bytes / 512 bytes
  7. Disk identifier: 0xf853bc18

  8.    Device Boot      Start         End      Blocks   Id  System
  9. /dev/vda1   *           1        3003    24117216+   7  HPFS/NTFS
  10. /dev/vda2            3003        3041      307200   83  Linux
  11. /dev/vda3            3041        8880    46899200   8e  Linux LVM
  12. /dev/vda4            8880       15926    56601947    5  Extended
  13. /dev/vda5            8880       10154    10238325+  8e  Linux LVM
  14. /dev/vda6           10155       11047     7172991   8e  Linux LVM
  15. /dev/vda7           11048       11940     7172991   8e  Linux LVM
  16. /dev/vda8           11941       12833     7172991   8e  Linux LVM
  17. /dev/vda9           12834       13726     7172991   8e  Linux LVM
  18. /dev/vda10          13727       14249     4200966   82  Linux swap / Solaris
  19. /dev/vda11          14250       15926    13470471   8e  Linux LVM
  20. [root@station15 ~]# df -h
  21. Filesystem            Size  Used Avail Use% Mounted on
  22. /dev/mapper/vol0-root
  23.                        44G   16G   27G  37% /
  24. tmpfs                  14G  155M   14G   2% /dev/shm
  25. /dev/vda2             283M   41M  228M  16% /boot
  26. [root@station15 ~]# pvs
  27.   PV         VG   Fmt  Attr PSize  PFree
  28.   /dev/vda3  vol0 lvm2 a--u 44.72g    0
  29. [root@station15 ~]# pvcreate /dev/vda11
  30.   Physical volume "/dev/vda11" successfully created
  31. [root@station15 ~]# pvs
  32.   PV         VG   Fmt  Attr PSize  PFree
  33.   /dev/vda11      lvm2 ---- 12.85g 12.85g
  34.   /dev/vda3  vol0 lvm2 a--u 44.72g     0
  35. [root@station15 ~]# vgs
  36.   VG   #PV #LV #SN Attr   VSize  VFree
  37.   vol0   1   1   0 wz--n- 44.72g    0
  38. [root@station15 ~]# vgextend vol0 /dev/vda11
  39.   Volume group "vol0" successfully extended
  40. [root@station15 ~]# pvs
  41.   PV         VG   Fmt  Attr PSize  PFree
  42.   /dev/vda11 vol0 lvm2 a--u 12.84g 12.84g
  43.   /dev/vda3  vol0 lvm2 a--u 44.72g     0
  44. [root@station15 ~]# vgs
  45.   VG   #PV #LV #SN Attr   VSize  VFree
  46.   vol0   2   1   0 wz--n- 57.57g 12.84g
  47. [root@station15 ~]# vgdisplay vol0
  48.   --- Volume group ---
  49.   VG Name               vol0
  50.   System ID            
  51.   Format                lvm2
  52.   Metadata Areas        2
  53.   Metadata Sequence No  3
  54.   VG Access             read/write
  55.   VG Status             resizable
  56.   MAX LV                0
  57.   Cur LV                1
  58.   Open LV               1
  59.   Max PV                0
  60.   Cur PV                2
  61.   Act PV                2
  62.   VG Size               57.57 GiB
  63.   PE Size               4.00 MiB
  64.   Total PE              14737
  65.   Alloc PE / Size       11449 / 44.72 GiB
  66.   Free  PE / Size       3288 / 12.84 GiB
  67.   VG UUID               h5RcUL-v5fH-e53T-in9j-8Nsd-vy1n-LcQo5K
  68.    
  69. [root@station15 ~]# lvextend -l +3288 /dev/vol0/root
  70.   Size of logical volume vol0/root changed from 44.72 GiB (11449 extents) to 57.57 GiB (14737 extents).
  71.   Logical volume root successfully resized.
  72. [root@station15 ~]# vgs
  73.   VG   #PV #LV #SN Attr   VSize  VFree
  74.   vol0   2   1   0 wz--n- 57.57g    0
  75. [root@station15 ~]# df -h
  76. Filesystem            Size  Used Avail Use% Mounted on
  77. /dev/mapper/vol0-root
  78.                        44G   16G   27G  37% /
  79. tmpfs                  14G  155M   14G   2% /dev/shm
  80. /dev/vda2             283M   41M  228M  16% /boot
  81. [root@station15 ~]# resize2fs  /dev/vol0/root  
  82. resize2fs 1.41.12 (17-May-2010)
  83. Filesystem at /dev/vol0/root is mounted on /; on-line resizing required
  84. old desc_blocks = 3, new_desc_blocks = 4
  85. Performing an on-line resize of /dev/vol0/root to 15090688 (4k) blocks.
  86. The filesystem on /dev/vol0/root is now 15090688 blocks long.

  87. [root@station15 ~]# df -h
  88. Filesystem            Size  Used Avail Use% Mounted on
  89. /dev/mapper/vol0-root
  90.                        57G   16G   39G  29% /
  91. tmpfs                  14G  155M   14G   2% /dev/shm
  92. /dev/vda2             283M   41M  228M  16% /boot
  93. [root@station15 ~]#
复制代码



回复

使用道具 举报

0

主题

11

帖子

100

积分

注册会员

Rank: 2

积分
100
QQ
发表于 2018-1-12 11:26:37 | 显示全部楼层
老师 安装失败怎么清除重新来过

Screenshot.png
Screenshot-Untitled Window.png
[root@station11 disks]# tail -n 50 /u01/app/oraInventory/logs/installActions2018-01-12_10-57-41AM.log
INFO: Setting value to transient variable s_ASMPasswordFlag
INFO: Setting value to transient variable s_ASMMonitorPasswordFlag
INFO: Successfully updated Transient Parameters in the Aggregates
INFO: Configuration log directory - /u01/app/grid/product/11.2.0/grid/cfgtoollogs
INFO:
The Runconfig command constructed is /u01/app/grid/product/11.2.0/grid/oui/bin/runConfig.sh ORACLE_HOME=/u01/app/grid/product/11.2.0/grid MODE=perform ACTION=configure RERUN=true $*
INFO: Since the option is to overwrite the existing /u01/app/grid/product/11.2.0/grid/cfgtoollogs/configToolAllCommands file, backing it up
INFO: The backed up file name is /u01/app/grid/product/11.2.0/grid/cfgtoollogs/configToolAllCommands.bak.2
INFO: Entering ConfigClient.executeSelectedToolsInAggregate method
INFO: Exiting ConfigClient.executeSelectedToolsInAggregate method
INFO:
The Runconfig command constructed is /u01/app/grid/product/11.2.0/grid/oui/bin/runConfig.sh ORACLE_HOME=/u01/app/grid/product/11.2.0/grid MODE=perform ACTION=configure RERUN=false $*
INFO: Since the option is to overwrite the existing /u01/app/grid/product/11.2.0/grid/cfgtoollogs/configToolFailedCommands file, backing it up
INFO: The backed up file name is /u01/app/grid/product/11.2.0/grid/cfgtoollogs/configToolFailedCommands.bak.1
INFO: ConfigClient.saveSession method called
INFO: Calling event ConfigSessionEnding
INFO: ConfigClient.endSession method called
INFO: Completed Configuration
INFO: Waiting for completion of background operations
INFO: Completed background operations
INFO: Validating view at state <setup>
INFO: Completed validating view at state <setup>
INFO: Validating state <setup>
WARNING: Validation disabled for the state setup
INFO: Completed validating state <setup>
INFO: Verifying route success
INFO: Get view named [FinishUI]
INFO: View for [FinishUI] is oracle.install.ivw.crs.view.FinishGUI@5158ce4
INFO: Initializing view <FinishUI> at state <finish>
INFO: Completed initializing view <FinishUI> at state <finish>
INFO: Displaying view <FinishUI> at state <finish>
INFO: Completed displaying view <FinishUI> at state <finish>
INFO: Loading view <FinishUI> at state <finish>
INFO: Install Succeeded: true
INFO: Config Tool Succeeded: false
INFO: Remote Install Succeeded: true
INFO: Completed loading view <FinishUI> at state <finish>
INFO: Localizing view <FinishUI> at state <finish>
INFO: Completed localizing view <FinishUI> at state <finish>
INFO: Waiting for completion of background operations
INFO: Completed background operations
INFO: Executing action at state finish
INFO: Completed executing action at state <finish>
INFO: Waiting for completion of background operations
INFO: Completed background operations
INFO: Moved to state <finish>
INFO: Finding the most appropriate exit status for the current application
INFO: Exit Status is 0
INFO: Shutdown Oracle Grid Infrastructure
INFO: Unloading Setup Driver
[root@station11 disks]#


回复 支持 反对

使用道具 举报

0

主题

11

帖子

100

积分

注册会员

Rank: 2

积分
100
QQ
发表于 2018-1-12 15:24:46 | 显示全部楼层
Screenshot-1.png
INFO: Started Plugin named: Automatic Storage Management Configuration Assistant
INFO: Found associated job
INFO: Starting 'Automatic Storage Management Configuration Assistant'
INFO: Starting 'Automatic Storage Management Configuration Assistant'
INFO: Executing ASMCA
INFO: Command /u01/app/grid/product/11.2.0/grid/bin/asmca -silent -oui_internal -configureASM -diskGroupName DATA -diskList ORCL:ASM2,ORCL:ASM3,ORCL:ASM4,ORCL:ASM5 -redundancy NORMAL
INFO: ... GenericInternalPlugIn.handleProcess() entered.
INFO: ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: ... GenericInternalPlugIn: checking secretArguments.
INFO: ... GenericInternalPlugIn: starting read loop.
INFO: Read: SYS_PASSWORD_PROMPT
INFO: Processing: SYS_PASSWORD_PROMPT for argument tag -sysAsmPassword
INFO: Read: ASMSNMP_PASSWORD_PROMPT
INFO: Processing: ASMSNMP_PASSWORD_PROMPT for argument tag -asmMonitorPassword
INFO: End of argument passing to stdin
INFO: Read:
INFO: Read: Configuring ASM failed with the following message:
INFO: Read: One or more diskgroup(s) creation failed as below:
INFO: Read: DiskGroup DATA creation failed with the following message:
INFO: Read: ORA-15018: diskgroup cannot be created
INFO: Read: ORA-15038: disk '' size mismatch with diskgroup [4096] [] []
INFO: Read:
INFO: Read:
INFO: Completed Plugin named: Automatic Storage Management Configuration Assistant
INFO: Automatic Storage Management Configuration Assistant failed.
INFO: Automatic Storage Management Configuration Assistant failed.
INFO: ConfigClient.executeSelectedToolsInAggregate action performed
INFO: Exiting ConfigClient.executeSelectedToolsInAggregate method
INFO:
The Runconfig command constructed is /u01/app/grid/product/11.2.0/grid/oui/bin/runConfig.sh ORACLE_HOME=/u01/app/grid/product/11.2.0/grid MODE=perform ACTION=configure RERUN=false $*
INFO: Since the option is to overwrite the existing /u01/app/grid/product/11.2.0/grid/cfgtoollogs/configToolFailedCommands file, backing it up
INFO: The backed up file name is /u01/app/grid/product/11.2.0/grid/cfgtoollogs/configToolFailedCommands.bak.1
INFO: ConfigClient.saveSession method called
INFO: Calling event ConfigSessionEnding
INFO: ConfigClient.endSession method called
INFO: Completed Configuration
INFO: Performing Configuration
INFO: Entering ConfigClient.init method
INFO: ConfigClient.init sOracleHomeLoc=/u01/app/grid/product/11.2.0/grid, sTopAggId=oracle.crs
INFO: Entering ConfigClient.initClientAndSession method
INFO: ConfigClient.initClientAndSession status : connected to the config framework
INFO: ConfigClient.initClientAndSession session begun oracle.sysman.emCfg.client.CfwSession@18a9b68c
INFO: ConfigClient.initClientAndSession m_oAggregate=[Loracle.sysman.emCfg.common.IAggregate;@2e0fadfa
INFO: Configuration log directory - /u01/app/grid/product/11.2.0/grid/cfgtoollogs
INFO: Exiting ConfigClient.init method
INFO: Calling event ConfigSessionInitialized
INFO: ConfigClient.registerOutErrStream method called
INFO: Entering ConfigClient.getToolsList method
INFO: Selecting job named 'Automatic Storage Management Configuration Assistant' for retry
INFO: Updating Transient Parameters in the Aggregates
INFO: Updating Transient Parameters for oracle.crs
INFO: Updating Transient Parameters for oracle.assistants.netca.client
INFO: Updating Transient Parameters for OuiConfigVariables
INFO: Updating Transient Parameters for oracle.assistants.asm
INFO: Setting value to transient variable S_ASMMONITORPASSWORD
INFO: Setting value to transient variable S_ASMPASSWORD
INFO: Setting value to transient variable s_asmcaArgs
INFO: Setting value to transient variable s_ASMPasswordFlag
INFO: Setting value to transient variable s_ASMMonitorPasswordFlag
INFO: Successfully updated Transient Parameters in the Aggregates
INFO: Configuration log directory - /u01/app/grid/product/11.2.0/grid/cfgtoollogs
INFO:
The Runconfig command constructed is /u01/app/grid/product/11.2.0/grid/oui/bin/runConfig.sh ORACLE_HOME=/u01/app/grid/product/11.2.0/grid MODE=perform ACTION=configure RERUN=true $*
INFO: Since the option is to overwrite the existing /u01/app/grid/product/11.2.0/grid/cfgtoollogs/configToolAllCommands file, backing it up
INFO: The backed up file name is /u01/app/grid/product/11.2.0/grid/cfgtoollogs/configToolAllCommands.bak.2
INFO: Entering ConfigClient.executeSelectedToolsInAggregate method
INFO: ConfigClient.executeSelectedToolsInAggregate oAggregate=oracle.crsracle.crs:11.2.0.1.0:common
INFO: Entering ConfigClient.assignAction method
INFO: ConfigClient.assignAction actionref=[Loracle.sysman.emCfg.common.IActionReference;@59c8466
INFO: ConfigClient.assignAction action is of type :configuration
INFO: Exiting ConfigClient.assignAction method
INFO: ConfigClient.executeSelectedToolsInAggregate action assigned
INFO: Started Plugin named: Automatic Storage Management Configuration Assistant
INFO: Found associated job
INFO: Starting 'Automatic Storage Management Configuration Assistant'
INFO: Starting 'Automatic Storage Management Configuration Assistant'
INFO: Executing ASMCA
INFO: Command /u01/app/grid/product/11.2.0/grid/bin/asmca -silent -oui_internal -configureASM -diskGroupName DATA -diskList ORCL:ASM2,ORCL:ASM3,ORCL:ASM4,ORCL:ASM5 -redundancy NORMAL
INFO: ... GenericInternalPlugIn.handleProcess() entered.
INFO: ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: ... GenericInternalPlugIn: checking secretArguments.
INFO: ... GenericInternalPlugIn: starting read loop.
INFO: Read: SYS_PASSWORD_PROMPT
INFO: Processing: SYS_PASSWORD_PROMPT for argument tag -sysAsmPassword
INFO: Read: ASMSNMP_PASSWORD_PROMPT
INFO: Processing: ASMSNMP_PASSWORD_PROMPT for argument tag -asmMonitorPassword
INFO: End of argument passing to stdin
INFO: Read:
INFO: Read: Configuring ASM failed with the following message:
INFO: Read: One or more diskgroup(s) creation failed as below:
INFO: Read: DiskGroup DATA creation failed with the following message:
INFO: Read: ORA-15018: diskgroup cannot be created
INFO: Read: ORA-15038: disk '' size mismatch with diskgroup [4096] [] []
INFO: Read:
INFO: Read:
INFO: Completed Plugin named: Automatic Storage Management Configuration Assistant

回复 支持 反对

使用道具 举报

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
 楼主| 发表于 2018-1-13 19:42:45 | 显示全部楼层
删掉/etc/ora*
删掉/etc/inittab的最后一行
删掉/etc/rc.d/init.d/*has*
删掉/u01/app/*

dd if=/dev/zero of=/dev/vda...   bs=100M  count=3 那几个ASM盘
重启
确认环境变量没有设(单用户双HOME,不要设ORACLE_HOME, TNS_ADMIN)。
重新oracleasm createdisk
./runInstaller
注意11.2.0.1在执行root.sh时候那个bug
回复 支持 反对

使用道具 举报

0

主题

11

帖子

100

积分

注册会员

Rank: 2

积分
100
QQ
发表于 2018-1-17 15:10:42 | 显示全部楼层
本帖最后由 叶俊海 于 2018-1-17 15:12 编辑

QQ图片20180117150944.png
感谢吴家硕分享的 我用的这个方法解决的
INFO: Read: ORA-15018: diskgroup cannot be created
INFO: Read: ORA-15038: disk '' size mismatch with diskgroup [4096] [] []

vim /etc/sysconfig/oracleasm
修改了ORACLEASM_USE_LOGICAL_BLOCK_SIZE=true 参数
service oracleasm restart



回复 支持 反对

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 08:24 , Processed in 0.051577 second(s), 28 queries .

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