4 Postinstallation Configuration Tasks on Windows

4.1 Resetting Passwords for Default Accounts

Oracle Database installs with a number of default accounts. Database Configuration Assistant locks and expires most default database accounts upon successful installation. Oracle recommends changing all user passwords immediately after installation.

4.2 NTFS File System and Windows Registry Permissions

Oracle recommends that you configure Oracle Database files, directories, and registry settings to allow only authorized database administrators (DBAs) to have full control. If you created a database using Database Configuration Assistant or upgraded a database using Oracle Database Upgrade Assistant, then no further action is required.

This section describes the permissions automatically set by Oracle Universal Installer, Database Configuration Assistant, and Oracle Database Upgrade Assistant and the steps to set these permissions manually.

This section contains these topics:

• File Permissions

• Setting NTFS File System Security

• Setting Windows Registry Security

  
  

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

4.3 Configuring External Job Support for the Scheduler on Windows

This release includes a new database scheduler to provide enterprise scheduling functionality. External jobs performed by the user are started using the OracleJobScheduler service. This service is disabled by default. In order to use the external jobs functionality, the administrator must set the username and password for the user account under which this service must run and enable the service.

Restricting execution of external jobs to a low-privileged user prevents unauthorized database users from gaining operating system level privileges, but it also places restrictions on the kinds of jobs that can be run. Jobs requiring a higher level of operating system privileges cannot be run by this mechanism.

4.4 Oracle interMedia on Windows

Performance related components of Oracle interMedia are now packaged on the Companion CD. Although interMedia functions properly without the Companion CD, the following components must be installed from the Companion CD in order to achieve acceptable performance of image processing:

• JAccelerator (NCOMP)

• Oracle interMedia Image Accelerator

Oracle interMedia includes the following components.

Client

Oracle interMedia Client provides an Oracle Database interMedia Audio, Image, and Video Java interface that lets you use local (client-side) applications to manipulate or modify multimedia data stored in a network-accessible (server-side) database. To use the Java library, set environment variable CLASSPATH so that it contains the Oracle interMedia library.

Client also provides a simple interMedia Image sample (SimpImg.exe) that was developed using Microsoft Visual C++. SimpImg.exe locates and updates images, using interMedia Image in Oracle Database.

Audio

Oracle interMedia Audio manages audio data in multiple file formats in Oracle Database. Types of audio data supported include conversations, songs, and other sounds in popular audio file formats. This makes it possible to integrate audio data with other application-specific object-relational data.

Video

Oracle interMedia Video manages video data in multiple video file formats. This makes it possible to integrate video data with other application-specific object-relational data.

Image

Oracle interMedia Image provides image storage, retrieval, and format conversion capabilities through an object data type (ODT). It also supports image storage, using Binary Large Objects (BLOBs), and references to image data residing in external files (BFILEs).

The Image component of Oracle interMedia also comes with a sample demonstration that shows how an image is extracted from Oracle Database.

Locator

Oracle interMedia Locator enables Oracle Database to support online internet-based geocoding facilities for locator applications and proximity queries.

ORACLE_BASE\ORACLE_HOME\md\demo\geocoder

4.5 Configuring Oracle Text on Windows

Oracle Text enables text queries through SQL and PL/SQL from most Oracle interfaces. By installing Oracle Text with an Oracle Database server, client tools such as SQL*Plus, Oracle Forms, and Pro*C/C++ are able to retrieve and manipulate text in Oracle Database.

Oracle Text manages textual data in concert with traditional data types in Oracle Database. When text is inserted, updated, or deleted, Oracle Text automatically manages the change.

Your Oracle Text postinstallation tasks depend on your situation.

If you install Oracle Text from the CD-ROM and have a previous release of Oracle Text (formerly called interMedia Text) already installed, then see Oracle Text Application Developer's Guide.

If you upgrade your database, then you may be required to configure Oracle Net for external procedures. Otherwise, Oracle Text may not work. In any case other than upgrade, Oracle Net will be configured correctly by default to work with Oracle Text. See Oracle Text Application Developer's Guide and Oracle Text Reference.

If you are indexing formatted documents such as Microsoft Word, then you must set your environment to use the Inso filter before you can index your documentation set. For more information on setting up your environment for Inso filtering, see Oracle Text Reference.

Finally, if you install Oracle Text from the CD-ROM and do not have a previous release of Oracle Text installed, then Oracle Database is already configured for use with Oracle Text if one of the following is true:

• You created the database by using Database Configuration Assistant in standalone mode, and selected Typical database creation type.

• The database is a starter database that you created by performing the following sequence of steps:

  1. Select Oracle Database in the Available Products window.

  2. Select Enterprise Edition, Standard Edition, or Personal Edition in the Installation Types window.

  3. Select General Purpose in the Database Configuration window.

     
     

     See Also: For more information about creating a starter database Chapter 3, "Postinstallation Database Creation on Windows" Oracle Database Installation Guide for Windows

If none of these is true, then you must configure Oracle Database for use with Oracle Text by doing one of the following:

