How do I delete a database instance on VMS?

There is no utility to delete a database however Oracle recommends the following procedure:

  • Shut down the database.
  • Edit the file ORA_RDBMS:ORA_RDBMS_SIDS.DAT and remove the reference to the database instance.
  • Do the same again to the file ORA_UTIL:DATABASE.TXT
  • All the database files can now be deleted without confusing Oracle.