7
Post-installation Configuration Tasks

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

Specific topics discussed are:

• Setting NTFS File System and Windows NT Registry Permissions

• Validating Invalid PL/SQL Modules with the UTLRP.SQL Script

• Configuring Additional Components

Setting NTFS File System and Windows NT Registry Permissions

Oracle Corporation recommends that you configure Oracle8i database files, directories, and registry settings to allow only authorized database administrators (DBAs) to have full control. The following topics describe how to perform these tasks:

• NTFS File System Security

• Windows NT Registry Security

  See Also: Your Windows NT documentation for more information about modifying NTFS file system and Windows NT registry settings

NTFS File System Security

The Oracle8i database uses files to store database data, backup data, log information, and so on. To do this, the Oracle8i database process runs under a security account. This security account (the Windows NT LocalSystem account called SYSTEM) includes the ability to create and access these files. The security account is assigned to the service that the Oracle8i database uses (in the Control Panel). This account requires full file system permissions to create, read, write, delete, and execute files.

To ensure that only authorized users have full file system permissions:

1. Go into Windows NT Explorer.

2. Right-click Oracle8 database files (in the ORACLE_BASE\ORADATA\DB_NAME directory), executables and dynamic link libraries (in the ORACLE_BASE\ORACLE_HOME\BIN directory), and directories.

3. Select Properties from the menu that appears.

4. Adjust the file and directory permissions to ensure that:
   • Only the security account that the Oracle8i database is configured to use has full control permissions to these files

   • User accounts that must run Oracle applications (for example, SQL*Plus, Server Manager, and Pro*C) have read privileges on their executables (for example, SQLPLUS.EXE for SQL*Plus)

     Note: The Oracle8i database uses the Windows NT LocalSystem built-in security account. Therefore, file permissions must be granted to the SYSTEM account of the local computer running the Oracle8i database.

Windows NT Registry Security

Oracle Corporation recommends that you remove write permissions from users who are not Oracle8i DBAs or system administrators in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE of the Windows NT registry.

To remove write permissions:

1. Open the registry.

2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.

3. Select Permissions from the Security main menu.

   The Registry Key Permissions dialog box appears.

4. Remove write permissions from any users who are not Oracle8i DBAs or system administrators. Note that the SYSTEM account must have Full Control, since this is the account with which the Oracle8i database runs.

5. Ensure that user accounts that must run Oracle applications have read privileges.

6. Click OK.

7. Exit the registry.

Validating Invalid PL/SQL Modules with the UTLRP.SQL Script

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 it 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
   

Configuring Additional Components

Some individual components require post-installation configuration tasks. Review the following table for configuration requirements and see the sections or documents referenced for specific configuration procedures:

Component	Description	See Also...
Advanced Replication support	Configuration is dependent on how support was installed. If you installed the Oracle8i database through the Typical or Minimal installation types, or selected Advanced Replication when prompted by Oracle Database Configuration Assistant, Advanced Replication was automatically configured for you. In all other cases, Advanced replication support must be manually configured.	Chapter 5, "Post-Installation Configuration Tasks", of Oracle8i Administrator's Guide for Windows NT Chapter 4, "Selecting Database Creation and Net8 Configuration Methods" of this guide
Multithreaded server support	Configuration is dependent on how support was installed. If you installed the Oracle8i database through the Typical or Minimal installation types, multithreaded support was not configured. If you created your Oracle8i database through Oracle Database Configuration Assistant, you were offered a choice of multithreaded or dedicated.	Chapter 5, "Post-Installation Configuration Tasks", of Oracle8i Administrator's Guide for Windows NT Chapter 4, "Selecting Database Creation and Net8 Configuration Methods" of this guide
Net8 network software	Net8 Configuration Assistant is a tool that assists you in configuring your Oracle network. If you installed Net8 Server and Net8 Client, Net8 Configuration Assistant automatically started at the end of installation to guide you through network configuration. You can also configure your Oracle network after installation with the Net8 Configuration Assistant and Net8 Assistant tools.	Net8 Administrator's Guide and the online help available with both tools "Selecting a Net8 Configuration Method" for a discussion of available configuration choices
Oracle Administration Assistant for Windows NT	This tool requires the Microsoft Management Console 1.0 or 1.1 (1.1 is recommended) and HTML Help 1.2 to run. Microsoft Management Console is included with Windows 2000, but must be manually installed if you are using Windows NT 4.0.	Microsoft documentation
Oracle Advanced Security	Authentication, encryption, integrity support, and enterprise user security require configuration before using.	Oracle Advanced Security Administrator's Guide
Oracle Enterprise Manager	Two areas require configuration: Oracle Management Server/Repository Configuration Oracle Enterprise Manager Configuration Assistant is a tool that enables you to create, configure, drop, or upgrade your repository. If you installed Oracle Management Server through the Custom installation type or Oracle Management Server installation type of the Oracle Management Infrastructure top-level component, Oracle Enterprise Manager Configuration Assistant automatically started at the end of installation to guide you through repository configuration. If you installed Oracle Management Server through any other installation type, Oracle Enterprise Manager Configuration Assistant did not run automatically. Manually start this tool after installation if a repository needs to be created, configured, upgraded, or dropped. Oracle Enterprise Manager Console Configuration You must perform additional configuration tasks, such as discovering services to manage from the Oracle Enterprise Manager Console, setting up administrator preferred credentials, configuring enhanced notification, and so on.	Oracle Enterprise Manager Configuration Guide for complete configuration instructions for both: Oracle Management Server/Repository Configuration Oracle Enterprise Manager Console Configuration
Oracle interMedia Oracle Spatial Oracle Time Series Oracle Visual Information Retrieval	These components are automatically configured when installed during the same installation as the Oracle8i database. If you installed these components during a separate installation from the Oracle8i database or if you manually copied Oracle7 LISTENER.ORA and TNSNAMES.ORA files into your Oracle8i network directory, manual configuration tasks need to be performed.	Chapter 5, "Post-Installation Configuration Tasks", of Oracle8i Administrator's Guide for Windows NT for procedures
Oracle Parallel Server	Post-configuration procedures must be performed to enable high availability and Oracle Enterprise Manager functionality.	Chapter 6 of the Oracle8i Parallel Server Setup and Configuration Guide
Oracle Services for Microsoft Transaction Server	Configuration must be performed manually. In addition, you must install Microsoft Transaction Server.	Using Microsoft Transaction Server With Oracle8 Your Microsoft documentation
Oracle Windows NT services	The two main Oracle services are automatically started after installation: OracleServiceSID (the Oracle8i database service) OracleHOME_NAMETNSListener (the database listener service) If you installed Oracle Enterprise Manager components, additional services automatically start: OracleHOME_NAMEAgent OracleHOME_NAMEDataGather OracleHOME_NAMEManagementServer However, other services for networking or other individual components may not automatically start.	Chapter 7, "Administering the Database", of the Oracle8i Administrator's Guide for Windows NT for instructions on starting services
PL/SQL External Routines	Configuration is dependent on the network configuration files used.	Chapter 12, "Developing Applications", of Oracle8i Administrator's Guide for Windows NT
Pro*COBOL	Pro*COBOL supports specific compilers.	Chapter 1 of Pro*C/C++ Precompiler Getting Started
SQL*Plus help file	If you want to use online help with SQL*Plus, you must populate the SQL*Plus tables with help files.	SQL*Plus Getting Started for Windows