Hi,
I found this blog describe how to cold fail over single instance database to another node in ODA
https://weidongzhou.wordpress.com/2013/09/11/cold-failover-single-instance-db-to-different-node-on-oda/
but when I tried the similar with Oak 12.2.1.4.0 and database 12.2.0.1 ,
after I modify the database with srvctl below to switch the database to node2
srvctl modify database -db dbtest -node node2
when I tried to start the dbtest database in node2, the error below prompt
[oracle@node2 dbs]$ srvctl start database -db dbtest
PRCR-1079 : Failed to start resource ora.dbtest.db
CRS-5017: The resource action "ora.dbtest.db start" encountered the following error:
ORA-27106: system pages not available to allocate memory
Additional information: 6048
Additional information: 1
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/node2/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.dbtest.db' on 'node2' failed
CRS-2632: There are no more servers to try to place resource 'ora.dbtest.db' on that would satisfy its placement policy
Anyone if the similar thing can be configured in GI 12.2.0.1?
Thanks