6
Post-Installation Configuration Tasks

This chapter describes post-installation configuration tasks for Oracle8 Client.

Specific topics discussed are:

What Must You Configure?

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 ConText Workbench

Depends upon how product was installed and whether you are upgrading or migrating from a previous release.

"Oracle8 ConText Cartridge Workbench" of this chapter

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 ConText Workbench	Depends upon how product was installed and whether you are upgrading or migrating from a previous release.	"Oracle8 ConText Cartridge Workbench" of this chapter

Net8

Net8 is the Oracle network software that enables 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. See Chapter 2, "Introducing Oracle8 Client" for information on how this product is installed. See also Net8 Getting Started for Windows NT and Windows 95 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:

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

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 same computer as the Oracle Enterprise Manager Console if it is a Windows NT computer
a separate Windows NT computer to which a Windows 95 or Windows NT Oracle Enterprise Manager Console can remotely connect

The sole responsibility of the repository database is to act as the Oracle Enterprise Manager's storage resource. The Oracle8 repository database is:

a separate database from the managed Oracle8 database that you use for your production work
installed on a separate computer from the managed Oracle8 database

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

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:

Go to the Oracle8 database to be managed.

Start the Oracle services listed above in either of two ways:

From the MS-DOS command prompt, enter:

C:\> NET START SERVICE_NAME

From the Control Panel's Services window, select the service, and click Start.

Continue to "Step 2: Create a Repository User Account".

Note:

Oracle Intelligent Agent automatically creates SNMP_RO and SNMP_RW. These are used instead of the SNMP.ORA file of 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:

Go to the computer on which the Oracle8 database that will become your repository is installed.

Start Server Manager:

C:\> SVRMGR30

Connect to the Oracle8 repository database:

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.

Create a special tablespace for the Oracle Enterprise Manager repository:

SVRMGR> CREATE TABLESPACE REPOSIT_TABLESPACE DATAFILE                  
'ORACLE_HOME\DATABASE\DATAFILE' SIZE XM;

where:

