Oracle A423961 User Manual
Page 51

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>\ 1. List files for the instance For each instance you want to migrate, make a list of the control, 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 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 5. De–install the 7.0/7.1/7.2 server, RSFs and Utilities
data, and log files for the instance.
database version using
database documentation.