Oracle9i Database Administrator's Guide Release 1 (9.0.1) for Windows Part Number A90164-01 |
|
This chapter describes some of the configuration tasks you must perform before using Oracle interMedia and other Oracle options. Where appropriate, the chapter provides references to other guides for those configuration tasks.
This chapter contains these topics:
The directory path examples in this chapter follow Optimal Flexible Architecture (OFA) guidelines (for example,
Note:
ORACLE_BASE\ORACLE_HOME
\rdbms\admin
). If you specified non-OFA compliant directories during installation, your directory paths will differ. See Multiple Oracle Homes and Optimal Flexible Architecture in the Oracle9i Database Getting Started for Windows for more information.
This section describes the components of Oracle interMedia.
Oracle interMedia Audio manages audio data in multiple file formats in an 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.
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.
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 an Oracle database.
Oracle interMedia Locator enables Oracle9i to support online internet-based geocoding facilities for locator applications and proximity queries.
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 an Oracle database.
Oracle Text manages textual data in concert with traditional data types in an Oracle database. When text is inserted, updated, or deleted, Oracle Text automatically manages the change.
Review Table 2-1 to determine how to configure Oracle interMedia Audio, Video, Image, and Locator.
If You... | Then... |
---|---|
Installed the Oracle9i Enterprise Edition Typical installation |
No manual configuration is required. All tasks described in "Configuring Oracle interMedia Audio, Video, Image, and Locator" are automatically performed. |
Installed the Oracle9i Enterprise Edition |
Oracle Database Configuration Assistant starts at the end of installation. If you select the following option: |
Manually copy your Oracle8i |
You must modify the |
Want to use the demos |
Perform the tasks described for the configuration of the Oracle interMedia sample demos below. |
Want to build the Oracle interMedia Image sample demonstration |
Install a C compiler. |
To configure Oracle interMedia Audio, Video, Image, and Locator:
C:\> SQLPLUS / NOLOG
SYS
account:
SQL> CONNECT SYS/password
AS SYSDBA
SQL> STARTUP
ordinst.sql
script:
SQL> @
ORACLE_BASE\ORACLE_HOME
\ord\admin\ordinst.sql
iminst.sql
script:
SQL> @
ORACLE_BASE\ORACLE_HOME
\ord\im\admin\iminst.sql
SQL> EXIT
To configure Oracle interMedia Audio demos:
ORACLE_BASE\ORACLE_HOME
\ord\aud\demo
directory.
readme.txt
file.
To configure Oracle interMedia Video demonstrations:
ORACLE_BASE\ORACLE_HOME
\ord\vid\demo
directory.
readme.txt
file.
To configure Oracle interMedia Image demonstrations:
ORACLE_BASE\ORACLE_HOME
\ord\img\admin
directory.
readme
file in this directory for instructions on configuring the demo.
C:\> make
An additional demonstration resides in the following location:
ORACLE_BASE\ORACLE_HOME
\ord\img\demo\vc\imgsamp\simpimg
In order to build and run the demonstration, you must first modify the MAKEFILE to adapt it to your environment.
To configure Oracle interMedia Locator demonstrations:
ORACLE_BASE\ORACLE_HOME
\md\demo\geocoder
directory.
nh_cs.sql
file contains the sample data that can be loaded into Oracle9i. geohttp.sql
and geolocat.sql
are examples that show the use of Locator functionality. geoindex.sql
contains examples of data indexes created by using the Locator.
Review Table 2-2 to determine your Oracle Text postinstallation tasks.
If You... | Then... |
---|---|
Installed Oracle Text from the CD-ROM, and you do not have a previous release of Oracle Text (formerly called interMedia Text) installed |
See the description below this table. |
Installed Oracle Text from the CD-ROM, and you do have a previous release of Oracle Text (formerly called interMedia Text) installed |
|
Migrated your database, you may need to configure Oracle Net for external routines. Otherwise, Oracle Text may not work. In any case other than migration, Oracle Net should be configured correctly by default to work with Oracle Text. |
See Oracle Text Application Developer's Guide and Oracle Text Reference. |
Are indexing formatted documents such as Microsoft Word |
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. |
If one of the following is true, the Oracle9i database is already configured for use with Oracle Text:
See Chapter 1, "Postinstallation Database Creation" and the Oracle9i Database installation guide for Windows for more information about creating a starter database.
See Also:
If none of these are true, you must configure the Oracle database for use with Oracle Text by doing one of the following:
You can use Oracle Database Configuration Assistant to configure an Oracle9i database for use with Oracle Text at the time you create the database or later. Table 2-3 describes how to configure an Oracle9i database
To configure... | Do this... |
---|---|
At a later time |
Manually configuring an Oracle database for use with Oracle Text consists of creating a tablespace for the Oracle Text data dictionary tables and then creating the ctxsys
username and the Oracle Text data dictionary tables themselves.
To create a tablespace for the Oracle Text data dictionary tables:
C:\> sqlplus / nolog
SYS
:
Enter user-name: SYS/password
AS SYSDBA
SQL> CREATE TABLESPACE
tablespace_name
DATAFILE 'ORACLE_BASE
\oradata\
db_name
\dr01.dbf' SIZE 80m;
To create the ctxsys
username and the Oracle Text data dictionary tables:
AS
SYSDBA
:
SQL
> CONNECT USERNAME/PASSWORD
AS SYSDBA
dr0csys.sql
script to create the ctxsys
username:
SQL
> @ORACLE_BASE\ORACLE_HOME\
ctx\admin\dr0csys.sql
password
default_tablespace_name temporary_tablespace_name;
where:
password
is the password that you want to use for the ctxsys
username.
default_tablespace_name
is the default tablespace for the Oracle Text data dictionary tables. Set the default tablespace to the value of tablespace_name
in step 3 of the instructions "To create a tablespace for the Oracle Text data dictionary tables:".
temporary_tablespace_name
is the temporary tablespace for the Oracle Text data dictionary tables. Set the temporary tablespace to the value of tablespace_name
in step 3 of the instructions "To create a tablespace for the Oracle Text data dictionary tables:".
ctxsys
:
SQL> CONNECT ctxsys
/password
dr0inst.sql
script to create and populate the Oracle Text data dictionary tables:
SQL> @
ORACLE_BASE\ORACLE_HOME
\bin\oractxx9.dll;
xx
is the language code (for example, us
):
SQL> @
ORACLE_BASE\ORACLE_HOME
\ctx\admin\defaults\drdef
xx
.sql
;
SQL
> EXIT
Oracle Spatial makes the 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. The locations of cities, roads, and political boundaries are projected onto a two-dimensional display or piece of paper, preserving the relative positions and relative distances of the objects.
Review Table 2-4 to determine your configuration responsibilities:
If You... | Then... |
---|---|
Installed Oracle Spatial through the Oracle9i Enterprise Edition |
No manual configuration is required. All Oracle Spatial configuration tasks described under "Configuring Oracle Spatial" are automatically performed. |
Installed both Oracle Spatial and Oracle9i Server together through the Oracle9i Enterprise Edition or Oracle9i Standard Edition Custom installation |
Oracle Database Configuration Assistant starts at the end of installation. If you select the following: Oracle Database Configuration Assistant prompts you about whether or not you want Oracle Spatial to be automatically configured. |
Installed Oracle Spatial during a separate installation from Oracle9i Enterprise Edition |
You must manually configure Oracle Spatial by either:
|
C:\> sqlplus / nolog
SYSDBA
account:
Enter user-name: SYS/password
AS SYSDBA
SQL> STARTUP
ordinst.sql
script:
SQL> @
ORACLE_BASE\ORACLE_HOME\
ord\admin\ordinst.sql
SYSTEM
user:
SQL> CONNECT SYSTEM
/password
mdinst.sql
script:
SQL> @
ORACLE_BASE\ORACLE_HOME
\md\admin\mdinst.sql
SQL> EXIT
Oracle Database Configuration Assistant lets you enable or disable shared server support in your Oracle9i database.
If your Oracle9i database is not configured for shared server mode, then it is configured for dedicated server mode.
Table 2-5 describes the differences between dedicated server mode and shared server mode.
See Also:
Oracle9i Net Services Administrator's Guide for more information about the shared server mode |
There are two types of shared server support:
These types are independent of each other. In other words, you can have any of the following combinations:
Table 2-6 describes how the current configuration of your Oracle9i database depends on how the database was installed.
Shared server support for IIOP clients is automatically enabled when you install Oracle9i JVM.
Shared server support for two-task Oracle Net clients must be enabled manually.
To enable shared server support for two-task Oracle Net clients:
The Oracle Database Configuration Assistant Welcome page appears. Choose Next.
SYSDBA
password.
A dialog box prompts you to select the initialization parameter file to use.
Your initialization parameter file is modified.
Shared server support for two-task Oracle Net clients must be disabled manually.
To disable shared server support for two-task Oracle Net clients:
The Oracle Database Configuration Assistant Welcome page appears.
A dialog box prompts you to select the initialization parameter file to use.
Your initialization parameter file is modified.
Oracle9i installs the replication packages and procedures automatically rather than as a separate manual process. This section describes how to manually configure Advanced Replication in your Oracle9i database.
Follow the instructions only if you want to add Advanced Replication to an Oracle9i database that was not previously configured with this feature.
Configuring Advanced Replication consists of the following steps:
The following are recommended tablespace and rollback segment requirements for Advanced Replication:
Certain initialization parameter values must be set or added to the init.ora
file (recommended values are included) if you use Advanced Replication.
Add these initialization parameters to the master site.
Add this initialization parameter for materialized view sites.
Parameter Name | Recommended Value |
---|---|
|
2 |
If you use Advanced Replication and intend to set up a large number of replicated objects, monitor the following data dictionary tables with the SQL SELECT
command:
If necessary, increase the storage parameters to accommodate the storage requirements of large numbers of replicated objects.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|