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 ...
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.