Oracle7 Workgroup Server for Windows NT Installation Go to Product Documentation Library
Library		 Go to books for this product
Product

Release 7.3.3
March 1997
Part No. A51570-01


Contents

This document describes how to install or upgrade Oracle7 Workgroup Server for Windows NT. It includes the following topics:

Before You Install or Upgrade Oracle7 Workgroup Server
Fresh Installation of Oracle7 Workgroup Server
Upgrade from a Previous Release of Oracle7 Workgroup Server
Re-installing Oracle7 Workgroup Server
Co-existence of Different Versions of Oracle7 Workgroup Server
About the Oracle Installer
Oracle Home Directory
Multiple Oracle Homes Support for Windows 3.1
Check Hardware Requirements
Check Software Requirements
Check OCSM Installation Requirementss
Check Oracle Enterprise Manager Installation Requirements
Oracle7 Products
Installing Oracle7 Workgroup Server Software on Windows
Installing Oracle7 Client Software on Windows 95 and Windows 3.1
Installing OCSM on a File Server
Removing Oracle7 Products
Upgrading Tasks

Before You Install or Upgrade Oracle7 Workgroup Server

Before you install or upgrade Oracle7 Workgroup Server for Windows NT:

  1. Review the hard copy Release Notes. Note that hard copy Release Notes are only included if important installation information needs be included after the HTML Release Notes have been included on the CD-ROM disc.
  2. Review the Hypertext Markup Language (HTML) documentation. Note that all Oracle documentation is available in HTML, including this CD-ROM Insert. To access the HTML documentation, click on the WELCOME.HTM file at the root of the CD-ROM. Your Web browser is automatically started and a Welcome Screen displays instructions on using the Oracle Information Navigator.

    Additional Information
     See the chapter "Getting Started With Your Documentation" of Oracle7 Workgroup Server Getting Started for Windows NT for further information on the HTML documentation set, Oracle Information Navigator, and how to obtain a Java-enabled browser if you do not have one.

  3. Install and test your network hardware and software, if applicable.

  4. Decide if you need to perform a "Fresh Installation of Oracle7 Workgroup Server" or "Upgrade from a Previous Release of Oracle7 Workgroup Server".

Fresh Installation of Oracle7 Workgroup Server

 If you are installing Oracle7 Workgroup Server on a system containing no previous version of an Oracle7 Workgroup Server (also known as a fresh installation), first check the hardware and software requirements in this document.

If you want to install Oracle7 server software on a Windows NT server, see the section "Installing Oracle7 Workgroup Server Software on Windows NT". If you want to install Oracle7 client software on a Windows 95 or Windows 3.1 client, see the section "Installing Oracle7 Client Software on Windows 95 and Windows 3.1".

Upgrade from a Previous Release of Oracle7 Workgroup Server

If you are upgrading Oracle7 Workgroup Server from a previous release of Oracle7 Workgroup Server, for example, upgrading from release 7.3.2.2.0 to release 7.3.3.0.0, follow the instructions in the section "Upgrading Tasks".

Re-installing Oracle7 Workgroup Server

The Oracle Installer detects previous Oracle7 Workgroup Server installations. Oracle Installer attempts to use the same volumes, company name, and language when re-installing Oracle7 Workgroup Server for Windows NT. You can accept the default information provided by the Oracle Installer or provide new information.

You will receive an error message during installation if your system previously contained Oracle products and the volume containing those products no longer exists. To complete the installation, delete the ORACLE_HOME line from the Windows NT Registry and run the Oracle Installer again.

Co-existence of Different Versions of Oracle7 Workgroup Server

Two versions of Oracle7 Workgroup Server for Windows NT cannot co-exist if they are of the same major version. For example, Oracle7 Workgroup Server release 7.3.2.0.0 and Oracle7 Workgroup Server release 7.3.3.0.0 cannot co-exist. Like versions cannot co-exist because they depend on common files; one overwrites the other. If the servers are of different major versions (for example, one version 7.1 and another version 7.2), then they can co-exist.

About the Oracle Installer

The Oracle Installer for Windows NT is a Graphical User Interface (GUI) that lets you quickly install, update and remove Oracle7 products. Three versions of the Oracle Installer are available on the Oracle7 Workgroup Server for Windows NT CD-ROM disc.

Oracle Installer for... Installs Oracle7 Products for...
Windows NT client and server Windows NT
Windows 95 client Windows 95
Windows 3.1 client Windows 3.1

Oracle Home Directory

When you install the Oracle7 Workgroup Server for Windows NT, a top-level directory called Oracle Home is created on your hard disk. By default, the Oracle Home directory for:

Multiple Oracle Homes Support for Windows 3.1

 The Oracle Installer version included on your CD-ROM allows you to maintain more than one Oracle Home on a single computer and to switch between Oracle Homes.

