Home > linux, oracle > Removing an Oracle Instance in silent mode

Removing an Oracle Instance in silent mode


This post will be simple but really efective. If you want to delete an instance in silent mode, without using any GUI, you just have to write the following as oracle user:

 

dbca -silent -deleteDatabase -sourceDB YOUR_DATABASE

 

I hope you will find this command as useful as it is for me 🙂

Advertisements
Categories: linux, oracle Tags: ,
  1. Prashanth K
    August 20, 2011 at 7:50 pm

    Hi..
    I found this script effective.
    Can you please Explain this in detail.
    Where this command have to write…In command prompt or SQL Worksheet as SYSDBA.
    I am working as Oracle DBA Instructor.
    I am curious to know, how this command works…
    I would grateful, if any one who could solve my doubt.

    • August 22, 2011 at 6:39 am

      Hi, you have to execute it in command prompt, using dbca, the command which is used to create an instance in interactive mode. However, if you add the parameter -silent, you can launch this command without using the graphic mode.

      I think it’s useful if you need to delete an instance and you don’t have a graphical environment at this moment, or you want to delete it faster.

      If you have any more questions, feel free to ask again.

      Regards

  2. Abhijit
    July 30, 2012 at 4:22 pm

    Hi,
    Please send me scenario based questions for DBA fresher
    Thanks in advance..!!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: