Home » Server Options » RAC & Failsafe » ORA-29701: unable to connect to Cluster Synchronization Service (oracle, 12c, oraclelinux)
ORA-29701: unable to connect to Cluster Synchronization Service [message #684227] Mon, 26 April 2021 04:11 Go to next message
solution
Messages: 13
Registered: November 2020
Junior Member
I have a RAC with 2 nodes. I couldn't start the database now one of them.
I got this error when trying to startup the database on node2.

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

SQL> startup

ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/mydborcl/spfilemydborcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/mydborcl/spfilemydborcl.ora
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-29701: unable to connect to Cluster Synchronization Service
How can I resolve the problem?
Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #684229 is a reply to message #684227] Mon, 26 April 2021 04:21 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Looks as though the clusterware is not running on the node, better try to start it.

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwadd/oracle-clusterware-control-crsctl-utility-reference.html#GUID-7 33FDFE5-52FF-4B37-9A09-70AF465FF3C5
Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #684231 is a reply to message #684229] Mon, 26 April 2021 04:34 Go to previous messageGo to next message
solution
Messages: 13
Registered: November 2020
Junior Member
John Watson wrote on Mon, 26 April 2021 04:21
Looks as though the clusterware is not running on the node, better try to start it.

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwadd/oracle-clusterware-control-crsctl-utility-reference.html#GUID-7 33FDFE5-52FF-4B37-9A09-70AF465FF3C5
with grid user, I got this error:
node2:
[grid@node2 ~]$ crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager

[grid@node2 ~]$ crsctl start cluster -n node2
CRS-4563: Insufficient user privileges.

CRS-4000: Command Start failed, or completed with errors.

with oracle user:
[oracle@node2 ~]$ crsctl stat res -t
-bash: crsctl: command not found
Where I missed?

[Updated on: Mon, 26 April 2021 04:47]

Report message to a moderator

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #684232 is a reply to message #684231] Mon, 26 April 2021 04:50 Go to previous messageGo to next message
solution
Messages: 13
Registered: November 2020
Junior Member
solution wrote on Mon, 26 April 2021 04:34

with oracle user:
[oracle@node2 ~]$ crsctl stat res -t
-bash: crsctl: command not found
Where I missed?
How can I set . oraenv ORACLE_SID = [+ASM2]?

[Updated on: Mon, 26 April 2021 04:51]

Report message to a moderator

Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #684235 is a reply to message #684232] Mon, 26 April 2021 08:15 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
With Grid Infrastructure, some operations have to be done as root.
The oraenv script is pretty useless in GI, just set the variables for your ORACLE_HOME, PATH, and SID by hand.

This is all in the docs, you know. And in any basic RAC training course.
Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #684261 is a reply to message #684235] Wed, 28 April 2021 21:16 Go to previous messageGo to next message
solution
Messages: 13
Registered: November 2020
Junior Member
John Watson wrote on Mon, 26 April 2021 08:15
... just set the variables for your ORACLE_HOME, PATH, and SID by hand.
Actually I don't how to set my $ORACLE_HOME, $PATH, and SID by hand.
I logged in as root but still no luck.
[root@node1 bin]#  crsctl check
bash: crsctl: command not found
How can I run the crsctl command from actual dir? Quote:
"The CRSCTL utility is located in the Grid_home/bin directory"
How can I switch to Grid_home/bin from root user?
I tried like this, but didn't find crsctl
[root@node1 bin]# cd $Grid_home/bin
Re: ORA-29701: unable to connect to Cluster Synchronization Service [message #684262 is a reply to message #684261] Thu, 29 April 2021 01:17 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Actually I don't how to set my $ORACLE_HOME, $PATH, and SID by hand.
You set the ORACLE_HOME environment variable to the directory where the Grid Infrastructure software is installed. Your PATH must include $ORACLE_HOME/bin, and the ORACLE_SID should be the name of the ASM instance that will be running on this node. You had better ask whomever did the installation if you do not know this basic information.
Previous Topic: user session are not created on both nodes
Next Topic: SCAN Listener redirecting to wrong Local listener port
Goto Forum:
  


Current Time: Thu Mar 28 08:12:38 CDT 2024