4
Configuring the Console when Connected to a Management Server

Beginning with Release 9.0 when you start the Enterprise Manager Console or various other Enterprise Manager applications, you are prompted to choose between starting the product standalone (that is, not connecting to the middle tier Management Server) or starting the product with a Management Server connection. While starting the Console standalone enables a single administrator to perform direct database administration, starting the Console by connecting to a middle tier Management Server provides more comprehensive management capabilities, such as sharing of administrative data among multiple administrators, being proactively notified of potential problems, and automating repetitive administrative tasks. This chapter will describe how to configure the Enterprise Manager Console when it is connected to a middle tier Management Server.

The following topics will be discussed:

• Starting the Console with a Management Server Connection
• Discovering Nodes in Your Environment
• Creating Administrator Accounts
• Granting OEM_MONITOR Role to Database Preferred Credentials
• Enabling the Job System
• Configuring the E-mail Server
• Starting the Enterprise Manager Paging Server
• Configuring Enterprise Manager Reporting
• Configuring the Console If Using a Dialup Line
• Using System Colors for Windows
• Customizing Access to Enterprise Manager's Areas of Database Management
• Using Oracle LogMiner Viewer

Choosing to Start the Console by Logging into a Management Server

When you start the Enterprise Manager Console, you are prompted to choose between starting the product standalone or starting it with a Management Server connection.

Figure 4-1 Oracle Enterprise Manager Console Login

Text description of the illustration login.gif

Choose to start the Console by logging into a Management Server when you want access to functionality such as:

• Management of several different target types. For example, a target type may include databases, web servers, application servers, applications, or others.
• Sharing of administrative data among multiple administrators
• Proactive notification of potential problems
• Automation of repetitive administrative tasks
• Backup and data management tools
• Customization, scheduling, and publishing of reports
• Running the client from within a web browser
• LogMiner Viewer

Figure 4-2 Console Connected to a Management Server

Text description of the illustration console.gif

Starting the Console with a Management Server Connection

On Windows-based platforms, you start the Console from the Windows Start Menu.

On any supported platform, you can start the Console from the command line by using the command:

oemapp console

On UNIX platforms, the oemapp part of the command line is case-sensitive and must be entered with lowercase characters.

All of the above options prompt you with the Oracle Enterprise Manager Console Login. If you want to bypass the Oracle Enterprise Manager Console Login, you can enter the following command at the command line to automatically login to the Console by connecting to a Management Server:

oemapp console oem.loginmode=

oms oem.credential=<username>/<password>@<management server>

Figure 4-3 Oracle Enterprise Manager Console Login

Text description of the illustration login.gif

When the Oracle Enterprise Manager Console Login appears, select the Login to the Management Server option and if this is the first time you have logged in to the Management Server, enter the Enterprise Manager administrator name and password, which are the default credentials, and the Management Server machine name. The default Enterprise Manager administrator name is sysman and its password is oem_temp. The Management Server on the node you select or enter must be one which is already configured with the repository you want to access.

If the name of the node where the Management Server is running does not appear in the list, you can either enter the node name in the field or follow these instructions:

1. Click Management Servers, which is located to the right of the Management Server field. The Management Servers dialog appears.
2. Click Add. The Add Management Server dialog appears.
3. Enter the name of the node where the Management Server is running and click OK.

If you add a Management Server using the Management Server dialog it becomes the current choice when you return to the login dialog.

After the initial login with sysman/oem_temp, a security dialog appears where you can change the default sysman password. The password you specify is not case sensitive. Other than spaces at the beginning or at the end of the password, you can specify any character in an Enterprise Manager Administrator's password.

Discovering Nodes in Your Environment

Oracle Enterprise Manager provides a Discovery Wizard for identifying network nodes and machines and populating the Console Navigator with these discovered nodes and targets. The discovered targets, such as databases and listeners, can then be administered with Enterprise Manager.

