Re: Control File Blues!
From: Helena Whitaker <helena_at_creighton.edu>
Date: 1995/05/12
Message-ID: <Pine.HPP.3.91.950512091717.15475A-100000_at_finch.creighton.edu>#1/1
Date: 1995/05/12
Message-ID: <Pine.HPP.3.91.950512091717.15475A-100000_at_finch.creighton.edu>#1/1
On 11 May 1995, Anthony B. Cillo wrote:
> I am migrating our database from V6 to V7. I think I have done everything
> but when I try to start the database it tells me that the control file is
> not for this version of the database. I look in the messages books and it
> tells me to do a create controlfile command and build the new control file.
> The problem is that the database needs to be up for me to create the
> control file!
>
> Any ideas?
>
> Tony
>
Try startup nomount before the create controlfile.
(REF: SQL Language Reference Manual, for Create Controlfile: 'The database must not be mounted by any instance') There are other warnings and cautions in that section, such as needing media recovery afterwards, and doing a shutdown and full backup right away. Also more warnings in Oracle7 Administrator's Guide, pg 6-5+. Good Luck ! helena
-- <:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:> <: Helena Whitaker, Database Administrator helena_at_creighton.edu :> <: Creighton University (0800-1630 CT) (402)280-2311 :> <: Old Gym - 2500 California Plaza fax (402)280-2573 :> <: Admin Computing-Fin Sys Spt Platform: HP-UX 9.0.4 (unix) :> <: Omaha, NE 68178-0046 HP 9000/887 (aka H50), 842, 806 :> <: Oracle 6.0.36.7.1/Banner Finance 2.0.3 :> <: Oracle 7.1.3/DeLair Patient Accounting :> <:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>Received on Fri May 12 1995 - 00:00:00 CEST