DBA Hub

📋Steps in this guide1/6

Drop oracle database

STEP 1. Set up the environment

oracle configurationintermediate
by OracleDba
13 views
1

Overview

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]$
2

Section 2

[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:
3

Section 3

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.
4

Section 4

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
5

Section 5

Variable Size 629147720 bytes Database Buffers 197132288 bytes Redo Buffers 2433024 bytes Database mounted. STEP 5. Drop the database finally. SQL> drop database;
6

Section 6

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.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!