Oracle8 Enterprise Edition Getting Started 
Release 8.0.5 for Windows NT 
A64416-01
 
Library
 
Product
 
Contents
 
Index
 

Prev Next

8
Post-Installation Configuration Tasks

This chapter describes post-installation configuration tasks for Oracle8 Enterprise Edition.

Specific topics discussed are:

What Must You Configure?

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.5? 

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.

Product  Is Configuration Automatic?  See the Following for Instructions... 

Net8 network software 

For server configuration files, configuration is usually automatic. For client configuration files, configuration must typically be manually performed (unless you use the Host Adapter). 

"Net8" of this chapter 

Oracle Enterprise Manager 

No. 

"Oracle Enterprise Manager" of this chapter 

Oracle8 Options 

 

 

  • Oracle Parallel Server 
 

No. 

Oracle Parallel Server Getting Started for Windows NT 

  • Oracle8 Objects 
 

Yes. 

No manual configuration is required 

  • Oracle8 Partitioning 
 

Yes. 

No manual configuration is required 

PL/SQL External Procedures 

Depends upon network configuration files used. 

"Building External Procedures" of Chapter 15, "Developing Applications" 

Oracle8 Cartridges: 

 

 

  • Oracle8 Spatial 
 

Depends upon how product was installed. 

"Oracle8 Spatial Cartridge" of this chapter 

  • Oracle8 ConText (and Workbench) 
 

No. 

"Oracle8 ConText Cartridge" of this chapter 

  • Oracle8 Image 
 

Depends upon how product was installed and network configuration files used. 

"Oracle8 Image Cartridge" of this chapter 

  • Oracle8 Time Series 
 

Depends upon how product was installed and network configuration files used. 

"Oracle8 Time Series Cartridge" of this chapter 

  • Oracle8 Visual Information Retrieval 
 

Depends upon how product was installed and network configuration files used. 

"Oracle8 Visual Information Retrieval Cartridge" of this chapter 

Advanced Replication Support 

Depends upon how support was installed. 

"Advanced Replication" of this chapter 

Multi-threaded External Callouts 

No. 

"Step 6: Enabling Multi-threaded Callout Support" of Chapter 15, "Developing Applications" 

 

Net8

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" in Chapter 2, "Introducing Oracle8 Enterprise Edition" 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. 

 
 

Oracle Enterprise Manager

Before describing how to configure Oracle Enterprise Manager, the key components are briefly described.

Oracle Enterprise Manager Console

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 and Managed Oracle8 Databases

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:

Oracle8 Repository Database

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? 

Step 1: Start Oracle Services on Managed Oracle8 Database 

Yes 

No 

No 

Step 2: Create a Repository User Account 

No 

Yes  

 

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 

Step 4: Create Network Configuration Files 

No 

No 

Yes 

Step 5: Create the Repository and Discover Services 

No 

Yes 

Yes, but only perform this task on the computer on which you create the repository 

 

Step 1: Start Oracle Services on Managed Oracle8 Database

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:

  1. Go to the Oracle8 database to be managed.
  2. Start the Oracle services listed above in either of two ways:
  3. Continue to "Step 2: Create a Repository User Account".

  4. Note:  

    Oracle Intelligent Agent automatically creates SNMP_RO and SNMP_RW. These are used instead of the SNMP.ORA file of some previous releases. If you want to use an SNMP.ORA file that you configured with a previous release instead of SNMP_RO and SNMP_RW, set the following line to TRUE in the SNMP.ORA file.  

    nmi.register_with_names=true  

    If you set this line to FALSE, Oracle Intelligent Agent uses SNMP_RO and SNMP_RW. 


     
     

Step 2: Create a Repository User Account

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:

  1. Go to the computer on which the Oracle8 database that will become your repository is installed.
  2. Start Server Manager:
  3. C:\> SVRMGR30
  4. Connect to the Oracle8 repository database:
  5. 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.

  6. Create a special tablespace for the Oracle Enterprise Manager repository:
  7. SVRMGR> CREATE TABLESPACE REPOSIT_TABLESPACE DATAFILE                  
    
    'ORACLE_HOME\DATABASE\DATAFILE' SIZE XM;

    where:

  8. Create a user account and password where the user's default tablespace is the one created in step 4:
  9. SVRMGR> CREATE USER USERNAME IDENTIFIED BY PASSWORD DEFAULT TABLESPACE 
    REPOSIT_TABLESPACE;
  10. Grant the SYSTEM privileges to this user account:
  11. SVRMGR> GRANT DBA TO USERNAME;
  12. Exit Server Manager:
  13. SVRMGR> EXIT

    Exiting Server Manager closes the database connection.

  14. Follow Steps 3-6 for additional repository user accounts.
  15. Continue to "Step 3: Create a Windows NT User Account on Managed Oracle8 Database Server".

