Oracle8 Enterprise Edition Getting Started
Release 8.0.4 for Windows NT
A55928-01

Library
Product
Contents
Index

Prev Next

7
Migrating and Upgrading

This chapter describes the installation types you can choose when you have existing databases on your system. In particular, it describes how to migrate an Oracle7 database or upgrade an earlier Oracle8 database release to the current release of Oracle8 Enterprise Edition. This chapter also includes information on migrating a Microsoft Access database to an Oracle8 database.

Specific topics discussed are:

Intended Audience

This chapter is necessary for anyone who has existing Oracle7 and Oracle8 databases on their system and wants to install Oracle8 Enterprise Edition release 8.0.4.

Installation Types When You Have Existing Databases

Consider the following installation types if you have existing Oracle7 database(s) and Oracle8 database(s) on your system and want to install Oracle8 Enterprise Edition(s) release 8.0.4.

All of these installation types are described in detail in this chapter.

Additional Information:

See Oracle8 Enterprise Edition Installation for Windows NT if you want to install Oracle8 Enterprise Edition on a system containing no existing databases.

 

Database Coexistence and Multiple Oracle Homes Overview

Releases of Oracle for Windows NT and Windows 95 prior to release 8.0.4 supported single Oracle homes, allowing you to install and run Oracle products in a single Oracle home. Different versions of Oracle products could be installed in the same Oracle home provided they had different second-digit release numbers. For example, you could install version 7.2 products and version 7.3 products in the same Oracle home (database coexistence). However, you could not install multiple third-digit releases of the same products. For example, you could not install release 7.3.2 and release 7.3.3 versions of the same Oracle products on the same computer; one installation would over-write the other.

This release includes the new multiple Oracle homes feature, which enables you to install one or more releases of Oracle products on the same computer in multiple Oracle homes. For example, with multiple Oracle homes, you can install version 8.0.3 products and 8.0.4 products in different Oracle homes on the same computer. You can still install different versions of Oracle products in the same Oracle home provided they have different second-digit release numbers. See Chapter 6, "Using Multiple Oracle Homes" for more information.

Migrating and Upgrading Overview

This section explains the difference between migrating and upgrading.

What is Migrating?

Migrating is the process of transforming one database version to a later database version. For example, transforming an Oracle7 database to an Oracle8 database is migrating the database system. The term migrating is also used in this manual to refer to the transformation of a Microsoft Access database to an Oracle8 database.

What is Upgrading?

Upgrading is the process of transforming one database release to another database release of the same database version. For example, transforming an Oracle8 database release 8.0.3 to an Oracle8 database release 8.0.4 is upgrading the database system.

Migrating and Upgrading Using Multiple Oracle Homes

You can easily migrate or upgrade databases across multiple Oracle homes. If you use the graphical user interface (GUI) Oracle Data Migration Assistant, all database instances on your system are displayed in a drop-down list. You select the Oracle database instance you want to migrate or upgrade and the assistant takes care of any multiple Oracle homes issues.

If you use the command line tools, the Migration Utility (MIG80) to migrate, or the CAT8004.SQL script to upgrade, you need to copy files from one Oracle home directory to another. You also must ensure the PATH variable is set correctly so that any Oracle database tools you run are started from the correct Oracle home directory.

Choosing an Installation Type

If you have an existing Oracle7 database(s) and Oracle8 database(s) on your system and want to install Oracle8 Enterprise Edition(s) release 8.0.4, you must decide to:

Consider the following database coexistence issues before you decide which of the above installation types is most suitable for your requirements:

Oracle7 Applications

Can all my Oracle7 applications run on an Oracle8 database?

Most Oracle7 applications can run on an Oracle8 database. Some applications cannot run on an Oracle8 database unless you upgrade them to versions which support Oracle8 databases. If you have a combination of Oracle7 and Oracle8 applications, you may want to have an Oracle7 database and Oracle8 database coexist on the same system, until you have time to upgrade all your Oracle7 applications to version 8. Contact your application vendor to check if your third-party applications are supported with Oracle8 Enterprise Edition.

Oracle7 Client Connections to Oracle8 Databases

As this figure illustrates, an Oracle7 client requires SQL*Net Client, and an Oracle server requires Net8 Server. When the client and server are on the same computer, both SQL*Net Client and Net8 Server are required.

Consider the following questions for your own environment:

Oracle8 Client Connections to Oracle7 Databases

An Oracle8 client requires Net8 Client, and an Oracle7 server requires SQL*Net Server. When the client and server are on the same computer, both Net8 Client and SQL*Net Server are required.

Consider the following questions for your own environment:

Oracle7 Client and Oracle8 Client/Server Configurations

Oracle7 and Oracle8 clients can communicate either with Oracle7 or Oracle8 databases. This functionality gives you maximum flexibility when designing your network and deciding when to:

Install Oracle7 and Oracle8 Databases in the Same Oracle Home

Install Oracle7 and Oracle8 databases in the same Oracle home directory and have both Oracle7 and Net8 clients connecting to Oracle7 and Oracle8 databases. The figure below gives an example of this network configuration:

You can install different versions of Oracle databases in the same Oracle home provided they have different first or second-digit versions. For example, you can have release 7.2.x, 7.3.x, and 8.0.x databases in the same Oracle home. You cannot install multiple third-digit releases of the same products. For example, you cannot install release 7.3.2 and release 7.3.3, or release 8.0.3 and release 8.0.4 versions of the same Oracle databases in the same Oracle home; one installation overwrites the other.

Ensure that each database instance has a unique SID. In particular, be careful that you do not use the default SID ORCL for subsequent installations if you already have a starter database with the SID ORCL installed. If you do so, the services of the later installation overwrite the services of the earlier installation.

Install Oracle7 and Oracle8 Databases in Multiple Oracle Homes

Install Oracle7 and Oracle8 databases in multiple (different) Oracle homes and have both Oracle7 and Net8 clients connecting to Oracle7 and Oracle8 databases. Multiple Oracle homes functionality currently only works with release 8.0.4. If you have, for example, release 7.3.3 products already installed, you cannot install any other release 7.x products in a different Oracle home. Also, if you have release 8.0.3 products already installed, you cannot install any other 8.0.3 products in a different Oracle home. The figure below gives an example of this network configuration:

Install Oracle7 and Oracle8 Databases on Separate Computers

Install Oracle7 and Oracle8 databases on separate computers and have both Oracle7 and Oracle8 clients connecting to both databases. The figure below shows two computers and a number of Oracle7 and Oracle8 clients. On each computer you can have a mix of databases and products in both single and multiple Oracle homes.

Migrate an Oracle7 Database to an Oracle8 Database

Migrate your Oracle7 database to an Oracle8 database and have both Oracle7 and Oracle8 clients connecting to the Oracle8 database. You can migrate your Oracle7 database to an Oracle8 database either in the same Oracle home or in a different Oracle home. See "Migrating an Oracle7 Database" for instructions. The figure below illustrates this network configuration:

Upgrade an Oracle8 Database to the Current Oracle8 Database Release

Upgrade your Oracle8 database, for example, release 8.0.3, to release 8.0.4 and have both Oracle7 and Oracle8 clients connecting to the release 8.0.4 Oracle8 database. You can upgrade databases either in the same Oracle home or across different Oracle homes. See "Upgrading an Oracle8 Database" for instructions. The figure below illustrates this network configuration:

Migrate Oracle7 Clients to Oracle8

Migrate some or all of your Oracle7 clients to Oracle8 release 8.0.4 and migrate your Oracle7 database to an Oracle8 database or upgrade your Oracle8 database to the current Oracle8 release at a later date. See Net8 Getting Started for Windows NT and Windows 95 for instructions. The figure below illustrates this network configuration.

Installing Two or More Databases Into the Same Oracle Home

In the following example, an Oracle7 release 7.3.3 starter database named ORACLE with a SID of ORCL is already installed in C:\ORANT. Now, create an Oracle release 8.0.4 database named PROD with a SID of PROD in C:\ORANT.

To install an Oracle8 database and Oracle7 database into the same Oracle home:

  1. Ensure you have enough hard disk space and RAM for both databases. You need to add the system requirements for Oracle8 Enterprise Edition and Oracle7 Server to determine the total system requirements. See Oracle8 Enterprise Edition Installation for Windows NT for system requirements.

  1. Ensure all Oracle7 services are stopped. See "Managing Oracle Services" in Chapter 10, "Administering a Database" for information on how to stop services.

  2. Install Oracle8 Enterprise Edition for Windows NT from the CD-ROM. See Oracle8 Enterprise Edition Installation for Windows NT for complete installation instructions.

    The Oracle Installation Settings dialog box appears.

    1. Do not enter a value in the Name: field of the Oracle Installation Settings dialog box.

    2. Set the Oracle home directory location to the same directory where release 7.3.3 is already installed. In this example, enter C:\ORANT in the Location: field of the Oracle Installation Settings dialog box. Click OK.

    The Select Installation Settings dialog box appears.

  3. Select Oracle8 Enterprise Edition from the Select Installation Options dialog box, then click OK.

    The Select Cartridges and Options dialog box appears.

  4. Select the cartridges and options you are licensed to install, then click OK.

    The Previous Version of Oracle Database Detected dialog box appears indicating that Oracle Installer has detected an earlier version of the database. You are asked if you want to migrate your Oracle7 database to release 8.0.4 using Oracle Data Migration Assistant.

  5. Click No. If you click Yes, Oracle Data Migration Assistant is launched at the end of installation. Do not click Yes to run Oracle Data Migration Assistant while you are installing another database into the same Oracle home as an existing database.

    The Select a Starter Database Configuration dialog box appears.

  6. Select Custom Configuration (allows you to create a customized database).

  7. Complete Oracle8 Enterprise Edition Installation. At the end of installation the Oracle Database Assistant is launched.

    The following Oracle Database Assistant window appears:

  8. Respond to instructions in each Oracle Database Assistant window, and click Next when you are ready to continue to the next window.

  9. When the following Oracle Database Assistant window appears, you will notice that the Database Name and SID fields are automatically set to ORC1. Substitute PROD in both of these fields. Do not set the SID to ORCL as you will overwrite the Oracle7 release 7.3.3 starter database.

    When you get to the last window, click Finish to start the creation of the PROD database. More documentation on this assistant is included with the Help.

Installing Databases Into Multiple Oracle Homes

In the following example, an Oracle7 release 7.3.3 starter database called ORACLE with a SID of ORCL is already installed in C:\ORANT. Now, install the Oracle release 8.0.4 starter database ORCL in a different Oracle home directory called C:\ORANTv8 with an Oracle home name of TESTv8.

To install an Oracle8 database and Oracle7 database in multiple (different) Oracle homes:

  1. Ensure you have enough hard disk space and RAM for both databases. You need to add the system requirements for Oracle8 Enterprise Edition and Oracle7 Server to determine the total system requirements. See Oracle8 Enterprise Edition Installation for Windows NT for system requirements.

  1. Ensure all Oracle7 services are stopped. See "Managing Oracle Services" in Chapter 10, "Administering a Database" for information on how to stop services.

  2. Install Oracle8 Enterprise Edition for Windows NT from the CD-ROM. See Oracle8 Enterprise Edition Installation for Windows NT for complete installation instructions.

    The Oracle Installation Settings dialog box appears.

    1. Enter the name of the new Oracle home in the Name: field of the Oracle Installation Settings dialog box.In this example, enter TESTv8.

    2. Enter the location of the Oracle home directory where you want to install release 8.0.4. In this example, enter C:\ORANTv8 in the Location: field of the Oracle Installation Settings dialog box. Click OK.

    The Select Installation Settings dialog box appears.

  3. Select Oracle8 Enterprise Edition from the Select Installation Options dialog box, then click OK.

    The Select Cartridges and Options dialog box appears.

  4. Select the cartridges and options you are licensed to install, then click OK.

    The Select a Starter Database Configuration dialog box appears.

  5. Select Typical Configuration (allows you to create a preconfigured starter database).

  6. Complete Oracle8 Enterprise Edition installation.

    During installation of the release 8.0.4 database, Oracle Installer detected the listener of the previously installed release 7.3.3 database. To avoid conflicts of listening addresses (for example, the Port number for TCP/IP), the new release 8.0.4 listener is not started and is set to Manual Startup mode. After installation is complete, modify the release 8.0.4 LISTENER.ORA file to resolve possible conflicts in listening addresses, and then start the listener. This is required to enable the release 8.0.4 database to accept connections from clients. See Net8 Getting Started for Windows NT and Windows 95 for information on how to modify the LISTENER.ORA file.

Migrating an Oracle7 Database

This section describes how to migrate an Oracle7 database to the current Oracle8 database release. You can choose either of the following database tools to perform a migration:

Oracle Corporation recommends that new users use Oracle Data Migration Assistant to migrate databases because it is the easiest method to perform a migration. If you want to perform a migration manually using command line tools, use the Migration Utility (MIG80).

Migration Networking Issues

If you perform a migration, the following networking issues may need to be resolved:

Migrating Oracle7 Clients

Although Oracle7 clients using SQL*Net Client version 2.x can connect to Oracle8 databases, they should be migrated to Oracle8 clients configured with Net8 when their applications are upgraded to version 8. Note that SQL*Net version 2.x can coexist with Net8 in the same Oracle home directory.

Using the Net8 Listener

To use the Net8 listener, you may need to change your network configuration on either the SQL*Net version 2.x or Net8 configurations to prevent a conflict. For example, you may need to change:

You may also need to start the Net8 listener and change the status of the service to Automatic Startup, depending upon your network needs. If you make changes to the listener, you must make changes to client configuration files to reflect those listener changes.

SQL*Net version 2.x uses configuration files from ORACLE_HOME\NETWORK\ADMIN, while Net8 uses files from ORACLE_HOME\NET80\ADMIN by default. If you want SQL*Net version 2.x and Net8 to use configuration files from the same directory, you can set the registry variable TNS_ADMIN.

Installing Appropriate Versions of SQL*Net

When migrating from Oracle7 Server release 7.3.x to Oracle8 release 8.0.4, install the appropriate version of SQL*Net for the server before using Oracle Data Migration Assistant or the Migration Utility (MIG80). Migration will be unsuccessful if you do not install the appropriate versions of SQL*Net.

Migrating from...   Install...  

Oracle7 release 7.3.2.x to Oracle8  

SQL*Net version 2.3.2.1.4

SQL*Net version 2.3.2.1.12

Note: If you do not have SQL*Net version 2.3.2.1.4 on your system, you must install it before installing SQL*Net version 2.3.2.1.12. SQL*Net version 2.3.2.1.4 is not available on the CD-ROM. To obtain it, you must contact Oracle Worldwide Customer Support.  

Oracle7 release 7.3.3.x to Oracle8  

SQL*Net version 2.3.3.0.3  

 

To install SQL*Net version 2.3.2.1.12 or 2.3.3.0.3

  1. Start Oracle Installer from the CD-ROM. See Oracle8 Enterprise Edition Installation for Windows NT for complete installation instructions.

  2. Answer questions about language and Oracle home directory location.

  3. Select Custom Installation. The Software Asset Manager window appears.

  4. Click From...

  5. Navigate to \PATCHES\SQLNET\232112 on the CD-ROM if you want to install SQL*Net version 2.3.2.1.12. Navigate to \PATCHES\SQLNET\23303 if you want to install SQL*Net version 2.3.3.0.3.

  6. Select SQL*Net Server 2.3.2.1.12 and SQL*Net Client 2.3.2.1.12 if you want to install SQL*Net version 2.3.2.1.12. Select SQL*Net Server 2.3.3.0.3 and SQL*Net Client 2.3.3.0.3 if you want to install SQL*Net version 2.3.3.0.3.

  7. Click Install.

A window appears showing the progress of the installation. After installation is complete, a message appears confirming the installation.
  1. Click Exit to exit Oracle Installer.

 

Editing the LISTENER.ORA File for Multiple Oracle Homes

Using Migration Utility (MIG80)

When you migrate from an Oracle7 database in one Oracle home to a release 8.0.4 Oracle8 database in a different Oracle home, the SID needs to be removed from the Oracle7 Oracle home's LISTENER.ORA file and added to the release 8.0.4 Oracle home's LISTENER.ORA file.

Using Oracle Data Migration Assistant

When you migrate from an Oracle7 database in one Oracle home to a release 8.0.4 Oracle8 database in a different Oracle home, Oracle Data Migration Assistant adds the appropriate SID value to the release 8.0.4 Oracle home's LISTENER.ORA file. However, the assistant does not remove the SID from the Oracle7 Oracle home's LISTENER.ORA file. To prevent a conflict when you start the Oracle7 listener, remove the SID entry from the Oracle7 Oracle home's LISTENER.ORA file.

Migrating Using Oracle Data Migration Assistant

Oracle Data Migration Assistant helps you migrate data from an Oracle7 database to an Oracle8 database. During installation of Oracle8 Enterprise Edition, you are prompted to migrate a database with this assistant if Oracle Installer detects that an earlier database release exists on your system. If you do not want to migrate a database during the installation process, you can choose install this assistant and use it later.

Before you use this assistant, ensure the Oracle7 database to be migrated meets these requirements:

To migrate a database using Oracle Data Migration Assistant:

  1. Choose Start > Programs > Oracle for Windows NT - [HOME_NAME] > Oracle Data Migration Assistant.

    The Oracle Data Migration Assistant welcome window appears:

  1. Respond to instructions in each Oracle Data Migration Assistant window, and click Next when you are ready to continue to the next window. When you get to the last window, click Finish to start the migration of the database. More documentation on this product is included with the Help.

Migrating Using Migration Utility (MIG80)

This section describes how to use the Migration Utility (MIG80) to migrate your Oracle7 database to an Oracle8 database.

Before Using the Migration Utility (MIG80)

Complete the following steps before you use the Migration Utility (MIG80):

To migrate an Oracle7 database using MIG80:

Step 1: Shut Down the Oracle7 Database

Step 2: Back Up the Oracle7 Database

Step 3: Prepare the Oracle7 Database for Migration

Step 4: Install Oracle8 Enterprise Edition

Step 5: Run the Migration Utility (MIG80)

Step 6: Create Oracle8 Services and Database Files

Step 7: Remove Oracle7 Software (Optional)

Step 1: Shut Down the Oracle7 Database

  1. Start SQL*DBA or Server Manager:

    Using...   Enter at the MS-DOS Command Prompt...  

    Oracle7 release 7.1.x  

    C:\> SQLDBA71 MODE=LINE  

    Oracle7 release 7.2.x  

    C:\> SQLDBA72 MODE=LINE  

    Oracle7 release 7.3.x  

    C:\> SVRMGR23  

  1. Connect to the Oracle7 database as INTERNAL, where PASSWORD is the password of the database you want to migrate. Note that ORACLE is the default password for INTERNAL.

    Using...   Enter at the SQLDBA or SVRMGR Command Prompt...  

    Oracle7 release 7.1.x1  

    		 
    SQLDBA> CONNECT INTERNAL/PASSWORD
SQLDBA> ALTER USER SYS DEFAULT TABLESPACE SYSTEM 
TEMPORARY TABLESPACE SYSTEM;
SQLDBA> ALTER TABLESPACE SYSTEM ADD DATAFILE 
`ORACLE_HOME\RDBMS71\SYS2SID.ORA' SIZE 50 M;
     

    Oracle7 release 7.2.x  

    		 
    SQLDBA> CONNECT INTERNAL/PASSWORD
     

    Oracle7 release 7.3.x  

    		 
    SVRMGR> CONNECT INTERNAL/PASSWORD
     
    1 For Oracle7 release 7.1 only, edit the INITSID.ORA file and set the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE or SHARED.

    The message Connected. appears if you successfully connected to the database.

  2. Shut down the database. Do not use SHUTDOWN IMMEDIATE or SHUTDOWN ABORT. If the database is not shut down before you start the migration, MIG80 stops and issues an error message. Also, if the database was not cleanly shutdown, any backup you make may be useless as it was taken while data was being written to the data files.

    Using...   Enter at the SQLDBA or SVRMGR Command Prompt...  

    Oracle7 release 7.1.x  

    SQLDBA> SHUTDOWN  

    Oracle7 release 7.2.x  

    SQLDBA> SHUTDOWN  

    Oracle7 release 7.3.x  

    SVRMGR> SHUTDOWN  

Step 2: Back Up the Oracle7 Database

  1. Back up the entire Oracle home directory and all its subdirectories.

    WARNING:

    If anything goes wrong with the Oracle7 database during migration, you will need to restore the database from the backup. Back up your database now as a precaution!

     

    Ensure the database was cleanly shutdown before you back up. Ensure you back up the database files in the following list (and any other database files you may have created). Also, back up any scripts you may have created.

    • Data files
     

    SYS1SID.ORA, USR1SID.ORA, RBS1SID.ORA, TMP1SID.ORA  
    • Initialization parameter file
     

    INITSID.ORA  
    • Redo log files
     

    LOG1SID.ORA, LOG2SID.ORA, LOG3SID.ORA, LOG4SID.ORA

    (the last two redo log files are only available for Oracle release 7.3.4)  
    • Control files
     

    CTL1SID.ORA and CTL2SID.ORA  

    To obtain the list of database files you must back up:

    1. Create a spool file called V7DBFILES.LOG:

      Using...   Enter at the SQLDBA or SVRMGR Command Prompt...  

      Oracle7 release 7.1.x  

      SQLDBA> SPOOL V7DBFILES.LOG  

      Oracle7 release 7.2.x  

      SQLDBA> SPOOL V7DBFILES.LOG  

      Oracle7 release 7.3.x  

      SVRMGR> SPOOL V7DBFILES.LOG  

    2. Enter the following commands at the SQL*DBA or Server Manager prompt where the WHERE clause equals control_files, DB_FILES, or LOG_FILES. Note that control_files must be lowercase. The list of database files is output to V7DBFILES.LOG.

      Using...   Enter at the SQLDBA or SVRMGR Command Prompt...  

      Oracle7 release 7.1.x  

      		 
      SQLDBA> SELECT MEMBER FROM V$LOGFILE;
SQLDBA> SELECT NAME FROM V$DATAFILE;
SQLDBA> SELECT VALUE FROM V$PARAMETER WHERE NAME = 
'control_files';
       

      Oracle7 release 7.2.x  

      		 
      SQLDBA> SELECT MEMBER FROM V$LOGFILE;
SQLDBA> SELECT NAME FROM V$DATAFILE;
SQLDBA> SELECT VALUE FROM V$PARAMETER WHERE NAME = 
'control_files';
       

      Oracle7 release 7.3.x  

      		 
      SVRMGR> SELECT MEMBER FROM V$LOGFILE;
SVRMGR> SELECT NAME FROM V$DATAFILE;
SVRMGR> SELECT VALUE FROM V$PARAMETER WHERE NAME = 
'control_files';
       

    3. Turn off the SPOOL command:

      Using...   Enter at the SQLDBA or SVRMGR Command Prompt...  

      Oracle7 release 7.1.x  

      		 
      SQLDBA> SPOOL OFF
       

      Oracle7 release 7.2.x  

      		 
      SQLDBA> SPOOL OFF
       

      Oracle7 release 7.3.x  

      		 
      SVRMGR> SPOOL OFF
       

    See Chapter 13, "Backing Up and Recovering Database Files", Oracle8 Concepts, Oracle8 Backup and Recovery, and Oracle8 Administrator's Guide for information on how to back up a database.

Step 3: Prepare the Oracle7 Database for Migration

You must perform the following tasks to prepare the Oracle7 database for migration.

  1. Remove all obsolete parameters from the Oracle7 INITSID.ORA file. Obsolete parameters can cause errors if used with an Oracle8 database.

    Release 7.x Parameters Obsolete in Release 8.0.4  

    CCF_IO_SIZE  

    CHECKPOINT_PROCESS  

    GC_DB_LOCKS  

    GC_FREELIST_GROUPS  

    GC_ROLLBACK_SEGMENTS  

    GC_SAVE_ROLLBACK_LOCKS  

    GC_SEGMENTS  

    GC_TABLESPACES  

    IO_TIMEOUT  

    INIT_SQL_FILES  

    IPQ_ADDRESS  

    IPQ_NET  

    LM_DOMAINS  

    LM_NON_FAULT_TOLERANT  

    OPTIMIZER_PARALLEL_PASS  

    PARALLEL_DEFAUILT_MAX_SCANS  

    PARALLEL_DEFAULT_SCAN_SIZE  

    SEQUENCE_CACHE_HASH_BUCKETS  

    SERIALIZABLE  

    SESSION_CACHED_CURSORS  

    UNLIMITED_ROLLBACK_SEGMENTS  

    USE_IPQ  

    USE_READV  

    USE_SIGIO  

    V733PLANS_ENABLED  

  1. Change any Oracle7 parameter names that have been renamed in Oracle8 Enterprise Edition:

    Change Oracle7 Parameter Name...   To Release 8.0.4 Parameter Name...  

    ASYNC_READ  

    ASYNC_READ  

    ASYNC_WRITE  

    DISK_ASYNCH_IO  

    DB_FILE_STANDBY_NAME_CONVERT  

    DB_FILE_NAME_CONVERT  

    DB_WRITERS  

    DBWR_IO_SLAVES  

    LOG_FILE_STANDBY_NAME_CONVERT  

    LOG_FILE_NAME_CONVERT  

    SNAPSHOT_REFRESH_INTERVAL  

    JOB_QUEUE_INTERVAL  

    SNAPSHOT_REFRESH_PROCESSES  

    JOB_QUEUE_PROCESSES  

    USE_ASYNC_IO  

    DISK_ASYNCH_IO  

    See Appendix A "Version 8 INIT.ORA Changes" in Oracle8 Migration for other changes you may need to make to the initialization parameter file.

  2. Change the names of any Oracle7 database objects (for example, tables and columns) that use names that are key words or reserved words for Oracle8 Enterprise Edition. The key words and reserved words new to Oracle8 Enterprise Edition are listed in the following table:

    ACCOUNT  

    ARRAY  

    BFILE  

    BLOB  

    CAST  

    CFILE  

    CHAR_CS  

    CHUNK  

    CLOB  

    CLONE  

    DANGLING  

    DATAOBJNO  

    DEFERRABLE  

    DEFERRED  

    DEREF  

    DIRECTORY  

    ENFORCE  

    EXCHANGE  

    EXPIRE  

    EXTENT  

    FLOB  

    GLOBALLY  

    HASH  

    HASHKEYS  

    HEAP  

    IDGENERATORS  

    INITIALLY  

    LIBRARY  

    LOCKED  

    LOGGING  

    LOGICAL_READS_PER_CALL  

    LOGICAL_READS_PER_SESSION  

    MASTER  

    NATIONAL  

    NCHAR  

    NCHAR_CS  

    NCLOB  

    NESTED  

    NOLOGGING  

    NOPARALLEL  

    NOREVERSE  

    NORMAL  

    NVARCHAR2  

    OBJECT  

    OBJNO_REUSE  

    OID  

    OIDINDEX  

    ORGANIZATION  

    OVERFLOW  

    PASSWORD  

    PCTTHRESHOLD  

    PCTVERSION  

    PRESERVE  

    PURGE  

    QUEUE  

    REF  

    REPLACE  

    RETURN  

    RRETURNING  

    REVERSE  

    SCOPE  

    SEG_BLOCK  

    SEG_FILE  

    SKIP  

    SYS_OP_NTCIMG  

    THAN  

    THE  

    TOPLEVEL  

    UNLOCK  

    USAGE  

    VALUE  

    VARYING  

     

     

     

Step 4: Install Oracle8 Enterprise Edition

  1. Ensure all Oracle7 services are stopped. See "Managing Oracle Services" in Chapter 10, "Administering a Database" for information on how to stop services.

  1. Insert the Oracle8 Enterprise Edition CD-ROM into the mapped CD-ROM drive and install Oracle8 Enterprise Edition. See Oracle8 Enterprise Edition Installation for Windows NT for complete installation instructions.

    When the Oracle Installation Settings dialog box appears:

    Using...   Do the Following...  

    One Oracle home directory  

    Accept the default Oracle Home Name, DEFAULT_HOME in the Name: field.

    Ensure the same directory where the Oracle7 database to be migrated is already installed is entered in the Location: field.  

    Two or more Oracle home directories  

    Enter the name you want to use for the additional Oracle home directory in the Name: field.

    Enter another directory location where you want to put Oracle8 Enterprise Edition release 8.0.4 in the Location: field.  

    The Select Installation Options dialog box appears.

  2. Select Oracle8 Enterprise Edition, then click OK.

    The Select Cartridges and Options dialog box appears.

  3. Select the cartridges and options you are licensed to install, then click OK.

    The Previous Version of Oracle Database dialog box appears indicating that Oracle Installer has detected an earlier version of the database. You are asked if you want to migrate your Oracle7 database to release 8.0.4 using Oracle Data Migration Assistant.

  4. Click No. If you click Yes, Oracle Data Migration Assistant is launched at the end of installation. Do not click Yes to run Oracle Data Migration Assistant while you are performing a manual migration using MIG80.

    The Select a Starter Database Configuration dialog box appears.

  5. Choose None when prompted to install a database in the Starter Database Installation Options dialog box.

  6. After installation is complete, copy the release 7.x INITSID.ORA file to the correct location:

    • If you installed Oracle8 Enterprise Edition into the default Oracle home where Oracle7 release 7.x is already located:

      Using...   Copy...  

      Oracle7 release 7.1.x  

      INITSID.ORA file from ORACLE_HOME\RDBMS71 to ORACLE_HOME\DATABASE  

      Oracle7 release 7.2.x  

      Not required because the release 7.2.x initialization parameter file is already located in ORACLE_HOME\DATABASE  

      Oracle7 release 7.3.x  

      Not required because the release 7.3.x initialization parameter file is already located in ORACLE_HOME\DATABASE  

    • If you installed Oracle8 Enterprise Edition into another Oracle home:

      Using...   Copy...  

      Oracle7 release 7.1.x  

      INITSID.ORA file from the release 7.1.x ORACLE_HOME\RDBMS71 directory to the release 8.0.4 ORACLE_HOME\DATABASE directory  

      Oracle7 release 7.2.x  

      INITSID.ORA file from the release 7.2.x ORACLE_HOME\DATABASE directory to the release 8.0.4 ORACLE_HOME\DATABASE directory  

      Oracle7 release 7.3.x  

      INITSID.ORA file from the release 7.3.x ORACLE_HOME\DATABASE directory to the release 8.0.4 ORACLE_HOME\DATABASE directory  

      Note:

      MIG80 will not be able to connect to the Oracle7 database if SQL*Net version 2.x is not installed in the Oracle home directory. You will receive the error ORA-12203: TNS: Unable to connect to destination, if this is the case. If this product is not installed, install it from the Oracle8 Enterprise Edition CD-ROM. See "Installing Appropriate Versions of SQL*Net" in this chapter for more information.

       

  7. Shut down and restart the computer if you have installed Oracle8 Enterprise Edition into another Oracle home. If you have installed Oracle8 Enterprise Edition into the same Oracle home as Oracle7 release 7.x, there is no need to do this.

Step 5: Run the Migration Utility (MIG80)

The Migration Utility (MIG80) was installed as part of Oracle8 Utilities when you installed Oracle8 Enterprise Edition in "Step 4: Install Oracle8 Enterprise Edition".

  1. Ensure that you have DBA privileges, which are necessary to run MIG80.

  1. Ensure that no other DBA (connected as INTERNAL or SYS) with RESTRICTED SESSION privilege connects to the database while MIG80 is running. Normal users cannot connect to the database during this phase.

  2. Do not start the Oracle7 database. MIG80 starts the Oracle7 database as part of its processing.

  3. Start the Oracle7 service OracleServiceSID at the MS-DOS command prompt: 

    C:\> NET START OracleServiceSID

  4. Set ORACLE_SID to the SID of the database you want to migrate. For example, if the database you want to migrate is the starter database SID ORCL, enter the following at the MS-DOS command prompt. Note there are no spaces around the equal sign (=) character. 

    C:\> SET ORACLE_SID=ORCL

  5. Run MIG80:

    • If you installed Oracle8 Enterprise Edition into the default Oracle home where Oracle7 release 7.x is already installed:

      Using...   Enter at the MS-DOS Command Prompt...  

      Oracle7 release 7.1.x  

      		 
      C:\> MIG80 PFILE=ORACLE_HOME\RDBMS71\INITSID.ORA

      where ORACLE_HOME is the Oracle7 release 7.1.x Oracle home directory.  

      Oracle7 release 7.2.x  

      C:\> MIG80  

      Oracle7 release 7.3.x  

      C:\> MIG80  

    • If you installed Oracle8 Enterprise Edition into another Oracle home:

      Using...   Enter at the MS-DOS Command Prompt...  

      Oracle7 release 7.1.x  

      		 
      C:\> MIG80 PFILE=ORACLE_HOME\RDBMS71\INITSID.ORA

      where ORACLE_HOME is the Oracle7 release 7.1.x Oracle home directory.  

      Oracle7 release 7.2.x  

      		 
      C:\> MIG80 PFILE=ORACLE_HOME\DATABASE\INITSID.ORA

      where ORACLE_HOME is the Oracle7 release 7.2.x Oracle home directory.  

      Oracle7 release 7.3.x  

      		 
      C:\> MIG80 PFILE=ORACLE_HOME\DATABASE\INITSID.ORA

      where ORACLE_HOME is the Oracle7 release 7.3.x Oracle home directory.  

    This command creates the MIGSID.ORA file which is required in a later step to create Oracle8 Enterprise Edition control files.

    You can specify MIG80 HELP=YES at the MS-DOS command prompt for a complete list of parameters that can be included with the MIG80 command.

    The prompt Oracle7 Password: appears.

  6. Enter the password for Oracle7 Password. This is the same password as the INTERNAL password for the Oracle7 database.

    MIG80 runs and displays the operations being performed. MIG80 can take considerable time to run. Please wait until it has finished running.

  7. Stop the Oracle7 service at the MS-DOS command prompt when MIG80 has completed successfully: 

    C:\> NET STOP OracleServiceSID

  8. Delete the Oracle7 services at the MS-DOS command prompt:

    Using...   Enter at the MS-DOS Command Prompt...  

    Oracle7 release 7.1.x  

    		 
    C:\> ORADIM71 -DELETE -SID SID
     

    Oracle7 release 7.2.x  

    		 
    C:\> ORADIM72 -DELETE -SID SID
     

    Oracle7 release 7.3.x  

    		 
    C:\> ORADIM73 -DELETE -SID SID
     

    Note:

    If you need to return to the Oracle7 database after MIG80 has run please restore the Oracle7 database from the backup you made in "Step 2: Back Up the Oracle7 Database".

     

Step 6: Create Oracle8 Services and Database Files

  1. Create the Oracle8 database service at the MS-DOS command prompt: 

    C:\> ORADIM80 -NEW -STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA  
-SID SID -INTPWD PASSWORD -MAXUSERS USERS -STARTTYPE SRVC

    where:

    • ORACLE_HOME
     

    is the release 8.0.4 Oracle home directory. Ensure you specify the full pathname with the -PFILE option, including drive letter of the Oracle home directory.  
    • SID
     

    is the release 8.0.4 SID.  
    • PASSWORD
     

    is the password for the new release 8.0.4 database instance.  
    • USERS
     

    is the maximum number of users who can be granted SYSDBA and SYSOPER privileges.  

  1. Delete the control files from the release 7.x ORACLE_HOME\DATABASE directory. Check the file V7DBFILES.LOG that you created in "Step 2: Back Up the Oracle7 Database" for the complete list and location of control files you must delete. You will recreate them later using the ALTER DATABASE CONVERT statement in Step 7.

    To delete the control files: 

    C:\ORACLE_HOME\DATABASE> DEL CTL1SID.ORA
C:\ORACLE_HOME\DATABASE> DEL CTL2SID.ORA

  2. Before starting Server Manager:

    1. Ensure all release 7.x data files and log files are accessible and in the correct directories.

    2. Ensure all release 7.x control files are deleted.

    3. Change any parameters that point to RDBMS71, RDBMS72, or RDBMS73 to point to RDBMS80 in the release 7.x INITSID.ORA file.

    4. Ensure the COMPATIBLE parameter is set to 8.0.0.0.0 in the release 7.x INITSID.ORA file.

      If you use the default setting (8.0.0.0.0), you will not be able to use new features of release 8.0.4 such as Propagation in Advanced Queuing (AQ) and Improved SCN Generation. To use these new release 8.0.4 features, set the COMPATIBLE parameter to the following: 

      COMPATIBLE=8.0.4.0.0

      See Appendix C "Version 8 INIT.ORA Changes" of Oracle8 Migration for more information on COMPATIBLE parameter values.

  3. Start the Oracle8 Enterprise Edition version of Server Manager at the MS-DOS command prompt: 

    C:\> SVRMGR30

  4. Connect to the Oracle8 instance as INTERNAL: 

    SVRMGR> CONNECT INTERNAL/PASSWORD

  5. Start an Oracle8 instance without mounting the new Oracle8 database: 

    SVRMGR> STARTUP NOMOUNT

    WARNING:

    Starting in any other mode will corrupt the database!

     

  6. Create new Oracle8 Enterprise Edition control files: 

    SVRMGR> ALTER DATABASE CONVERT;

    All data files that are online are converted to Oracle8 Enterprise Edition format, and new control files are built. This command uses the MIGSID.ORA file which was created earlier when you ran the Migration Utility (MIG80).

    Note:

    Successful execution of this command is the point of no return to Oracle7. If you need to return to the Oracle7 database, please restore it from the backup you made in "Step 2: Back Up the Oracle7 Database". If an error occurs during this step, you must correct the condition(s) that caused the error(s). See Oracle8 Migration and run the migration again by restarting at Step 1. of "Step 5: Run the Migration Utility (MIG80)".

     

  7. Open the Oracle8 database: 

    SVRMGR> ALTER DATABASE OPEN RESETLOGS;

    All rollback segments that are online when the Oracle8 database is opened are also opened and converted to the Oracle8 database format.

  8. Create a spool file called CATOUT.LOG by entering the following at the Server manager prompt: 

    SVRMGR> SPOOL CATOUT.LOG

  9. Run the following scripts:

    Script   Required by...   Enter at the Server Manager Prompt...  

    CAT8000.SQL  

    All databases  

    SVRMGR> @%ORACLE_HOME%\RDBMS80\ADMIN\CAT8000.SQL

    where %ORACLE_HOME% represents your drive letter and release 8.0.4 Oracle home directory. This script can take over thirty minutes to run depending on the size of your database. Check CATOUT.LOG to verify that the operation was successful.

    CAT8000.SQL creates and alters certain system tables and drops the MIGRATE user. Objects in the MIGRATE user's schema are not needed after the conversion is complete. You can also delete the binary file (%ORACLE_HOME%\RDBMS80\CONVERT.ORA) that is used as part of the conversion process.

    CAT8000.SQL also runs the CATALOG.SQL and CATPROC.SQL scripts, which create the system catalog views and all the necessary packages for using PL/SQL.  

    PUPBLD.SQL  

    All databases  

    SVRMGR> @%ORACLE_HOME%\DBS\PUPBLD.SQL

    where %ORACLE_HOME% represents your drive letter and release 8.0.4 Oracle home directory. This script creates the USER PROFILE table.  

    CATREP8M.SQL  

    Advanced Replication. Run this script only if you have Advanced Replication and want to use it.  

    SVRMGR> @%ORACLE_HOME%\RDBMS80\ADMIN\CATREP8M.SQL

    where %ORACLE_HOME% represents your drive letter and release 8.0.4 Oracle home directory. The CATREP8M.SQL script automatically runs the CATREP.SQL script. CATREP8M.SQL takes over an hour to run.  

    CATPARR.SQL  

    Oracle Parallel Server. Run this script only if you have Oracle Parallel Server and want to use it.  

    SVRMGR> @%ORACLE_HOME%\RDBMS80\ADMIN\CATPARR.SQL

    where %ORACLE_HOME% represents your drive letter and release 8.0.4 Oracle home directory.  

    Oracle Corporation supplies other scripts with Oracle8 Enterprise Edition that create additional structures you can use in managing your database and creating database applications. See Oracle8 Reference for a complete list and descriptions of available scripts.

  10. Turn off the SPOOL command: 

    SVRMGR> SPOOL OFF

  11. Check the spool file CATOUT.LOG and verify that the scripts you ran compiled every package and procedure successfully. Correct any problems you find in this file.

  12. Shut down the Oracle8 database in NORMAL mode. Do not use SHUTDOWN IMMEDIATE or SHUTDOWN ABORT. Note that NORMAL is the default parameter. 

    SVRMGR> SHUTDOWN NORMAL

    Performing a clean database shutdown flushes all caches, clears buffers, and performs other Object Relational Database Management System (ORDBMS) housekeeping activities. These measures are an important final step to ensure the integrity and consistency of the newly migrated release 8.0.4 database.

  13. Back up the Oracle8 database. See Chapter 13, "Backing Up and Recovering Database Files" for a list of tools to back up the database.

    The Oracle7 database has now been migrated to the Oracle8 database and is ready for use.

    Note:

    After a migration, all objects have the status INVALID, which is the correct status at this time. To check the status of objects, enter the following at the Server Manager prompt.

    SVRMGR> SELECT * FROM ALL_OBJECTS WHERE STATUS = `INVALID';

     

