Oracle8(TM) Enterprise Edition Getting Started for Windows NT Release 8.0.3 A53722-01

Library Product Contents Index

6
Configuration Tasks

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

Specific topics discussed are:

• What Must You Configure?
• Configuring Net8
• Configuring Oracle Enterprise Manager
• Configuring Oracle8 Spatial Cartridge
• Configuring Oracle8 ConText Cartridge
• Configuring Oracle8 Image Cartridge
• Configuring Advanced Replication

What Must You Configure?

Some of the configuration procedures described in this chapter are required only if you choose to add the following products/support to an already installed Oracle8 database. Depending on which type of database and products/support you selected for installation, most configuration tasks are automatically performed for you. Review the table below to identify your configuration responsibilities.

Configuring Net8

Net8 is the Oracle networking software that enables applications running on client workstations to access, modify, share, and store data on the Oracle8 database. To configure Net8 so that your client workstations and Oracle8 database can communicate, you must use Oracle Net8 Assistant to create and modify server and client configuration files. Oracle Net8 Assistant is automatically installed when you select the following:

• Oracle8 Enterprise Edition option
• Oracle8 Client option
• Oracle Net8 Assistant from Custom Installation

Additional Information: See Oracle Network Products Getting Started for Windows Platforms and the Net8 Administrator's Guide for instructions on using Oracle Net8 Assistant to configure your client/server network.

Configuring Oracle Enterprise Manager

Oracle Enterprise Manager

Oracle Enterprise Manager works with the Oracle Intelligent Agent (installed on the Oracle8 database server) to perform database administration from a single console. Oracle Enterprise Manager is installed on a console workstation, a Windows NT or Windows 95 client.

Oracle Intelligent Agent

The Oracle Intelligent Agent is installed on the Oracle8 database. The Oracle Intelligent Agent is responsible for managing and completing tasks requested from the console workstation by the Oracle Enterprise Manager. Once installed, the Oracle Intelligent Agent:

• listens for and responds to job requests initiated by the Oracle Enterprise Manager console workstation
• schedules job requests (requests can include detecting and correcting abnormal conditions, performing standard database administration procedures, and monitoring events)
• executes the job request

Perform the following configuration tasks after installing the Oracle Enterprise Manager on a client Windows NT or Windows 95 console workstation and the Oracle Intelligent Agent on your Oracle8 Enterprise Edition for Windows NT machine:

1. Step 1: Start Oracle Services
2. Step 2: Create a Repository User Account
3. Step 3: Create an NT User Account
4. Step 4: Create Configuration Files
5. Step 5: Create the Repository and Discover Services

Each of these tasks is described in the sections that follow.

Step 1: Start Oracle Services

Before configuring Oracle Enterprise Manager, ensure that the Oracle8 database services OracleServiceSID, OracleTNSListener80, and OracleAgent are started on the server. The 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 the Oracle Services:

1. Start the OracleServiceSID, OracleTNSListener80, and OracleAgent services on Oracle8 database:
• From the MS-DOS command line, enter:

C:\>NET START SERVICE

• From the Control Panel's Services window, select a service, and choose Start.
2. Continue to "Step 2: Create a Repository User Account".

Step 2: Create a Repository User Account

You need to have a user account with DBA (database administrator) privileges set up on the Oracle8 repository database. Oracle Enterprise Manager places its 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 its default tablespace.

To create a repository user account on the Oracle8 repository database:

1. Start Server Manager and connect to the Oracle8 repository database:

C:\> SVRMGR30
SVRMGR> CONNECT SYSTEM/MANAGER

2. Create a special tablespace for the Oracle Enterprise Manager repository:

SVRMGR> CREATE TABLESPACE REPOSIT_TABLESPACE DATAFILE 'path\DATAFILE' SIZE 
XM;

where X is the tablespace size in megabytes; 20 MB is a good starting place.

3. Create a user account where the user's default tablespace is the newly-created tablespace:

SVRMGR> CREATE USER USERNAME IDENTIFIED BY PASSWORD
2> DEFAULT TABLESPACE REPOSIT_TABLESPACE;

4. Grant the SYSTEM privileges to this user account:

SVRMGR> GRANT DBA TO USERNAME IDENTIFIED BY PASSWORD;

5. When done, enter:

SVRMGR> EXIT

Exiting Server Manager closes the database connection.

6. Follow Steps 1-5 for additional repository user accounts.

Step 3: Create an NT User Account

After a repository user account is created, an NT user account with the same user name as the repository user account must be created on the Oracle8 Enterprise Edition server.

To create a user account on the Oracle8 Enterprise Edition server:

1. Choose Start>Programs>Administrative Tools (Common)>User Manager:

The User Manager window appears:

2. Choose New User from the User menu.