The Console is the central location for management and therefore the window from which you would see all the targets you are managing.

During start up of the Console, any manageable targets on the machine where the Management Server is running are automatically discovered if the Intelligent Agent is installed and running on that Management Server machine. The Console Navigator then displays all those discovered targets.

To discover additional nodes and targets which reside on nodes within your environment:

1. Choose Discover Nodes from the Navigator menu.
2. When the Discovery Wizard appears, read the introduction and click Next to continue.
3. When the Specify Nodes page appears, enter the name of the node or the IP address in the field. You can also discover targets on multiple nodes at one time by entering each node or IP address you want to discover separated by a space, comma, tab, or new line within the field or using the Import button to import a text file of node names. Then click Next to continue.
4. A Progress page appears, showing you the status of the node discovery. A checkmark indicates that the node was discovered successfully. An X indicates that the discovery has failed. If an error occurs, an error message explaining the reason for the error appears, giving you insight on how to continue. After the discovery process has completed, click Finish.
5. A Discovery Results dialog appears, telling you which nodes have or have not been automatically discovered. Click OK to close the dialog.

   If nodes have failed automatic discovery, you can click Next on the Progress page. On the Errors page, you will have the option to retry, skip, or perform a manual discovery on the failed nodes.

   If no Intelligent Agent is running for some nodes which failed to be discovered, you can still add the node to the navigator, and add databases to that node using manual discovery.

   During manual discovery, you will be prompted for the following information:

   • database name
   • SID
   • TCP/IP port to use for the communication

   When a node is manually added, you cannot register events or submit jobs against the node.

   Note: Manually discovered nodes must be dropped from the Navigator before they can be automatically discovered.

   
   
   

   If a node cannot be discovered, check if the node is down or if the node does not have an Intelligent Agent running. You can also check if you are using the TCP/IP network protocol. See the Oracle Enterprise Manager Administrator's Guide for more information on discovering nodes.

   Note: If you discover two or more targets with the exact same name, regardless of the target type, only one of the discovered targets will appear in the Navigator.

   
   
   
6. If regular Enterprise Manager administrators are defined, an Access to Target page appears, allowing a super administrator to control what appears in the Console Navigator for regular Enterprise Manager administrators. This lets the super administrator create customized Navigators for specific users. The page provides a multi-column list. The first column shows all objects that appear in the Console Navigator. Clicking the + next to the object's name expands the object. One column exists for each Enterprise Manager administrator defined by the super administrator. To allow a regular administrator to see a particular object within the Navigator, in the column belonging to that administrator, select the box in the row corresponding to the Navigator entry.
7. Click Finish.

Creating Administrator Accounts

Enterprise Manager is a multi-administrator system: every person who is administering systems using Enterprise Manager has his or her own administrator account which he or she uses to log into the Console by connecting to a Management Server.

The installation of Enterprise Manager creates a Reports user and a Super Administrator named sysman. The Super Administrator sysman can create administrators using the Manage Administrators item in the Configuration menu. In addition to an administrator name and password, each account can be tagged as a Super Administrator account or an account to which the administrator has access to only jobs, or events, or both.

Differences between the two types of accounts are as follows:

• Super Administrators automatically have full privileges for all objects in the system. To provide greater security, only Super Administrators can discover, refresh, or remove targets from the Console Navigator.

  Most Super Administrators also have a separate account for daily operations but use their Super Administrator account for special operations only available to Super Administrators, such as creating new Enterprise Manager Administrators, configuring paging or e-mail servers, defining management regions, or granting other administrators access to targets. Using the sysman account for daily administration work is not recommended. The Super Administrator account is similar to root on UNIX or Administrator on Windows NT and is a user which cannot be deleted or renamed. It is a user that can perform any task and therefore should be used only for setting up the environment.

• Regular Administrators can have access to a subset of Console operations and will only see these targets to which they have been granted access by the Super Administrator. For detailed information about customizing what administrators can see, refer to the Oracle Enterprise Manager Administrator's Guide.