Step 7: Remove Oracle7 Software (Optional)

You can remove Oracle7 software if you have successfully migrated to Oracle8 Enterprise Edition and have a backup of the Oracle7 software. Oracle Installer warns you of any product dependencies that might cause problems if particular products are removed, and prompts you to confirm the de-installation.

To remove Oracle7 software:

  1. Stop all Oracle services. For information on how to stop Oracle services, see "Managing Oracle Services" in Chapter 10, "Administering a Database".

  1. Choose Start > Programs > Oracle for Window NT - [HOME_NAME] > Oracle Installer to start Oracle Installer.

    The Software Asset Manager window appears.

  2. Select the Oracle7 product(s) you want to remove from the Installed Products window of the Software Asset Manager window.

  3. Click Remove.

Upgrading an Oracle8 Database

This section describes how to upgrade an Oracle8 database release 8.0.3 to release 8.0.4. You can choose either of the following database tools to upgrade:

Oracle Corporation recommends that new users use Oracle Data Migration Assistant to upgrade databases because it is the easiest and quickest method to perform an upgrade. If you already have upgrade scripts from a previous Oracle database release, you may want to edit them to include the CAT8004.SQL script.

Upgrading Using Oracle Data Migration Assistant

Oracle Data Migration Assistant helps you upgrade data from an Oracle8 database release 8.0.3 to release 8.0.4. During installation of Oracle8 Enterprise Edition, you are prompted to upgrade a database with this assistant if Oracle Installer detects that a release 8.0.3.0.0 database exists on your system. If you do not want to upgrade during the installation process, you can choose to install this assistant and use it later. Although you are upgrading, the assistant text refers to this process as migrating.

