Re: ORA-19951: cannot modify control file until DBNEWID is completed

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 30 Nov 2007 09:34:59 +0100
Message-ID: <486b2b610711300034n5b983fd6yaa4e9f6ecc71912b@mail.gmail.com>

You can re-run nid with REVERT option, then fix the tempfile and run it again with all files in the right place.

Stefan

On Nov 30, 2007 5:57 AM, Prasad <p4cldba_at_gmail.com> wrote:

> All,
>
> while trying to change the dbname for a test db nid failed as I did not
> have a temp file in proper location. and it started giving this error while
> trying to create the tempfile.
>
> ORA-19951: cannot modify control file until DBNEWID is completed
>
> Is there anyway I can overcome this error.
>
> Please advise.
>
> thanks
> -Prasad
>
>
>

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 30 2007 - 02:34:59 CST