Oracle environment and data sources
After an uncontrolled failover, for Oracle SI and RAC complete the following procedure:
Enable dSources and VDBs on the target engine. dSources will be enabled but the VDBs/vPDBs will fail.
To enable VDBs, shutdown the database instance using SHUTDOWN ABORT.
Remove all the mounts from the target environment with sudo privilege.
List all the mounts on the target environment using the
mount
command.Run
umount -lf <Delphix-mount>
to remove the mounts. For example:umount -lf /mnt/provision/VDBOMSR8A1718_FPX/datafile
Remove all the stale oracle processes of the database instance using
kill -p <process id>.
Run
ps -ef | grep “DATABASE INSTANCE
to get all the running processes associated with the database instance. For exampleps -ef | grep VDBOMSR8A1718_FPX
. This command list all the running processes, e.g. oracle 15236 9227 0 11:01 pts/0 00:00:00 grep --color=auto VDBOMSR8A1718_FPXRun
kill -p <process id
to kill all the running processes. For example:kill -9 15236
Now enabling VDBs and VPDBs will be successful.