Typically, all administrators share a single Enterprise Manager repository, which enables administrators to share information. The Enterprise Manager repository is one in which Management Servers share; it is not a standalone repository. Although you can set up multiple repositories, administrators using different repositories will not have access to each other's information; there is no sharing of data between repositories. Administrative data stored in the repository is filtered based on administrator permissions.

Preferred Credentials must be set up for each administrator account. When an administrator connects to managed targets through the Management Server, the preferred credentials used are those defined explicitly for that administrator.

See the Oracle Enterprise Manager Administrator's Guide for information on how Enterprise Manager administrators are created, edited, and deleted with the Manage Administrators option of the Console Configuration menu.

Granting OEM_MONITOR Role to Database Preferred Credentials

Beginning with Oracle 8.0.6 databases and higher, the OEM_MONITOR role is created by the Oracle database creation scripts. This role permits access to database functionality within Enterprise Manager, such as registering events against a database or browsing through the objects in a database through the Console Navigator. These types of functionality require database credentials on which to perform these operations. Rather than granting the powerful DBA role to the database credentials, many administrators prefer to provide only the necessary privileges required to do these operations. Granting the OEM_MONITOR role to the database credentials, ensures that the user has the minimum sufficient privileges required for these operations.

You must perform the following steps:

1. Create a role called OEM_MONITOR

   drop role OEM_MONITOR;
   create role OEM_MONITOR:
   
   

2. Grant the "connect" role to OEM_MONITOR

   grant connect to OEM_MONITOR;
   
   

3. Grant the "analyze any" and "create table" system privileges to OEM_MONITOR

   grant analyze any to OEM_MONITOR;
   grant create table to OEM_MONITOR;
   
   

4. Create the SELECT_CATALOG_ROLE role as defined in sc_role.sql.
5. Grant the SELECT_CATALOG_ROLE to the OEM_MONITOR role

   grant select_catalog_role to OEM_MONITOR;
   

You are now ready to grant the OEM_MONITOR role to the database user that will be used as "database preferred credentials" in Enterprise Manager. In addition to granting the OEM_MONITOR role to a user, you must also ensure that the QUOTA for the user account is set to UNLIMITED.

The Continued Row event test needs to analyze results into a table so it needs both the "analyze any" and "create table" privileges.

Enabling the Job System

In order for Enterprise Manager administrators to be able to successfully submit jobs, certain configuration steps must be performed:

• An operating system user account must exist with the advanced user right, "logon as batch job" on any Intelligent Agent machine to which administrators plan to submit jobs. This applies to Intelligent Agent machines running on Windows NT, Windows 2000, and Windows XP platforms.
• For Windows NT, Windows 2000, and Windows XP, the user must be a member of the Administrators group. For details on creating a new operating system user or editing an existing user for this purpose, refer to the sections further below.
• Preferred credentials must be set for any node to which jobs will be submitted. The preferred credentials that are used on Windows NT, Windows 2000, and Windows XP must be the same as the operating system user account with the advanced user right "logon as batch job." For more details on preferred credentials, see the Oracle Enterprise Manager Administrator's Guide.
• The operating system user account with advanced user rights must have read/write permissions to ORACLE_HOME\NETWORK directory as well as read, write, update, and delete permissions to the TEMP directory or the ORACLE_HOME directory.

In addition, because the output of some jobs may be quite large, you have the option in Oracle Enterprise Manager to specify the maximum size for any job output. For details, see the Oracle Enterprise Manager Administrator's Guide.

Creating a New Windows NT User Account

To create a new Windows NT user account on the Windows NT machine where the Intelligent Agent is installed and grant the "log in as batch jobs" privilege to this user, perform the procedure below.

1. From the Windows Start Menu, select Programs > Administrative Tools > User Manager.
2. Select New User from the User menu and check for the following:
   • The User Must Change Password at the Next Logon option is not selected.
   • SYSTEM or system is not used for the user name.
