Moving an Oracle 7 installation

From: Stephan Marwedel <marwedel_at_thales.de>
Date: Fri, 03 Sep 1999 17:25:32 +0200
Message-ID: <37CFE86C.74731502@thales.de>

Hi,

I want to move an existing Oracle 7 installation on AIX (/usr/local/oracle) from to another filesystem (/opt/oracle). What must I change in the configuration do achive this? I changed the init.ora for my instance and all startup variables for the oracle dba user, but the server stills complains about a missing database file (.dbf), which is seems to search for in the old location:

SVRMGR> startup
ORACLE instance started.

Total System Global Area       4938876 bytes
Fixed Size                       48124 bytes
Variable Size                  4055168 bytes
Database Buffers                819200 bytes
Redo Buffers                     16384 bytes

Database mounted.
ORA-01157: cannot identify data file 1 - file not found ORA-01110: data file 1: '/usr/local/oracle/dbs/systTC_ORA2.dbf'

So far I only got the server up again by linking the new location the the old.

Any hints?

Thanks in advance.

Stephan

Stephan Marwedel, Object Technology Group THALES Communication GmbH, Hamburg, Germany Email: marwedel_at_thales.de
Web: http://www.thales.de

-> This message was created 100% Micro$oft free <-

Received on Fri Sep 03 1999 - 10:25:32 CDT