Thursday, June 11, 2020

ORA-03113: end-of-file on communication channel CRS-2632: There are no more servers to try to place resource 'ora.dbf.db' on that would satisfy its placement policy


oracle@nodea:$ srvctl start instance -d DBFS040 -i DBFS0401
PRCR-1013 : Failed to start resource ora.dbfs040.db
PRCR-1064 : Failed to start resource ora.dbfs040.db on node dgcldb040a
CRS-5017: The resource action "ora.dbfs040.db start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/dgb040a/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.dbfs040.db' on 'dgcldb040a' failed


2020-06-08 21:53:48.484 :CLSDYNAM:282011392: [ora.dbfs040.db]{1:8976:28615} [start] clsnUtils::error Exception type=2 string=
CRS-5017: The resource action "ora.dbfs040.db start" encountered :Q1
the following error:
ORA-03113: end-of-file on communication channel



Solution: making imaginary ips for safety
cat /etc/hosts/ and there priv 1 ad priv 2 is what we need in terms  of IPS

get the ips of

10.10.100.30            node1-priv-1.com             node2-priv-1
10.10.100.31             node2-priv-1.com             node-priv-1

10.10.100.32            node1-priv-2.com             nodea-priv-2
10.10.100.33            node2-priv-2.com             nodeb-priv-2


alter system set cluster_interconnects = '10.10.100.30:10.10.100.32' scope=spfile sid='DBFS0401';
alter system set cluster_interconnects = '10.10.100.31:10.10.100.33' scope=spfile sid='DBFS0402';

No comments:

Post a Comment