The processing process of a service that cannot be started normally

The processing process of a service that cannot be started normally
the
1. The service cannot be started normally, indicating that the database status is abnormal
the
[grid@dtydb4 ~]$ srvctl start service -d epmdb -s srv_epm1 -i epmdb1
PRCR-1013 : Failed to start resource ora.epmdb.srv_epm1.svc
PRCR-1064 : Failed to start resource ora.epmdb.srv_epm1.svc on node dtydb3
CRS-2800: Cannot start resource 'ora.epmdb.db' as it is already in the INTERMEDIATE state on server 'dtydb3'
the
2. The reason is that the database status is abnormal, Stuck Archiver
[grid@dtydb4 ~]$ crsctl status resource -t
www.2cto.com
ora.epmdb.db
                                                               
                                                                   
                                                               
the
3. Find the reason and solve the problem.
the
According to the meaning, the query should be the reason of the archive, query the log
the
ORA-19815: ???ˉ???|: db_recovery_file_dest_size ?—?–???? (?1?2 5218762752 ?—?–????) ?’?’???1?”?? 100.00 %,
the
Since it is a test system, adjust the parameter size
the
sys@EPMDB1(10.4.124.233)> alter system set db_recovery_file_dest_size = 10G scope=both;
the
?μí3ò??ü???￡
the
4. Return to normal, the next step is to adjust some parameters of the test library
the
Check the status again and return to normal
[grid@dtydb4 ~]$ crsctl status resource -t
ora.epmdb.db
                                                                           
                                                                   
                                                                     
the
www.2cto.com
Start the service again, back to normal
[oracle@dtydb3 trace]$ srvctl start service -d epmdb -s srv_epm1 -i epmdb1
PRCC-1014 : srv_epm1 was already running
PRCR-1004 : Resource ora.epmdb.srv_epm1.svc is already running

the
the
Author hijk139