Note:
This feature is currently supported on Windows 3.1 but not on Windows 95 and Windows NT.

Multiple Oracle Home support allows you to:

Additional Information
 See the chapter "Post-installation Tasks" of Oracle7 Workgroup Server Getting Started for Windows NT on how to implement multiple Oracle Homes.

Check Hardware Requirements

 Oracle7 Workgroup Server requires the hardware described in the following table:

Windows NT Server Windows NT, 95 and 3.1 Clients
Hewlett-Packard, Compaq, or 100%-compatible personal computer based on an Intel 80486 or Pentium processor. Multi-processor computers are also supported.

 Hewlett-Packard, Compaq, or 100%-compatible personal computer based on an Intel 80386 processor or higher.

32 MB RAM recommended

 8 MB RAM recommended

To find out how much disk space is required by a product, select the product in the Software Asset Manager and view the disk space requirements in the information field. 65 MB hard disk space is recommended

 To find out how much disk space is required by a product, select the product in the Software Asset Manager and view the disk space requirements in the information field. 25 MB RAM hard disk space is recommended.

Windows NT compatible Network Interface Card (NIC). The NIC must be supported by Microsoft.

 A Network Interface Card (NIC) and accompanying software. The NIC must be supported by Microsoft.

A connected CD-ROM drive, functioning as a logical drive

 A connected CD-ROM drive, functioning as a logical drive

Check Software Requirements

Oracle7 Workgroup Server requires the software in the following table.

Note:
The client version of SQL*Net must be the same as the server version of SQL*Net.

Windows NT Server Windows NT, 3.1 and 95 Clients
One of the following operating system releases:

 One of the following operating system releases:

A SQL*Net Server version 2.3 to accept client connections and to make server to server connections.

 A SQL*Net Client version 2.3 to connect to remote Oracle7 Workgroup Server databases.

One of the following Web browsers to view Oracle7 online documentation:

 One of the following Web browsers to view Oracle7 online documentation:

Check OCSM Installation Requirements

System Requirements

 You must have the required Oracle Client Software Manager (OCSM) hardware and software in addition to the hardware and software requirements of the products you intend to install.

Hardware Requirements

OCSM requires the hardware described in the following table:

Server Hardware Client Hardware
Server hardware that supports any operating system and networking software that provides complete file sharing services to OCSM supported client hardware and software.

 Hewlett-Packard, Compaq, or 100%-compatible personal computer based on an 80386 processor (or higher).

Compatible network interface card (NIC) for networked operations

 Minimum of 4 MB of RAM; 8 MB recommended

Sufficient hard disk space for products to be installed on the server

 Minimum of 4 MB of free hard disk space

 Compatible network interface card (NIC), for networked operation

 Connected CD-ROM drive, functioning as a logical drive (for the administrator)

Software Requirements

OCSM requires the software described in the following table:

Server Software Client Software
Any server operating system and networking software that provides complete file sharing services to OCSM supported client hardware and software

 Windows 3.1, Windows for Workgroups 3.11, Windows 95, or Windows NT Version 3.51 or 4.0 for Windows-based clients

 OS/2 2.1 or 2.11, OS/2 Warp, or Fullpack 3.0 for OS/2-based clients

 CD-ROM device driver (for the administrator)

 Installed and functioning network

Note:
The included versions of Oracle Objects for OLE and the Oracle ODBC Driver are not OCSM-compliant. If you want to take advantage of the shared-installation feature of Oracle Installer, do not attempt to share-install Oracle Objects for OLE or the Oracle ODBC Driver.

Note:
Oracle Objects for OLE and the Oracle ODBC Driver can be installed through the Custom Installation option.

Check Oracle Enterprise Manager Installation Requirements

Please refer to the chapter "Installing Oracle Enterprise Manager" of Oracle Enterprise Manager Installation Guide for details on hardware and software requirements for Oracle Enterprise Manager.

Note:
Before installing the new version, uninstall previous versions of Oracle Enterprise Manager to remove any unnecessary files.

Oracle7 Products

When you run Oracle Installer the Oracle7 Workgroup Server dialog box appears with various product installation options depending on the operating system you use.

Operating System Installation Options
Windows NT

 Oracle7 Workgroup Server Products

Oracle7 Client Products

Custom Installation

Windows 95 and Windows 3.1

 Oracle7 Client Products

Custom Installation

The products in the following tables are listed according to the product installation options available from the Oracle7 Workgroup Server for Windows NT CD-ROM disc.

Note:
Although the CD-ROM disc in your kit contains many Oracle products, you are only licensed to use those products for which you have purchased licenses.

Oracle7 Workgroup Server Products

