Release 8.0.6 for Windows NT
A69518-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8 Enterprise Edition Getting Started Release 8.0.6 for Windows NT A69518-01 |
|
This chapter describes post-installation configuration tasks for Oracle8 Enterprise Edition.
Specific topics discussed are:
The configuration tasks that you must perform are determined by the products that you install and the network configuration files that you use. Some products such as Oracle Enterprise Manager must always be manually configured, while the configuration requirements for other products such as Oracle8 cartridges are determined by how you install the product and the network configuration files you use. The following table describes the circumstances under which Oracle products are automatically configured or must be manually configured:
| Did You... | If Yes... | If No... |
|---|---|---|
|
Install the Oracle8 Spatial, Image, Time Series, and Visual Information Retrieval Cartridges during the same installation as Oracle8 Enterprise Edition release 8.0.6? |
Cartridge configuration was automatically performed for you.1 |
You must manually perform cartridge configuration. |
|
Manually copy your Oracle7 TNSNAMES.ORA and LISTENER.ORA files into your Oracle8 network files directory? |
Your TNSNAMES.ORA and LISTENER.ORA network configuration files require several modifications in order for some cartridges to function properly. |
Your network configuration files do not require any modification.
|
|
1
Oracle8 ConText Cartridge must always be manually configured. |
Review the table below and the sections/documents referenced to identify the configuration responsibilities for your products.
Net8 is the Oracle network software that enable applications running on Windows NT and Windows 95 client workstations to access, modify, share, and store data on Oracle8 databases. An easy-to-use network configuration tool, Oracle Net8 Easy Config, enables you to configure Windows NT and Windows 95 clients to communicate with Oracle8 databases. Use Oracle Net8 Easy Config to create and modify server and client configuration files.
|
Additional Information:
See "Oracle Products for Windows NT, Windows 95, and Windows 98" for information on how this product is installed. See also Net8 Getting Started for Windows NT and Windows 95/98 for instructions on using Oracle Net8 Easy Config. |
Before describing how to configure Oracle Enterprise Manager, the key components are briefly described.
Oracle Enterprise Manager works with Oracle Intelligent Agent (installed in the Oracle8 database to be managed) to perform remote database management from a single console computer. Oracle Enterprise Manager is installed on a console computer, a Windows NT or Windows 95 client.
Oracle Intelligent Agent runs on the Oracle8 database to be managed. This Oracle8 database is the one you use for your production work. Oracle Intelligent Agent manages and completes tasks on the Oracle8 database that are requested from the Oracle Enterprise Manager Console computer. Oracle Intelligent Agent:
The Oracle Enterprise Manager Console uses an Oracle8 database as a repository for storing key configuration information. The Oracle8 repository database can be installed on:
The sole responsibility of the repository database is to act as the Oracle Enterprise Manager's storage resource. The Oracle8 repository database is:
Do not create a repository and a production database in the same Oracle8 database. If you do, you will not be able to perform many database administration tasks, such as starting or shutting down the database.
Set up your Oracle Enterprise Manager Console, managed Oracle8 database(s), and Oracle8 repository environment in either of two ways:
Oracle Enterprise Manager setup involves configuring the computers on which your Oracle Enterprise Manager, managed Oracle8 database(s), and Oracle8 repository database are installed. This table describes the tasks that must be performed to configure the two Oracle Enterprise Manager environments illustrated previously and the computers on which to perform these tasks. Each task is then fully described in the sections that follow. Use this table as a reference as you perform your configuration tasks.
| Perform This Task... | On Managed Oracle8 databases? | If Console and Repository are on same computer? | If Console and Repository are on separate computers? |
|---|---|---|---|
|
Yes |
No |
No |
|
|
No |
|
Yes, but only perform this task on the computer on which you create the repository |
|
|
Step 3: Create a Windows NT User Account on Managed Oracle8 Database Server |
Yes |
No |
No |
|
No |
No |
Yes |
|
|
No |
Yes |
Yes, but only perform this task on the computer on which you create the repository |
Ensure that the Oracle8 database services OracleServiceSID, OracleTNSListener80 (or OracleHOME_NAMETNSListener80 if using an Oracle home directory with a home name), and OracleAgent are started. Oracle Intelligent Agent automatically locates the services on the computer where it resides and passes this information to the Oracle Enterprise Manager Console.
To start Oracle Services:
You need to have a user account with database administrator (DBA) privileges set up on the Oracle8 repository database. Oracle Enterprise Manager places the repository in the default tablespace of the user account to which you are connected when creating the repository. Because of this, Oracle Corporation recommends that you create a new user account so that the repository can be created in its own tablespace. It is also recommended that you create a new tablespace and the newly-created user be customized to use this tablespace as their default tablespace.
To create a repository user account on the Oracle8 repository database:
C:\> SVRMGR30
SVRMGR> CONNECT SYSTEM/PASSWORD
where PASSWORD is MANAGER for the SYSTEM user account by default. If you have changed this password, substitute MANAGER with the correct password.
SVRMGR> CREATE TABLESPACE REPOSIT_TABLESPACE DATAFILE 'ORACLE_HOME\DATABASE\DATAFILE' SIZE XM;
where:
SVRMGR> CREATE USER USERNAME IDENTIFIED BY PASSWORD DEFAULT TABLESPACE REPOSIT_TABLESPACE;
SVRMGR> GRANT DBA TO USERNAME;
SVRMGR> EXIT
Exiting Server Manager closes the database connection.
After a repository user account is created, an NT user account must be created on the managed Oracle8 database server.
To create a user account on the managed Oracle8 database server:
The User Manager window appears:
The New User dialog box appears:
The user name and password that you enter here do not need to match those that you created in "Step 2: Create a Repository User Account".
The Group Memberships dialog box appears:
Administrators is added to the Member of list box.
The user is added and the User Manager window reappears.
The User Rights Policy dialog box appears:
If Users does not exist, create it:
The User Manager window reappears.
If Oracle Enterprise Manager is installed on the same computer as the repository database, you do not need to configure your network. If Oracle Enterprise Manager is installed on a Windows 95 or Windows NT client console separate from the computer on which the repository database is installed, you must configure the client computer so it can connect to the Oracle8 repository database:
To create network configuration files:
Before you can use Oracle Enterprise Manager, you need a repository. The repository is a set of base tables in a database that contains status and environment information for your managed databases. A separate repository must be created for each user wanting to use Oracle Enterprise Manager.
The Oracle Enterprise Manager Console workstation must also discover network services, such as databases, listeners, and nodes, to populate the Oracle Enterprise Manager Navigator tree. In addition to discovery, Oracle Enterprise Manager must also be able to manage these services for the Job Scheduling and Event Management systems. This can be achieved with the Discovery Wizard.
When the agent starts up and is explicitly requested by the Oracle Enterprise Manager with the Navigator Discovery feature, the agent passes information from the Oracle Enterprise Manager Console to populate the Navigator tree.
To create a repository:
The Oracle Enterprise Manager Repository Login Information dialog box appears.
The Oracle Repository Manager window appears, prompting you to build the repository:
The repository is built. A dialog box asking if you want a quick tour of Oracle Enterprise Manger appears.
The Discover New Services Wizard appears:
Services are discovered when you see the dialog box below with a status of Discovered:
If the services are not discovered, click Help for troubleshooting hints. The wizard can be restarted by selecting Service Discovery under Navigator in the main menu.
The Oracle Enterprise Manager Console appears:
Configuration is complete. Oracle Enterprise Manager is now available for use.
Oracle8 Spatial Cartridge makes the storage, retrieval, and manipulation of spatial data easier and more intuitive to users. An example of spatial data is a road map. A road map is a 2-dimensional object containing 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 2-dimensional display or piece of paper, preserving the relative positions and relative distances of the objects.
Review the table below to determine your configuration responsibilities:
| If You Installed... | Then... |
|---|---|
|
Oracle8 Spatial Cartridge during the same installation as Oracle8 Enterprise Edition |
No manual configuration is required. All tasks described in "Configuring Oracle8 Spatial Cartridge" were automatically performed. |
|
Oracle8 Spatial Cartridge during a separate installation from Oracle8 Enterprise Edition |
You must manually configure Oracle8 Spatial Cartridge by either:
|
To configure Oracle8 Spatial Cartridge:
C:\> SVRMGR30
SVRMGR> CONNECT SYSTEM/PASSWORD
where PASSWORD is MANAGER for the SYSTEM user account by default. If you have changed this password, substitute MANAGER with the correct password.
SVRMGR> CREATE USER MDSYS IDENTIFIED BY MANAGER;
SVRMGR> GRANT ALL PRIVILEGES TO MDSYS IDENTIFIED BY MANAGER WITH ADMIN OPTION; SVRMGR> ALTER USER MDSYS QUOTA UNLIMITED ON SYSTEM;
SVRMGR> EXIT
C:\> PLUS80W
The Host String field can be left blank as this is a local database connection. This field is for specifying a service name when connecting to a remote database.
SQL> @%ORACLE_HOME%\MD80\ADMIN\CATMD.SQL
This script creates the following:
For information on using Oracle8 Spatial Cartridge, see the Oracle8 Spatial Cartridge User's Guide and Reference.
Oracle8 ConText Cartridge provides search, retrieval, and viewing capabilities for text stored in an Oracle8 database. Oracle8 ConText Cartridge manages textual data in concert with traditional data types in an Oracle8 database. When text is inserted, updated, or deleted, Oracle8 ConText Cartridge automatically manages the change. Oracle8 ConText Cartridge enables text queries to be performed through SQL and PL/SQL from most Oracle interfaces, using tools such as SQL*Plus, Oracle Forms, and Pro*C/C++.
Review the following table to determine your configuration responsibilities.
This section describes how to upgrade from previous releases of ConText to Oracle8 ConText Cartridge release 2.4.6.
The following table lists the release numbers of ConText with the corresponding Oracle Server releases:
| ConText Release | Oracle Server Release |
|---|---|
|
1.1.2 |
7.3.2 |
|
2.0.4 |
7.3.3 |
|
2.0.6 |
8.0.3 |
|
2.3.4 |
7.3.4 |
|
2.3.6 |
8.0.4 |
|
2.4.5 |
8.0.5 |
|
2.4.6 |
8.0.6 |
Follow the instructions appropriate to your situation:
To migrate from release 1.1.2 to release 2.4.6:
C:\> SVRMGR30 SVRMGR> CONNECT SYS/PASSWORD SVRMGR> STARTUP [PFILE=PATH\FILENAME]
where PFILE is the option to specify the full path and file name of an initialization parameter file (INITSID.ORA) that exists in a location other than that for the default INITSID.ORA file.
SVRMGR> EXIT
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
Enter user-name: SYS/PASSWORD
SQL> @SYS20000.SQL;
SQL> CONNECT CTXSYS/PASSWORD;
SQL> @UPG20000.SQL;
SQL> @UPG23600.SQL;
SQL> @UPG24500.SQL;
SQL> @UPG24600.SQL;
SQL> @DR0PACK.SQL;
SQL> @DRGUS.SQL;
SQL> EXIT
C:\ORACLE_HOME\CTX80\ADMIN> START CTXSRV80 -user CTXSYS/PASSWORD -personality DQM
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80 Enter user-name: CTXSYS/PASSWORD SQL> EXEC CTX_DDL.UPGRADE_INDEX(`DOC_POL1');
where DOC_POL1 is the name of the policy of the index to be upgraded.
To upgrade from release 2.0.4 to release 2.4.6:
C:\> SVRMGR30 SVRMGR> CONNECT SYS/PASSWORD SVRMGR> STARTUP [PFILE=PATH\FILENAME]
where PFILE is the option to specify the full path and file name of an initialization parameter file (INITSID.ORA) that exists in a location other than that for the default INITSID.ORA file.
SVRMGR> EXIT
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
Enter user-name: CTXSYS/PASSWORD
SQL> @UPG23600.SQL;
SQL> @UPG24500.SQL;
SQL> @UPG24600.SQL;
SQL> @DR0PACK.SQL;
SQL> @DRGUS.SQL;
SQL> EXIT
C:\ORACLE_HOME\CTX80\ADMIN> START CTXSRV80 -user CTXSYS/PASSWORD -personality DQM
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80 Enter user-name: CTXSYS/PASSWORD SQL> EXEC CTX_DDL.UPGRADE_INDEX(`DOC_POL1');
where DOC_POL1 is the name of the policy of the index to be upgraded.
To upgrade from release 2.0.6 to release 2.4.6:
C:\> SVRMGR30 SVRMGR> CONNECT SYS/PASSWORD SVRMGR> STARTUP [PFILE=PATH\FILENAME]
where PFILE is the option to specify the full path and file name of an initialization parameter file (INITSID.ORA) that exists in a location other than that for the default INITSID.ORA file.
SVRMGR> EXIT
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
Enter user-name: CTXSYS/PASSWORD
SQL> @UPG23600.SQL;
SQL> @UPG24500.SQL;
SQL> @UPG24600.SQL;
SQL> @DR0PACK.SQL;
SQL> @DRGUS.SQL;
SQL> EXIT
C:\ORACLE_HOME\CTX80\ADMIN> START CTXSRV80 -user CTXSYS/PASSWORD -personality DQM
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80 Enter user-name: CTXSYS/PASSWORD SQL> EXEC CTX_DDL.UPGRADE_INDEX(`DOC_POL1');
where DOC_POL1 is the name of the policy of the index to be upgraded.
To upgrade from release 2.3.4 to release 2.4.6:
C:\> SVRMGR30 SVRMGR> CONNECT SYS/PASSWORD SVRMGR> STARTUP [PFILE=PATH\FILENAME]
where PFILE is the option to specify the full path and file name of an initialization parameter file (INITSID.ORA) that exists in a location other than that for the default INITSID.ORA file.
SVRMGR> EXIT
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
Enter user-name: CTXSYS/PASSWORD
SQL> @UPG24500.SQL;
SQL> @UPG24600.SQL;
SQL> @DR0PACK.SQL;
SQL> @DRGUS.SQL;
SQL> EXIT
To upgrade from release 2.3.6 to release 2.4.6:
C:\> SVRMGR30 SVRMGR> CONNECT SYS/PASSWORD SVRMGR> STARTUP [PFILE=PATH\FILENAME]
where PFILE is the option to specify the full path and file name of an initialization parameter file (INITSID.ORA) that exists in a location other than that for the default INITSID.ORA file.
SVRMGR> EXIT
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
Enter user-name: CTXSYS/PASSWORD
SQL> @UPG24500.SQL;
SQL> @UPG24600.SQL;
SQL> @DR0PACK.SQL;
SQL> @DRGUS.SQL;
SQL> EXIT
To upgrade from release 2.4.5 to release 2.4.6:
C:\> SVRMGR30 SVRMGR> CONNECT SYS/PASSWORD SVRMGR> STARTUP [PFILE=PATH\FILENAME]
where PFILE is the option to specify the full path and file name of an initialization parameter file (INITSID.ORA) that exists in a location other than that for the default INITSID.ORA file.
SVRMGR> EXIT
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
Enter user-name: CTXSYS/PASSWORD
SQL> @UPG24600.SQL;
SQL> @DR0PACK.SQL;
SQL> @DRGUS.SQL;
SQL> EXIT
This section describes how to configure Oracle8 ConText Cartridge release 2.4.6 when you do not have a previous release of ConText installed.
To configure Oracle8 ConText Cartridge, the SHARED_POOL_SIZE initialization parameter for your database must be at least 11534336. If the SHARED_POOL_SIZE initialization parameter is less than 11534336, you must increase the parameter.
To increase the SHARED_POOL_SIZE initialization parameter:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> SHUTDOWN
shared_pool_size = 12000000
SVRMGR> STARTUP
SVRMGR> EXIT
To start the OracleConTextService80 Service:
The Control Panel window appears.
The Services window appears.
The following procedure creates the user name CTXSYS with the password CTXSYS, and then creates the ConText data dictionary.
If you select Enable Demo, the procedure also creates the user name CTXDEMO with the password CTXDEMO, and then creates and populates the CTXDEMO.EMP and CTXDEMO.DEPTNO tables.
A message appears showing the progress of the configuration. Note that the configuration can take more than an hour.
C:\> START CTXSRV80 -USER CTXSYS/PASSWORD -PERSONALITY DQL
A message appears indicating that your database has been successfully modified.
Oracle Database Assistant closes.
This section describes how to perform the initial setup required to use the CTXLING, CTXPLUS, and CTXQUERY demos.
The CTXLING and CTXPLUS demos are installed with Oracle8 ConText Cartridge. The CTXQUERY demo is installed with Oracle8 ConText Cartridge Workbench.
If you do not have the CTXDEMO user name, you must create it.
|
Note: If you performed the steps in "Configuring Oracle8 ConText Cartridge" and selected Enable Demo, the CTXDEMO user was created for you. |
To create the CTXDEMO user name:
C:\> PLUS80
Enter user-name: CTXSYS/PASSWORD
SQL> GRANT CONNECT, RESOURCE TO CTXDEMO IDENTIFIED BY PASSWORD; SQL> GRANT CTXAPP TO CTXDEMO;
SQL> EXIT
In this step, you import a dump file, start a ConText server, and then run a SQL script.
To set up the CTXLING, CTXPLUS, and CTXQUERY demos:
The Control Panel window appears.
The Services window appears.
C:\ORACLE_HOME\CTX80\DEMO\INSTALL> IMP80 CTXSYS/PASSWORD FILE=DEMO.DMP IGNORE=Y TABLES=ARTICLES
Importing the DEMO.DMP file:
C:\ORACLE_HOME\CTX80\DEMO\INSTALL> START CTXSRV80 -USER CTXSYS/PASSWORD -PERSONALITY DQL
C:\ORACLE_HOME\CTX80\DEMO\INSTALL> PLUS80
Enter user-name: CTXDEMO/PASSWORD
SQL> @DEMOINST.SQL
This script creates the policies, preferences, views, and results tables used by the demos and creates a text index for the ARTICLES table. The script serves as an example of the tasks that you must perform to set up any table for processing text queries.
Oracle8 ConText Cartridge Workbench consists of administrative tools and application development tools for Oracle8 ConText Cartridge.
Specific topics discussed in this section are:
To upgrade from previous releases of Oracle8 ConText Cartridge Workbench, install the current release of Oracle8 ConText Cartridge Workbench in the same Oracle home directory as the previous release using Oracle Installer. Oracle Installer automatically upgrades all Workbench files to the current release.
Chapter 3 of the Oracle8 ConText Cartridge Workbench User's Guide describes how to configure Oracle8 ConText Cartridge Viewer Cartridge.
Chapter 2 of the Oracle8 ConText Cartridge Workbench User's Guide describes how to configure Oracle8 ConText Cartridge Configuration Manager.
"Configuring the CTXLING, CTXPLUS, and CTXQUERY Demos" describes how to configure the CTXQUERY demo.
Oracle8 Image Cartridge provides image storage, retrieval, and format conversion capabilities through an object data type (ODT). Oracle8 Image Cartridge supports image storage using Binary Large Objects (BLOBS) and references to image data residing in external files (BFILEs).
Review the table below to determine your configuration responsibilities:
| If You... | Then... |
|---|---|
|
Installed Oracle8 Image Cartridge during the same installation as Oracle8 Enterprise Edition |
No manual configuration is required. All tasks described in "Configuring Oracle8 Image Cartridge" were automatically performed. |
|
Installed Oracle8 Image Cartridge during a separate installation from Oracle8 Enterprise Edition |
You must manually configure Oracle8 Image Cartridge by either:
|
|
Want to use the demos |
You must manually configure Oracle8 Image Cartridge Demos by either:
|
|
Manually copied your Oracle7 LISTENER.ORA and TNSNAMES.ORA files into your Oracle8 network directory |
You must modify the TNSNAMES.ORA and LISTENER.ORA network configuration files on your server to enable external procedure calls to work and Oracle8 Image Cartridge to function properly. Follow the tasks in "Configuring External Procedure Calls" in Chapter 8 of Net8 Getting Started for Windows NT and Windows 95. |
|
Want to use Oracle8 Visual Information Retrieval Cartridge with Oracle8 Image Cartridge |
Install Oracle8 Image Cartridge first. If you selected both cartridges for installation in the Select Cartridges and Options dialog box, Oracle8 Image Cartridge was installed first. |
|
Want to build the Oracle8 Image Cartridge sample application |
Install a C compiler. |
|
Did not install Oracle8 Objects Option |
Install Oracle8 Objects Option, which is required for Oracle8 Image Cartridge to function properly. |
|
Want multi-threaded external callout functionality |
Perform the tasks in "Step 6: Enabling Multi-threaded Callout Support". |
To configure Oracle8 Image Cartridge:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> STARTUP
SVRMGR> @%ORACLE_HOME%\ORD80\IMG\ADMIN\ORDIINST.SQL
Password: PASSWORD
SVRMGR> EXIT
Oracle8 Image Cartridge Demos provide a sample demonstration showing how an image is extracted from an Oracle8 database.
To configure Oracle8 Image Cartridge Demos:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> @%ORACLE_HOME%\ORD80\IMG\DEMO\IMGDEMO.SQL
Password: PASSWORD
SVRMGR> EXIT
C:> CD ORACLE_HOME\ORD80\IMG\DEMO
| If Using a... | Then Enter... |
|---|---|
|
Microsoft C compiler |
MAKE |
|
Borland C compiler |
BMAKE |
Oracle8 Time Series Cartridge stores and retrieves timestamped data through object data types (ODTs). Oracle8 Time Series Cartridge is a building block for applications, rather than being an end-user application. For example, applications can use this cartridge to process historical data derived from financial market transactions, such as trades of stocks, bonds, and mutual fund shares. From this you can find the opening, closing, low, and high prices for a stock on a specific date; calculate monthly volumes for a stock for a specific year; and derive the 30-day moving average for a stock over a year.
Review the table below to determine your configuration responsibilities:
| If You... | Then... |
|---|---|
|
Installed Oracle8 Time Series Cartridge during the same installation as Oracle8 Enterprise Edition |
No manual configuration is required. All tasks described in "Configuring Oracle8 Time Series Cartridge" were automatically performed. |
|
Installed Oracle8 Time Series Cartridge during a separate installation from Oracle8 Enterprise Edition |
You must manually configure Oracle8 Time Series Cartridge by either:
|
|
Want to use the demos |
Perform the tasks in "Configuring Oracle8 Time Series Cartridge Demos". |
|
Manually copied your Oracle7 LISTENER.ORA and TNSNAMES.ORA files into your Oracle8 network directory |
You must modify the TNSNAMES.ORA and LISTENER.ORA network configuration files on your server to enable external procedure calls to work and Oracle8 Time Series Cartridge to function properly. Follow the tasks in "Configuring External Procedure Calls" in Chapter 8 of Net8 Getting Started for Windows NT and Windows 95. |
|
Did not install Oracle8 Objects Option |
Install Oracle8 Objects Option, which is required for Oracle8 Time Series Cartridge to function properly. |
|
Want multi-threaded external callout functionality |
Perform the tasks in "Step 6: Enabling Multi-threaded Callout Support". |
To configure Oracle8 Time Series Cartridge:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> CREATE USER ORDSYS IDENTIFIED BY ORDSYS;
SVRMGR> GRANT CONNECT,RESOURCE,CREATE LIBRARY TO ORDSYS; SVRMGR> GRANT GRANT ANY PRIVILEGE TO ORDSYS;
SVRMGR> CONNECT ORDSYS/PASSWORD
SVRMGR> @%ORACLE_HOME%\ORD80\TS\ADMIN\ORDTINST.SQL
This script:
SVRMGR> EXIT
Five Oracle8 Time Series Cartridge Demos are provided:
To configure Oracle8 Time Series Cartridge Demos:
Oracle Visual Information Retrieval Cartridge stores, retrieves, and manipulates image data managed by an Oracle8 database. This cartridge supports image storage using BLOBS and references to image data residing in external files (BFILEs). This cartridge is a building block for various imaging applications, rather than being an end-user application. Some example applications for this cartridge are digital art galleries and museums, real estate marketing, document imaging, and stock photo collections (such as for fashion designers and architects).
Review the table below to determine your configuration responsibilities:
| If You... | Then... |
|---|---|
|
Installed Oracle8 Visual Information Retrieval Cartridge during the same installation as Oracle8 Enterprise Edition |
No manual configuration is required. All tasks described in "Configuring Oracle8 Visual Information Retrieval Cartridge" were automatically performed. |
|
Installed Oracle8 Visual Information Retrieval Cartridge during a separate installation from Oracle8 Enterprise Edition |
You must manually configure Oracle8 Visual Information Retrieval by either:
|
|
Want to use the demos |
Perform the tasks in "Configuring Oracle8 Visual Information Retrieval Cartridge Demos". |
|
Want to build an Oracle8 Visual Information Retrieval Cartridge sample application. |
Install a C compiler. |
|
Manually copied your Oracle7 LISTENER.ORA and TNSNAMES.ORA files into your Oracle8 network directory |
You must modify the TNSNAMES.ORA and LISTENER.ORA network configuration files on your server to enable external procedure calls to work and Oracle8 Visual Information Retrieval Cartridge to function properly. Follow the tasks in "Configuring External Procedure Calls" in Chapter 8 of Net8 Getting Started for Windows NT and Windows 95. |
|
Did not install Oracle8 Objects Option |
Install Oracle8 Objects Option, which is required for Oracle8 Visual Information Retrieval Cartridge to function properly. |
|
Want multi-threaded external callout functionality |
Perform the tasks in "Step 6: Enabling Multi-threaded Callout Support". |
To configure Oracle8 Visual Information Retrieval Cartridge:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> @%ORACLE_HOME%\ORD80\VIR\DEMO\ORDRINST.SQL
Password: PASSWORD
SVRMGR> EXIT
Oracle8 Visual Information Retrieval Cartridge Demos provide a sample demonstration showing how an image is extracted from an Oracle8 database.
To configure Oracle8 Visual Information Retrieval Cartridge Demos:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> @%ORACLE_HOME%\ORD80\VIR\ADMIN\VIRDEMO.SQL
Password: PASSWORD
SVRMGR> EXIT
CD ORACLE_HOME\ORD80\VIR\DEMO
| If Using a... | Then Enter... |
|---|---|
|
Microsoft C compiler |
MAKE |
|
Borland C compiler |
BMAKE |
Review the table below to determine your configuration responsibilities:
| If You... | Then... |
|---|---|
|
Selected:
|
All configuration tasks described in "Configuring Advanced Replication Support" were automatically performed. No manual configuration is required. |
|
Want to add replication support to a previously installed Oracle8 Enterprise Edition |
You must manually configure Advanced Replication support by following the procedures in "Configuring Advanced Replication Support". |
Follow the procedures described below:
See Oracle8 Enterprise Edition Installation for Windows NT for Advanced Replication installation requirements.
The following are recommended tablespace requirements for Advanced Replication:
Certain initialization parameter values must be set or added to the INITSID.ORA file (recommended values are included) if you use Advanced Replication.
Add these initialization parameters to the master site:
Add these initialization parameters for snapshot sites:
| Parameter Name | Recommended Value |
|---|---|
|
JOB_QUEUE_PROCESSES |
2 |
|
JOB_QUEUE_INTERVAL |
60 seconds |
After setting up the INITSID.ORA file with the initialization parameters for Advanced Replication, perform the following steps:
To configure Advanced Replication:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> STARTUP
The script is found in the ORACLE_HOME\RDBMS80\ADMIN directory. It takes approximately one hour to run. Spool output to a log file first before running CATREP8M.SQL.
SVRMGR> SPOOL OUTPUT.LOG
This creates a file called OUTPUT.LOG to which to output all on-screen activity while the SPOOL session is open.
SVRMGR> @%RDBMS80%\ADMIN\CATREP8M.SQL
SVRMGR> SPOOL OFF
OUTPUT.LOG is saved to your current directory.
SVRMGR> SELECT * FROM ALL_OBJECTS WHERE STATUS = 'INVALID';
If all package bodies compiled successfully, the following message displays:
0 rows selected.
If you find that any of the package bodies compiled incorrectly, recompile them manually. The syntax for running them manually is:
SVRMGR> ALTER PACKAGE PACKAGE NAME COMPILE BODY;
If CATREP8M.SQL ran successfully, a number of replication tables are created in the SYSTEM subdirectory. The database is now set up for Advanced Replication support.
SVRMGR> EXIT
The practical limit to the number of master sites an environment can have is 36. The processes SNP0 to SNP9 (total of 10) and SNPA to SNPZ (total of 26) each handle one destination master at a time.
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:
|
SOURCE$ |
I_ARGUMENT1 |
|
IDL_UB1$ |
IDL_SB4$ |
|
IDL_UB2$ |
IDL_CHAR$ |
|
I_SOURCE1I$ |
TRIGGER$ |
|
ARGUMENT$ |
|
If necessary, increase the storage parameters to accommodate the storage requirements of large numbers of replicated objects.
If you are upgrading from a previous version of the Oracle8 database and want to use Advanced Replication, you must first complete the upgrade (see Chapter 7, "Installing, Migrating, and Upgrading Databases" in this guide). After upgrading, Advanced Replication is automatically installed with the Oracle8 database during Release 8.0 installation (see Oracle8 Enterprise Edition Installation for Windows NT).
Advanced Replication is an advanced feature. Please consult your Oracle8 Replication documentation for concepts and details before proceeding. For additional information, contact Oracle Education.
|
 Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|
