5
Postinstallation Configuration Tasks

This chapter identifies postinstallation configuration tasks. Where appropriate, this chapter references other guides for procedures on performing these configuration tasks.

This chapter contains these topics:

• Patch Set Information

• Validating Invalid PL/SQL Modules

• Individual Component Postinstallation Configuration Tasks

Patch Set Information

Oracle Corporation recommends installing the latest patch set release after successful installation of the base release.

Current patch set information is available at

http://metalink.oracle.com

You must register online before using OracleMetaLink. After logging into OracleMetaLink, select Patches from the left-hand column.

To find and download patches:

1. Find the latest patch set.

   Find the latest patch set for Oracle9i using OracleMetaLink.

2. From the list of selected patches, select a patch to download.

   Note that patch sets for Oracle databases are identified as "x.x.x PATCH SET FOR ORACLE DATA SERVER."

3. Review the README before proceeding with the download.

   The README contains installation requirements and instructions.

4. Download and install the patch.

Validating Invalid PL/SQL Modules

When the Oracle9i database is created, the utlrp.sql script runs automatically. However, when an Oracle9i database is created through the Custom installation type, this script does not automatically run. Oracle Corporation recommends running the utlrp.sql script after creating, upgrading, or migrating a database. This script recompiles all PL/SQL modules that may be in an INVALID state, including packages, procedures, types, and so on. This step is optional, but recommended so that the cost of recompilation is incurred during the installation rather than in the future.

Note: There should be no other data definition language (DDL) statements running on the database while the script is running, and packages STANDARD and DBMS_STANDARD must already be valid.

1. Start SQL*Plus:

   C:\> sqlplus

2. Connect to the database with the sys account:

   SQL> CONNECT sys/password as SYSDBA

   where password is change_on_install by default, unless you changed it after installation.

3. Start the database (if necessary):

   SQL> STARTUP

4. Run the utlrp.sql script:

   SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql

Individual Component Postinstallation Configuration Tasks

Some individual components require postinstallation configuration tasks. The following sections list configuration requirements and the sections or documents referenced for specific configuration procedures.

• Oracle Advanced Security

• Oracle HTTP Server

• Oracle interMedia and Oracle Spatial

• UNIX Emulation Utility

• Oracle Net Services

• Oracle OLAP API

• Oracle Counters for Windows Performance Monitor

• Oracle Real Application Clusters

• Oracle Services for Microsoft Transaction Server

• Oracle Workflow

• Oracle XML DB

• PL/SQL External Procedures

Oracle Advanced Security

Authentication, encryption, integrity support, and enterprise user security require configuration.

See Also: Oracle Advanced Security Administrator's Guide

Oracle interMedia and Oracle Spatial

These components are automatically configured when installed during the same installation as the Oracle9i database.

If you installed these components during a separate installation of the Oracle9i database manual configuration tasks need to be performed.

See Also: "Postinstallation Configuration Tasks" of Oracle9i Database Platform Guide for Windows for procedures

UNIX Emulation Utility

You must download a UNIX emulation utility for Windows to run Oracle Internet Directory shell script tools on Windows (bulkload.sh, bulkdelete.sh, bulkmodify.sh, catalog.sh, and ldaprepl.sh). Two third-party software vendors provide this utility:

• Cygnus (open source)

  http://sources.redhat.com/cygwin/

• MKS Toolkit (commercially available)

  http://www.datafocus.com/products/

  See Also: Oracle Internet Directory Administrator's Guide

Oracle Net Services

Oracle Net Configuration Assistant assists you in configuring your Oracle network.

If you installed Oracle Net Services, Oracle Net Configuration Assistant automatically guided you through network configuration of client computers and database servers.

You can also configure your Oracle network after installation with the Oracle Net Configuration Assistant and Oracle Net Manager tools.

See Also: Oracle9i Net Services Administrator's Guide and the online help available with both tools "Configuring Your Network" for a discussion of available configuration choices

Oracle OLAP API

Before writing Java programs that use the OLAP API, you must make the files accessible in your Java development environment.

See Also: "Setting Up the Development Environment" of Oracle9i OLAP Developer's Guide to the OLAP API

Oracle Counters for Windows Performance Monitor

Before using Oracle for Windows Performance Monitor to view Oracle-specific counters, you must specify the SYSTEM password using OperfCfg.exe located in the ORACLE_BASE\ORACLE_HOME\bin directory.

To set the SYSTEM password, enter the following:

C:\> operfcfg.exe -U system -P password [-D database_name]

See Also: Oracle9i Database Platform Guide for Windows for additional information about Oracle for Windows Performance Monitor

Oracle Real Application Clusters

Postinstallation configuration procedures must be performed to enable high availability and Oracle Enterprise Manager functionality.

Note: A 64-bit version of Oracle Enterprise Manager is not available in this release. Use Oracle Enterprise Manager from your 32-bit computer to manage the cluster of 64-bit computer nodes remotely. See Oracle Enterprise Manager Advanced Configuration Guide for more information.

Oracle Services for Microsoft Transaction Server

Perform the following tasks before using Oracle Services for Microsoft Transaction Server:

• Create the Microsoft Transaction Server administrator account

• Schedule a database server-level transaction recovery job

Oracle Workflow

You must perform a number of configuration tasks, including:

• Editing the init.ora parameter file

• Installing and configuring a Web server

• Verifying your base URL

• Setting up the Oracle Workflow Monitor and HTML help

Oracle XML DB

Refer to Appendix A of Oracle9i XML Database Developer's Guide - Oracle XML DB for more information on the following tasks:

• Re-installation of Oracle XML DB

• Configuring or customizing the Oracle XML DB tablespace

• Configuring FTP, HTTP/WebDAV port numbers

PL/SQL External Procedures

Configuration is dependent on the network configuration files used. In nearly all cases, configuration is automatic.

See Also: "Developing Applications" of Oracle9i Database Platform Guide for Windows