Step 3: Create a Windows NT User Account on Managed Oracle8 Database Server

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:

  1. Go to the Oracle8 database to be managed.
  2. Choose Start > Programs > Administrative Tools > User Manager.
  3. The User Manager window appears:

  4. Choose New User from the User menu.
  5. The New User dialog box appears:

  6. Enter the appropriate information in the dialog box:
    1. Enter a user name in the Username field.
    2. Enter the same password in both the Password and Confirm Password fields.
    3. 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".

    4. Make sure the User Must Change Password at Next Logon check box is not checked and Password Never Expires check box is checked.
    5. Make the user a member of the Administrator's group by clicking Groups.
    6. The Group Memberships dialog box appears:

    7. Select Administrators from the Not member of list box and click <- Add.
    8. Administrators is added to the Member of list box.

    9. Click OK to close the Group Memberships dialog box and return to the New User dialog box.
  7. Click OK in the New User dialog box to accept the user information.
  8. The user is added and the User Manager window reappears.

  9. Select the newly created user and choose User Rights from the Policies menu.
  10. The User Rights Policy dialog box appears:

  11. Click the Show Advanced User Rights check box and select Log on as a batch job from the Right drop-down list box.
  12. Select Users from the Grant To list box.
  13. If Users does not exist, create it:

    1. Click Add.
    2. The Add Users and Groups dialog box appears:

    3. Select the name of the local host computer from the List Names From drop-down list box.
    4. Select Users from the Names list box and click Add.
    5. Click OK.
    6. Users appears in the Grant To list box.

  14. Click OK in the User Rights Policy dialog box.
  15. The User Manager window reappears.

  16. Click Exit from the User menu.
  17. Repeat Steps 1-9 for any other repository user accounts you created.
  18. Continue to "Step 4: Create Network Configuration Files".

Step 4: Create Network Configuration Files

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:

  1. Use Oracle Net8 Easy Config to configure your network. See Net8 Getting Started for Windows NT and Windows 95/98 for instructions on using Oracle Net8 Easy Config.
  2. Continue to "Step 5: Create the Repository and Discover Services".

Step 5: Create the Repository and Discover Services

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:

  1. Go to the computer on which the Oracle8 database that will become your repository is installed.
  2. Choose Start > Programs > Oracle Enterprise Manager > Enterprise Manager.
  3. The Oracle Enterprise Manager Repository Login Information dialog box appears:

  4. Enter the following information and click OK:
  5. The Oracle Repository Manager window appears, prompting you to build the repository:

  6. Click OK.
  7. The repository is built. A dialog box asking if you want a quick tour of Oracle Enterprise Manger appears.

  8. Click Continue to dismiss this dialog box.
  9. The Discover New Services Wizard appears:

  10. Follow the wizard instructions to discover services.
  11. 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.

  12. Click Close.
  13. The Oracle Enterprise Manager Console appears:

Configuration is complete. Oracle Enterprise Manager is now available for use.

Oracle8 Spatial Cartridge

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: 

 
 

Configuring Oracle8 Spatial Cartridge

To configure Oracle8 Spatial Cartridge:

  1. Go to the computer on which Oracle8 Spatial Cartridge is installed.
  2. Start Server Manager at the MS-DOS command prompt:
  3. C:\> SVRMGR30
  4. Start the Oracle8 database if it is not currently running. Otherwise, go to step 4.
    1. Connect to the database as INTERNAL:
    2. SVRMGR> CONNECT INTERNAL/PASSWORD
    3. Start the Oracle8 database:
    4. SVRMGR> STARTUP
  5. Connect to the database as the SYSTEM user:
  6. 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.

  7. Create a user called MDSYS with a password of MANAGER:
        SVRMGR> CREATE USER MDSYS IDENTIFIED BY MANAGER;
  1. Grant the following privileges to the MDSYS user:
        SVRMGR> GRANT ALL PRIVILEGES TO MDSYS IDENTIFIED BY MANAGER WITH ADMIN OPTION;SVRMGR> ALTER USER MDSYS QUOTA UNLIMITED ON SYSTEM;
  1. Exit Server Manager:
       SVRMGR> EXIT
  1. Start SQL*Plus from the MS-DOS command prompt:
  2. C:\> PLUS80W
  3. Connect to the database as MDSYS/MANAGER:

  4.  

     

    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.


    Note:  

    You must use SQL*Plus to run CATMD.SQL. Server Manager cannot run CATMD.SQL. 


     
     
  5. Run the CATMD.SQL script:
       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.


Note:  

In order to develop applications that work with Oracle8 Spatial Cartridge, you must link with SDO80.LIB, which is located in the ORACLE_HOME\MD80 directory. 


 
 

Oracle8 ConText Cartridge

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.

If...  Then... 

You installed Oracle8 ConText Cartridge release 2.4.5 from the Oracle8 Enterprise Edition CD-ROM and you do not have a previous release of ConText installed 

Follow the instructions in: 

 

You installed Oracle8 ConText Cartridge release 2.4.5 from the Oracle8 Enterprise Edition CD-ROM and you want to upgrade a previously installed release of ConText to Oracle8 ConText Cartridge release 2.4.5 

Follow the instructions in: 

 
 

Upgrading Oracle8 ConText Cartridge

This section describes how to upgrade from previous releases of ConText to Oracle8 ConText Cartridge release 2.4.5.

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 

 

Follow the instructions appropriate to your situation:

Migrating from Release 1.1.2 to Release 2.4.5

To migrate from release 1.1.2 to release 2.4.5:

  1. Ensure that there are no ConText servers currently running. See the Oracle8 ConText Cartridge Administrator's Guide for information about how to shut down ConText servers.
  2. Migrate the Oracle database from release 7.3.2 to release 8.0.5, if you have not already done so.
  3. Start the Oracle database by entering the following at the MS-DOS command prompt:
  4. 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.

  5. Exit Server Manager:
  6. SVRMGR> EXIT
  7. Start SQL*Plus from the ORACLE_HOME\CTX80\ADMIN directory:
  8. C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
  9. Connect as SYS:
  10. Enter user-name: SYS/PASSWORD
  11. Run the SYS20000.SQL script:
  12. SQL> @SYS20000.SQL;
  13. Connect as CTXSYS:
  14. SQL> CONNECT CTXSYS/PASSWORD;
  15. Run the UPG20000.SQL script:
  16. SQL> @UPG20000.SQL;
  17. Run the UPG23600.SQL script:
  18. SQL> @UPG23600.SQL;
  19. Run the UPG24500.SQL script:
  20. SQL> @UPG24500.SQL;
  21. Run the DR0PACK.SQL script:
  22. SQL> @DR0PACK.SQL;
  23. Run the DRGUS.SQL script:
  24. SQL> @DRGUS.SQL;
  25. If you want to use the ConText Linguistics and your text is in English, perform the following steps:
    1. Remove all of the rows from the CTX_SETTINGS table:
    2. SQL> TRUNCATE TABLE CTX_SETTINGS;
    3. Run the DRLNGSET.SQL script:
    4. SQL> @DRLNGSET.SQL;
  26. Exit SQL*Plus:
  27. SQL> EXIT
  28. Start a ConText server:
  29. C:\ORACLE_HOME\CTX80\ADMIN> START CTXSRV80 -user CTXSYS/PASSWORD 
    -personality DQM
  30. Run the PL/SQL function CTX_DDL.UPGRADE_INDEX for each existing ConText index that must be upgraded for use with release 2.4.5. The owner of the index should perform this task, but it can also be performed by CTXSYS. The following syntax assumes that CTXSYS owns the index:
  31. 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.

Upgrading from Release 2.0.4 to Release 2.4.5

To upgrade from release 2.0.4 to release 2.4.5:

  1. Ensure that there are no ConText servers currently running. See the Oracle8 ConText Cartridge Administrator's Guide for information about how to shut down ConText servers.
  2. Migrate the Oracle database from release 7.3.3 to release 8.0.5, if you have not already done so.
  3. Start the Oracle database by entering the following at the MS-DOS command prompt:
  4. 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.

  5. Exit Server Manager:
  6. SVRMGR> EXIT
  7. Start SQL*Plus from the ORACLE_HOME\CTX80\ADMIN directory:
  8. C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
  9. Connect as CTXSYS:
  10. Enter user-name: CTXSYS/PASSWORD
  11. Run the UPG23600.SQL script:
  12. SQL> @UPG23600.SQL;
  13. Run the UPG24500.SQL script:
  14. SQL> @UPG24500.SQL;
  15. Run the DR0PACK.SQL script:
  16. SQL> @DR0PACK.SQL;
  17. Run the DRGUS.SQL script:
  18. SQL> @DRGUS.SQL;
  19. If you want to use the ConText Linguistics and your text is in English, perform the following steps:
    1. Remove all of the rows from the CTX_SETTINGS table:
    2. SQL> TRUNCATE TABLE CTX_SETTINGS;
    3. Run the DRLNGSET.SQL script:
    4. SQL> @DRLNGSET.SQL;
  20. Exit SQL*Plus:
  21. SQL> EXIT
  22. Start a ConText server:
  23. C:\ORACLE_HOME\CTX80\ADMIN> START CTXSRV80 -user CTXSYS/PASSWORD 
    -personality DQM
  24. Run the PL/SQL function CTX_DDL.UPGRADE_INDEX for each existing ConText index that must be upgraded for use with release 2.4.5. The owner of the index should perform this task, but it can also be performed by CTXSYS. The following syntax assumes that CTXSYS owns the index:
  25. 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.

