I have run some searches and review the documentation... but I haven't found any way to drop/remove/delete databases using 12c EM.
We have multi-instance environments (one physical server with several instances/database). And from time to time we have to remove one or more instances when they are decommissioned.
So far we are using DBCA, but I wonder if there is any way to do the same with EM "out of the box ...
Could someone point me in the right direction?
Thanks in advance,
the only "out of the box" methods to delete/remove a database would be:
- Create a "User defined procedure" to do the job - Checkout the "Lifecycle Management" guide in the documentation
- When using the Self Service Portal as part of the Cloud Management feature, users would be able to request for a database to be created. When requesting for a database to be created the user can also identify for what period he/she would need the database. Meaning that you can indicate the moment a database need to be decommissioned. In that case not only a Job will be scheduled to create the requested database, but also a job will be scheduled to remove the database after the indicated time frame has passed. Check for this the Cloud Management Guide.
- You could of course also think about doing this using a custom made script that you could schedule from the EM job system.
Well enough material to think about ;-)
Rob's summary is spot on. While we do have plans in future of providing a formal delete procedure for databases, at the moment you are limited to the 3 options listed in Rob's response.
Here is some helpful documentation:
DB Cloud / Self Service portal: