Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am running Oracle 11g on windows 2003. What are the steps to rename database? I had followed the steps in http://www.ordba.net/Tutorials/OracleUtilities~DBNEWID.htm but I can't get past the error,

NID-00121: Database should not be open

I had tried the exact steps that were mentioned in the link but still it gives me the same error.

Appreciate any help, thanks in advance.

Arther

share|improve this question

1 Answer 1

First, make a backup of the db. Second, try this one:

http://www.oracle-base.com/articles/misc/RenamingOrMovingOracleFiles.php

Anyway renaming an oracle db is always complicated. That error is because you try to rename the db when it's open. As it's written there, you should:

shutdown immediate

startup mount

share|improve this answer
    
Thanks for the repy. –  arthur.aoife Jul 1 '10 at 3:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.