Re: V6 to V7 migration question

From: Nick Ife <no.account_at_nt.com>
Date: 1995/09/26
Message-ID: <no.account-260995155612_at_nnsgm831.lon40.nt.com>#1/1


In article <DFIIrp.5Iq_at_ranger.daytonoh.attgis.com>, Nalini Vallampati <nalini.vallampati_at_daytonoh.attgis.com> wrote:

<version 6 to version 7 migration story abbreviated>

<in version 6 database>
> >>exp system/<password> file=expdat.dmp full=y

<in as-yet-uncreated version 7 database>
> >>SQLDBA> startup nomount pfile=/disk4/oracle/7.1.4/dbs/AUTO/initAUTO.ora
> >>ORACLE instance started.
> >>SQLDBA> exit
> >>SQL*DBA complete.
> >>$ sqlplus
 

> >>SQL*Plus: Release 3.1.3.5.1 - Production on Mon Sep 25 15:48:40 1995
 

> >>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
 

> >>Enter user-name: system
> >>Enter password:
> >>ERROR: ORA-01033: ORACLE initialization or shutdown in progress
> >
 

> Thanks,
> Nalini

In SQL*DBA, your startup was fine. At this point you could run your 'create database' script.

Only then can you log in using SQL*Plus and continue the build.

This may not be the only way, but it works for me!!

HTH
Nick Received on Tue Sep 26 1995 - 00:00:00 CET

Original text of this message