Note:

Oracle Data Migration Assistant does not upgrade Oracle8 release 8.0.1 and 8.0.2 Beta releases to release 8.0.4. If you need to upgrade these Beta releases, see the README.DOC file in the ORACLE_HOME\RDBMS80 directory.

 

Before you use this assistant, ensure the Oracle8 database to be migrated meets these requirements:

To upgrade a database using Oracle Data Migration Assistant:

  1. Choose Start > Programs > Oracle for Windows NT - [HOME_NAME] > Oracle Data Migration Assistant.

    The Oracle Data Migration Assistant welcome window appears:

  1. Respond to instructions in each Oracle Data Migration Assistant window, then click Next when you are ready to continue to the next window. When you get to the last window, click Finish to start the upgrade of the database. More documentation on this product is included with the Help.

Upgrading Using CAT8004.SQL Script

You can run SQL scripts in Server Manager to upgrade an Oracle8 database release 8.0.3 to release 8.0.4.

Before Using CAT8004.SQL to Upgrade

Read Chapter 8, "Upgrading and Downgrading" in Oracle8 Migration for background information.

Upgrading consists of the following tasks:

Step 1: Shut Down the Release 8.0.3 Database

Step 2: Back Up the Release 8.0.3 Database

Step 3: Edit the COMPATIBLE Parameter in the Release 8.0.3 INITSID.ORA File

