Oracle 12c RAC, what should I do if one of the node database instances can t get up

Generally, there are 2 VIPs on one node, and your situation here is that the positions of the 2 VIPs are reversed.

Although you can't tell why this is the case based on the information you provided, you can try the crs stop and crs start commands, shut down the VIP and then restart the VIP resource on the correct node. Then you should be ready to start listening.

It's a bit strange for you, generally 2 VIPs are on one node, and your situation here is that the positions of 2 VIPs are reversed.

Although you can't tell why this is the case based on the information you provided, you can try the crs stop and crs start commands, shut down the VIP and then restart the VIP resource on the correct node. Then you should be ready to start listening.

Check the logs to see what errors are reported to know what causes node 2 to not get up.

What about the operating system, the Oracle version, the error logs?

Do you want me to pinch my fingers?

I have also encountered this problem, it should be that the process parameter in the spfile is not set large enough, resulting in not being able to start two instances at the same time, you try to set the process to a little larger, of course, you also have a larger memory, otherwise the return memory is not enough.

1. Whether the manual sqlplus can be started successfully.

2. Upload and.

Oracle DBA: PRM disaster recovery tool for schema-level data recovery. PRM for Oracle Database Schema-level Oracle Database Data Recovery Manager, or ParnassusData Recovery Manager, is an enterprise-level Oracle database disaster recovery tool.

PRM can restore truncated tables without backup, and can also restore data in Oracle databases that cannot be opened (alter database open failed). PRM is a graphical enhancement to Oracle DUL that has many features that Oracle DUL does not have.