3. Click Groups in the New User page.
4. Click the left-arrow button to move the Administrators item in the Not a Member of list to the Member of list. Click OK.
5. In the User Manager window, choose User Rights from the Policies menu.
6. Select the Show Advanced User Rights option.
7. Select "Logon as a batch job" from the Right list.
8. Give the selected user this privilege.

Assigning Privileges to an Existing Windows NT User Account

Alternately, to assign privileges to an existing local user account, perform the following steps.

1. Double-click the user on the User Manager panel and check for the following:
   • The User Must Change Password at the Next Logon option is not selected.
   • SYSTEM or system is not used for the user name.
2. Click Groups in the User Properties page.
3. Click the left-arrow button to move the Administrators item in the Not a Member of list to the Member of list. Click OK.
4. In the User Manager window, choose User Rights from the Policies menu.
5. Select the Show Advanced User Rights option.
6. Select "Logon as a batch job" from the Right list.
7. Click Add. The Add Users and Group window appears.
   1. Select your domain from the List Names From list.
   2. Click Show Users.
   3. Select the domain user from the list.
   4. Click Add.
   5. Click OK.
8. In the User Rights Policy dialog, click OK.

Configuring a Windows NT Domain User as Your Intelligent Agent User

1. Alternately, to configure a domain user as your Intelligent Agent user, perform the following steps.
2. In the User Manager window, choose User Rights from the Policies menu.
3. Select the Show Advanced User Rights option.
4. Select "Logon as a batch job" from the Right list.
5. Click Add.
   1. Select your domain from the List Names From list.
   2. Click Show Users.
   3. Select the domain user from the list.
   4. Click Add.
   5. Click OK.
6. In the User Rights Policy dialog, click OK.

Configuring the E-mail Server

To enable administrators to receive e-mail notifications, super administrators must first configure the e-mail server from the Console:

1. From the Console Configuration menu, choose Configure Paging/Email. The Configure Paging/Email dialog appears. By default, the Email Configuration is already selected.
2. Enter the node on which the SMTP mail gateway resides in the SMTP Mail Gateway field. For example, mailserver.company.com.
3. Enter the name you want to use to identify the sender of the e-mail in the Sender's SMTP Mail Address field.

After completing the SMTP mail configuration, notification and schedule preferences should be specified for all administrators who want to receive e-mail notifications. See the Oracle Enterprise Manager Administrator's Guide for details.

Starting the Enterprise Manager Paging Server

Enterprise Manager bundles its own Paging Server which enables administrators to receive notifications on events and jobs on their pagers. Both numeric and alphanumeric pagers are supported; however, alphanumeric pagers must utilize one of the following paging service protocols:

• TAP (Telocator Alphanumeric Protocol)
• GSM (Global System for Mobile Communications)
• FLEX-TD (FLEX Time-Diversity Protocol)

Most paging service providers support the sending of e-mail messages to pagers. If your provider offers the option of sending e-mail; then, you can choose not to install and configure the Enterprise Manager Paging Server.

If you choose not to install our Paging Server, you can specify the e-mail address of your pager as the Receiver's Email address when you configure your e-mail notification preferences (Figure 4-4, "Email Preferences") or your paging notification preferences (Figure 4-5, "Paging Preferences").

Figure 4-4 Email Preferences

Text description of the illustration emailnot.jpg

Figure 4-5 Paging Preferences

Text description of the illustration pageviae.jpg

If you specify paging through email using the paging preferences, it will be based on your pager notification's schedule and filters. In Enterprise Manager, you can distinguish the e-mail notification's schedule and filters from the pager notification's schedule and filters. Refer to Figure 4-6, "Email and Paging Filters" and Figure 4-7, "Paging Schedule" below.

Figure 4-6 Email and Paging Filters

Text description of the illustration filter.jpg

Figure 4-7 Paging Schedule

