OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-29702 Error (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-29702 Error [message #471056]

Thu, 12 August 2010 02:09

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Hi,

I have deinstalled Oracle database, ASM and oracle software. I installed the oracle software, ASM and database. I have seen the error in the ASM trace called

Errors in file /opt/oracle/admin/+ASM/bdump/+asm_gmon_10518.trc:
ORA-29702: error occurred in Cluster Group Service operation
ORA-29702: error occurred in Cluster Group Service operation

Please advise.

Report message to a moderator

Re: ORA-29702 Error [message #471058 is a reply to message #471056]

Thu, 12 August 2010 02:13

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-29702: error occurred in Cluster Group Service operation
 *Cause: An unexpected error occurred while performing a CGS operation.
 *Action: Verify that the LMON process is still active.  Also,
          check the Oracle LMON trace files for errors.

Regards
Michel

Report message to a moderator

Re: ORA-29702 Error [message #471062 is a reply to message #471058]

Thu, 12 August 2010 02:20

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

please share some other hidden information which cause this error, from your session
Does any RAC involved ?
OS ?
sriram

Report message to a moderator

Re: ORA-29702 Error [message #471076 is a reply to message #471056]

Thu, 12 August 2010 03:12

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

We are using standalone with ASM and RAC with two systems. Now I am trying in standlaone system.

Here is the output for LMON

[root@platform1 udump]# ps ax|grep lmon
2755 pts/1 S+ 0:00 grep lmon

I have the following files in bdump folder.

[root@platform1 bdump]# ll
total 28
-rw-r----- 1 oracle oinstall 6642 Aug 12 14:50 alert_+ASM.log
-rw-r----- 1 oracle oinstall 2090 Aug 12 14:50 +asm_gmon_10518.trc
-rw-r----- 1 oracle oinstall 7408 Aug 12 14:38 +asm_gmon_5927.trc
-rw-r----- 1 oracle oinstall 812 Aug 12 14:49 +asm_rbal_10516.trc
-rw-r----- 1 oracle oinstall 838 Aug 12 14:19 +asm_rbal_5925.trc

Report message to a moderator

Re: ORA-29702 Error [message #471117 is a reply to message #471056]

Thu, 12 August 2010 07:19

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

While upgrading the Opatch, When I Start CSS i m facing the below mentioned problem.

[root@platform1 bdump]# /opt/oracle/product/10.2.0/db/bin/localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
Giving up: Oracle CSS stack appears NOT to be running.
Oracle CSS service would not start as installed
Automatic Storage Management(ASM) cannot be used until Oracle CSS service is started

It is very urgent.

Please advise.

Report message to a moderator

Re: ORA-29702 Error [message #471150 is a reply to message #471117]

Thu, 12 August 2010 09:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You might find additional clues in logfile.

Report message to a moderator

Re: ORA-29702 Error [message #471151 is a reply to message #471056]

Thu, 12 August 2010 09:12

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

I checked all the instances and ASM is down.I found the following error in shutdown.log file.

SQL> ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance
SQL> Disconnected from Oracle Database 10g Release 10.2.0.4.0 - Production

Report message to a moderator

Re: ORA-29702 Error [message #471152 is a reply to message #471151]

Thu, 12 August 2010 09:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

5097, 00000, "cannot SHUTDOWN ASM instance with connected client"
// *Cause:  A SHUTDOWN command was issued to an ASM instance that had one or 
//          more connected clients.
// *Action: Stop all clients that are using this ASM instance and retry the 
//          SHUTDOWN command.  Alternatively, use the SHUTDOWN ABORT command.  
//          Note that issuing the SHUTDOWN ABORT command to an ASM instance 
//          results in abormal termination of all RDBMS instances connected 
//          to that ASM instance. Query the V$ASM_CLIENT fixed view in an ASM
//          instance or use ASMCMD LSOF to list active clients.
//

Report message to a moderator

Re: ORA-29702 Error [message #471153 is a reply to message #471056]

Thu, 12 August 2010 09:19

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

ASM is down and I am going to start the ASM with force option but same problem.

[oracle@platform1 bin]$ export ORACLE_SID=+ASM
[oracle@platform1 bin]$ sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 12 22:14:45 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> shut abort
ORACLE instance shut down.
SQL> startup
ORA-29701: unable to connect to Cluster Manager
SQL> startup force
ORA-29701: unable to connect to Cluster Manager

It is very urgent. Please advise.

Report message to a moderator

Re: ORA-29702 Error [message #471154 is a reply to message #471153]

Thu, 12 August 2010 09:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

29701, 00000, "unable to connect to Cluster Synchronization Service"
// *Cause: Connect to CSS failed or timed out.
// *Action: Verify the state of the CSS.  If the CSS was not started,
//          start it and then retry the database startup. If the CSS died
//          or is not responding, check the Oracle and CSS trace files for
//          errors and contact Oracle Support Services.

Report message to a moderator

Re: ORA-29702 Error [message #471156 is a reply to message #471056]

Thu, 12 August 2010 09:31

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

CSS is not starting and I m getting the error.

[root@platform1 bdump]# /opt/oracle/product/10.2.0/db/bin/localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
Giving up: Oracle CSS stack appears NOT to be running.
Oracle CSS service would not start as installed
Automatic Storage Management(ASM) cannot be used until Oracle CSS service is started

and I checked in the log file. Dont find any logs.
/opt/oracle/product/10.2.0/db/css/log

Report message to a moderator

Re: ORA-29702 Error [message #471157 is a reply to message #471156]

Thu, 12 August 2010 09:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

contact Oracle Support Services

Report message to a moderator

Previous Topic:	undo & temp tablespace
Next Topic:	oracle 10g problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:38:28 CST 2024