ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.1]

ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.1]

  修改时间 20-DEC-2011    
类型 PROBLEM     状态 PUBLISHED
 

In this Document
  Symptoms
  Cause
  Solution


Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 to 11.2.0.1.0 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms

While upgrading 10.2 CRS to 11.2 in a standalone installation, ASMCA fails to create 11.2 ASM instance.

Oracle 11gR2 Grid infrastructure installation reports the following errors:

INFO: Read: PRCR-1079 : Failed to start resource ora.asm
INFO: Read: CRS-2674: Start of ora.cssd on edprddb01 failed
INFO: Read: CRS-2678: ora.cssd on edprddb01 has experienced an unrecoverable failure
INFO: Read: CRS-0267: Human intervention required to resume its availability.

Installation invokes ASMCA to create ASM instance. ASMCA log shows ORA-1034 when starting ASM instance with "checkAndStartupInstance"

SEVERE:method oracle.sysman.assistants.usmca.backend.USMInstanceRac:checkAndStartupInstance
ORA-01034: ORACLE not available

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01034: ORACLE not available

oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:823)
oracle.sysman.assistants.usmca.backend.USMInstance.checkAndStartupInstance(USMInstance.java:602)
oracle.sysman.assistants.usmca.backend.USMInstanceRac.checkAndStartupInstance(USMInstanceRac.java:2668)
oracle.sysman.assistants.usmca.backend.USMInstanceRac.discoverASMInstance(USMInstanceRac.java:2383)
oracle.sysman.assistants.usmca.backend.USMInstance.initialize(USMInstance.java:248)
oracle.sysman.assistants.usmca.backend.USMInstanceRac.initialize(USMInstanceRac.java:275)
oracle.sysman.assistants.usmca.backend.USMInstance.getInstance(USMInstance.java:213)
oracle.sysman.assistants.usmca.service.UsmcaService.getASMStatus(UsmcaService.java:128)
oracle.sysman.assistants.usmca.Usmca.execute(Usmca.java:174)
oracle.sysman.assistants.usmca.Usmca.main(Usmca.java:333)

In the meantime, 11.2 CSS logs shows that CSS fails to listen with IPC protocol. Hence, 11.2 CSS cannot be started.

2010-02-21 10:06:46.569: [ CSSD][1030]clssgmclientOpenEndp: listening on clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=Oracle_CSS_LclLstnr_localhost_1)(GIPCID=37f4a6e0-00000000-1740982))
2010-02-21 10:06:46.573: [GIPCXCPT][1030]gipcmodNetworkProcessBind: failed to bind endp 1111e3eb0 [0000000000000060] { gipcEndpoint : localAddr 'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_edprddb01_localhost)(GIPCID=00000000-00000000-0))', remoteAddr '', numPend
0, numReady 0, numDone 0, numDead 0, numTransfer 0, objFlags 0x0, pidPeer 0, flags 0x240712, usrFlags 0x14000 }, addr 1111e4370 [0000000000000062] { gipcAddress : name 'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_edprddb01_localhost)(GIPCID=00000000-00000000-0))',
objFlags 0x0, addrFlags
2010-02-21 10:06:46.573: [GIPCXCPT][1030]gipcmodNetworkProcessBind: slos op : sgipcnDSBindHelper
2010-02-21 10:06:46.573: [GIPCXCPT][1030]gipcmodNetworkProcessBind: slos dep : Address already in use (67)
.
.
2010-02-21 10:06:46.968: [ CSSD][1030]###################################
2010-02-21 10:06:46.968: [ CSSD][1030]clssscExit: CSSD aborting from thread GMClientListener
2010-02-21 10:06:46.968: [ CSSD][1030]###################################

Cause

CSSD aborts itself as its listener thread can not be started. The error is "Address already in use". This is due to network socket files created by current CSS daemon (10.2).

Solution

1- Clean up network socket files

# rm -rf /tmp/.oracle /usr/tmp/.oracle /var/tmp/.oracle

Then reboot the server.

2- Deconfigure 11.2 ( Following example is for 11.2.0.1 / Use the equivalent commands for 11.2.0.2 and 11.2.0.3 ) CSS daemon:

As root, execute "$GRID_HOME/crs/install/roothas.pl -delete -force -verbose"

script /tmp/deconfigure.log
date
id
env

# perl $GRID_HOME/crs/install/roothas.pl -delete -force -verbose

exit

3- To reconfigure

script /tmp/configure.log
date
id
env

# perl roothas.pl

exit

4- Then run ASMCA manually to create ASM instance

时间: 2024-10-31 09:33:02

ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.1]的相关文章

ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database

ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database home [ID 1070880.1] --------------------------------------------------------------------------------     修改时间 26-OCT-2011     类型 PROBLEM     状态 PUBLIS