REPOSIT_TABLESPACE is the tablespace name
`ORACLE_HOME\DATABASE\DATAFILE' is the complete path (including drive letter) to the data file (single quotes are required)
X is the tablespace size in megabytes (20 MB is a good starting place)

Create a user account and password where the user's default tablespace is the one created in step 4:

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

Grant the SYSTEM privileges to this user account:

SVRMGR> GRANT DBA TO USERNAME IDENTIFIED BY PASSWORD;

Exit Server Manager:

SVRMGR> EXIT

Exiting Server Manager closes the database connection.

Follow Steps 3-6 for additional repository user accounts.
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:

Go to the Oracle8 database to be managed.

Choose Start > Programs > Administrative Tools > User Manager.

The User Manager window appears:

Choose New User from the User menu.

The New User dialog box appears:

Enter the appropriate information in the dialog box:

Enter a user name in the Username field.
Enter the same password in both the Password and Confirm Password fields.

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".

Make sure the User Must Change Password at Next Logon check box is not checked and Password Never Expires check box is checked.
Make the user a member of the Administrator's group by clicking Groups.

The Group Memberships dialog box appears:

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

Administrators is added to the Member of list box.

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

Click OK in the New User dialog box to accept the user information.

The user is added and the User Manager window reappears.

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

The User Rights Policy dialog box appears:

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

If Users does not exist, create it:

Click Add.

The Add Users and Groups dialog box appears:

Select the name of the local host computer from the List Names From drop-down list box.
Select Users from the Names list box and click Add.
Click OK.

Users appears in the Grant To list box.

Click OK in the User Rights Policy dialog box.

The User Manager window reappears.

Click Exit from the User menu.
Repeat Steps 1-9 for any other repository user accounts you created.
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:

Use Oracle Net8 Easy Config to configure your network. See Net8 Getting Started for Windows NT and Windows 95 for instructions on using Oracle Net8 Easy Config.

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 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, 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:

Go to the computer on which the Oracle8 database that will become your repository is installed.

Choose Start > Programs > Oracle Enterprise Manager > Enterprise Manager.

The Oracle Enterprise Manager Repository Login Information dialog box appears:

Enter the following information and click OK:

Repository user name and password you created earlier in "Step 2: Create a Repository User Account"
Net8 service name (or database alias) of the repository database; it is only necessary to enter a service name if you are connecting from a client console to the Oracle8 repository database on a different computer

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

Click OK.

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

Click Continue to dismiss this dialog box.

The Discover New Services Wizard appears:

Follow the wizard instructions to discover services.

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.

Click Close.

The Oracle Enterprise Manager Console appears:

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

Oracle8 ConText Cartridge Workbench

Oracle8 ConText Cartridge Workbench consists of administrative tools and application development tools. Specific topics discussed in this section are:

Upgrading Oracle8 ConText Cartridge Workbench

To upgrade from previous releases of 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

To configure Oracle8 ConText Cartridge Workbench:

Choose Start > Programs > Oracle for Windows NT (or Windows 95) - [HOME_NAME] > Viewer Cartridge Setup.

Oracle Installer starts, and the Oracle8 ConText Cartridge Viewer Cartridge Setup dialog box appears:

Enter the appropriate information in each of the fields, and click OK:

Field¹	Description
Machine name	Enter the machine name of the WebServer or Web Application Server.
Admin listener port	Enter the admin listener port of the WebServer or Web Application Server.
Admin listener user and password	Enter the admin listener user and password.
Listener name	Enter an existing listener name.
User/Password	Enter the CTXSYS user and password. The default password is CTXSYS.
Connection alias	Enter the database alias for the WebServer or Web Application Server to the Oracle8 database. Note: The alias that you enter here is not the alias that connects the client to the Oracle database.

¹ Ask your web server administrator for assistance with these values.

If your web server is on the same computer as the Viewer Cartridge, then go to Step 5. Otherwise, the Remote Web Application Server dialog box appears.

Select the platform of the web server, and select how you want to copy configuration files to the web server computer (in one of two ways):

automatically

You can only select Automatically if the web server and Configuration Manager are installed on the same computer.

manually

Enter the database alias of the client computer to the Oracle8 database. Also, note the directory information so that you can copy the files after the configuration process.

Click OK.

Oracle Installer begins installing Viewer Cartridge files. This process may take several minutes.

After installation is complete, an information message appears with important post-installation instructions.

Copy the files and directories specified in Step 3.
Shut down and restart all web server listeners and services.
Double-click the new Viewer Cartridge icon that appears in the Oracle for Windows NT (or Windows 95) program group to start the Viewer Cartridge.

Configuring Oracle8 ConText Cartridge Configuration Manager

To configure Oracle8 ConText Cartridge Configuration Manager:

Choose Start > Programs > Oracle for Windows NT (or Windows 95) - > Configuration Manager Setup.

Oracle Installer starts, and the Oracle8 ConText Cartridge Configuration Manager Setup dialog box appears:

Enter the appropriate information in each of the fields, and click OK:

Field¹	Description
Machine name	Enter the machine name of the WebServer or Web Application Server.
Admin listener port	Enter the admin listener port of the WebServer or Web Application Server.
Admin listener user and password	Enter the admin listener user and password.
Listener name and port	Enter an existing listener name and port number.
User/Password	Enter the CTXSYS user and password. The default password is CTXSYS.
Connection alias	Enter the database alias for the WebServer or Web Application Server to the Oracle8 database. The alias that you enter here is not the alias that connects the client to the Oracle database.

¹ Ask your web server administrator for assistance with these values.

If your web server is on the same computer as the Configuration Manager, then go to Step 5. Otherwise, the Remote Web Application Server dialog box appears:

Select the platform of the web server, and select how you want to copy configuration files to the web server computer (in one of two ways):

Automatically

You can only select Automatically if the web server and Configuration Manager are installed on the same computer.

Manually

Enter the database alias of the client computer to the Oracle8 database. Also, note the directory information so that you can copy the files after the configuration process.

Click OK.

Oracle Installer begins installing Configuration Manager files. This process may take several minutes.

After installation is complete, an information message appears with important post-installation instructions.

Copy the files and directories specified in Step 3.
Shut down and restart all web server listeners and services.
Double-click the new icon Configuration Manager that appears in the Oracle for Windows NT (or Windows 95) program group to start the Configuration Manager.

Configuring Oracle8 ConText Cartridge Workbench Demo

This section provides instructions for performing the initial set up required to use the Oracle8 ConText Cartridge Workbench sample, CTXFORM.

To set up the CTXFORM demo:

Determine the user you will use to log in to the database in order to use the demo. You can use the supplied user CTXDEMO, or create an Oracle user for the demos.

The CTXDEMO user is provided with the Oracle8 ConText Cartridge. The CTXDEMO user has all of the required privileges to set up and use the demos. The initial password is CTXDEMO.

If you want to create a user, note that in addition to the standard privileges required for an Oracle user, the demo user must have CREATE privileges for the tables and views used in the demos. Also, the demo user must be assigned the CTXAPP role.

To create a demo user:

Start SQL*Plus:

Start SQL*Plus...	By Doing This...
From the MS-DOS command line
From the Taskbar	Choose Start > Programs > Oracle for Windows NT - [HOME_NAME] > SQL*Plus 8.0

SQL> CONNECT CTXSYS/PASSWORD

Enter the following commands:

SQL> GRANT CONNECT, RESOURCE TO MYDEMO IDENTIFIED BY MYDEMO;
SQL> GRANT CTXAPP TO MYDEMO;

where MYDEMO is the newly created user.

Go to the ORACLE_HOME\CTX80\DEMO\INSTALL directory.
Run the IMP80 utility from the MS-DOS command prompt with parameter TABLES=ARTICLES to import the DEMO.DMP file into the schema of the demonstration user:

ORACLE_HOME\CTX80\DEMO\INSTALL> IMP80 CTXSYS/PASSWORD FILE=DEMO.DMP 
IGNORE=Y TABLES=ARTICLES

Importing the DEMO.DMP file:

creates an ARTICLES table for the demonstration user
populates ARTICLES.TEXT with the text of the articles used in the demos

The DEMO.DMP file was originally exported for CTXDEMO. If you specified a user name other than CTXDEMO for your demonstration user, you must include the following parameters when running the Oracle Import utility:

FROMUSER=CTXDEMO
TOUSER=USER_NAME

For example:

IMP80 SYSTEM/PASSWORD FILE=DEMO.DMP FROMUSER=CTXDEMO TOUSER=MYDEMO 
TABLES=ARTICLES

In the example above, a user named SYSTEM imports the ARTICLES table from the DEMO.DMP file created by CTXDEMO into the schema for a user named MYDEMO.

Start a ConText Server with the DDL (D) personality:

C:\ORACLE_HOME\CTX80\DEMO\INSTALL> CTXSRV80 -USER CTXSYS/CTXSYS -
PERSONALITY DDL

Log on to SQL*Plus as the demonstration user, and run the DEMOINST.SQL script:

SQL> @DEMOINST.SQL

This script serves as an example of the tasks that you must perform to set up your tables for processing text queries using Oracle8 ConText Cartridge.

The script creates the policies, preferences, views, and results tables used by the demos and creates a text index for the ARTICLES table.

6 Post-Installation Configuration Tasks