Relocating enabl database for oracle 19c

Relocating enabl database for oracle 19c

1:- After the upgrade add this hosting members as below

$GRID_HOME/bin/crsctl modify resource ora.enabl.db -attr "HOSTING_MEMBERS='server01 server02' PLACEMENT='favored'" -unsupported

2:- Create directories as show below and copy the tns enties on db1

mkdir -p /u01/app/oracle/diag/rdbms/enabl/enabl1/trace

3:-Relocate the enabl database to db1

crsctl relocate resource ora.enabl.db -c server01 -f -unsupported

4:- Create the senabl service on db1

$ORACLE_HOME/bin/srvctl add service -database enabl -service senabl -pdb enabl

5:- Start the service

$ORACLE_HOME/bin/srvctl start service -database enabl -service senabl
$ORACLE_HOME/bin/srvctl status service -database enabl -service senabl

6:- Validate the connection

sqlplus cdba/cdba@enabl1
show user
show con_name

7:- Relocate enabl back to db2 and validate the connection

crsctl relocate resource ora.enabl.db -c server02 -f -unsupported
$ORACLE_HOME/bin/srvctl status service -database enabl -service senabl
sqlplus cdba/cdba@enabl1
show user
show con_name

NOTE:- If the senabl service is already created on DB2, remove the service and create it back from db1

On DB2

srvctl stop service -d enabl -s senabl
srvctl stop service -d enabl -s rman_enabl
$ORACLE_HOME/bin/srvctl remove service -database enabl -service senabl -pdb enabl

On DB1

$ORACLE_HOME/bin/srvctl add service -database enabl -service senabl -pdb enabl
$ORACLE_HOME/bin/srvctl start service -database enabl -service senabl -pdb enabl