6
Post-Installation Configuration Tasks

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

Specific topics discussed are:

• What Must You Configure?

• Net8

• Oracle Enterprise Manager

• Oracle8 ConText Cartridge Workbench

What Must You Configure?

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

• 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

• any computer to which a Windows 95 or Windows NT Oracle Enterprise Manager Console can remotely connect. The repository can reside in an Oracle database on any platform.

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

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:
   • 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.

3. 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 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:

   C:\> SVRMGR30
   

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

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

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

6. Grant the SYSTEM privileges to this user account:

   SVRMGR> GRANT DBA TO USERNAME;
   

7. Exit Server Manager:

   SVRMGR> EXIT
   

   Exiting Server Manager closes the database connection.

8. Follow Steps 3-6 for additional repository user accounts.

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

   The User Manager window appears:

   
   
3. Choose New User from the User menu.

   The New User dialog box appears:

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

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

   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 clicking Groups.

      The Group Memberships dialog box appears:

      
      
   5. Select Administrators from the Not member of list box and click <- 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.

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

   The user is added and the User Manager window reappears.

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

   The User Rights Policy dialog box appears:

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

8. 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 name of the local host computer 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.

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

   The User Manager window reappears.

10. Click Exit from the User menu.

11. Repeat Steps 1-9 for any other repository user accounts you created.

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

   The Oracle Enterprise Manager Repository Login Information dialog box appears.

3. 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:

   
   
4. Click OK.

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

5. Click Continue to dismiss this dialog box.

   The Discover New Services Wizard appears:

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

7. Click Close.

   The Oracle Enterprise Manager Console appears:

   
   

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

• Configuring Oracle8 ConText Cartridge Viewer Cartridge

• Configuring Oracle8 ConText Cartridge Configuration Manager

• Configuring Oracle8 ConText Cartridge Workbench Demo

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

Appendix C of the Oracle8 ConText Cartridge Application Developer's Guide describes how to configure the CTXQUERY demo.