How to Drop Database in Oracle 19c and Uninstall the Oracle 19C Binaries in Windows Os

Shaik Mohammed Nawaz March 8, 2020 ORACLE

This article contains information about dropping database in Oracle 19c and unistalling Oracle 19C binaries in Windows.

STEP1 : Connect As SYSDBA

C:\Users\DELL>sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 9 01:09:25 2020
Version 19.3.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> set lines 300
SQL> select name,open_mode,version from v$database,v$instance;
NAME OPEN_MODE VERSION
--------- -------------------- -----------------
NAWAZDB READ WRITE 19.0.0.0.0

C:\Users\DELL>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 9 01:09:25 2020

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> set lines 300

SQL> select name,open_mode,version from v$database,v$instance;

NAME OPEN_MODE VERSION

--------- -------------------- -----------------

NAWAZDB READ WRITE 19.0.0.0.0

STEP 2: Shut Down The Database

SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

SQL> shu immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

Step 3: Startup the DB in MOUNT Restrict Mode

SQL> startup mount restrict
ORACLE instance started.

Total System Global Area 725611424 bytes
Fixed Size 9032608 bytes
Variable Size 532676608 bytes
Database Buffers 176160768 bytes
Redo Buffers 7741440 bytes
Database mounted.
SQL>
SQL> select name,open_mode,version,host_name from v$database,v$instance;

NAME OPEN_MODE VERSION HOST_NAME
--------- -------------------- ----------------- -------------------------------
---------------------------------
NAWAZDB MOUNTED 19.0.0.0.0 DELL-PC

SQL>
SQL> col host_name for a30
SQL> /

NAME OPEN_MODE VERSION HOST_NAME
--------- -------------------- ----------------- ------------------------------
NAWAZDB MOUNTED 19.0.0.0.0 DELL-PC

SQL> startup mount restrict

ORACLE instance started.

Total System Global Area 725611424 bytes

Fixed Size 9032608 bytes

Variable Size 532676608 bytes

Database Buffers 176160768 bytes

Redo Buffers 7741440 bytes

Database mounted.

SQL>

SQL> select name,open_mode,version,host_name from v$database,v$instance;

NAME OPEN_MODE VERSION HOST_NAME

--------- -------------------- ----------------- -------------------------------

---------------------------------

NAWAZDB MOUNTED 19.0.0.0.0 DELL-PC

SQL>

SQL> col host_name for a30

SQL> /

NAME OPEN_MODE VERSION HOST_NAME

--------- -------------------- ----------------- ------------------------------

NAWAZDB MOUNTED 19.0.0.0.0 DELL-PC

STEP 4 : Drop The Database

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Pr
oduction
Version 19.3.0.0.0
SQL>