Monday, October 3, 2011

ORA-29701: unable to connect to Cluster Manager when startup oracle asm instance

I found this error when trying to startup oracle asm instance... solution is very easy . just see below.

i use

C:\>set ORACLE_SID=+ASMHALIM
C:\> localconfig delete
C:\>localconfig add

live example:-

SQL> startup pfile='G:\oracle\asmhalim\initasm.ora'
ORA-29701: unable to connect to Cluster Manager
SQL>
SQL>
SQL> host
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>set ORACLE_SID=+ASMHALIM

C:\>
C:\> localconfig delete

Step 1: stopping local CSS stack
Step 2: deleting OCR repository
failed to open the OCR subkey, err(1060)
failed to cleanup local OCR repository
successfully deleted local CSS setup

C:\>
C:\>localconfig add

Step 1: creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'administrator', privgrp ''..
Operation successful.
Step 2: creating new CSS service
successfully created local CSS service
successfully added CSS to home

C:\>
C:\>
C:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 3 15:44:07 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL>
SQL>
SQL> startup pfile='G:\oracle\asmhalim\initasm.ora'
ASM instance started

Total System Global Area 176160768 bytes
Fixed Size 1247948 bytes
Variable Size 149746996 bytes
ASM Cache 25165824 bytes

2 comments:

akpeau said...

D:\>localconfig delete
'localconfig delete' is not recognized as an internal or external command,
operable program or batch file.



please help

Unknown said...

"ORA-29701: unable to connect to Cluster Manager when startup oracle asm instance"
adding local config is not working in 11g can anybody help me