DROP A DATABASE IN ORACLE
High level steps of database drop in oracle
Shutdown the database instance
SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
Startup database in exclusive restrict to block incoming client connections to the database
SQL> startup mount exclusive restrict;
ORACLE instance started.
Total System Global Area 1169149952 bytes
Fixed Size 2252624 bytes
Variable Size 385876144 bytes
Database Buffers 771751936 bytes
Redo Buffers 9269248 bytes
Database mounted.
Drop the database
SQL> drop database;
Database dropped.Then you can use dbca to delete the SID and other entries from the server
Then perform the housekeeping of old archivelogs ,audit files and trace files related to the database