Upgrading from Release 2.0.6 to Release 2.4.5

To upgrade from release 2.0.6 to release 2.4.5:

  1. Ensure that there are no ConText servers currently running. See the Oracle8 ConText Cartridge Administrator's Guide for information about how to shut down ConText servers.
  2. Upgrade the Oracle database from release 8.0.3 to release 8.0.5, if you have not already done so.
  3. Start the Oracle database by entering the following at the MS-DOS command prompt:
  4. 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.

  5. Exit Server Manager:
  6. SVRMGR> EXIT
  7. Start SQL*Plus from the ORACLE_HOME\CTX80\ADMIN directory:
  8. C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
  9. Connect as CTXSYS:
  10. Enter user-name: CTXSYS/PASSWORD
  11. Run the UPG23600.SQL script:
  12. SQL> @UPG23600.SQL;
  13. Run the UPG24500.SQL script:
  14. SQL> @UPG24500.SQL;
  15. Run the DR0PACK.SQL script:
  16. SQL> @DR0PACK.SQL;
  17. Run the DRGUS.SQL script:
  18. SQL> @DRGUS.SQL;
  19. If you want to use the ConText Linguistics and your text is in English, perform the following steps:
    1. Remove all of the rows from the CTX_SETTINGS table:
    2. SQL> TRUNCATE TABLE CTX_SETTINGS;
    3. Run the DRLNGSET.SQL script:
    4. SQL> @DRLNGSET.SQL;
  20. Exit SQL*Plus:
  21. SQL> EXIT
  22. Start a ConText server:
  23. C:\ORACLE_HOME\CTX80\ADMIN> START CTXSRV80 -user CTXSYS/PASSWORD 
    -personality DQM
  24. Run the PL/SQL function CTX_DDL.UPGRADE_INDEX for each existing ConText index that must be upgraded for use with release 2.4.5. The owner of the index should perform this task, but it can also be performed by CTXSYS. The following syntax assumes that CTXSYS owns the index:
  25. 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.

Upgrading from Release 2.3.4 to Release 2.4.5

To upgrade from release 2.3.4 to release 2.4.5:

  1. Ensure that there are no ConText servers currently running. See the Oracle8 ConText Cartridge Administrator's Guide for information about how to shut down ConText servers.
  2. Migrate the Oracle database from release 7.3.4 to release 8.0.5, if you have not already done so.
  3. Start the Oracle database by entering the following at the MS-DOS command prompt:
  4. 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.

  5. Exit Server Manager:
  6. SVRMGR> EXIT
  7. Start SQL*Plus from the ORACLE_HOME\CTX80\ADMIN directory:
  8. C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
  9. Connect as CTXSYS:
  10. Enter user-name: CTXSYS/PASSWORD
  11. Run the UPG24500.SQL script:
  12. SQL> @UPG24500.SQL;
  13. Run the DR0PACK.SQL script:
  14. SQL> @DR0PACK.SQL;
  15. Run the DRGUS.SQL script:
  16. SQL> @DRGUS.SQL;
  17. If you want to use the ConText Linguistics and your text is in English, perform the following steps:
    1. Remove all of the rows from the CTX_SETTINGS table:
    2. SQL> TRUNCATE TABLE CTX_SETTINGS;
    3. Run the DRLNGSET.SQL script:
    4. SQL> @DRLNGSET.SQL;
  18. Exit SQL*Plus:
  19. SQL> EXIT

Upgrading from Release 2.3.6 to Release 2.4.5

