首页 > oracle > oralce删除数据库

oralce删除数据库

2017年8月14日 发表评论 阅读评论

sqlplus / as sysdba
SQL> startup
ORACLE instance started.

Total System Global Area 2.0176E+10 bytes
Fixed Size 2261928 bytes
Variable Size 2818575448 bytes
Database Buffers 1.7314E+10 bytes
Redo Buffers 41463808 bytes
Database mounted.
Database opened.
SQL> alter database close;

Database altered.

SQL> alter system enable restricted session;

System altered.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With

删除 /etc/oratab
删除 rm -rf product/
删除 rm -rf oraInventory/

未关闭的进程杀掉
[root@localhost ~]# ps -ef|grep ora
root 4736 3961 0 13:17 pts/2 00:00:00 su - oracle
oracle 4737 4736 0 13:17 pts/2 00:00:00 -bash
oracle 4763 1 0 13:18 ? 00:00:00 /home/oracle/product/11gR2/bin/tnslsnr LISTENER -inherit
root 5482 3790 0 13:36 pts/1 00:00:00 grep ora
[root@localhost ~]# kill -9 4763

这样重新安装数据库,不会报实例冲突

除非注明,本站文章均为: nginx.cn原创,转载请注明本文地址: http://www.nginx.cn/4680.html

--完--

分类: oracle 标签:
  1. 本文目前尚无任何评论.
  1. 本文目前尚无任何 trackbacks 和 pingbacks.