The New User dialog box appears:



3. Enter the appropriate information in the dialog box:
1. Enter a user name that is the same as the one you entered in section "Step 2: Create a Repository User Account" in the Username field.
2. Enter the same password you entered in section "Step 2: Create a Repository User Account" in both the Password and Confirm Password fields.
3. Make sure the User Must Change Password at Next Logon check box is not checked and Password Never Expires check box is checked.
4. Make the user a member of the Administrator's group by choosing Groups.

The Group Memberships dialog box appears:



5. Select Administrators from the Not member of list box and choose <- Add.

Administrators is added to the Member of list box.

6. Click OK to close the Group Memberships dialog box and return to the New User dialog box.



4. Click OK in the New User dialog box.

The user is added and the User Manager window re-appears.

5. Select the newly-created user and choose User Rights from the Policies menu.

The User Rights Policy dialog box appears:



6. Click the Show Advanced User Rights check box and select Log on as a batch job from the Right drop-down list box.
7. Select Users from the Grant To list box.

If Users does not exist, create it:

1. Click Add.

The Add Users and Groups dialog box appears:



2. Select the names of the local host machine from the List Names From drop-down list box.
3. Select Users from the Names list box and click Add.
4. Click OK.

Users appears in the Grant To list box.

8. Click OK in the User Rights Policy dialog box.

The User Manager window re-appears.

9. Choose Exit from the User menu.
10. Repeat Steps 1-9 for any other repository user accounts you created.

Step 4: Create Configuration Files

If Oracle Enterprise Manager is installed on a Windows 95 or Windows NT client console, you must configure the client machine so it can connect to the Oracle8 repository database. Use the Oracle Net8 Assistant to configure your network.

If Oracle Enterprise Manager is installed on the machine where the Oracle repository database is installed, you do not need to configure your network.

Step 5: Create the Repository and Discover Services

Before you can use Oracle Enterprise Manager, you need a repository on the console workstation where Oracle Enterprise Manager will run. 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, the 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 on the console workstation:

1. Choose Start>Programs>Oracle Enterprise Manager.

The Oracle Enterprise Manager Repository Login Information dialog box appears:



2. Enter the following appropriate information and choose OK:
• Repository user name and password you created in "Step 2: Create a Repository User Account" in Username
• Net8 service name (or database alias) of the repository database; only necessary to enter service name if you are connecting from a client console machine connecting to the Oracle8 repository database

The Oracle Repository Manager window appears, prompting you to build the repository:

3. Click OK.

The repository is built.

The Discover New Services Wizard appears:

4. Follow the wizard to discover services.

Services are discovered when you see the dialog box below with a status of Discovered:

5. Click Close.

The Oracle Enterprise Manager Console appears:

Configuring Oracle8 Spatial Cartridge

If you are adding Oracle8 Spatial Cartridge to an already installed Oracle8 Enterprise Edition, you must follow these configuration procedures. If you installed Oracle8 Spatial Cartridge during the same installation as Oracle8 Enterprise Edition, you do not have to perform the procedures in this section; Oracle8 Spatial Cartridge was automatically configured for you.

To configure Oracle8 Spatial Cartridge:

1. Start Server Manager at the MS-DOS command prompt:

C:\> SVRMGR30

2. Create an MDSYS user. For example,

SVRMGR> CREATE USER MDSYS IDENTIFIED BY MANAGER;

3. Connect to the database as SYSTEM/MANAGER:

SVRMGR> CONNECT SYSTEM/MANAGER

4. 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;

5. Start SQL*Plus:

C:\> PLUS80W

6. Connect to the database as MDSYS/MANAGER.

Note: You cannot use Server Manager to run CATMD.SQL.

7. Run the CATMD.SQL script:

SQL> @%ORACLE_HOME%\MD80\ADMIN\CATMD.SQL

This script creates the following:

• MD3 data dictionary tables
• MD3 data dictionary user views
• MDSQL packages for MD operations
• MDWEX packages for extracting data
• MDGTRIG package for generating triggers

Additional Information: See the Oracle8 Spatial Data Option User's Guide and Reference.

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

Configuring Oracle8 ConText Cartridge

If you are adding Oracle8 ConText Cartridge to an already installed Oracle8 Enterprise Edition, you must follow these configuration procedures. If you installed Oracle8 ConText Cartridge during the same installation as Oracle8 Enterprise Edition, you do not have to perform the procedures in this section; Oracle8 ConText Cartridge was automatically configured for you.

To configure Oracle8 ConText Cartridge:

1. Create the Oracle8 ConText Cartridge dictionary and packages in the schema CTXSYS. About 5 MB of database space is needed for these objects. You can create these objects in an existing tablespace or preferably in a separate tablespace.

