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
We did {insert item} and it failed!
21 hours ago
2 comments:
D:\>localconfig delete
'localconfig delete' is not recognized as an internal or external command,
operable program or batch file.
please help
"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
Post a Comment