OraFAQ Forum: Server Administration » Trying to delete a database

Home » RDBMS Server » Server Administration » Trying to delete a database

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

Trying to delete a database [message #140303]

Mon, 03 October 2005 09:41

duff
Messages: 5
Registered: October 2005
Location: Dublin

Junior Member

We are currently trying to delete a database using Database Configuration Assistant, Oracle 8. It asks for the internal password - which I don't have access to. I have tried the usual "oracle" but this doesn't work.

To make things more difficult, we no longer can access the database with sysdba privileges and the database is in shutdown mode, so I can't try to reset the password.

Is there any way to go around this?

Thanks in advance

Report message to a moderator

Re: Trying to delete a database [message #140305 is a reply to message #140303]

Mon, 03 October 2005 09:50

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

If you don't have anything else oracle on your system that you want to keep, you can (after double checking this is ok) just uninstall the oracle software, delete all the files from the system, and clean out all registry entries. Then install 10gR2.

Report message to a moderator

Re: Trying to delete a database [message #140306 is a reply to message #140305]

Mon, 03 October 2005 09:53

duff
Messages: 5
Registered: October 2005
Location: Dublin

Junior Member

smartin wrote on Mon, 03 October 2005 09:50

Unfornately I can't do that! There are other lives databases running on the server - thanks anyhow Smile

Report message to a moderator

Re: Trying to delete a database [message #140392 is a reply to message #140306]

Tue, 04 October 2005 00:46

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Hi

The default password for internal is "oracle". Try with that. You may get lucky.

--Girish

Report message to a moderator

Re: Trying to delete a database [message #140682 is a reply to message #140392]

Wed, 05 October 2005 03:50

duff
Messages: 5
Registered: October 2005
Location: Dublin

Junior Member

Yeah have tried that password but its not accepting it!

Report message to a moderator

Re: Trying to delete a database [message #140710 is a reply to message #140682]

Wed, 05 October 2005 05:32

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,
do one thing rename the password file for the database ... that means ur database is crashed as it will not get password file to do authentication .... as u told earlier that ur database is in shutdown mode ... so now you recreate password file for the database and then try to connect to that database ... Smile

Note :- I assume that u had access to the server as root user (ie. on linux, unix o/s) or if your database is on windows then u you had admin right on it.

regards
Always friend sunilkumar

Report message to a moderator

Re: Trying to delete a database [message #140712 is a reply to message #140710]

Wed, 05 October 2005 05:43

duff
Messages: 5
Registered: October 2005
Location: Dublin

Junior Member

Thanks for that info - can I ask where would the password file be located? thanks

Report message to a moderator

Re: Trying to delete a database [message #140715 is a reply to message #140712]

Wed, 05 October 2005 05:50

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

You cant edit the existing password file,

create a new password file using ORAPWD utility,

Read this
http://www.orafaq.com/faqdbase.htm#INTERNAL

regards,
tarun

Report message to a moderator