Text description of the illustration schedule.jpg

Administrators can specify an email address or several email addresses separated by a comma for email notifications as well as either a phone number or an email address for paging notifications. This lets administrators specify different schedules, filters, and message formatting for both methods of notification. See the Oracle Enterprise Manager Administrator's Guide for details.

Figure 4-8 Paging through Paging Server

Text description of the illustration pageviap.jpg

The Enterprise Manager Paging Server is automatically installed with the Oracle Management Server on Windows NT, Windows 2000, or Windows XP; it is not installable for any UNIX platform.

While you can install the Paging Server only on certain Windows platforms, you can configure the Paging Server from the Enterprise Manager Console on any Windows or UNIX operating system.

Only one Paging Server is necessary for an Enterprise Manager deployment.

There are two most common options for deploying the Paging Server.

In the deployment shown in Figure 4-9, "Management Server on Windows NT Machine", the Console is on one machine, and the Management Server is on another Windows NT machine (connecting to repository). The Paging Server and modem are on the same Windows NT machine as the Management Server.

Figure 4-9 Management Server on Windows NT Machine

Text description of the illustration ntpage.gif

In the deployment shown Figure 4-10, "Management Server on UNIX Machine",

the Console is on one machine and Management Server is on another UNIX machine (connecting to the repository). The Paging Server and modem are on a Windows NT machine.

Figure 4-10 Management Server on UNIX Machine

Text description of the illustration unixpage.gif

The installation of the Enterprise Manager Paging Server does not automatically start the Paging Server service nor does it configure it. After installation, you must specify the modem settings, start the Paging Server service manually, and configure the Paging Server from the Enterprise Manager Console.

To specify the modem settings:

1. From the Start menu, choose Settings > Control Panel.
2. Double-click Modems (Windows NT).
3. Click Dialing Properties in the Modem Properties page to specify how your calls are dialed by setting the following parameters:
   • From what area code you are dialing
   • From what country you are dialing
   • How you access an outside line. If you are not required to dial a number to access an outside line, leave this field blank.
4. Click OK in the Dialing Properties page.
5. In the Modem Properties page, click Properties to set the Maximum Speed parameter. Click OK. Oracle recommends setting this parameter to 9600K Baud; however, you should find the baud rate setting optimal for your system.

To start the Paging Server:

1. From the Start menu, choose Settings > Control Panel.
2. Double-click Services.
3. Select the Oracle<ORACLE_HOME_NAME>PagingService and click Start.

You can also start the paging server by typing the following at a command prompt

oemctl start paging

Configuring the Enterprise Manager Paging Server

To enable administrators to receive paging notifications through the Enterprise Manager Paging Server, super administrators must first configure the Paging Server from the Console.

Adding a Paging Server

To add a paging server to the Enterprise Manager Console, perform the following operations:

1. Choose Configure Paging/Email from the Configuration menu. The Configure Paging/Email property sheet appears.
2. Click Paging Configuration in the list to display current paging server information.
3. Click Add Server. The Add Paging Server dialog appears.
4. Enter the name of the machine on which the paging server runs. For example, smpqa-pc.
5. Click OK.

If the Console is unable to find the paging server with the given hostname, an error appears.

If the paging server is found, a new paging server object is added under the Paging Configuration object in the list. The new paging server will have no paging carrier. You must add at least one paging carrier in order for paging to function.

Adding Paging Carrier

1. Choose Configure Paging/Email from the Configuration menu. The Configure Paging/Email property sheet appears.
2. Expand the Paging Configuration object in the list. Click one of the paging servers you added previously and click the Add Carrier button in the detail view to the right. The Add Paging Carrier dialog appears.
3. Enter the requisite information in the text entry fields. Once the paging carrier is defined, you can view the paging carriers by expanding the appropriate paging server and carrier objects in the Configure Paging/Email list. See Figure 4-11, "Add Paging Carrier Dialog"
4. Click OK.