To upgrade from release 2.3.6 to release 2.4.5:

  1. Ensure that there are no ConText servers currently running. See the Oracle8 ConText Cartridge Administrator's Guide for information about how to shut down ConText servers.
  2. Upgrade the Oracle database from release 8.0.4 to release 8.0.5, if you have not already done so.
  3. Start the Oracle database by entering the following at the MS-DOS command prompt:
  4. 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.

  5. Exit Server Manager:
  6. SVRMGR> EXIT
  7. Start SQL*Plus from the ORACLE_HOME\CTX80\ADMIN directory:
  8. C:\ORACLE_HOME\CTX80\ADMIN> PLUS80
  9. Connect as CTXSYS:
  10. Enter user-name: CTXSYS/PASSWORD
  11. Run the UPG24500.SQL script:
  12. SQL> @UPG24500.SQL;
  13. Run the DR0PACK.SQL script:
  14. SQL> @DR0PACK.SQL;
  15. Run the DRGUS.SQL script:
  16. SQL> @DRGUS.SQL;
  17. If you want to use the ConText Linguistics and your text is in English, perform the following steps:
    1. Remove all of the rows from the CTX_SETTINGS table:
    2. SQL> TRUNCATE TABLE CTX_SETTINGS;
    3. Run the DRLNGSET.SQL script:
    4. SQL> @DRLNGSET.SQL;
  18. Exit SQL*Plus:
  19. SQL> EXIT

Configuring Oracle8 ConText Cartridge

This section describes how to configure Oracle8 ConText Cartridge release 2.4.5 when you do not have a previous release of ConText installed.

Step 1: Increase the SHARED_POOL_SIZE Initialization Parameter (Optional)

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:

  1. Start Server Manager at the MS-DOS command prompt:
  2. C:\> SVRMGR30
  3. Connect as INTERNAL:
  4. SVRMGR> CONNECT INTERNAL/PASSWORD
  5. Shut down the database:
  6. SVRMGR> SHUTDOWN
  7. Use any ASCII text editor to open the INITSID.ORA file.
  8. Increase the SHARED_POOL_SIZE parameter so that the value is at least 11534336. For example:
  9. shared_pool_size = 12000000
  10. Save the INITSID.ORA file.
  11. Start the database:
  12. SVRMGR> STARTUP
  13. Exit Server Manager:
  14. SVRMGR> EXIT

Step 2: Start the OracleConTextService80 Service

To start the OracleConTextService80 Service:

  1. Choose Start > Settings > Control Panel.
  2. The Control Panel window appears.

  3. Double-click the Services icon.
  4. The Services window appears.

  5. If the OracleConTextService80 service does not have a status of Started, select the service and click Start.

Step 3: Use Oracle Database Assistant to Configure Oracle8 ConText Cartridge

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.

  1. Choose Start > Programs > Oracle for Windows NT - [HOME_NAME] > Oracle Database Assistant.
  2. Select Modify a database, and click Next.
  3. Select the instance for the database that you want to modify, type the password for the INTERNAL user name, and click Next.
  4. Select Configure Oracle cartridges, and click Next.
  5. Select ConText Cartridge.
  6. Select Enable Demo if you want to create and populate the CTXDEMO.EMP and CTXDEMO.DEPTNO tables. ConText indexes will be created for these tables.
  7. Click Finish.
  8. A message appears showing the progress of the configuration. Note that the configuration can take more than an hour.

  9. If you selected Enable Demo, a message appears indicating that you need to start a ConText server. Enter the following at the MS-DOS command prompt:
  10. C:\> START CTXSRV80 -USER CTXSYS/PASSWORD -PERSONALITY DQL
  11. Click Retry.
  12. A message appears indicating that your database has been successfully modified.

  13. Click OK.
  14. Oracle Database Assistant closes.

Configuring the CTXLING, CTXPLUS, and CTXQUERY Demos

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.

Demo  Location  Description 

CTXLING 

ORACLE_HOME\CTX80\DEMO\CTXLING 

SQL*Plus linguistic extraction 

CTXPLUS 

ORACLE_HOME\CTX80\DEMO\CTXPLUS 

SQL*Plus text query 

CTXQUERY 

ORACLE_HOME\CTXW\DEMO 

Oracle Forms text query 

 

Step 1: Create the CTXDEMO User Name (Optional)

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:

  1. Start SQL*Plus:
  2. C:\> PLUS80
  3. Connect as CTXSYS:
  4. Enter user-name: CTXSYS/PASSWORD
  5. Enter the following commands:
  6. SQL> GRANT CONNECT, RESOURCE TO CTXDEMO IDENTIFIED BY PASSWORD;
    SQL> GRANT CTXAPP TO CTXDEMO;
  7. Exit SQL*Plus:
  8. SQL> EXIT

