Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle manually delete the library

2025-04-07 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report