How to use ASMCA in silent mode to configure ASM for a stand-alone server [ID 1068788.1]

  How to use ASMCA in silent mode to configure ASM for a stand-alone server [ID 1068788.1] --------------------------------------------------------------------------------     修改时间 05-OCT-2011     类型 HOWTO     状态 PUBLISHED   In this Document   Goal  

【RAC】Diskgroup shows offline after restart even it is mounted in ASM instance

Diskgroup resource shows status offline after restart even it is mounted in ASM instance Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 - Release: 11.2 Information in this document applies to any platform. Symptoms After restart

rac11g错误:ORA-15097: cannot SHUTDOWN ASM instance with connected client

背景: 想停rac环境,之前10g都是用crs_stop -all 来停止,所以,这次也这样做的,没想到报了如下错误: [grid@rac2 ~]$ crs_stop -allCRS-2500: Cannot stop resource 'ora.gsd' as it is not runningCRS-2500: Cannot stop resource 'ora.oc4j' as it is not runningAttempting to stop `ora.ons` on member

Unable To Create Database Using ASM ORA-15055

不能在asm 实例上创建oracle 10g 数据库,报错如下: CREATE DATABASE "ekbkprd1" ORA-01501: CREATE DATABASE failed ORA-00200: controlfile could not be created ORA-00202: controlfile: '+DG1_NR/ekbkprd1/control/ekbkprd1_control.ctl' ORA-17502: ksfdcre:4 Failed to crea

能够管理ASM instance的三种角色

能够管理ASM instance的角色有三种,他们的分工如下:组描述     OS指定的组      具有的权限    能做的事情OSASM      asmadmin        SYSASM           ASM所有管理工作OSDBA      asmdba           SYSDBA            访问diskgroup上的文件,database instance所在用户必须是此组成员,因为要对数据文件进行操作,注意只有基于数据库层面的操作权限,没有底层diskgro

How to move ASM spfile to a different disk group [ID 1082943.1]

  How to move ASM spfile to a different disk group [ID 1082943.1] Goal The goal is to move ASM spfile from one disk group to another. During initial ASM setup the spfile might have been created in a default disk group (e.g. DATA).  The requirement is

11月纽约州制造指数与美国10月进口价格指数均逊于预期

周五美国股市小幅高开.11月纽约州制造指数与美国10月进口价格指数均逊于预期,10月工业产出环比下降0.1%. 美东时间11月15日09:30(北京时间11月15日22:30),道琼斯工业平均指数上涨13.17点,报15,889.39点,涨幅为0.08%:纳斯达克综合指数上涨4.72点,报3,977.46点,涨幅为0.12%:标准普尔500指数上涨1.14点,报1,791.76点,涨幅为0.06%. 中国概念股周五早盘涨跌互现,截至北京时间22:45,优酷土豆涨10.17%( 盘前已涨超6% )

Oracle中的create spfile to asm

--查看sid SQL> show parameter instance_name  ; NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ instance_name                        string      tos --创建pfile SQL> c