Oracle7 Workgroup Server products include a starter database, applications, utilities, and network products that enable client connections.

Most of the following products are automatically installed when you select the Oracle7 Workgroup Server Products option. Some products listed require a separate licence.

Oracle Products Release
Oracle Installer

 3.1

Oracle Documentation (HTML)

 7.3

Oracle7 Server

 7.3

Required Support Files

 7.3

Oracle7 Utilities

 7.3

Oracle Call Interface

 7.3

Oracle Migration Wizard for Microsoft Access

 1.5

SQL*Plus

 3.3

SQL*Net Products

Oracle Intelligent Agent

 7.3

2.3

2.3

2.3

2.3

2.3

2.3

2.3

2.3

2.3

Oracle Enterprise Manager

Oracle Enterprise Manager Documentation

Oracle Client Software Manager

 1.3

1.3

1.3

Oracle Administrator Toolbar

 1.3

Oracle Enterprise Manager Software Development Kit (SDK)

 1.3

Oracle Enterprise Manager Repository Builder

 1.3

Oracle7 Client Products

Oracle7 Client products include applications, utilities and network products used on the client side to access and manipulate databases on the server.

Note:
The Oracle7 Client Products installation option contains two sub-options:
The following products are automatically installed when you select the Oracle7 Client Products option.

Oracle Products Release Database Administrator ApplicationUser Windows NT Client Windows 95 Client Windows 3.1 Client
Oracle Installer

 3.1

 YES

 YES

 YES

 YES

 YES

Oracle Call Interface

 7.3

 YES

 YES

 YES

 YES

 YES

Oracle Documentation

 7.3

 YES

 YES

 YES

 YES

 YES

Oracle7 Utilities

 7.3

 YES

 NO

 YES

 YES

 YES

SQL*Plus

 3.3

 YES

 YES

 YES

 YES

 YES

Oracle Enterprise Manager

 3.1

 YES

 NO

 YES

 YES

 NO

Oracle Enterprise Manager Documentation

 3.1

 YES

 NO

 YES

 YES

 NO

Oracle Enterprise Manager SDK

 3.1

 YES

 NO

 YES

 YES

 NO

Oracle Administrator Toolbar

 1.3

 YES

 NO

 YES

 YES

 NO

Oracle Client Software Manager

 3.1

 YES

 NO

 YES

 YES

 NO

Oracle Migration Wizard

 1.5

 YES

 NO

 YES

 YES

 YES

SQL*Net Client

 2.3

 YES

 YES

 YES

 YES

 YES

Oracle Named Pipes Protocol Adapter

 2.3

 YES

 YES

 YES

 YES

 YES

Oracle SPX/IPX Protocol Adapter

 2.3

 YES

 YES

 YES

 YES

 YES

Oracle TCP/IP Protocol Adapter

 2.3

 YES

 YES

 YES

 YES

 YES

Oracle DECnet Protocol Adapter

 2.3

 YES

 YES

 YES

 YES

 YES

Oracle APPC/LU6.2 Protocol Adapter

 2.3

 YES

 YES

 NO

 NO

 YES

Oracle NetBIOS Protocol Adapter

 2.3

 YES

 YES

 NO

 NO

 YES

Oracle Network Manager

 3.1

 YES

 NO

 NO

 NO

 YES

Required Support Files

 7.3

 YES

 YES

 YES

 YES

 YES

Required Support Files1

 7.2

 NO

 NO

 YES

 YES

 YES

Required Support Files

 7.1

 NO

 NO

 YES

 YES

 YES

  1. Required Support Files version 7.2 and version 7.1 can be installed on Windows NT and Windows 95 clients but are only available for installation through the Custom Installation option. Oracle Corporation provides Required Support Files version 7.2 and 7.3 for third party applications linked with them.

Custom Installation

The Custom Installation option lets you selectively install or remove Oracle products. The products available for installation are displayed on the left side of the Software Asset Manager screen.

Installing Oracle7 Workgroup Server Software on Windows NT

