beautypg.com

Oracle A423961 User Manual

Page 51

background image

2 – 25

Installing Oracle7 Server for Windows NT

size (for example, the following SQL statement adds an 8MB file to the
SYSTEM tablespace:

alter tablespace SYSTEM add datafile ’

file>\’ size 8M;

1.

List files for the instance

For each instance you want to migrate, make a list of the control,
data, and log files for the instance.

To get a list of these files for the instance:

a.

Run Server Manager in line mode.

b. Enter the following at the Server Manager prompt:

SVRMGR> connect system/

SVRMGR> spool migrate.log;

SVRMGR> select member from v$logfile ;

SVRMGR> select name from v$datafile ;

SVRMGR> select value from v$parameter

where name = ’control_files’;

2.

Shut down your Oracle7 database

At the

SVRMGR

prompt, enter the following:

SVRMGR> connect internal

SVRMGR> shutdown

SVRMGR> exit

3.

Shut down and delete Oracle services

Shutdown and delete Oracle services belonging to the earlier
database version using

orasrv.exe

(for Version 7.0),

oradim71.exe

(for Version 7.1),

oradim72.exe

(for Version 7.2).

Example:

oradim71 –delete –srvc

Note:

This stops and deletes the service.

4.

Backup the 7.0/7.1/7.2 database

For more information on backing up your database, see your
database documentation.

5.

De–install the 7.0/7.1/7.2 server, RSFs and Utilities