Figure 4-11 Add Paging Carrier Dialog

Text description of the illustration addcarri.gif

• Name

  Paging carrier name. Field accepts alphanumeric characters and underscores.

• Type

  Type of paging carrier. Enterprise Manager supports alphanumeric or numeric.

• Protocol

  TAP, FLEX-TD, or GSM. Protocol selection is only available if the carrier type is Alphanumeric.

• Connection Properties
  • Country Code: The country code used to dial the pager if the call is international.
  • Area Code: Area code used by the country in which the pager is located.
  • Number: Local dialing number of the pager.
  • Suffix: Permits identification of voice messages from a paging carrier and enables the person being paged to choose from several options when using a touch tone phone. For example, commas can be used as pauses. The Suffix field accepts the following characters: integers, commas, pound sign, and the star (asterisk). This option is only available if the paging carrier type is set to Numeric.
• Dialing Properties
  • Timeout (in seconds): Maximum dialing time allowed for a successful page.
  • Delay (in seconds): Time delay before dialing. This option is only available if the paging carrier type is set to Numeric.

Specifying Paging Notification Preferences

After completing paging server configuration, notification and schedule preferences should be specified for all administrators who want to receive page notifications. See the Oracle Enterprise Manager Administrator's Guide for details.

Configuring Enterprise Manager Reporting

The Enterprise Manager reporting system provides flexible reporting functionality to administrators, permitting quick and easy access to information about the status of all monitored systems in their enterprise. Administrators can create, schedule, and publish a wide variety of enterprise system reports. When published to a web site, these reports can be accessed by a wider audience, enabling anyone from administrators to managers to executives to quickly access information regarding their monitored enterprise.

In order to access published reports, ensure that the Enterprise Manager Web Site component has been installed. By default, it is installed with the Management Server under the Oracle_Home/oem_webstage directory. In addition, the Enterprise Manager Web Site automatically installs a preconfigured Oracle HTTP Server to act as the reporting web server. This is the same HTTP Server that is used by default for the browser-based Enterprise Manager.

When you install the Management Server, a preconfigured Oracle HTTP Server is automatically installed and started for you, and this HTTP Server will serve as the reporting web server (this is the same web server as is used for browser-based Enterprise Manager). In addition, reporting functionality is also automatically installed. However, there are additional, manual steps you must perform in order to access the Enterprise Manager Reporting Web site.

Steps to Perform from the Console

1. Change the default password (oem_temp) for the REPORTS_USER administrator.
   1. From the Enterprise Manager Console, choose Manage Administrators from the Configuration menu. The Manage Administrators Accounts dialog appears.
   2. Select REPORTS_USER from the list.
   3. Click Edit. The Edit Administrator Preferences property sheet appears.
   4. Enter a new password in the Password field and retype the new password in the Confirm Password field.
   5. Click OK to set the password.
2. Set preferred credentials for the REPORTS_USER if you want to see database reports from the central Enterprise Manager Reporting Web Site. Any future database reports that other Enterprise Manager administrators create will also have to set their own database preferred credentials.
3. Register target up/down events for the all services you want valuable Service Level Reports against; otherwise, the Availability by Service Report shows 100% uptime for services that have no availability data collected, but the text following the Overall Availability bar chart will denote that no data was available for reporting.
4. If you want to see a Trending tab with trending information on the Reporting Web Site, you will need to have collections and affiliated analyses available from Capacity Planner. If you do not have these, the Trending tab will not appear.

Steps to Perform from the Management Server/HTTP Server Machine

