Drop oracle database

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 06 Jun, 2019
  • 0 Comments
  • 50 Secs Read

Drop oracle database

STEP 1. Set up the environment

[oracle@oracle database]$ . oraenv

ORACLE_SID = [oracle] ? mydb

The Oracle base for ORACLE_HOME=/data/oracle/app/oracle/product/11.2.0/dbhome_2 is /data/oracle/app/oracle

[oracle@oracle database]$

[oracle@oracle database]$

[oracle@oracle database]$

STEP 2. Connect to sqlplus utility

[oracle@oracle database]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 15 15:47:17 2018

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

STEP 3. Shutdown database

SQL> shu immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

STEP 4. Start database in mount stage with restricted mode.

SQL> startup mount restrict

ORACLE instance started.

Total System Global Area 830930944 bytes

Fixed Size 2217912 bytes

Variable Size 629147720 bytes

Database Buffers 197132288 bytes

Redo Buffers 2433024 bytes

Database mounted.

STEP 5. Drop the database finally.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.