Step 2: Set Up the CTXLING, CTXPLUS, and CTXQUERY Demos

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:

  1. Choose Start > Settings > Control Panel.
  2. The Control Panel window appears.
     

  3. Double-click the Services icon.
  4. The Services window appears.
     

  5. If the OracleConTextService80 service does not have a status of Started, select the service and click Start.
  6. Run the Import utility from the ORACLE_HOME\CTX80\DEMO\INSTALL directory to import the DEMO.DMP file:
  7. C:\ORACLE_HOME\CTX80\DEMO\INSTALL> IMP80 CTXSYS/PASSWORD FILE=DEMO.DMP 
    IGNORE=Y TABLES=ARTICLES

    Importing the DEMO.DMP file:

  8. Start a ConText Server with the DDL (D), Query (Q), and Linguistics (L) personalities:
  9. C:\ORACLE_HOME\CTX80\DEMO\INSTALL> START CTXSRV80 -USER CTXSYS/PASSWORD 
    -PERSONALITY DQL
  10. Start SQL*Plus:
  11. C:\ORACLE_HOME\CTX80\DEMO\INSTALL> PLUS80
  12. Connect as CTXDEMO:
  13. Enter user-name: CTXDEMO/PASSWORD
  14. Run the DEMOINST.SQL script:
  15. 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.

  16. If you plan to use the CTXLING demo, see the README.TXT file in the ORACLE_HOME\CTX80\DEMO\CTXLING directory for further setup instructions.

Oracle8 ConText Cartridge Workbench

Oracle8 ConText Cartridge Workbench consists of administrative tools and application development tools for Oracle8 ConText Cartridge.

Specific topics discussed in this section are:

Upgrading Oracle8 ConText Cartridge Workbench

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.

Configuring Oracle8 ConText Cartridge Viewer Cartridge

Chapter 3 of the Oracle8 ConText Cartridge Workbench User's Guide describes how to configure Oracle8 ConText Cartridge Viewer Cartridge.

Configuring Oracle8 ConText Cartridge Configuration Manager

Chapter 2 of the Oracle8 ConText Cartridge Workbench User's Guide describes how to configure Oracle8 ConText Cartridge Configuration Manager.

Configuring Oracle8 ConText Cartridge Workbench Demo

"Configuring the CTXLING, CTXPLUS, and CTXQUERY Demos" in the section "Configuring Oracle8 ConText Cartridge" describes how to configure the CTXQUERY demo.

Oracle8 Image Cartridge

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/98

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" in Chapter 15, "Developing Applications"

 

Configuring Oracle8 Image Cartridge

To configure Oracle8 Image Cartridge:

  1. Start Server Manager:
  2. C:\> SVRMGR30
  3. Connect to the database with the INTERNAL account:
  4. SVRMGR> CONNECT INTERNAL/PASSWORD
  5. Start the database:
  6. SVRMGR> STARTUP
  7. Run the following script:
  8. SVRMGR> @%ORACLE_HOME%\ORD80\IMG\ADMIN\ORDIINST.SQL
  9. Enter the password for INTERNAL when prompted by the ORDIINST.SQL script:
  10. Password: PASSWORD
  11. Change the password for ORDSYS (if necessary):
    1. Connect to the database with the INTERNAL account:
    2. SVRMGR> CONNECT INTERNAL/PASSWORD
    3. Enter the following command:
    4. SVRMGR> ALTER USER ORDSYS IDENTIFIED BY NEW_PASSWORD;
  12. Exit Server Manager:
  13. SVRMGR> EXIT

Configuring Oracle8 Image Cartridge Demos

Oracle8 Image Cartridge Demos provide a sample demonstration showing how an image is extracted from an Oracle8 database.

To configure Oracle8 Image Cartridge Demos:

  1. Start Server Manager:
  2. C:\> SVRMGR30
  3. Connect to the database with the INTERNAL account:
  4. SVRMGR> CONNECT INTERNAL/PASSWORD
  5. Run the following script:
  6. SVRMGR> @%ORACLE_HOME%\ORD80\IMG\DEMO\IMGDEMO.SQL
  7. Enter the password for INTERNAL when prompted by the IMGDEMO.SQL script:
  8. Password: PASSWORD
  9. Exit Server Manager:
  10. SVRMGR> EXIT
  11. Go to the following directory:
  12. C:> CD ORACLE_HOME\ORD80\IMG\DEMO
  13. Make the Oracle8 Image Cartridge Demo program:

  14. If Using a...  Then Enter... 

    Microsoft C compiler 

    MAKE 

    Borland C compiler 

    BMAKE 

     
     

Oracle8 Time Series Cartridge

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/98

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" in Chapter 15, "Developing Applications"

 

Configuring Oracle8 Time Series Cartridge


Note:  

Oracle8 Time Series Cartridge uses the same user name as Oracle8 Image Cartridge and Oracle8 Visual Information Retrieval Cartridge (ORDSYS). If you automatically or manually configured either of these cartridges first, then the error ORA-01920 can appear on-screen when running the script below. This error message can be ignored. 


 
 

