Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Unable to Start Second RAC DB Instance on Node 2: Troubleshooting Parameter file issue

MoHaMeD.AliFeb 9 2024

I have a 2 nodes RAC and I decided to add an extra instance for my DB in node 2 but whenever I start up the instance I get this error

oracle@vm1:~$ srvctl start database -d students

PRCR-1079 : Failed to start resource ora.students.db
CRS-5017: The resource action "ora.students.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19.0.0/db_1/dbs/initstudents2.ora'
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/vm2/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.students.db' on 'vm2' failed
CRS-2632: There are no more servers to try to place resource 'ora.students.db' on that would satisfy its placement policy

Then i tried to run it in my node 2 host server and got the following:

oracle@vm2:~$ srvctl start instance -d students -i students2
PRCR-1013 : Failed to start resource ora.students.db
PRCR-1064 : Failed to start resource ora.students.db on node vm2
CRS-5017: The resource action "ora.students.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19.0.0/db_1/dbs/initstudents2.ora'
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/vm2/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.students.db' on 'vm2' failed

Comments
Post Details
Added on Feb 9 2024
0 comments
50 views