1. Ensure Management Server process is started.
2. If the machine is UNIX:
   1. Execute the xhost +<host> command on the X Window machine where you are accessing reports from a web browser. For example, if your reporting web server is running on host servlet1 and the X Window is running on host xserv1, then execute the following command on xserv1: xhost +servlet1
   2. Specify the DISPLAY environment variable with the X Window machine name on the host where the reporting web server is running. For example, if your reporting web server is running on host servlet1 and the X Window is running on host xserv1, then execute the following command on servlet1:
      • if the command shell is C Shell: setenv DISPLAY xserv1:0.0
      • if the command shell is B or K Shell: DISPLAY=xwerv1:0.0; export DISPLAY
   3. Verify that the X Window environment has been configured properly. For example, execute the xclock command. If you see the xclock window on your X Server (reporting web server), your X Window environment has been configured properly.
3. Stop and restart the Oracle HTTP Server using apachectl stop and apachectl start.
4. Review the oem.conf file located in $ORACLE_HOME/oem_webstage/ directory, and note the ServerName directive value.
5. From the $ORACLE_HOME/bin directory of the Management Server/HTTP Server, run oemctl configure rws. You will be prompted to supply the following information:
   • Webserver host name: Specify the same name as what is used as the ServerName directive in oem.conf from Step 4 above.
   • Webserver port number: The default is 3339.
   • Oracle Management Server host name: Specify the same name as what is used as the ServerName directive in oem.conf from Step 4 above.
   • Password for REPORTS_USER: The password specified cannot be oem_temp; you must modify the password as indicated in Step 1 in the "Steps to Perform from the Console" section.
   • Whether you would like to specify an alternate location for historical data.

     You can put your historical data in either the Oracle Management Server repository (no) or a separate repository (yes). The default is no, store historical data in the Management Server repository. If you are storing the collections in a separate database, you will have to provide the username, password, and alias for that alternate database.

Access Reporting Web Site URL

1. Enter the URL

   http://<webserver host name>:3339
   
   