• Configuring Oracle Text Using Database Configuration Assistant

• Configuring Oracle Text Using Command-Line Tools

Configuring Oracle Text Using Database Configuration Assistant

To use Database Configuration Assistant to configure Oracle Database for use with Oracle Text at the time you create the database, simply select Oracle Text as the option to configure when prompted.

To configure the database at a later time:

1. Start Database Configuration Assistant.

   Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Configuration Assistant.

2. Select Configure database options in a database.

3. Select the database to modify when prompted.

4. Select Oracle Text as the option to configure when prompted.

Configuring Oracle Text Using Command-Line Tools

Manually configuring Oracle Database for use with Oracle Text consists of creating a tablespace for Oracle Text data dictionary tables and then creating username ctxsys and Oracle Text data dictionary tables.

1. Start SQL*Plus:

   C:\> sqlplus /NOLOG
   
   

2. Connect to Oracle Database with account SYSDBA:

   SQL: CONNECT / AS SYSDBA
   
   

3. Create a tablespace for Oracle Text data dictionary tables:

   SQL> CREATE TABLESPACE tablespace_name DATAFILE 'ORACLE_BASE\oradata\db_name\drsys01.dbf' SIZE 80m;
   
   

4. Connect AS SYSDBA:

   SQL> CONNECT USERNAME/PASSWORD AS SYSDBA
   
   

5. Run script dr0csys.sql to create username ctxsys:

   SQL> @ORACLE_BASE\ORACLE_HOME\ctx\admin\dr0csys.sql password default_tablespace_name temporary_tablespace_name;
   
   

   where:

   • password is the password that you intend to use for username ctxsys.

   • default_tablespace_name is the default tablespace for Oracle Text data dictionary tables. Set the default tablespace to the value of tablespace_name in step 3.

   • temporary_tablespace_name is the temporary tablespace for Oracle Text data dictionary tables. Set the temporary tablespace to the value of tablespace_name in step 3.

6. Connect as ctxsys:

   SQL> CONNECT ctxsys/password
   
   

7. Run script dr0inst.sql to create and populate Oracle Text data dictionary tables:

   SQL> @ORACLE_BASE\ORACLE_HOME\bin\dr0inst.sql;
   
   

8. Run the language-specific default script, where xx is the language code (for example, us):

   SQL> @ORACLE_BASE\ORACLE_HOME\ctx\admin\defaults\drdefxx.sql;
   
   

9. Exit SQL*Plus:

   SQL> EXIT
   

4.6 Configuring Oracle Spatial on Windows

Oracle Spatial makes storage, retrieval, and manipulation of spatial data easier and more intuitive to users.

One example of spatial data is a road map. A road map is a two-dimensional object that contains points, lines, and polygons representing cities, roads, and political boundaries such as states. A road map represents geographic information. Locations of cities, roads, and political boundaries are projected onto a two-dimensional display or piece of paper, preserving relative positions and relative distances of objects.

If you install Oracle Spatial through Enterprise Edition, then no manual configuration is required. All Oracle Spatial configuration tasks are performed automatically.

If you install both Oracle Spatial and Oracle Database together through Enterprise Edition or Standard Edition Custom installation, then Database Configuration Assistant starts automatically at the end of installation. If you choose Custom installation and select Create new database, then the assistant asks if Oracle Spatial is to be configured automatically.

If you install Oracle Spatial during a separate installation from Enterprise Edition, then you must either start Database Configuration Assistant and select Configure database options in a database or configure Oracle Spatial manually.

To configure Oracle Spatial manually:

1. Start SQL*Plus at the command prompt:

   C:\> sqlplus /NOLOG
   
   

2. Connect to Oracle Database with account SYSDBA:

   SQL> CONNECT / AS SYSDBA
   
   

3. Start the database (if necessary):

   SQL> STARTUP
   
   

4. Run script ordinst.sql:

   SQL> @ORACLE_BASE\ORACLE_HOME\ord\admin\ordinst.sql
   
   

5. Connect to the database as user SYSTEM:

   SQL> CONNECT SYSTEM/password
   
   

6. Run script mdinst.sql:

   SQL> @ORACLE_BASE\ORACLE_HOME\md\admin\mdinst.sql
   
   

7. Exit SQL*Plus:

   SQL> EXIT
   

   
   

   Note: Script mdinst.sql has a variable %MD_SYS_PASSWORD% that Oracle Universal Installer will instantiate at installation time. Therefore, if you have changed the mdsys user's password, then be sure during a manual installation to remember also to update script mdinst.sql with that password.

4.7 Configuring Advanced Replication on Windows

Oracle Database installs replication packages and procedures automatically rather than as a separate manual process. There are many configuration and usage possibilities with Advanced Replication.

This section describes how to manually configure Advanced Replication in Oracle Database. Follow the instructions only if you add Advanced Replication to an installation of Oracle Database that was not previously configured with this feature.

Configuring Advanced Replication consists of the following steps:

• Checking Tablespace and Rollback Segment Requirements

• Adding and Modifying Initialization Parameters

• Monitoring Data Dictionary Tables