Oracle8 Client Getting Started for Windows NT and Windows 95 Release 8.0.3 A54632_01

Library Product Contents Index

4
Configuring Oracle Enterprise Manager

This chapter describes post-installation configuration tasks for Oracle8 Client for Windows NT and Windows 95.

Specific topics discussed are:

• Configuring Net8
• Configuring Oracle Enterprise Manager

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 Client option
• Oracle Net8 Assistant from Custom Installation

Additional Information: See Oracle Net8 Getting Started for Windows NT/95 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

If you are connecting to a Windows NT database, follow all of the steps below. If you are connecting to a non-Windows NT database, complete steps 4 and 5 only.

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 Client for Windows NT and Windows 95 server.

To create a user account on the Oracle8 Client for Windows NT and Windows 95 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:

Prev Next

Copyright © 1997 Oracle Corporation. All Rights Reserved.

Library Product Contents Index