Oracle manually delete the library

When the graphical interface is unavailable, we need to manually delete the database.

1. Stop listening to prevent new connections from being generated. At the same time, if em is configured in the database, it needs to be stopped.

$ lsnrctl stop listener_name

$ emctl stop dbconsole

2. Get information about data files, log files and control files, including archives

$ sqlplus /as sysdba

SQL>show parameter control

Get the path to the control file

SQL>select file_name from dba_data_files;

Get the location of the data file

SQL>select * from v$logfile;

Get the location of the log file

SQL>archive log list;

Get path to archive logs

SQL>shutdown immediate(abort);

Close the database, anyway, to delete, you can consider using abort

3. Boot to mount state (using exclusive restart)

SQL> startup mount exclusive restrict;

mount database to exclusive mode

SQL> show parameter instance;

It is important to check if it is an instance to delete.

4. Modify parameter to allow restricted session mode

SQL>alter system enable restricted session;

5. Use the drop database command to purge the database

SQL>drop database;

SQL>exit

6. Manual purge of related files

Delete the corresponding file according to the result of query in step 2.

Windows can open a window into the directory delete. Linux can be deleted using RM

7. Clear relevant listening files

After 11G, many are dynamically registered, so don't consider this step. If static listening is configured, delete the configuration in the listener.ora file.

8. Modify oratab file and.bash_profile