3
Installing as an Upgrade

This chapter explains how to install Reports Developer Release 6i when you already have a previous release of the product installed.

(Note that in earlier releases, the product was called Oracle Developer or Developer/2000.)

There are two areas to consider:

• Upgrading the product itself -- that is, installing the new version of the software.

• Upgrading your existing applications -- that is, recompiling your applications with the new version of the product.

3.1 Upgrading the Product

Warning: Do not install or build the Oracle Reports Developer database tables until you run the appropriate upgrade script. If you have customized your product resource (.RES) files (e.g., fmrusw.res), you should backup these files before upgrading.

• Product resource (.RES) files

• tnsnames.ora

• sqluct.ora

3.1.1 Version Issues

3.1.1.1 Upgrading From Versions Before 6.0

All of your currently-installed components require upgrading. This is especially important if you have been using Release 1 or 2. Because of improvements to the underlying support files, such as the Tools Utilities, GUI Common files, and Required Support Files, the older set of components cannot run with the newer set.

If you have used previous versions of Reports Developer on Microsoft Windows 3.x, your ORACLE_HOME directory was called ORAWIN. When you upgraded your operating system to Windows 95, 98, or NT, your old ORAWIN directory was retained.

The installation of Reports Developer Release 6i creates a new ORACLE_HOME directory. This new directory is named either ORAWIN95 (on Windows 95), ORAWIN98 (on Windows 98), or ORANT (on Windows NT). In any case, your old ORAWIN directory is not used or overwritten.

3.1.1.2 Upgrading from Release 6.0 and 6i

Upgrading from Release 6.0 to this 6i release does not require a full reinstall.

3.1.2 Running the Oracle Installer

Use the Oracle Installer to install the new version of the product from the CD. If you are not familiar with this tool or the options, follow the instructions in the Chapter 2, "Installing as a New Customer".

Remember that if you are going to deploy applications to the web, you should also install/upgrade the new version of the Reports Server.

3.1.3 Server Considerations:

Listeners that support CGI (Common Gateway Interface), servlets, or OAS are supported in Reports Developer Release 6i.

The Oracle WebDB Listener is provided on the Reports Developer CD, and is a convenient choice, but any web server can be used.

If you are currently using Developer Release 6.0 and Oracle Application Server (OAS) Release 4.0.7, and you want to continue using OAS with Reports Release 6i, then you need to also install OAS Release 4.0.8. Be aware of the following considerations:

• You must install OAS 4.0.8 into a separate ORACLE_HOME from Reports Developer 6i.

• You must install OAS 4.0.8 into a separate ORACLE_HOME from OAS 4.0.7. Do not overlay or deinstall 4.0.7.

There also are likely to be additional cartridge upgrade requirements if you install OAS 4.0.8. Please see the Reports Developer Release Notes for the latest information.

3.2 Upgrading Your Applications

If you want to run your old applications (applications that were created with a version prior to Release 6) on this new version of the product, those applications need to be recompiled after you have the new product version installed.

When upgrading applications, please keep the following in mind:

• We strongly recommend that you make a backup of all modules before beginning the conversion process.

• In general, applications are upwards compatible. However, there are occasionally minor differences in functionality.

  See the sections New Features and Compatibility with Previous Releases in the online help for specifics. Additional compatibility information can be found on these websites:

  • http://technet.oracle.com/products/developer/

  • http://technet.oracle.com/products/reports/

  Chapter 6 of the Oracle8 Server Migration manual contains additional information on compatibility between releases.

• Applications that were built with SQL*Report or SQL*Reportmate Release 1, 2, or 3 cannot be moved directly to the 6i release for recompile. Instead, you must first recompile them with versions 4.0, 4.5, or 5.0. After that intermediate conversion, you can then recompile them again on this release.

• Reports Developer Release 6i includes a PL/SQL conversion utility for converting modules based on PL/SQL version 1 or 2 to PL/SQL version 8, which is the version this release is based on. If you are upgrading from a release prior to Developer 2000, you will need to convert all modules (Reports, Graphics, and PL/SQL libraries) to the newer version of PL/SQL. The conversion utility runs automatically whenever you open a report containing PL/SQL version 1 or 2, allowing you to interactively perform the conversion. The conversion can also be run automatically in batch mode.

  See Chapter 6 of the Oracle8 Server Migration for more detailed information on the PL/SQL conversion utility.

• If you are upgrading applications that contain user exits and user-created DLLs, those DLL files may need to be recompiled after recompiling your applications with the new release.

  Applications that make calls through the Reports Developer foreign function interface (ORA_FFI package) to 16-bit DLLs will not work under Windows 95/98/NT due to an operating system incompatibility between 16-bit code and 32-bit executables. The DLL must be recompiled/linked as a 32-bit DLL.

• Applications that use VBX controls do not run properly under Windows 95/98/NT due to an operating system incompatibility between 16-bit VBX controls and 32-bit executables. OCX/ActiveX controls are the equivalent for a 32-bit environment.

3.2.1 Redeploying Your Applications on the Web

After you recompile your older applications with this release, they are eligible to be deployed on the web.

For instructions, consult the manual Oracle Reports Server Building Reports, A73071. Information can also be found on the following website: http://technet.oracle.com/products/reports/.