2. Click the Access Reports button.

   Note: If you plan to launch reports on Windows 2000 using Internet Information Server (IIS) 5.0 instead of the Oracle HTTP Server, you need to modify the oem.conf file to configure reports on port 8099. Port 3339 is used for the Oracle HTTP Server which ships with 9.2.0, and port 8099 is the port used for Internet Information Server (IIS) web server. To launch reports, enter the URL: http://<webserver host name>:8099 and click the Access Reports button.

   
   
   

   Note about Service Availability Reports

   When a node experiences an outage, the Service Availability reports show the outage as "unknown time" rather than downtime. This is consistent with the node's state that you will see in the Console or Reporting Home Page. Node availability is determined by pinging the Agent, and not the node. When the Agent is unreachable, the node is in an unknown state. There may be a network latency or outage or the node may be down.

   Configuring the Console If Using a Dialup Line

   You must have the correct TCP/IP configuration; incorrect TCP/IP configurations result in timeouts and lost connections.

   Note: Dynamic IP addresses attributed by DHCP are not supported on nodes running the Management Server or an Intelligent Agent. DHCP is supported only on Enterprise Manager clients.

   
   
   

   When the Console connects over a dialup line, the Console machine obtains a dynamic IP address. This dynamic IP address needs to be sent by the operating system (Windows 2000, Windows NT, Windows 98) to the Enterprise Manager application.

   In order for the operating system to return the correct IP address, the network communication protocol (TCP-IP) needs to be configured to obtain the IP address using the Dynamic Host Configuration Protocol (DHCP).

   To specify the setting:

   1. From the Start menu, choose Settings > Control Panel.
   2. Double-click Network.
   3. Select the Protocols tab.
   4. Double-click TCP-IP Protocol.

   IMPORTANT:

   You must make note of your previous settings in order to return to those settings when you connect the same machine to the network through the ethernet. Copy the Settings specified in IP Address, Subnet Mask and Default Gateway to a file.

   5. In the IP Address page, select the Obtain an IP address from a DHCP Server option.
   6. Click OK.
   7. Connect to the network through your dial-up line. You will now be able to start the Console.

   Note: If you are not running from a web browser, you may need to restart your system after making the changes.

   
   
   

   Using System Colors for Windows

   You can set the preferred color by adding this line to the $ORACLE_HOME/sysman/config/ClientConfig.properties file:

   user.color.scheme=System
   
   

   The value can be any valid color scheme. Currently available color schemes are blue, khaki, olive, purple, red, teal, titanium, or System. The values are not case sensitive.

   Blue, khaki, olive, purple, red, teal, titanium, and System are the currently known values for this property. Setting the user.color.scheme property will change the color scheme in the Console with the basic color as the named color in the property. System is the only one that takes the system default properties.

   If the color scheme you are trying to use does not seem to take effect, turn on client tracing using the oemapp trace console command. Use level two tracing. In the trace output, search for "Color Scheme." The information is at the top of the trace output. If an incorrect value is entered, the following will appear in the trace file:

   Unrecognized Color Scheme: <>
   Color Schemes: ...
   

   Customizing Access to Enterprise Manager's Areas of Database Management

   You can restrict access to certain areas of database management in Oracle Enterprise Manager 9i so that the database management information will not appear in the navigator.

   Note: Because manual editing is error prone, backing up the OEMClient.properties file prior to editing is strongly recommended to ensure that the current Oracle Enterprise Manager environment can be recovered in cases of any error. The data in the file is crucial and the edits must be free of error to be of any use.

   
   
   

   For example, a DBA whose role is only to create new users will only need access to Security Management. He will not need access to Schema Management, Instance Management, Storage Management, and others.

   Note: Restricting access applies to database management. You cannot customize access with this procedure for Events, Jobs, Groups, and others.

   
   
   

   To restrict database management access:

   1. Locate the OEMClient.properties file in the client's ORACLE_HOME\sysman\config directory.
   2. Make a backup of the OEMClient.properties file so that you can back out of the procedure should an error occur.
   3. Locate the pair of entries that contain "/category/"

      For example,

      /com/oracle/sysman/em/category/storage/order=3
      /com/oracle/sysman/em/category/storage/class=oracle.sysman.vtg.VtgStorageCategory
      

   4. Comment out the two entries per area of management with a pound sign, #.

      For example,

      #/com/oracle/sysman/em/category/storage/order=3
      #/com/oracle/sysman/em/category/storage/class=oracle.sysman.vtg.VtgStorageCategory
      
      

      The area of management will no longer appear in the navigator under the database or databases that are managed.

      Using Oracle LogMiner Viewer

      Oracle LogMiner Viewer provides an easy-to-use graphical user interface to the Oracle9i LogMiner utility. LogMiner Viewer can be used to query online and archived redo log files to analyze the activity that has taken place in a database. Users can select redo log files, specify filters to be applied to the data, view query results and save the query and results for future use.

      You can launch LogMiner Viewer either through the Oracle Enterprise Manager Console or as a separate application.

      Using the Enterprise Manager Console

      To launch LogMiner Viewer through the Oracle Enterprise Manager Console, you must log into the Oracle Management Server. You cannot launch LogMiner Viewer if you launch the Oracle Enterprise Manager Console in standalone mode.

      After you log into the console, choose Tools > choose Database Applications > LogMiner Viewer to start LogMiner Viewer.

      Launching LogMiner Viewer as a Separate Application

      To launch LogMiner Viewer as a separate application, you must decide whether to log into the Oracle Management Server or to launch in standalone mode:

      • Logging into the Oracle Management Server gives you access to all databases on the discovered nodes. Any discovered databases appear in the Navigator tree.
      • Launching in standalone mode gives you access to all databases that you added to the Oracle Enterprise Manager Console. The databases that you added appear in the Navigator tree. Information about the databases is kept in a local record.

      To invoke LogMiner Viewer as a separate application:

      • On UNIX platforms, enter:

        oemapp lmviewer
        

      • On Windows NT, from the Programs menu, choose Oracle_home > Database Administration > LogMiner Viewer

      For more information, see the Oracle Enterprise Manager Help.