OraFAQ Forum: RAC & Failsafe » Drop database in standalone database

Home » Server Options » RAC & Failsafe » Drop database in standalone database (Oracle 11.2.0.4.0 , Linux 2.6 , SunOS 5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Drop database in standalone database [message #619576]

Wed, 23 July 2014 08:34

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hello ,

I once used the following command to drop a database in RAC environment and it was successful.

/u01/app/oracle/product/11.2.0/DB1/bin/dbca -silent -deleteDatabase -sourceDB AD0001C -sysDBAUserName SYS -sysDBAPassword Passw0rd
then insure that /etc/oratab is clean on all nodes

My question is shall i use the same command to drop a database for standalone database ?
Can you clarify ?

Regards,
Srini

Report message to a moderator

Re: Drop database in standalone database [message #619578 is a reply to message #619576]

Wed, 23 July 2014 08:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

yes
no

Report message to a moderator

Re: Drop database in standalone database [message #619584 is a reply to message #619576]

Wed, 23 July 2014 10:40

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Balaji/Ajit/Jack/Mohan/Mathew/Suhas/Srini,

This is the kind of question you could answer by yourself just trying it instead of relying on a forum answer which can be wrong.
Now you have a "yes" and then? Will you blindly trust it or will you try and check if it is actually done? In the later, why did you post the question before this test?
In short, the topic is completely useless and just a waste of time, for you, for us, for any reader.

Report message to a moderator

Re: Drop database in standalone database [message #619591 is a reply to message #619584]

Wed, 23 July 2014 12:11

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi Michel,
Quote:

This is the kind of question you could answer by yourself just trying it instead of relying on a forum answer which can be wrong.
Now you have a "yes" and then? Will you blindly trust it or will you try and check if it is actually done? In the later, why did you post the question before this test?
In short, the topic is completely useless and just a waste of time, for you, for us, for any reader.

Yes you are absolutely correct.I should have tried myself and then posted my question here if i had faced any problem in the middle.
In addidtion to that i should first try to install Oracle on my machine and then go for testing.I will soon do that.
In one point of view your answer is correct.But never mind who i am . And i am not an enemy to anybody here on this forum.
All i want to say is 'Think positive and be positive' so that your life will be positive'.

Regards,
Srini

Report message to a moderator

Re: Drop database in standalone database [message #619594 is a reply to message #619591]

Wed, 23 July 2014 12:34

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

.But never mind who i am

So don't sign if you don't want to give your real name.

Report message to a moderator

Re: Drop database in standalone database [message #619601 is a reply to message #619594]

Wed, 23 July 2014 12:49

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Michel,
Quote:

So don't sign if you don't want to give your real name.

What are you going to do by knowing my real name Smile

? I am eager to know your answer.
Do you think everyone is using their real name and has single account on this forum:) ?

This thread is going out of oracle Razz

[Updated on: Wed, 23 July 2014 12:50]

Report message to a moderator

Re: Drop database in standalone database [message #619604 is a reply to message #619601]

Wed, 23 July 2014 12:57

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

What are you going to do by knowing my real name ?

Nothing, it is a matter of honesty.

Quote:

Do you think everyone is using their real name and has single account on this forum:) ?

Maybe not but they are quite rare, and I doubt they have ten or so like you.
So why are you using several accounts? We have asked you this several times and you never answered.
I am eager to know your answer. Smile

Report message to a moderator

Re: Drop database in standalone database [message #619610 is a reply to message #619604]

Wed, 23 July 2014 13:15

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Quote:

So why are you using several accounts? We have asked you this several times and you never answered.

Just wanted to have more than one account.So created. Smile

[Updated on: Wed, 23 July 2014 13:15]

Report message to a moderator

Re: Drop database in standalone database [message #619612 is a reply to message #619610]

Wed, 23 July 2014 13:18

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why? You didn't answer the question.

Report message to a moderator

Re: Drop database in standalone database [message #619617 is a reply to message #619612]

Wed, 23 July 2014 13:49

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Quote:

Why? You didn't answer the question.

what question ?

Report message to a moderator

Re: Drop database in standalone database [message #619619 is a reply to message #619617]

Wed, 23 July 2014 13:54

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

So why are you using several accounts? We have asked you this several times and you never answered.

Report message to a moderator

Re: Drop database in standalone database [message #619620 is a reply to message #619619]

Wed, 23 July 2014 13:59

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Just like that Smile

Report message to a moderator

Re: Drop database in standalone database [message #619621 is a reply to message #619620]

Wed, 23 July 2014 14:13

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So once again you lie and you will create a new account to get answers to your next questions.

Report message to a moderator

Re: Drop database in standalone database [message #619622 is a reply to message #619621]

Wed, 23 July 2014 14:20

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Quote:

So once again you lie and you will create a new account to get answers to your next questions.

No Michel.I wont create new account.I hope i can get answers with the current account. Razz

[Updated on: Wed, 23 July 2014 14:21]

Report message to a moderator

Re: Drop database in standalone database [message #619624 is a reply to message #619622]

Wed, 23 July 2014 14:26

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Not from me until you sincerely answer to my question.
So I bet you will.

Report message to a moderator

Re: Drop database in standalone database [message #619626 is a reply to message #619624]

Wed, 23 July 2014 14:33

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Report message to a moderator

Re: Drop database in standalone database [message #619627 is a reply to message #619626]

Wed, 23 July 2014 14:43

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

'Think positive and be positive' so that your life will be positive'.

Report message to a moderator

Re: Drop database in standalone database [message #619628 is a reply to message #619627]

Wed, 23 July 2014 14:46

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Michel,
How was that ?

Report message to a moderator

Re: Drop database in standalone database [message #619635 is a reply to message #619628]

Wed, 23 July 2014 15:08

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.youtube.com/watch?v=L2Wx230gYJw

[Updated on: Wed, 23 July 2014 15:09]

Report message to a moderator

Previous Topic:	Standalone Database
Next Topic:	listener is down: TNS-12543: TNS:destination host unreachable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 17:10:57 CST 2025