Step 4: Install Oracle8 Enterprise Edition Release 8.0.4

Step 5: Run the CAT8004.SQL Script

Step 1: Shut Down the Release 8.0.3 Database

  1. Start Server Manager at the MS-DOS command prompt: 

    C:\> SVRMGR30

  1. Connect to the release 8.0.3 database as INTERNAL, where PASSWORD is the password of the database you want to migrate. Note that ORACLE is the default password for INTERNAL.

    The message Connected. appears if you successfully connected to the database.

  2. Shut down the database. Do not use SHUTDOWN IMMEDIATE or SHUTDOWN ABORT. If the database was not cleanly shutdown, any backup you make may be useless as it was taken while data was being written to the data files. Enter the following at the Server Manager prompt: 

    SVRMGR> SHUTDOWN

Step 2: Back Up the Release 8.0.3 Database

  1. Back up the entire Oracle home directory and all of its subdirectories.

    WARNING:

    If anything goes wrong with the release 8.0.3 database during upgrade, you will need to restore the database from the backup. Back up your database now as a precaution.

     

    Ensure the database is cleanly shutdown before you back up. Ensure you back up the database files in the following list (and any other database files you may have created). Also, back up any scripts you may have created.

    • Data files
     

    SYS1SID.ORA, USR1SID.ORA, RBS1SID.ORA, TMP1SID.ORA  
    • Initialization parameter file
     

    INITSID.ORA  
    • Redo log files
     

    LOG1SID.ORA, LOG2SID.ORA  
    • Control files
     

    CTL1SID.ORA  

    To obtain the list of database files you must back up:

    1. Create a spool file called V8DBFILES.LOG. Enter the following at the Server Manager prompt: 

      SVRMGR> SPOOL V8DBFILES.LOG
    2. Enter the following commands at the Server Manager prompt, where the WHERE clause equals control_files, DB_FILES, or LOG_FILES. Note that control_files must be lowercase. The list of database files is output to V8DBFILES.LOG.

    3. Enter the following commands at the Server Manager prompt: 

      SVRMGR> SELECT MEMBER FROM V$LOGFILE;
SVRMGR> SELECT NAME FROM V$DATAFILE;
SVRMGR> SELECT VALUE FROM V$PARAMETER WHERE NAME = 'control_files';
    4. Turn off the SPOOL command: 

      SVRMGR> SPOOL OFF

    See Chapter 13, "Backing Up and Recovering Database Files", Oracle8 Concepts, Oracle8 Backup and Recovery, and Oracle8 Administrator's Guide for information on how to back up a database.

Step 3: Edit the COMPATIBLE Parameter in the Release 8.0.3 INITSID.ORA File

