I want to delete multiple databases and its entries. These instances are not getting started. I want to delete data files also.

EDIT: I am thinking delete all data files. Please help on below concern.

Shall I delete data files manually? Will it cause any problem to my working database instance?

  • Could you provide us with additional information? What system is Oracle running on? (Windows or *nix) Are you able to run a GUI? Ever had a look at DBCA (Database Configuration Assistant)? – John K. N. Nov 28 '17 at 6:04
  • Thanks for a reply. Oracle is on windows system. On DBCA screen I can see the list of databases. As those instances are not getting started I am not able to login into it. – javaGuy Nov 28 '17 at 6:27
  • You are probably looking for drop pluggable database – a_horse_with_no_name Nov 28 '17 at 6:46

The easiest and safest way to delete a database is using the RMAN DROP DATABASE command.

If on Linux, set up your ORACLE_HOME and ORACLE_SID environment variables appropriately then start the database(s) using startup mount exclusive restrict. Then drop it using RMAN's DROP DATABASE. If you want to delete the backups/contents of the FRA as well, then use DROP DATABASE INCLUDING BACKUPS.

You could also use the GUI (DBCA - Database Creation Assistant), but this may be trickier depending on the environment.

  • Thanks for your help. Currently I am on windows system. As I said those databases are having some problems and will not start. Will 'start mount' command work? – javaGuy Nov 28 '17 at 10:09
  • It depends what the problems are. Startup mount doesn't attempt to read the datafiles, only the controlfile(s), so depending what's wrong, it might work. – Phil Sumner Nov 29 '17 at 9:33

Oracle has a Deinstall program. Go into the Oracle home of the database you want to remove. In the bin directory you will see a deinstall.pl (*nix) and a deinstall.bat (Windows). Depending on which OS you are using start either one or the other.

This will delete everything except the inventory file. You will then need to go into the OS and remove the database entry from the oratab file.

  • 2
    This will remove the Oracle Home, which, given that the user states that they have other running databases, might not be the best idea. – Phil Sumner Nov 28 '17 at 8:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.