本文共 1154 字，大约阅读时间需要 3 分钟。

本博文将介绍如何不使用DBCA（数据库配置助手）在Oracle 11中删除数据库。

1- 导入数据库的SID，如果没有定义的话

export ORACLE_SID=SIDNAME

• 1

2- 以操作系统认证连接数据库

[oracle@Oracle11 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 1 17:38:02 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.

• 1
• 2
• 3
• 4
• 5

3- 启动数据库实例

SQL> startupORACLE instance started.Total System Global Area 3340451840 bytesFixed Size 2217952 bytesVariable Size 1828718624 bytesDatabase Buffers 1493172224 bytesRedo Buffers 16343040 bytesDatabase mounted.Database opened.

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10

4- 关闭数据库

SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.

• 1
• 2
• 3
• 4
• 5

5- 启动独占模式

SQL> startup mount exclusive restrictORACLE instance started.Total System Global Area 3340451840 bytesFixed Size 2217952 bytesVariable Size 1828718624 bytesDatabase Buffers 1493172224 bytesRedo Buffers 16343040 bytesDatabase mounted.

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10

6- 删除数据库

SQL> drop database;
Database dropped.Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options