Drop Database

Learnomate Technologies > Drop Database
Drop oracle database
06
Jun

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. […]

Posted in: Oracle DBA ,
Tags: Drop Database , oracle , oracle admin , oracle Database , oracle dba ,
Drop oracle 12c database
06
Jun

Oracle 12c is a multi tenant architecture Oracle 12c database is having the root container database and it includes a pluggable database. following are the different ways to drop the Oracle 12c database. 1. DBCA (Silent Method or GUI) 2. Command Line Interface (startup mount restrict and then issue drop database) 3. Manually cleaning up […]

Posted in: Oracle DBA ,
Tags: Cleaning Up Files , Command Line Interface , database , DBCA , Drop Database , oracle , oracle 12c , oracle admin , oracle dba ,