Home » RDBMS Server » Server Administration » ORA-29701: unable to connect to Cluster Synchronization Service (Oracle Linux 6.7, Oracle 12.1.0.2.0 )
ORA-29701: unable to connect to Cluster Synchronization Service [message #670245] Wed, 20 June 2018 01:38 Go to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Hi,

I got into a problem at the start of the program, error is as follows:

ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-29701: unable to connect to Cluster Synchronization Service

could you please help to resolve the issue?
(Database is single instance)

[Updated on: Wed, 20 June 2018 01:46]

Report message to a moderator

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670247 is a reply to message #670245] Wed, 20 June 2018 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Check this: "ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora"

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670249 is a reply to message #670245] Wed, 20 June 2018 02:08 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Are the cluster services actually running? Set your environment to the GI home, and what do you get when you run
crsctl stat res -t -init
crsctl stat res -t
Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670250 is a reply to message #670249] Wed, 20 June 2018 02:24 Go to previous messageGo to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Thank you so much for you replies.
Quote:

Are the cluster services actually running?
I'm not sure, how to check it?

GI HOME?

./crsctl stat res -t -init

CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Status failed, or completed with errors.



./crsctl stat res -t
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Status failed, or completed with errors.

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670252 is a reply to message #670250] Wed, 20 June 2018 02:39 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You need to start the clusterware.
Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670254 is a reply to message #670252] Wed, 20 June 2018 02:53 Go to previous messageGo to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
You need to start the clusterware.

How can do it?
Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670256 is a reply to message #670254] Wed, 20 June 2018 03:08 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I'm not sure how to put this. I'll try.
Managing a GI environment can be a challenging task, and you need certain skills to do it successfully. You may need to invest in some learning, or hire a consultant to manage it for you.
Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670260 is a reply to message #670256] Wed, 20 June 2018 04:25 Go to previous message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Thank you.
Previous Topic: ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions
Next Topic: disabling the indexes at partition level (merged)
Goto Forum:
  


Current Time: Thu Mar 28 11:02:34 CDT 2024