Home » RDBMS Server » Enterprise Manager » Job to Shutdown an Instance (OEM 12c running on Linux)
Job to Shutdown an Instance [message #611957] Thu, 10 April 2014 07:48 Go to next message
WackyRacer
Messages: 2
Registered: April 2014
Location: UK
Junior Member
I have an interesting issue creating a Job to shutdown databases in given situation.

The Job executes correctly but when it gets to the step to shutdown the database I get:

ORA-29701: unable to connect to Cluster Synchronization Service

Cluster services are running on the database I'm testing against.
I can shutdown the database from SQLPlus on my client
I can shutdown the database from the Enterprise manager console

I get the same message whether I create a step using the pre-defined Shutdown Task
or crerate a SQL SCript Step and then connect sys as sysdba; shutdown immediate;

The job using named credentials with SYSDBA access specified.
Re: Job to Shutdown an Instance [message #611966 is a reply to message #611957] Thu, 10 April 2014 08:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

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.
Re: Job to Shutdown an Instance [message #611969 is a reply to message #611957] Thu, 10 April 2014 08:19 Go to previous message
WackyRacer
Messages: 2
Registered: April 2014
Location: UK
Junior Member
Oracle EM 12c 12.1.0.3.0

Output from the OEM 12c Job is ( attempting to shutdown an Oracle11g database ) :

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 10 13:15:10 2014

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

SQL> Connected.
SQL> ORA-29701: unable to connect to Cluster Synchronization Service
SQL>
Previous Topic: Ash Analytics Fails to install
Next Topic: Internal error when logging into the enterprise manager
Goto Forum:
  


Current Time: Fri Nov 22 16:07:14 CST 2024