Oracle Oracle7 Server 7.3, Руководство по началу работы

Страница: 57 / 202

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