WARNING
 If you are installing 16-bit Windows 3.1 compatible software under Windows 95 or Windows NT, do not run the root level SETUP.EXE executable described in Step 5. Instead, you must run the SETUP.EXE executable located in the WINDOWS directory of your CD-ROM disc.

  1. Start Windows NT 3.51 or Windows NT 4.0.

  2. Log on to your Windows NT server computer as a member of the Administrators group.

  3. Stop all Oracle services (if any already exist).

    To stop Oracle services, open the Windows NT Control Panel, and select the Services icon. If any Oracle services exist and have the status Started, select them and choose Stop.

  4. Insert the Oracle7 Workgroup Server for Windows NT CD-ROM disc into the CD-ROM drive.

    Note:
    The installation steps assume that the CD-ROM drive is mapped to the G:\> drive.

  5. Start the Oracle Installer for Windows NT by running the Oracle Installer executable, SETUP.EXE.

    Note:
    If you click Cancel in any Oracle Installer dialog boxes, the Oracle Installer exits.

    The following table describes the various ways to run SETUP.EXE.

    If Running... Then...
    Windows NT 3.51

    		 From the File Manager:

    1. Choose the File Manager icon from the Windows NT Program Manager.

    2. Select the drive to which the CD-ROM is connected.

    3. Double-click on SETUP.EXE.

    or

    From the Program Manager:

    1. Select Run from the File menu in the Windows NT Program Manager.

    2. Enter the path and SETUP.EXE to start the Oracle Installer. For example:

      G:\SETUP.EXE
    3. Click OK.

    Windows NT 4.0

    1. Open My Computer.

    2. Select the drive to which the CD-ROM is connected.

    3. Double-click SETUP.EXE.

    The Language dialog box appears.

  6. Select a language, or click OK to accept the default language, English.

    Note:
    The default language, English, is installed with every Oracle7 Workgroup Server for Windows NT, in addition to any other language you select.

    Note:
    When you select a language, the Oracle Installer sets the NLS_LANG parameter in the Windows NT Registry. National Language Support (NLS) can be changed after installation by changing the values for the NLS_LANG parameter and by using the Oracle Installer to install the message files for the additional language.

    Additional Information
     See the appendix "National Language Support" in Oracle7 Workgroup Server Getting Started for Windows NT for information on setting the NLS_LANG parameter.

    The Oracle Installation Settings dialog box appears.

  7. Specify a company name and Oracle Home location in the Oracle Installation Settings dialog box, then click OK.

    Note:
    When you run the Oracle Installer from the Oracle7 Workgroup Server for Windows NT CD-ROM disc, the Oracle Installer prompts you to enter the company name. (If you install and run the Oracle Installer from your computer's hard drive, you will not receive this prompt during subsequent uses.

    Note:
    Oracle Installer determines the hard drive partition on your computer that has the most available space. This hard drive partition becomes the default location of Oracle Home. For example, C:\ORANT. Oracle Corporation recommends that you use this default setting.

    The Oracle7 Workgroup Server dialog box appears.

  8. Select any of the following product installation options, then click OK

  9. Oracle7 Workgroup Server Products

  10. Oracle7 Client Products

  11. Custom Installation

  12. Follow the installation instructions for your selected product installation option.

Oracle7 Workgroup Server Products

 Select the Oracle7 Workgroup Server Products option. Oracle7 Workgroup Server Products installation continues with no further prompts for information.

Note:
A starter database is automatically installed when you choose the Oracle7 Workgroup Server Products option. See the chapter "Post-installation" of Oracle7 Workgroup Server Getting Started for Windows NT for more information.

Oracle7 Client Products

If you select the Oracle7 Client Products option, the Oracle7 Client dialog box appears.

  1. Select the client sub-option to install, then click OK.

    Sub-option Provides You With...
    Database Administrator

    		 Products for connecting to an Oracle7 Workgroup Server database and performing database administration.

    Application User

    		 Networking services and support files required for database application users to connect and interact with an Oracle7 Workgroup Server database.

    A message appears asking if you want to install the online documentation on to your hard drive or to keep it on the CD-ROM disc.

  2. Follow the installation dialog boxes for the sub-option you select.

Custom Installation

 If you select the Custom Installation option the Software Asset Manager screen appears.

  1. Select the products to install, and choose Install.

  2. Provide appropriate responses to the dialog boxes that appear for the products selected for installation.

    Installation begins.

  3. Choose Exit when the installation is complete.

  4. Confirm your selection when prompted.

Installing Oracle7 Client Software on Windows 95 and Windows 3.1

 Follow these steps to install Oracle7 client software on Windows 95 and Windows 3.1.

  1. Start Windows 95 or Windows 3.1.

  2. Stop all applications that are running.

  3. Insert the Oracle7 Workgroup Server for Windows NT CD-ROM disc into your CD-ROM drive.

    Note:
    The installation steps assume that the CD-ROM drive is mapped to the G:\> drive.

  4. Start the Oracle Installer for Windows 95 and Windows 3.1 by running the Oracle Installer executable, SETUP.EXE.

    The following table describes the various ways to run SETUP.EXE.

    If Running... Then...
    Windows 3.1 or Windows 3.1 16-bit in a Windows 95 environment.

    		 From the File Manager:

    1. Choose the File Manager icon from the Windows 3.1 Program Manager.

    2. Select the drive to which the CD-ROM is connected.

    3. Double-click on SETUP.EXE.

    or

    1. From the Program Manager:

    2. Select Run from the File menu in the Windows 3.1 Program Manager.

    3. Enter the path and SETUP.EXE to start the Oracle Installer. For example:

      G:\SETUP.EXE
    4. Click OK.

    Windows 95

    		 From the Windows 95 Start Button:

    1. Select Start.

    2. Select Run. The Run dialog box appears.

    3. Enter the path and executable file name. For example:

      G:\SETUP.EXE
    4. Click OK.

    The Language dialog box appears.

  5. Select a language, or click OK to accept the default language, English.

    The Oracle Installation Settings dialog box appears.

  6. Specify a company name and Oracle Home location in the Oracle Installation Settings dialog box, then click OK.

    The Oracle7 Client dialog box appears with two product installation options.

  7. Select either the Database Administrator or Application User option, then click OK.

  8. Follow the installation instructions for your selected product installation option.

Installing OCSM on a File Server

 To install OCSM on a file server, complete the following tasks:

  1. Insert the Oracle7 Workgroup Server for Windows NT CD-ROM disc into the CD-ROM drive.

  2. Choose File/Run in the Program Manager. The Run dialog box appears.

  3. Select Browse, and navigate to the directory containing OCSM on the CD-ROM disc. For example, G:\WINDOWS\INSTALL.

  4. Select ORAINST.EXE or SETUP.EXE.

  5. Type /SHARED after ORAINST.EXE or SETUP.EXE, and then click OK.

  6. Respond to questions and prompts as they appear.

    WARNING
     Older products may not be supported by OCSM. If you previously had a stand-alone Oracle Home directory, you must choose a different location for the new Oracle Home directory for a fresh installation. The new Oracle Home makes your old Oracle Home directory unusable, and existing configurations are destroyed.

  7. Enter a shared location for your Oracle Home directory (network drive or your local drive) and your company name. Click OK.

    Note:
    A previously entered company name appears as the default. Click the directory icon next to the Oracle Home field to open the Choose Directory dialog box. Select a directory in which to install your Oracle Home. The location you choose for the Oracle Home field will be referred to as %ORACLE_HOME%.

    Note:
    The Configuration dialog box appears if you are installing Oracle products in this Oracle Home directory for the first time. It informs you that the path variable does not include an %ORACLE_HOME%\BIN directory (required by third party products that access Oracle databases). Select Yes to let the Oracle Installer modify the AUTOEXEC.BAT file to add the %ORACLE_HOME%\BIN directory to the path.

    The Installation Package Options dialog box appears. Use it to choose the packages you want to install. To choose products and components on an individual basis, deselect the packages.

    Note:
    If you choose to locate the Oracle Home on your local drive, make it accessible to the other OCSM users.

  8. In the OCSM window, enter the System Administrator's username. Click OK.

  9. Select Oracle Installer, OCSM Administrator, and OCSM Agent in the Software Asset Manager. Click Install.

  10. Answer product-specific questions. A message informs you when installation is complete.

  11. Verify that you have granted the following permissions:

    ATTENTION
     In a NetWare environment, you must also grant CREATE access to clients.

    Additional Information
     See the chapter "Post-installation" of Oracle7 Workgroup Server Getting Started for Windows NT for information on configuration tasks you must perform before using OCSM.

Removing Oracle7 Products

 To remove Oracle7 products:

  1. Stop all Oracle services.

  2. Start up the local version of the Oracle Installer by going to the appropriate Oracle for Windows NT, Windows 95 or Windows 3.1 Program Group, and double-click the Oracle Installer icon.

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

  4. Click Remove.

    The 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.

Upgrading Tasks

 This section contains instructions for upgrading databases created using previous versions of Oracle7 Workgroup Server for Windows NT to the current version of Oracle7 Workgroup Server for Windows NT. If you have data stored in a version 7.0, 7.1, 7.2 or 7.3.2 Oracle7 database, you must upgrade your database to make it work with version 7.3.3 of Oracle7 Workgroup Server for Windows NT.

The upgrading process consists of the following tasks:

  1. Perform Pre-upgrading Tasks.

  2. Install Oracle7 Workgroup Server for Windows NT from the CD-ROM Disc.

  3. Move and Rename Database Files.

    Note:
    In the following sections you will be asked to enter commands at the SQL*DBA or Server Manager prompt. The SQLDBAxx application has been replaced by SVRMGR23 for version 7.3. Remember to use the appropriate version of SQL*DBA for your version of Oracle7 Workgroup Server.

If you are upgrading from:

Perform Pre-upgrading Tasks

 Before upgrading to version 7.3.3, complete the following:

  1. Remove SQL*Net version 2.2 (or any previous versions of SQL*Net) before installing the SQL*Net version 2.3 product included on this CD-ROM disc.

    If you remove SQL*Net version 2.2 after installing SQL*Net version 2.3, some shared SQL*Net version 2.3 files will be overwritten, rendering SQL*Net version 2.3 unusable. If you mistakenly remove SQL*Net version 2.2 after installing SQL*Net version 2.3, then install SQL*Net version 2.3 again.

  2. Ensure there is at least 8 MB of free space in the SYSTEM tablespace.

    a. Check the amount of free space in the SYSTEM tablespace by connecting as SYSTEM/MANAGER, then using this SQL statement at the SQL*DBA or Server Manager prompt:

    select sum(bytes) from sys.dba_free_space
    where tablespace_name = 'SYSTEM';
    If 8 MB of free space is not available, enlarge the SYSTEM tablespace.

    b. Increase the SYSTEM tablespace by adding a data file of the appropriate size. For example, the following SQL statement adds an 8 MB data file to the SYSTEM tablespace:

    alter tablespace SYSTEM add datafile 'directory for the file\filename' size 8M;
  3. Make a list of the control, data and log files for each database instance you want to upgrade. To get a list of these files for the instance enter the following SQL statement at the SQL*DBA or Server Manager prompt:

    connect system/account password for the instance
    spool upgrade.log;
    select member from v$logfile;
    select name from v$datafile;
    select value from v$parameter
    where name = 'control_files';
    where the WHERE clause equals CONTROL_FILES, DB_FILES or LOG_FILES.

  4. Shut down the Oracle7 Workgroup Server database and delete any Oracle services belonging to the database.

    a. To shut down the database enter the following at the SQL*DBA or Server Manager prompt:

    connect internal/password
    shutdown
    exit
    b. Delete Oracle services belonging to the database using:

  5. Back up your %ORACLE_HOME% directory.

    Additional Information
     See Oracle7 Workgroup Server Getting Started for Windows NT and Oracle Database Administrator's Guide for details on database backup.

  6. Change or add the value of the COMPATIBLE parameter in the INITsid.ORA file to the release of the Oracle7 Workgroup Server you are upgrading to. For example, set: COMPATIBLE=7.3.0.0.0

  7. Back up the version 7.0, 7.1, 7.2 or 7.3.2 INITsid.ORA file.

  8. Remove the version 7.0, 7.1, 7.2 or 7.3.2 Oracle7 Workgroup Server, SQL*Net Server and Oracle7 Utilities using Oracle Installer.

    Additional Information
     See the section "Removing Oracle7 Products" on how to remove products with the Oracle Installer.

    CAUTION
     Do not remove the version 7.0, 7.1, 7.2 or 7.3.2 database files or the Required Support Files when prompted!

Install Oracle7 Workgroup Server for Windows NT from the CD-ROM Disc

  1. Install the Oracle7 Workgroup Server for Windows NT from the CD-ROM disc. See the installation steps earlier in this document for details.

    Note:
    During installation, you have the choice of installing the starter database. If you do not need another database (in addition to the one that you are upgrading from), you do not have to install the starter database.

  2. If you installed a starter database, add an entry for ORACLE_SID to the Windows NT Registry. If you did not install a starter database proceed to Step 3.

    a. Create a SID for the instance you intend to upgrade.

    For example, choose ABCD as the SID.

    ATTENTION
     If you have chosen to install the starter database, do not use ORCL as the SID (the version 7.3.3 starter database has ORCL as the default SID).

    Note:
    SID is limited to four alphanumeric characters or less.

    b. Enter REGEDT32 (for Windows 3.51) or REGEDIT (for Windows NT 4.0) at the command prompt to open the NT Registry.

    c. Go to the \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE directory.

    d. Create the ORACLE_SID value with data type REG_EXPAND_SZ and the SID you chose earlier in the string field.

    e. Close the NT Registry.

  3. Create and start version 7.3.3 Oracle services.

    a. Create and start an Oracle version 7.3.3 instance (without creating a new database) using the command line version of Instance Manager. If you use the GUI version of Instance Manager a new database is automatically created.

    Additional Information
     See the chapter "Using Oracle Tools and Utilities" of Oracle7 Workgroup Server Getting Started for Windows NT for information on using the command line version of Instance Manager. Information on using Instance Manager GUI is available as online help.

    b. From the command line, enter:

    ORADIM73 -NEW -SID sid [-INTPWD internal_pwd] 
    [-MAXUSERS number][-STARTMODE auto, manual]
     
    [-PFILE INITsid.ORA]
     The following are created:

    c. From the command line, enter:

    ORADIM73 -STARTUP -SID sid -PFILE INITsid.ORA [-USRPWD user_pwd]  -STARTTYPE SRVC,INST  

    


    

     Note: 
    
    
This command only starts the Oracle services. It does not start the database.



    


    


    

     CAUTION
    
    
After installing Oracle7 Workgroup Server version 7.3.3, do not remove Oracle7 Workgroup Server version 7.1. Removing version 7.1 will disrupt your version 7.3.3 installation.

Move and Rename Database Files

  1. Move all version 7.0, 7.1, 7.2 or 7.3.2 database files to the version 7.3.3 ORANT\DATABASE directory.

    Note:
    Database files consist of control files, data files and log files. If you have your own database file structure, go to Step 3

    Move Database Files From... To...
    %ORACLE_HOME%\RDBMS70

    		 %ORACLE_HOME%\DATABASE

    %ORACLE_HOME%\RDBMS71

    		 %ORACLE_HOME%\DATABASE

    For example, move a version 7.1 control file to the version 7.3.3 directory as follows:

    move c:\orant\rdbms71\ctl1orcl.ora       c:\orant\database\ctl1abcd.ora.
  2. Move all version 7.0, 7.1, 7.2 or 7.3.2 archive files to the version 7.3.3 \ARCHIVE directory.

    Move Archive Files From... To...
    %ORACLE_HOME%\RDBMS70\ ARCHIVE

    		 %ORACLE_HOME%\DATABASE\ARCHIVE

    %ORACLE_HOME%\RDBMS71\ ARCHIVE

    		 %ORACLE_HOME%\DATABASE\ARCHIVE

    The following table lists the files of the version 7.0, 7.1, 7.2 or 7.3.2 starter database. This information is in the spool file you created earlier in Step 3 of the section "Perform Pre-upgrading Tasks". If you have expanded the starter database, move the additional database files as well.

    7.0 Files 7.1 Files 7.2 Files
    %RDBMS70%\ CTL1.ORA

    		 %RDBMS71%\ CTL1ORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\CTL1ORCL.ORA

    %RDBMS70%\ DBS1.ORA

    		 %RDBMS71%\ SYSORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\SYS1ORCL.ORA

    %RDBMS70%\ LOG1.ORA

    		 %RDBMS71%\ USERORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\USR1ORCL.ORA

    %RDBMS70%\ LOG2.ORA

    		 %RDBMS71%\ RBSORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\RBS1ORCL.ORA

    		 %RDBMS71%\ TEMPORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\TMP1ORCL.ORA

    		 %RDBMS71%\ LOG1ORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\LOG1ORCL.ORA

    		 %RDBMS71%\ LOG2ORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\LOG2ORCL.ORA

    		 %RDBMS71%\ARCHIVE\CTL1ORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\ARCHIVE\ CTL1ORCL.ORA

    		 %RDBMS71%\ARCHIVE\LOG1ORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\ARCHIVE\ LOG1ORCL.ORA

    		 %RDBMS71%\ARCHIVE\LOG2ORCL.ORA

    		 %ORACLE_HOME%\ DATABASE\ARCHIVE\ LOG2ORCL.ORA

    Note:
    This information is in the spool file you created earlier.

  3. Edit the version 7.0, 7.1, 7.2 or 7.3.2 initialization parameter files.

  4. Move the initialization parameter files to the 7.3.3 ORANT\DATABASE directory.

    Move Initialization Files From... To...
    %ORACLE_HOME%\RDBMS70\ INITsid.ORA

    		%ORACLE_HOME%\DATABASE\ INITsid.ORA

    %ORACLE_HOME%\RDBMS71\ INITsid.ORA

    		 %ORACLE_HOME%\DATABASE\ INITsid.ORA

  5. Edit the version 7.3.3 initialization parameter file.

    You moved the version 7.0, 7.1, 7.2 or 7.3.2 control files, data files, log files, archive files and any other database files you may have to the version 7.3.3 directory %ORACLE_HOME%\DATABASE. The new location of these files must be reflected in the version 7.3.3 initialization parameter file. For example, edit the CONTROL_FILES parameter as follows:

    CONTROL_FILES = (%ORACLE_HOME%\DATABASE\CTL1ABCD.ORA) 

    


    

     Note: 
    
    
Change any occurrence of %RDBMS70%, %RDBMS71%, or %RDBMS72% in the initialization parameter file to %RDBMS73%.



    

 
    


    

     Note: 
    
    
If you installed Oracle7 Workgroup Server release 7.3.3 without the starter database, remove the reference to CTL2SID.ORA in your initialization parameter file.



    

    


    

     Note: 
    
    
In Release 7.3.3 of the Oracle7 Workgroup Server for Windows NT, the CONTROL_FILES parameter in the initialization parameter file points to two control files. Since some previous versions pointed to only one control file, you must ensure that this parameter points to only one control file, unless you have customized the initialization parameter file.
  6. Verify REMOTE_LOGIN_PASSWORDFILE=SHARED in the version 7.3.3 initialization parameter file. If it does not, change the setting.

  7. Set ORACLE_SID=ORCL at the command prompt.

  8. Start the version 7.0, 7.1, 7.2 or 7.3.2 Oracle7 Workgroup Server database using Server Manager line mode.

    When prompted for a password, enter the password you used to create Oracle services. Then enter the following:

    SVRMGR> CONNECT INTERNAL/PASSWORD
    SVRMGR> STARTUP EXCLUSIVE MOUNT 

    


    

     Note: 
    
    
If you have your own database file structure, go to Step  10  (you have neither moved nor renamed your files).
  9. Enter the ALTER DATABASE statement at the Server Manager prompt to change the full paths of the data files and log files.

    The following example 7.0 statements upgrade the default SID ORCL. Your statement must match your actual files. 

    SVRMGR> ALTER DATABASE RENAME FILE
    2> C:\ORANT\RDBMS70\dbs1.ora',
    3> C:\ORANT\RDBMS70\log1.ora',
    4> C:\ORANT\RDBMS70\log2.ora' to 
    5> C:\ORANT\DATABASE\dbs1orcl.ora',
    6> C:\ORANT\DATABASE\log1orcl.ora',
    7> C:\ORANT\DATABASE\log2orcl.ora'
    The following example 7.1 statements upgrade the default SID ORCL. Your statement must match your actual files. 

    SVRMGR> ALTER DATABASE RENAME FILE
    2> C:\ORANT\RDBMS71\log1orcl.ora',
    3> C:\ORANT\RDBMS71\ARCHIVE\ log1orcl.ora',
    4> C:\ORANT\RDBMS71\log2orcl.ora',
    5> C:\ORANT\RDBMS71\ARCHIVE\ log2orcl.ora',
    6> C:\ORANT\RDBMS71\sysorcl.ora',
    7> C:\ORANT\RDBMS71\usrorcl.ora',
    8> C:\ORANT\RDBMS71\rbsorcl.ora',
    9> C:\ORANT\RDBMS71\tmporcl.ora' to 
    10> C:\ORANT\DATABASE\log1orcl.ora',
    11> C:\ORANT\DATABASE\ARCHIVE\ log1orcl.ora',
    12> C:\ORANT\DATABASE\log2orcl.ora',
    13> C:\ORANT\DATABASE\ARCHIVE\ log2orcl.ora',
    14> C:\ORANT\DATABASE\sys1orcl.ora',
    15> C:\ORANT\DATABASE\usr1orcl.ora',
    16> C:\ORANT\DATABASE\rbs1orcl.ora',
    17> C:\ORANT\DATABASE\tmp1orcl.ora'
     

    


    

     Note: 
    
    
If your Oracle Home directory is not C:\ORANT, replace it with the actual directory name.



    



    


    

     Note: 
    
    
If you have expanded the database, include the additional database files in the above statements.
  10. Run SQL scripts at the Server Manager prompt to upgrade the database.

    To Upgrade From 7.0.15 to 7.3.3:

    SVRMGR> ALTER DATABASE OPEN;
    SVRMGR> @%RDBMS73%\ADMIN\CAT70101.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT70102.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT70103.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7103.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7106.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7201.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7202.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7203.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7301.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7302.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7303.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CATALOG.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CATPROC.SQL
    To Upgrade From 7.1.3 to 7.3.3: 

    SVRMGR> ALTER DATABASE OPEN;
    SVRMGR> @%RDBMS73%\ADMIN\CAT7106.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7201.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7202.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7203.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7301.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7302.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7303.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CATALOG.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CATPROC.SQL
    To Upgrade From 7.2.2 to 7.3.3:

    SVRMGR> ALTER DATABASE OPEN;
    SVRMGR> @%RDBMS73%\ADMIN\CAT7203.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7301.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7302.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CAT7303.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CATALOG.SQL
    SVRMGR> @%RDBMS73%\ADMIN\CATPROC.SQL
     

    


    

     Note: 
    
    
CATPROC.SQL is for PL/SQL functionality. 



    



    


    

     Note: 
    
    
Ensure that you spool all of the output from the .SQL scripts to a file. Then, check the file for errors.
  11. Rerun UTLXPLAN.SQL in any schema in which you want to use EXPLAIN PLAN.

  12. Shut down and restart the 7.0, 7.1, 7.2 or 7.3.2 Oracle7 Workgroup Server database by entering the following command at the Server Manager prompt:

    SVRMGR> shutdown
  13. Shut down and restart the computer.

    Your 7.0, 7.1, 7.2 or 7.3.2 Oracle7 Workgroup Server database is now upgraded to version 7.3.3.


Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.		 Go to Product Documentation Library
Library		 Go to books for this product
Product