今天接到朋友的电话说他们装ORACLE 11G R1 RAC的时候遇到ORA-12801/ORA-15243错误,请求我帮忙解决
AIX系统以前装过11G R2 RAC,现因为项目要求11G R1,已经重装了系统,然后安装R1,在安装到DBCA配置ASM的时候,出现ORA-12801/ORA-15243错误
ORA-12801: error signaled in parallel query server PZ99, instance wmsdb1:+ASM1(1) ORA-15243: 22.214.171.124.0 is not a valid version number
3.直接使用dd清理该asm disk header信息(dd if=/dev/zero of=/dev/rhdisk1 bs=4096 count=1)
Applies to: Oracle Server - Enterprise Edition - Version 126.96.36.199 and later Information in this document applies to any platform. Symptoms On : 188.8.131.52 version, STORAGE When attempting to create database or query gv$asm_diskgroup, the following error occurs. ERROR ----------------------- ORA-12801: error signaled in parallel query server PZ99, instance dchilcmsdb2.hq.navteq.com:+ASM2 (2) ORA-15243: 184.108.40.206.0 is not a valid version number STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Previously had 11GR2 installed and configured. Removed this installation then installed 220.127.116.11 and created diskgroups using some of the same disks previously used. 2. Attempt to create database and receive the errors. Drop the newly created diskgroups and query the view still get same errors. BUSINESS IMPACT ----------------------- The issue has the following business impact: Due to this issue, users cannot create new database. Changes Removed 18.104.22.168 installation and installed 22.214.171.124 software without cleaning up all of the diskgroup information from previous installation. Cause All the current information shows that we are using correct binaries and that the diskgroups that are being used have correct comparability settings. HTML shows that the disks for the old diskgroup are still being discovered. This in conjunction with the text of the error as follows shows that we are picking up 126.96.36.199.0 as version from somewhere. ORA-15243: 188.8.131.52.0 is not a valid version number Problem was caused by the disks that had been used for the OCR/Voting disk diskgroup in 11GR2 installation still being present and accessible. Solution As the root user execute /etc/init.d/oracleasm/deletedisk command against all the disks that were previously used for the OCR/Voting disk diskgroup then try the operation again.