4 Oracle Database Postinstallation Tasks

4.3.1 Configuring Messaging Gateway

Messaging Gateway, an Oracle Database Advanced Queuing feature, requires additional configuration.

4.3.2 Installing Natively Compiled Java Libraries for Oracle JVM and Oracle interMedia

If you plan to use Oracle JVM or Oracle interMedia, Oracle strongly recommends that you install the natively compiled Java libraries (NCOMPs) used by those components from the Oracle Database Companion CD. These libraries are required to improve the performance of the components on your platform.

4.3.3 Configuring Oracle Administration Assistant for Windows

This tool requires the Microsoft Management Console and HTML Help 1.2 or higher to run. Microsoft Management Console is included with Windows 2000, but must be manually installed if you are using Windows NT 4.0. MMC version 1.2 or higher is required. The latest MMC version available is recommended.

http://www.microsoft.com/

4.3.4 Reconfiguring Oracle Cluster Synchronization Services (CSS)

To reconfigure Oracle Cluster Synchronization Services (CSS) to run from a different Oracle home, enter the following at the command prompt:

localconfig reset [destination_Oracle_home]

where destination_Oracle_home is required if you run this command from the Oracle home where the CSS service is currently configured.

4.3.5 Configuring Oracle Counters for Windows Performance Monitor

Before using Oracle Counters 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:

operfcfg.exe -U SYSTEM -P password -D TNS_Alias_for_database

4.3.6 Configuring Oracle Label Security

If you installed Oracle Label Security, you must configure it in a database before you use it. You can configure Oracle Label Security with or without Oracle Internet Directory integration. If you configure Oracle Label Security without Oracle Internet Directory integration, you cannot configure it to use Oracle Internet Directory at a later stage.

4.3.7 Configuring Oracle Net Services

If you have a previous release of Oracle software installed on this system, you might want to copy information from the Oracle Net tnsnames.ora and listener.ora configuration files from the previous release to the corresponding files for the new release.

If you are upgrading from a previous release of Oracle Database, Oracle recommends that you use the current release of Oracle Net listener instead of the listener from the previous release.

To use the listener from the current release, you may need to copy static service information from the listener.ora file from the previous release to the version of that file used by the new release.

For any database instances earlier than release 8.0.3, add static service information to the listener.ora file. Oracle Database releases later than release 8.0.3 do not require static service information.

Unless you are using a central tnsnames.ora file, copy Oracle Net service names and connect descriptors from the previous release tnsnames.ora file to the version of that file used by the new release.

If necessary, you can also add connection information for additional database instances to the new file.

4.3.8 Configuring Oracle Services for Microsoft Transaction Server

For Windows NT installations, if you did not install the Microsoft Management Console (MMC) before installing Oracle Database, then you must manually start the OracleMTSRecoveryService service and change its status to Automatic.

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

4.3.9 Installing Oracle Text Supplied Knowledge Bases

An Oracle Text knowledge base is a hierarchical tree of concepts used for theme indexing, ABOUT queries, and deriving themes for document services. If you plan to use any of these Oracle Text features, you can install two supplied knowledge bases (English and French) from the Oracle Database Companion CD.

4.3.10 Configuring or Reinstalling Oracle XML DB

Refer to Oracle XML DB Developer's Guide for more information about the following tasks:

• Reinstallation of Oracle XML DB

• Configuring or customizing the Oracle XML DB tablespace

• Configuring FTP, HTTP/WebDAV port numbers

4.3.11 Configuring PL/SQL External Procedures

Configuration is dependent on the network configuration files used. In nearly all cases, configuration is automatic. However, if you are using pre-8.0.3 tnsnames.ora and listener.ora files with your 10g release 1 (10.1) database, then manual configuration is required.

4.3.12 Configuring Shared Server Support

Configuration is dependent on how support was installed. If you installed Oracle Database through the Enterprise Edition, Standard Edition, or Personal Edition installation types, then shared support was not configured. If you created your database through Database Configuration Assistant, then you were offered a choice of shared or dedicated server support.

4.3.13 Setting Credentials for the Job System

Windows systems require that you set the correct credentials for the Jobs system to work properly in Enterprise Manager. By default, the Management Agent service is installed as a LocalSystem user. When submitting jobs, the user submitting the job must have the Log on as a batch job privilege enabled.

Perform the following steps to establish that privilege for any operating system user who needs to submit an Enterprise Manager job.

On Windows 2000 and Windows XP systems:

1. Start the Local Security Policy tool located in the Start menu by clicking Settings > Control Panel > Administrative Tools > Local Security Policy.

2. Under Local Policies/User Rights Assignment, add the user to the Log on as a batch job privilege.

3. Windows 2000 may require a restart for the policy change to take effect. Restart as necessary.

On Windows NT 4.0 systems:

1. Start the User Manager tool located in the Start menu by clicking Programs > Administrative Tools > User Manager.

2. Select User Rights from the Policies menu.

3. Select the Show Advanced User Rights check box.

4. Select Log on as a batch job from the Right drop-down menu.

5. Click Add to add the Windows user who is submitting an Enterprise Manager job.

If a user exist both locally and at the domain level, Windows gives the local user precedence. To use the domain user, qualify the username with the domain name. For example, to use the user joe in the ACCOUNTS domain specify the username as ACCOUNTS\joe.

If the Management Agent service is installed as any other user (that is, not LocalSystem), then, in addition to granting the Log on as a batch job privilege, the "Windows service" user must be granted the following three privileges:

• Act as part of the operating system

• Adjust memory quotas for a process. (This is named Increase memory quotas on Windows 2000 and Windows NT Server 4.0.)

• Replace a process level token

4.3.14 Installing Oracle Database Components from the Companion CD

The Oracle Database Companion CD contains additional components that you can install. Whether you need to install these components depends on which Oracle Database components or features that you plan to use. If you plan to use the following components or features, Oracle strongly recommends that you install the components from the Companion CD:

• JPublisher

• Oracle Database Examples (formerly Oracle Demos)

• Oracle JVM

• Oracle interMedia

• Oracle Text

To install Oracle Database components from the Companion CD, follow these steps:

1. Insert the CD labeled Oracle Database Companion CD Disk 1 of 1 in the disk drive.

   When installing from a hard disk, double-click setup.exe.

   When installing from the Oracle Database CD, the Autorun screen automatically appears. If the Autorun screen does not appear, then:

   1. Click Start > Run.

   2. Enter the following:

      DRIVE_LETTER:\autorun\autorun.exe
      
      

      The Autorun screen appears. Click Install/Deinstall Products from the Autorun screen.

2. Use the following guidelines to complete the installation:

   • On the Specify File Locations screen, select the Oracle home name and path for the existing Oracle Database installation where you want to add these components.

   • On the Select a Product to Install Screen, select Oracle Database 10g Products.