Oracle A423961 User Manual
Page 57
2 – 31
Installing Oracle7 Server for Windows NT
7.0.15 to 7.3
7.1.3 to 7.3
7.2.2 to 7.3
SVRMGR> alter database open;
SVRMGR> alter database open;
SVRMGR> alter database open;
SVRMGR> @%RDBMS73%\ADMIN\cat70101
SVRMGR> @%RDBMS73%\ADMIN\cat70102
SVRMGR> @%RDBMS73%\ADMIN\cat7103
SVRMGR> @%RDBMS73%\ADMIN\cat7201.sql
SVRMGR> @%RDBMS73%\ADMIN\cat7201.sql
SVRMGR> @%RDBMS73%\ADMIN\cat7203.sql
SVRMGR> @%RDBMS73%\ADMIN\cat7301
SVRMGR> @%RDBMS73%\ADMIN\cat7301
SVRMGR> @%RDBMS73%\ADMIN\cat7301
SVRMGR> @%RDBMS73%\ADMIN\cat7302.sql
SVRMGR> @%RDBMS73%\ADMIN\cat7302.sql
SVRMGR> @%RDBMS73%\ADMIN\cat7302.sql
SVRMGR> @%RDBMS73%\ADMIN\catalog
SVRMGR> @%RDBMS73%\ADMIN\catalog
Note:
The statements in the table below are for special
purposes.
catproc.sql
is for PL/SQL functionality.
catrep.sql
is for the Advanced Replication Option. Run
catrep
only if you have the Advanced Replication Option and
want to use it. Refer to Appendix A for a detailed discussion of
Advanced Replication before proceeding.
Note:
Ensure that you spool all of the output from the .sql
scripts to a file. Then, check the file for errors.
Note:
catrep
may take an hour or more to run!
7.0.15 to 7.3
7.1.3 to 7.3
7.2.2 to 7.3
SVRMGR> @%RDBMS73%\ADMIN\catproc
SVRMGR> @%RDBMS73%\ADMIN\catproc
SVRMGR> @%RDBMS73%\ADMIN\catproc
SVRMGR> @%RDBMS73%\ADMIN\catrep
SVRMGR> @%RDBMS73%\ADMIN\catrep
SVRMGR> @%RDBMS73%\ADMIN\catrep
b. Rerun
utlxplan.sql
in any schema in which you want to use
EXPLAIN PLAN.
5.
Shut down and restart the database
Your Oracle database is now migrated to Release 7.3. Shutdown
and restart by entering the following commands at the Server
Manager prompt:
SVRMGR> shutdown
SVRMGR> startup