To configure Oracle8 Time Series Cartridge:

  1. Start Server Manager:
  2. C:\> SVRMGR30
  3. Connect to the database with the INTERNAL account:
  4. SVRMGR> CONNECT INTERNAL/PASSWORD
  5. Create the user ORDSYS (if it does not currently exist):
  6. SVRMGR> CREATE USER ORDSYS IDENTIFIED BY ORDSYS;
  7. Grant the following privileges to ORDSYS:
  8. SVRMGR> GRANT CONNECT,RESOURCE,CREATE LIBRARY TO ORDSYS;
    SVRMGR> GRANT GRANT ANY PRIVILEGE TO ORDSYS;
  9. Connect as ORDSYS:
  10. SVRMGR> CONNECT ORDSYS/PASSWORD
  11. Run the following script:
  12. SVRMGR> @%ORACLE_HOME%\ORD80\TS\ADMIN\ORDTINST.SQL

    This script:

  13. Change the password for ORDSYS (if necessary):
    1. Connect to the database with the INTERNAL account:
    2. SVRMGR> CONNECT INTERNAL/PASSWORD
    3. Enter the following command:
    4. SVRMGR> ALTER USER ORDSYS IDENTIFIED BY NEW_PASSWORD;
  14. Exit Server Manager:
  15. SVRMGR> EXIT

Configuring Oracle8 Time Series Cartridge Demos

Five Oracle8 Time Series Cartridge Demos are provided:

Demo  This Demo... 

Usage 

Creates a sample database for use with Oracle8 Time Series Cartridge and demonstrates several basic queries. This demo is used as the basis for all five demos. 

Extend 

Includes sample PL/SQL code to extend the functionality of Oracle8 Time Series Cartridge with new functions. The Oracle8 Objects Option is required to extend the Oracle8 Time Series Cartridge. 

OCI 

Provides C examples of client side time series access. 

Pro*C 

Provides examples of several approaches to client side time series access. Users must have Pro*C to build this demo. 

Developers 

Includes a Developer 2000 Form that incorporates a Developer 2000 Graphic, both of which access data using the Oracle8 Time Series Cartridge. This demo requires Developer 2000 Release 2.0 or higher. 

 

To configure Oracle8 Time Series Cartridge Demos:

  1. Go to the ORACLE_HOME\ORD80\TS\DEMO directory.
  2. Read the README file in this directory for an overview of the five Oracle8 Time Series Cartridge Demos.
  3. Go to the appropriate subdirectory of ORACLE_HOME\ORD80\TS\DEMO for instructions on configuring the demo that you want to use (for example, directory PROC for Pro*C).
  4. Follow the README file instructions in the subdirectory to configure the demo.

  5. Note:  

    Each of the five subdirectories contains a README that provides configuration instructions. 


     
     

Oracle8 Visual Information Retrieval Cartridge

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:


Note:  

When you select Oracle8 Visual Information Retrieval Cartridge for installation, Oracle8 Image Cartridge is installed automatically. To function properly, Oracle8 Visual Information Retrieval Cartridge requires Oracle8 Image Cartridge. 


 
 
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/98

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" in Chapter 15, "Developing Applications"

 

Configuring Oracle8 Visual Information Retrieval Cartridge


Note:  

Oracle8 Visual Information Retrieval Cartridge uses the same user name as Oracle8 Image Cartridge and Oracle8 Time Series Cartridge (ORDSYS). If you automatically or manually configured either of these cartridges first, then the error ORA-01920 can appear on-screen when running the script below. This error message can be ignored. 


 
 

To configure Oracle8 Visual Information Retrieval Cartridge:

  1. Ensure that Oracle8 Image Cartridge is already configured. If not, see "Oracle8 Image Cartridge" for instructions.
  2. Start Server Manager:
  3. C:\> SVRMGR30
  4. Connect to the database with the INTERNAL account:
  5. SVRMGR> CONNECT INTERNAL/PASSWORD
  6. Run the following script:
  7. SVRMGR> @%ORACLE_HOME%\ORD80\VIR\DEMO\ORDRINST.SQL
  8. Enter the password for INTERNAL when prompted by the ORDRINST.SQL script:
  9. Password: PASSWORD
  10. Change the password for ORDSYS (if necessary):
    1. Connect to the database with the INTERNAL account:
    2. SVRMGR> CONNECT INTERNAL/PASSWORD
    3. Enter the following command:
    4. SVRMGR> ALTER USER ORDSYS IDENTIFIED BY NEW_PASSWORD;
  11. Exit Server Manager:
  12. SVRMGR> EXIT

