Error:
Below error while running a query.
ORA-12801: error signaled in parallel query server P009, instance (2)
ORA-01114: IO error writing block to file (block # )
ORA-01114: IO error writing block to file 206 (block # 1053056)
ORA-29701: unable to connect to Cluster Synchronization Service
But the same query work from other Rac Node.
Diag:
Looks like /u01 oracle/grid mount point is 100% full.
Solution:
After cleaning some of the log file from /u01 we are able to run the query from both the nodes
Below error while running a query.
ORA-12801: error signaled in parallel query server P009, instance (2)
ORA-01114: IO error writing block to file (block # )
ORA-01114: IO error writing block to file 206 (block # 1053056)
ORA-29701: unable to connect to Cluster Synchronization Service
But the same query work from other Rac Node.
Diag:
Looks like /u01 oracle/grid mount point is 100% full.
Solution:
After cleaning some of the log file from /u01 we are able to run the query from both the nodes
No comments:
Post a Comment