DBA Hub

📋Steps in this guide1/2

Delete database using DBCA silent mode - Bright DBA

Delete database using DBCA silent mode AIM: We want delete database POCNDEV using DBCA silent mode [oracle@rac2 ~]$ ps -ef | grep pmon oracle 3542 1 0 05:13 ? 00:00:00 asm_pmon_+ASM oracle 3686 1 0 05:14 ? 00:00:00 ora_pmon_COLLEGE oracle 3877 3976 0 07:12 pts/1 00:00:00 grep pmon oracle 5045 1 0 05:33 ? 00:00:00 … Continue reading Delete database using DBCA silent mode →

oracle clusteringintermediate
by OracleDba
13 views
1

Overview

Delete database using DBCA silent mode AIM: We want delete database POCNDEV using DBCA silent mode Please don't try in your office machines

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
[oracle@rac2 ~]$
ps -ef | grep pmon
oracle    3542     1  0 05:13 ?        00:00:00 asm_pmon_+ASM
oracle    3686     1  0 05:14 ?        00:00:00 ora_pmon_COLLEGE
oracle    3877  3976  0 07:12 pts/1    00:00:00 grep pmon
oracle    5045     1  0 05:33 ?        00:00:00 ora_pmon_
POCNDEV <---
oracle    6436     1  0 05:54 ?        00:00:00 ora_pmon_FICO
[oracle@rac2 ~]$
. oraenv
ORACLE_SID = [POCNDEV] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 21 07:13:35 2016

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
select name, open_mode from v$database;
NAME      OPEN_MODE
--------- --------------------
POCNDEV
READ WRITE

SQL>
shut immediate; <---
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rac2 ~]$
ps -ef | grep pmon
oracle    3542     1  0 05:13 ?        00:00:00 asm_pmon_+ASM
oracle    3686     1  0 05:14 ?        00:00:00 ora_pmon_COLLEGE
oracle    3957  3976  0 07:14 pts/1    00:00:00 grep pmon
oracle    6436     1  0 05:54 ?        00:00:00 ora_pmon_FICO
[oracle@rac2 ~]$
[oracle@rac2 ~]$
which dbca
/u01/app/oracle/product/11.2.0.4/db_1/bin/dbca
Please don't try in your office machines
[oracle@rac2 ~]$
dbca -silent -deleteDatabase -sourceDB POCNDEV -sysDBAUserName sys -sysDBAPassword sys
Connecting to database
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/POCNDEV.log" for further details.
[oracle@rac2 ~]$
2

Section 2

dbca -silent -deleteDatabase -sourceDB POCNDEV -sysDBAUserName sys -sysDBAPassword sys Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using. Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!