Configuring Oracle8 Visual Information Retrieval Cartridge Demos

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:

  1. Start Server Manager:
  2. C:\> SVRMGR30
  3. Connect to the database with the INTERNAL account:
  4. SVRMGR> CONNECT INTERNAL/PASSWORD
  5. Run the following script:
  6. SVRMGR> @%ORACLE_HOME%\ORD80\VIR\ADMIN\VIRDEMO.SQL
  7. Enter the password for INTERNAL when prompted by the VIRDEMO.SQL script:
  8. Password: PASSWORD
  9. Exit Server Manager:
  10. SVRMGR> EXIT
  11. Go to the following directory:
  12. CD ORACLE_HOME\ORD80\VIR\DEMO
  13. Make the Oracle8 Visual Information Retrieval Demos program:

  14. If Using a...  Then Enter... 

    Microsoft C compiler 

    MAKE 

    Borland C compiler 

    BMAKE 

     
     

Advanced Replication

Review the table below to determine your configuration responsibilities:

If You...  Then... 

Selected: 

  • Typical Configuration when prompted for a database type during Oracle8 Enterprise Edition installation. 
  • Oracle8 Enterprise Edition during Custom installation in the Software Asset Manager window. 
  • Advanced Replication while creating a customized Oracle8 Enterprise Edition with Oracle Database Assistant 
 

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"

 

Configuring Advanced Replication Support

Follow the procedures described below:

See Oracle8 Enterprise Edition Installation for Windows NT for Advanced Replication installation requirements.

Additional Information:  

There are many configuration and usage possibilities with Advanced Replication. For more information about advanced replication and for definitions of master sites and snapshot sites, see: 

 
 
 

Step 1: Checking Tablespace Requirements

The following are recommended tablespace requirements for Advanced Replication:

Tablespace  Requirement 

SYSTEM 

At least 20 MB of free space is required for replication packages. Replication triggers and procedures are stored here. 

ROLLBACK SEGMENTS 

  • Rollback Initial Extent = 50 KB 
  • Rollback Next Extent = 50 KB 

ROLLBACK 

At least 5 MB of free space. 

TEMPORARY 

At least 10 MB of free space. 

USER 

No specific requirement. 

 

Step 2: Checking Initialization Parameters

Certain initialization parameter values must be set or added to the INITSID.ORA file (recommended values are included) if you use Advanced Replication.

Master Site

Add these initialization parameters to the master site:

Parameter Name  Recommended Value 

SHARED_POOL_SIZE 

At least 10 MB 

DISTRIBUTED_LOCK_TIMEOUT 

300 seconds 

DISTRIBUTED_TRANSACTIONS 

GLOBAL_NAMES 

TRUE 

OPEN_LINKS 

PROCESSES 

Add 9 to current value 

JOB_QUEUE_PROCESSES 

2 (depends on number of n-way sites) 

JOB_QUEUE_INTERVAL 

10 seconds 

 

Snapshot Sites

Add these initialization parameters for snapshot sites:

Parameter Name  Recommended Value 

JOB_QUEUE_PROCESSES 

JOB_QUEUE_INTERVAL  60 seconds 
 

Step 3: Performing Configuration Tasks

After setting up the INITSID.ORA file with the initialization parameters for Advanced Replication, perform the following steps:

To configure Advanced Replication:

  1. Start Server Manager:
  2. C:\> SVRMGR30
  3. Connect to the database with the INTERNAL account:
  4. SVRMGR> CONNECT INTERNAL/PASSWORD
  5. Start the database if it is not currently running:
  6. SVRMGR> STARTUP
  7. Run the script CATREP8M.SQL once the database has started.
  8. 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.

    1. Enter the following command:
    2. 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.

    3. Run CATREP8M.SQL:
    4. SVRMGR> @%RDBMS80%\ADMIN\CATREP8M.SQL
    5. Close the SPOOL file by entering OFF when the script completes running:
    6. SVRMGR> SPOOL OFF

      OUTPUT.LOG is saved to your current directory.

  9. Confirm that CATREP8M.SQL ran correctly by running a query on ALL_OBJECTS where STATUS = 'INVALID':
  10. 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.

  11. Exit Server Manager:
  12. SVRMGR> EXIT
  13. See Oracle8 Replication for details on setting up:

Step 4: Monitoring Data Dictionary Tables

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.

Step 5: Upgrading Advanced Replication

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, "Database Coexistence and Migration" 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.



 
Prev
 
Next
 
Oracle 
Copyright © 1998 Oracle Corporation. 
All Rights Reserved. 
 
Library
 
Product
 
Contents
 
Index