OraFAQ Forum: Server Administration » ORA-29701: unable to connect to Cluster Synchronization Service

Home » RDBMS Server » Server Administration » ORA-29701: unable to connect to Cluster Synchronization Service (Oracle Linux 6.7, Oracle 12.1.0.2.0 )

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

ORA-29701: unable to connect to Cluster Synchronization Service [message #670245]

Wed, 20 June 2018 01:38

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

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

Senior Member
Account Moderator

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

Report message to a moderator

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670249 is a reply to message #670245]

Wed, 20 June 2018 02:08

John Watson
Messages: 8960
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

Report message to a moderator

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670250 is a reply to message #670249]

Wed, 20 June 2018 02:24

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.

Report message to a moderator

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670252 is a reply to message #670250]

Wed, 20 June 2018 02:39

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

You need to start the clusterware.

Report message to a moderator

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670254 is a reply to message #670252]

Wed, 20 June 2018 02:53

fabi88
Messages: 112
Registered: November 2011

Senior Member

You need to start the clusterware.

How can do it?

Report message to a moderator

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670256 is a reply to message #670254]

Wed, 20 June 2018 03:08

John Watson
Messages: 8960
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.

Report message to a moderator

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #670260 is a reply to message #670256]

Wed, 20 June 2018 04:25

fabi88
Messages: 112
Registered: November 2011

Senior Member

Thank you.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 11:42:35 CST 2024