To create objects in an existing tablespace:

1. Extend the existing tablespace by at least 5 MB.
2. Start Server Manager at the MS-DOS command prompt:

C:\> SVRMGR30

3. Connect to the database as SYSTEM:

CONNECT SYSTEM/MANAGER

4. Expand an existing tablespace by at least 5 MB.

SVRMGR30> ALTER TABLESPACE EXISTING_TABLESPACE;
SVRMGR30> ADD DATAFILE `%ORACLE_HOME%\DATABASE\SYS2ORCL.ORA' SIZE 5 M; 

5. Exit Server Manager:

SVRMGR30> EXIT 

To create objects in a separate tablespace:

1. Create a tablespace of at least 5 MB.
2. Start Server Manager at the MS-DOS command prompt:

C:\> SVRMGR30

3. Connect to the database as SYSTEM:

SVRMGR30> CONNECT SYSTEM/MANAGER

4. Create a tablespace called DRSYS with a size of at least 5 MB.

SVRMGR30> CREATE TABLESPACE DRSYS DATAFILE 
'%ORACLE_HOME%\DATABASE\DR1ORCL.ORA' SIZE 5 M; 

5. Exit Server Manager:

SVRMGR30> EXIT 

2. Go to the ORACLE_HOME\CTX80\ADMIN directory and execute the scripts DRCRSYST.SQL and DR0INST.SQL.

To execute the DRCRSYST.SQL script:

1. Start SQL*Plus:

C:\> PLUS80W

2. Enter the SYSTEM username and MANAGER password when prompted.
3. Execute the DRCRSYST script:

SQLPLUS> @DRCRSYST CTXSYS PASSWORD EXISTING_TABLESPACE 
EXISTING_TABLESPACE 

or

SQLPLUS> @DRCRSYST CTXSYS PASSWORD DRSYS DRSYS 

The password supplied here becomes the password for the new CTXSYS user.

4. Exit SQL*Plus:

SQLPLUS> EXIT

To execute the DR0INST.SQL script:

1. Start SQL*Plus:

C:\> PLUS80W

2. Enter the CTXSYS username and password when prompted.
3. Execute the DR0INST script:

SQLPLUS> @DR0INST 

4. Exit SQL*Plus

SQLPLUS> EXIT

3. Import the Oracle8 ConText Cartridge linguistics settings into the schema of user CTXSYS.
1. Go to the directory ORACLE_HOME\CTX80\ADMIN.

C:\> CD ORACLE_HOME\CTX80\ADMIN

2. Execute the IMP80 command:

C:\ORACLE_HOME\CTX80\ADMIN> IMP80 CTXSYS/PASSWORD_FOR_CTXSYS \ 
FILE=CTXSET.DMP FULL=Y IGNORE=Y 

3. Execute the DRSYS.SQL script. This creates a user called DRSYS for backward compatibility purposes.

C:\ORACLE_HOME\CTX80\ADMIN> PLUS80W SYSTEM/PASSWORD_FOR_SYSTEM 
SQLPLUS>@DRSYS 

4. Exit SQL*Plus:

SQLPLUS> EXIT

4. Add or check for the following line in the INITSID.ORA file. This is required to issue one-step queries through the Oracle8 ConText Cartridge.

TEXT_ENABLE = TRUE 

5. Set the SHARED_POOL_SIZE initialization parameter in the INITSID.ORA file to at least 9 MB when using the Oracle8 ConText Cartridge.
6. Restart the database.

Additional Information: See Oracle ConText Cartridge QuickStart, Oracle ConText Cartridge Administrator's Guide, and Oracle ConText Application Developer's Guide.

Another configuration step:

To run the CTXPLUS and CTXLING Demos as well as the Oracle Forms Demo on Workbench:

1. Go to the ORACLE_HOME\CTX80\DEMO directory.
2. Run SQL scripts in order to get these demos to work.

Running Server Processes on Windows NT

Oracle8 ConText Cartridge servers can be started from the MS-DOS command prompt or the Oracle8 ConText Cartridge control utility.

From the MS-DOS command prompt, enter:

C:\> START CTXSRV80 -USER CTXSYS/PASSWD_FOR_CTXSYS@CONN_STRING -PERSONALITY 

From the Oracle8 ConText Cartridge control utility, enter:

C:\> CTXCTL80 
COMMAND> START 1 [DML | DDL | LOAD | LING | QUERY] 

Oracle8 ConText Cartridge server processes started from the MS-DOS command prompt are killed by Windows NT when a console user logs off the Windows NT console.

To help Oracle8 ConText Cartridge servers survive Windows NT console log off, use the Oracle8 ConText Cartridge control utility CTXCTL80.EXE to start, stop, and view the Oracle8 ConText Cartridge servers running on the Windows NT server/workstation.

The Oracle8 ConText Cartridge control utility interacts with a Windows NT service for Oracle8 ConText Cartridge. It is this service that manages the various Oracle8 ConText Cartridge server processes on that Windows NT server/workstation. The service is called OracleConTextService80 and must be started prior to using the Oracle8 ConText Cartridge control utility. By default the service starttype is AUTO.

The Oracle8 ConText Cartridge control utility cannot list or kill Oracle8 ConText Cartridge servers started directly by executing CTXSRV80.EXE or CTXSRX80.EXE. It can only manage Oracle8 ConText Cartridge servers through the OracleConTextService80 Windows NT service.

Configuring Oracle8 Image Cartridge

If you are adding Oracle8 Image Cartridge to an already installed Oracle8 Enterprise Edition, you must follow these configuration procedures. If you installed Oracle8 Image Cartridge during the same installation as Oracle8 Enterprise Edition, you do not have to perform the procedures in this section; Oracle8 Image Cartridge was automatically configured for you.

Oracle8 Image Cartridge is an extension of Oracle8 Enterprise Edition that provides image storage, retrieval, and format conversion capabilities through an object data type (ODT).

After Oracle8 Enterprise Edition installation, run the following SQL script to enable Oracle8 Image Cartridge:

1. Start Server Manager:

C:\> SVRMGR30

2. Connect to the database with the INTERNAL account:

SVRMGR> CONNECT INTERNAL/PASSWORD

3. Run the following script:

SVRMGR> @%ORACLE_HOME%\ORD80\IMG\ADMIN\ORDIINST.SQL

4. Connect as INTERNAL:

SVRMGR> CONNECT INTERNAL/PASSWORD

5. Change the password for ORDSYS:

SVRMGR> ALTER USER ORDSYS IDENTIFIED BY NEW_PASSWORD;

Once this has been completed, Oracle8 Image Cartridge is usable.

Configuring Advanced Replication

If you want to install Advanced Replication support after previously installing Oracle8 Enterprise Edition, you must follow the procedures described below:

• Tablespace Requirements
• Initialization Parameters
• Configuration Tasks
• Data Dictionary Tables
• Upgrading Advanced Replication
• Using Advanced Replication

See the Oracle8 Enterprise Edition for Windows NT Installation CD-ROM Insert   for Advanced Replication installation requirements.

Tablespace Requirements

These are the recommended tablespace requirements for Advanced Replication:

Initialization Parameters

Certain default initialization parameter values must be set for the replication database. For a complete list of these parameters, see the section "Advanced Replication Initialization Parameters" in Appendix B, "Initialization Parameter Files" of this guide.

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:

C:\> SVRMGR30

2. Connect to the database with the INTERNAL account:

SVRMGR> CONNECT INTERNAL/PASSWORD

3. Start the database.

SVRMGR> STARTUP

4. Execute the script CATREP.SQL once the database has started.

The script is found in the ORACLE_HOME\RDBMS80\ADMIN directory. It takes approximately one hour to run. A good idea is to spool output to a log file first before running CATREP.SQL:

1. Enter the following command:

SVRMGR> SPOOL 

This creates a file called OUTPUT.LOG to which to output all onscreen activity while the SPOOL session is open.

Run CATREP.SQL:

SVRMGR> @%ORACLE_HOME%\RDBMS80\ADMIN\CATREP.SQL

2. Close the SPOOL file by entering OFF when the script completes running:

SVRMGR> SPOOL OFF

OUTPUT.LOG is placed in your current directory.

5. Confirm that CATREP.SQL ran correctly by running a query on ALL_OBJECTS where STATUS = 'INVALID':

SVRMGR> SELECT * FROM ALL_OBJECTS WHERE STATUS = 'INVALID';

If you find that any of the package bodies compiled incorrectly, recompile them manually. Here is the syntax for running them manually:

SVRMGR> ALTER PACKAGE <package name> COMPILE BODY;

If CATREP.SQL has run successfully, a number of replication tables are created in the SYSTEM subdirectory. The database is now set up for Advanced Replication.

6. See Oracle8 Server Replication for details on setting up:
• master definition site
• master sites
• updatable snapshot sites
• conflict resolution

Note: Execute the following statement on the master site when setting up updatable snapshot sites: SVRMGR> GRANT EXECUTE ON DBMSOBJGWRAPPER TO PUBLIC;

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:

If necessary, increase the storage parameters to accommodate the storage requirements of large numbers of replicated objects.

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 migration (see the Chapter Chapter 5, "Database Co-existence 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 for Windows NT Installation CD-ROM Insert).

Using Advanced Replication

Prev Next

Copyright © 1997 Oracle Corporation. All Rights Reserved.

Library Product Contents Index