In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.