V6 to V7 migration question
Date: 1995/09/25
Message-ID: <DFH8Jv.I2C_at_ranger.daytonoh.attgis.com>#1/1
Hello all !
I am trying to migrate a version 6 database to version 7, and decided to use the import/export utility. I logged into the V6 database as owner of the database and exported the entire database into a file using:
exp system/<password> file=expdat.dmp full=y
My next step was to log into UNIX as owner of the installation ( Oracle7 ) in order to create a new database and the tablespace shells into which the Oracle-binary data in the expdat.dmp file can be imported.
I copied the parameter files to new filenames ( initAUTO.ora and configAUTO.ora
),
and I modified all the parameters in these files. Then did a startup nomount
with these parameter files:
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
Enter user-name:
What is happening here ? Before this attempt, when I tried to connect internal,
the message was that the ARCH process terminated with error. I did an
ipcs -b, and removed the ARCH process from the shared memory. Then the
instance started. But now I am having this problem...All I want to do is to
create
the database and some tablespaces in this database.
Any opinions as to what I am doing wrong ? Thank you very much...
Nalini Vallampati
Nalini Vallampati
AT&T Capital GIS
Miamisburg, OH 45342
UNIX Admin/Oracle DBA
AT&T Capital - Global Information Solutions
Miamisburg, OH 45342
Received on Mon Sep 25 1995 - 00:00:00 CET