3 Replies Latest reply: Apr 4, 2013 10:53 AM by Francisco Palomares RSS

    Deleting/dropping/removing database using Enterprise Manager  (12c)

    Francisco Palomares
      Hi,
      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,

      Francisco Palomares
        • 1. Re: Deleting/dropping/removing database using Enterprise Manager  (12c)
          Rob Zoeteweij
          Hello Francisco,

          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 ;-)

          Regards
          Rob

          http://oemgc.wordpress.com
          • 2. Re: Deleting/dropping/removing database using Enterprise Manager  (12c)
            Adeesh Fulay
            Francisco,

            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:

            Deployment Procedures:
            http://docs.oracle.com/cd/E24628_01/em.121/e27046/part_dp.htm#CCHJBDFD

            DB Cloud / Self Service portal:
            http://docs.oracle.com/cd/E24628_01/doc.121/e28814/cloud_roadmap.htm#BEHFHCDJ
            • 3. Re: Deleting/dropping/removing database using Enterprise Manager  (12c)
              Francisco Palomares
              Unfortunately not the answer I was hoping.
              But valid workarounds.
              Thanks to both !