Change the value of the COMPATIBLE parameter in the INITSID.ORA file to the release of Oracle8 Enterprise Edition to which you are upgrading. The COMPATIBLE parameter is set to the following by default: 

COMPATIBLE=8.0.0.0.0

However, if you use the default setting (8.0.0.0.0), you will not be able to use the following new features of release 8.0.4:

To use these new release 8.0.4 features, set the COMPATIBLE parameter to the following: 

COMPATIBLE=8.0.4.0.0

See Appendix C "Version 8 INIT.ORA Changes" of Oracle8 Migration for more information on COMPATIBLE parameter values.

Step 4: Install Oracle8 Enterprise Edition Release 8.0.4

  1. Ensure all Oracle services are stopped. See "Managing Oracle Services" in Chapter 10, "Administering a Database" for information on how to stop services.

  1. Insert the Oracle8 Enterprise Edition CD-ROM into the mapped CD-ROM drive and install Oracle8 Enterprise Edition. See Oracle8 Enterprise Edition Installation for Windows NT for complete installation instructions.

    When the Oracle Installation Settings dialog box appears:

    Using...   Do the Following...  

    One Oracle home directory  

    Accept the default Oracle Home Name, DEFAULT_HOME in the Name: field.

    Ensure the same directory where the Oracle7 database to be upgraded is already installed is entered in the Location: field.  

    Two or more Oracle home directories  

    Enter the name you want to use for the additional Oracle home directory in the Name: field.

    Enter another directory location where you want to put Oracle8 Enterprise Edition release 8.0.4 in the Location: field.  

    The Select Installation Options dialog box appears.

  2. Select Oracle8 Enterprise Edition, then click OK.

    The Select Cartridges and Options dialog box appears.

  3. Select the cartridges and options you are licensed to install, then click OK.

    The Previous Version of Oracle Database dialog box appears indicating that Oracle Installer has detected an earlier version of the database. You are asked if you want to upgrade your Oracle8 database to release 8.0.4 using Oracle Data Migration Assistant.

  4. Click No. If you click Yes, Oracle Data Migration Assistant is launched at the end of installation. Do not click Yes to run Oracle Data Migration Assistant while you are performing a manual upgrade using CAT8004.SQL.

    The Select a Starter Database Configuration dialog box appears.

  5. Choose None when prompted to install a database in the Starter Database Installation Options dialog box.

  6. After installation is complete, if you installed release 8.0.4 into another Oracle home, you must copy the release 8.0.3 INITSID.ORA file from the release 8.0.3 ORACLE_HOME\DATABASE directory to the release 8.0.4 ORACLE_HOME\DATABASE directory. If you have installed Oracle8 Enterprise Edition into the same Oracle home as Oracle7 release 7.x, there is no need to do this.

  7. Shut down and restart the computer if you have installed Oracle8 Enterprise Edition release 8.0.4 into another Oracle home. If you have installed Oracle8 Enterprise Edition into the same Oracle home as Oracle7 release 7.x, there is no need to do this.

Step 5: Run the CAT8004.SQL Script

  1. Start the Oracle8 services of the release 8.0.3 database you want to upgrade. For example, enter the following at the MS-DOS command prompt to start the services of the starter database with a SID of ORCL: 

    C:\> NET START ORACLESERVICEORCL

  1. Set ORACLE_SID to the SID of the release 8.0.3 database you want to upgrade. For example, if the database you are upgrading is the starter database with a SID of ORCL, enter the following at the MS-DOS command prompt. Note there are no spaces around the equal sign (=) character. 

    C:\> SET ORACLE_SID=ORCL

  2. Start Server Manager at the MS-DOS command prompt: 

    C:\> SVRMGR30

  3. Connect to the release 8.0.3 Oracle8 instance as INTERNAL: 

    SVRMGR> CONNECT INTERNAL/PASSWORD

  4. Create a spool file called UPGRADE.LOG: 

    SVRMGR> SPOOL UPGRADE.LOG

  5. Run the following scripts:

    Script   Required by...   Enter at the Server Manager Prompt...  

    CAT8004.SQL  

    All databases  

    		 
    SVRMGR> @%ORACLE_HOME%\RDBMS80\ADMIN\CAT8004.SQL

    where %ORACLE_HOME% represents your drive letter and release 8.0.4 Oracle home directory. This script can take over thirty minutes to run depending on the size of your database. Check UPGRADE.LOG to verify that the operation was successful.

    CAT8004.SQL also runs the CATALOG.SQL and CATPROC.SQL scripts, which create the system catalog views and all the necessary packages for using PL/SQL.  

  6. Turn off the SPOOL command. 

    SVRMGR> SPOOL OFF

  7. Exit Server Manager: 

    SVRMGR> EXIT

    Oracle Corporation supplies other scripts with Oracle8 Enterprise Edition that create additional structures you can use in managing your database and creating database applications. See Oracle8 Reference for a complete list and descriptions of available scripts.

Migrating a Microsoft Access Database

Oracle Migration Assistant for Microsoft Access helps you migrate data from a Microsoft Access database to an Oracle8 database. Specifically, Oracle Migration Assistant for Microsoft Access:

Oracle Migration Assistant for Microsoft Access can migrate several types of Microsoft Access databases, including:

Oracle Migration Assistant for Microsoft Access can be used to migrate both 16-bit Access 2.0 databases and 32-bit Microsoft Access 7.0 databases.

To prepare a Microsoft Access database for migration:

  1. Compact and back up your Microsoft Access database files.

  1. Separate your Microsoft Access data tables and referential integrity into a different .MDB file from the application (forms, reports, macros, and modules) and create attachments. The .MDB file containing the data tables and referential integrity is the .MDB file to migrate to Oracle8 Enterprise Edition.

    Note:

    Microsoft Access tables with two or more MEMO or OLE datatype columns, which need to be mapped to a LONG or LONGRAW in Oracle8 Enterprise Edition, are not converted. The Oracle Migration Assistant for Microsoft Access tries to convert these datatypes to a VARCHAR2(2000) so the table can be converted. However, if the existing data does not permit this, the Microsoft Access table is not converted. Change the Microsoft Access structure to move the additional MEMO or OLE columns to a separate table. Oracle8 Enterprise Edition does not support two LONG columns in one table.

     

To migrate a database using Oracle Migration Assistant for Microsoft Access:

  1. Choose Start > Programs > Oracle for Windows NT - [HOME_NAME] > Oracle Migration Assistant for Microsoft Access.

    The Oracle Migration Assistant for Microsoft Access welcome window appears:

  1. Respond to instructions in each Oracle Migration Assistant for Microsoft Access window, then click Next when you are ready to continue to the next window. When you get to the last window, click Finish to complete the migration of the database. More documentation on this product is included with the Help.

Known Issues, Restrictions and Workarounds

This section lists known issues and restrictions with Oracle Migration Assistant for Microsoft Access.


Prev
Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library
Product
Contents
Index