Oracle Enterprise Manager Configuration Guide Release 2.2 Part Number A85247-01 |
|
Please check the compatibility matrix in the Oracle Enterprise Manager Readme before installing or using Oracle Enterprise Manager. emreadme.txt
or emreadme.html
is located in the ORACLE_HOME\RelNotes\EM
directory. For example, C:\Oracle\Ora81\RelNotes\EM
.
This chapter describes possible troubleshooting issues.
When you use Oracle Enterprise Manager and encounter problems, you can turn to many sources for help.
Before you contact Oracle Technical Support, please take the time to consult your manuals and the Oracle Enterprise Manager Readme. A list of Oracle Enterprise Manager manuals are listed in the Preface under Documentation Set on page xv.
Manuals of particular interest are listed below:
In addition to the manuals and online help, Oracle offers OracleMetaLink, an electronic support service available to Oraclemetals (Gold, Silver, Bronze) customers, 24 hours a day, seven days a week. Customers can register on-line through http://www.oracle.com/support
.
MetaLink 2.0 includes the following features:
Uses push technology to provide you with proactive notifications. My Headlines gives you the ability to customize information in your user profile such that you get only the specific information you desire when you access the My Headlines section of MetaLink. You can also choose to have this information sent to you via email. The information delivered to you falls into the following categories and can be personalized by product and platform: News & Notes, Knowledge Base, Patches, Bugs, TAR Updates, Product Lifecycle, and Forum Updates.
Gives companies the ability to manage access of MetaLink users at the support identifier/CSI level. In situations where you want to restrict the access to certain areas of MetaLink to specific users at your site, this feature enables that control. For example, only internal help desk employees at your site may be allowed to create TARs in MetaLink.
You can update your contact information, add and remove support identifiers, view other users registered under the same support identifier, customize MetaLink, change your password, and view your license information. You will now have a choice of languages in which to view the MetaLink interface: English, German, or French.
Organized by product and platform, these libraries enable you to access information that support analysts have determined will aid you in your installation and use of Oracle products (documentation, white papers, problem/solution articles, and more).
You can post questions to technical analysts and receive responses within two business days. Users also share information and ideas with other Oracle users.
Previously referred to as Download, this section provides you the ability to download patches and patch sets directly from within MetaLink. View the Readme files to find out which bugs have been fixed in the patch sets.
Allows you to do a full-text search against the internal repositories within Oracle Support Services. Advanced searching is also available.
Provides you with query access to published header and abstract information in the Oracle Bug Database.
If the manuals and MetaLink do not answer your questions, contact Oracle Technical Support and provide them with the following information:
The Oracle Enterprise Manager Release 2.2 system supports tracing and logging. Tracing is the writing of data to a display for informational purposes. Logging is the redirection of trace information to a file.
This appendix discusses the following topics:
For information about logging and tracing for the Intelligent Agent, refer to the Oracle Intelligent Agent User's Guide.
Logging and tracing of the Management Server is specified in the omsconfig.properties
file, located in the $ORACLE_HOME\sysman\config
directory.
The logging and tracing properties are listed below:
A
ctivates/deactivates tracing. Default is false.
A
ctivates/deactivates logging. Default is false.
Default is $ORACLE_HOME\sysman\log.
Set value to specify the detail of trace information to collect if tracing is enabled.
Possible values for <oem_trace_levels>
are listed below:
Defaults to oms.log.0
, oms.log.1
, oms.log.2
, and so on.
Controls the total maximum size of the log files. The value you specify for the LOGGING.MAX_SIZE
property is in MB. Its default value is 50 and will result in two log files of max size 25MB. Setting the parameter to 0 indicates that a single log file will be used with no limit.
Defines the maximum number of files the log will span at any given time. The cumulative size of all the files would be less than or equal to LOGGING.MAXSIZE.
Default value is 2.
If LOGGING.MAX_SIZE=0 (unlimited log size), LOGGING.MAX_FILE_CNT will not make sense and hence ignored.
Note: LOGGING.MAX_SIZE and LOGGING.MAX_FILE_CNT control how much disk space is used for the Management Server log files. You can affect the size and disk usage of the log files with these parameters. |
A true value indicates that the Management Server is to rename any existing log files from a previous Management Server invocation. Such log files would be appended with a timestamp (format: yyyyMMddHHmmss
) when they are renamed.
Default value is false.
Note: When you enable logging and tracing, you automatically enable Backup and Data Management logging and tracing. |
The Management Server places all its trace messages in Management Server log files (oms.log.0
, oms.log.1
, oms.log.2
, and so on). It writes to one log file, and when the log file is full, it writes to the next file, recycling the last two files.
The Management Server's log files have size limits. By default, when the Management Server starts, it can only create log files with a size of 25 MB. The initial log file name is oms.log.0. If the file reaches its 25 MB limit, a separate log file is created. The separate log file name is oms.log.1
. If that file reaches its 25 MB limit, the oms.log.0
file is deleted and a new log file, oms.log.2
, is created. The last two log files are kept.
Important Note:
When the Management Server starts, all previous log files of the name |
To activate client tracing of all client applications integrated with Enterprise Manager, add and save the following parameters and values for the clientconfig.properties
file, located in the $ORACLE_HOME\sysman\config
directory.
TRACING.ENABLED=TRUE TRACING.LEVEL=2
In addition, for Windows NT only, open a DOS window and set the following environment variable:
C:\>SET ORACLE_OEM_CLIENTTRACE=TRUE
Then start a client application from the command line using the OEMAPP script.
For example
oemapp console
Note: You cannot start an application using icons or shortcuts if you want to trace it and redirect its output to a file. |
If you encounter problems bringing up Oracle Enterprise Manager in a browser, collect tracing information before reporting the problem to Oracle Support Services.
To set up tracing for your browser perform the following steps:
From the Windows Start menu, click Programs-> JInitiator Control Panel. A window appears.
The Java Console window appears, showing the Java classes loaded by the plugin as well as any exceptions that may occur. If no exceptions are displayed, clear the screen (by clicking the Clear button) every 3rd or 4th screen-full of displayed information.
The paging service can be debugged and traced separately from the Management Server. Tracing for the paging server is disabled by default. If tracing is enabled, the server writes trace statements for all telephone line handling and any successes or failures. Since information is logged whenever a page is sent, the log file grows proportionally to the number of pages sent. To delete a tracing file, you must shut down the paging server and delete the file.
The installation of the Oracle Enterprise Manager Paging Server provides a template configuration file, paging.cfg.template
, located in the ORACLE_HOME\sysman\config
directory.
paging.cfg.template
file to the paging.cfg
file, which is also located in the ORACLE_HOME\sysman\config
directory.
Oracle recommends copying this file (not renaming it) to retain information. If you do not copy this file, all comments concerning paging configuration will be removed. In addition, when updates to Enterprise Manager software are made, any configuration will be lost and not retrievable.
paging.cfg.template
file, modify the paging.cfg
file according to your tracing needs and save it.
In the paging.cfg
file, the following parameters influence the tracing:
Set value for debugging purposes; paging service will then track what paging is occurring by writing trace statements for all telephone line handling and any successes or failures.
The value can be either TRUE or FALSE. If the value is set to TRUE, you must specify a value for TRACEFILENAME
and a value for TRACING.LEVEL
. If the value is set to FALSE, you need not specify values for TRACEFILENAME
and TRACING.LEVEL
.
Set value to specify the detail of trace information to collect if tracing is enabled.
Value can be either 5 (user level which collects critical messages and error messages), 3 (administrator level which collects critical, error, and warning messages) or 2 (developer level which collects maximum trace information).
Set value for where to write tracing output if tracing is enabled.
Oracle recommends setting the value to PAGING_LOG.TRC. By default, this file is located in the Paging Server's ORACLE_HOME\SYSMAN\LOG
directory.
If you specify a different directory, you must specify <Drive_Letter>:\\<directory_path>\paging_log.trc. For example, if you want the tracing file stored in C:\temp\, set the value to C:\\temp\paging_log.trc.
This section contains the following topics:
On Unix, if the ORACLE_HOME environment variable is not set to the Oracle home where the management server is running, the management server will not start correctly. It will try to find its class files in the default Oracle home instead of the correct Oracle home.
To set the environment variable:
setenv ORACLE_HOME '/usr/local/oracle'
To set the environment variable:
ORACLE_HOME = '/usr/local/oracle' export ORACLE_HOME
On UNIX systems, the Oracle environment can also be set by calling coraenv
(for the CSH) or oraenv
(for any other shell). This shell script sets the oracle environment for a given identifier. This identifier can be a specific database or it can point to an ORACLE_HOME
which contains the Management Server software. These scripts can be customized to include specific machine or server based settings.
Refer to the specific operating system's Oracle Administration documentation for more information about the coraenv
and oraenv
scripts.
For information to troubleshooting the Management Server if it does not start, refer to the following resources:
The $ORACLE_HOME\sysman\log
directory contains the output of traces that are redirected to disk. This directory contains the oms.log
and oms.nohup
files.
The Management Server places all its trace messages in oms.log
file. The oms.log
file contains messages generated when the Management Server is starting and running.
The oms.nohup
file in the $ORACLE_HOME/sysman/log directory contains Management Server error messages which appear before the Management Server starts up and critical messages during its run.
To access the Windows NT Event Log to view the events logged by the Management Server.
Events and event numbers which the Management Server can log in the event viewer are listed below:
Errors will only be reported in the Event Viewer if the Management Server is voluntarily shutting down.
To obtain more information for debugging, you can change the JRE startup command in the OEMCTRL script.
Performing this procedure enables you to identify class loading problems caused by environmental or installation problems. When you have collected the data from the batch file, send the information to Oracle Support Services.
If you receive the following error when starting the Management Server, refer to the solutions below:
Could not start the Oracle<ORACLE_HOME_NAME>ManagementServer service on <HOST NAME>. Error 0203: The system could not find the environment option that was entered.
For Windows NT: The Enterprise Manager Configuration Assistant has been run, and you have chosen to not save the repository connection's username and password to a file (in secure Management Server mode). You must select the Oracle<ORACLE_HOME_NAME>ManagementServer service and then enter the username and password in the Control Panel's Startup Parameters' field or you must enter the repository credentials when you are prompted for them in a dialog.
If a Management Server fails in a multi-Management Server environment, it only affects the clients connected to it. Each Management Server is independent of the other Management Servers connected to the repository.
To change your Management Server node to another node where a Management Server is still running, follow the procedure below.
If the node name where the Management Server is running does not appear in the pull-down list, follow the instructions below:
If a page notification fails, the paging service will try to resend the page three more times. The interval of time between these retries is a value that can be altered. By default, the interval of time between retries is 1 minute. You can change this default setting by editing the OMSCONFIG.PROPERTIES file located in the Management Server's ORACLE_HOME\sysman\config
directory. Users can add the property
OEM.PAGING.RETRYINTERVAL=<integer>
to the OMSCONFIG.PROPERTIES file and replace <integer>
with the number of minutes between retries.
If you start the web browser, log in to the Console, but the Console hangs, and the following is displayed in JInitiator Console:
@org.omg.CORBA.INITIALIZE[completed=MAYBE, reason=java.net.BindException: Cannot assign requested address]
You must perform the following steps:
@.us.oracle.com
If you forget your SYSMAN password and need to reset it to oem_temp
, follow the instructions below:
You must first be connected to the Management Server repository (via SQL*Plus) before using the reset_sysman() procedure.
sqlplus
<emrepository>/<emrepository-pwd>@<em-repository>
to connect to the database.
For example:
mynode/mypassword@mynode.world
since the default repository name is the hostname.
execute smp_maintenance.reset_sysman();
This section describes the Enterprise Manager Configuration Assistant error messages and their probable causes, and provides the actions recommended to correct them.
If the omsconfig.properties
file is not writable, the "Configuration File Not Accessible" page appears. Please refer to Configuration File Not Accessible on page B-12 for more information.
When you login as a DBA user on a selected database, the Configuration Assistant checks whether the user has the necessary privileges. If the user does not have the necessary DBA privileges, a message appears: "The database user you chose does not have the necessary DBA privileges. Logon to the database as a user with DBA privileges." Click OK to dismiss the message box. You must enter the proper credentials in order to continue. Enter the credentials and try again.
If you have entered an invalid username, password, or service, an error message indicating the failure appears. For example: "Connection failed ORA-01017: Invalid username/password; logon denied" message appears. Click OK to dismiss the message box. Enter the data and try again.
The user already exists, and already contains an incomplete Enterprise Management Release 2 repository. A repository create, drop, or upgrade operation may be in progress, or a previous operation may have failed. Continuing the current operation can replace incomplete components and create missing components in the repository.
What would you like to do?
If a repository operation is already actively in progress elsewhere, do not continue. Attempting to perform simultaneous operations on the same repository may cause repository corruption.
The user "<username>" already contains a complete and up-to-date Enterprise Manager Release 2 repository. If you wish to overwrite the existing repository, first use the Drop option.
If the Oracle Enterprise Manager Configuration Assistant detects that the chosen repository name is the name of an already existing user/schema in the database and that it contains an Oracle Enterprise Manager Release 1.x repository, a message appears: "The user already exists and contains a V1 repository. A V2 repository may not coexist with a V1 repository in the same schema. Please choose another user name."
If the Oracle Enterprise Manager Configuration Assistant detects that the chosen repository name is the name of an already existing user/schema in the database, and that it contains neither an Oracle Enterprise Manager Release 2.x nor Release 1.x repository, a message appears: "The user already exists in this database. Do you wish to create the repository within this user's schema anyway?"
If you choose no, you may select a different user name.
If you choose yes, the "Create Repository Summary" page appears. Refer to Step 5 "Create Repository Summary" on page 2-16 for more information.
During create repository, if the Configuration Assistant detects that a managed repository is already specified in the omsconfig.properties
file, and you are creating a repository that is different from the managed repository, a message appears: "The Management Server on this machine is currently managing a repository owned by user <user_name> on service <service_name>. Would you like to change it to now manage the repository owned by user <user_name> on service <service_name>?"
If you choose yes, the configuration will be updated. The Management Server must be stopped and restarted in order for the changes to the configuration file to take effect. If you choose no, the configuration will not be updated. The "Create Repository Summary" page and the steps in the Configuration Assistant Progress Window will reflect your choices.
Note that the Configuration Assistant, when it creates the user for an Oracle Enterprise Manager repository, asks you for the default and temporary tablespaces to use. If you choose SYSTEM for either of these, Configuration Assistant puts up the following warning: "You have chosen the user's default or temporary tablespace to be SYSTEM. We recommend the SYSTEM tablespace be used only for data dictionary tables and the SYSTEM rollback segment. Are you sure?" Pick another tablespace.
If the Oracle Enterprise Manager Configuration Assistant detects that the default tablespace for the repository does not contain enough free space, the following message appears: "The default tablespace for the repository does not contain enough free space." Refer to Repository Database Default Tablespace Does Not Contain Enough Free Space on page D-22 for information for possible solutions.
The Configuration Assistant checks that the selected default tablespace for the repository has the appropriate attributes/characteristics, but if it does not contain enough free space, the following message appears: "The default tablespace for the repository does not contain enough free space."
Use the OEM_REPOSITORY
tablespace if it exists. It is the default tablespace for Enterprise Manager.
If you are creating a repository in a new user, the Configuration Assistant's Select Repository User Tablespaces screen strongly encourages you to create an OEM_REPOSITORY tablespace. Using the Enterprise Configuration Assistant to create the OEM_REPOSITORY tablespace ensures that the tablespace has appropriate attributes/characteristics.
However, if you prefer, you can create another tablespace, or use an existing tablespace. If you decide to use an existing tablespace, you may have to increase its size.
Note: You do not have to exit from the Configuration Assistant when using DBA Studio's Storage Management tool to create another tablespace or increase the size of an existing tablespace. |
Refer to Appendix E, "Repository Sizing" to determine storage requirements and disk space allocation for your Oracle Enterprise Manager repository.
If the OEM_REPOSITORY tablespace has not been created for you, the "Create a new OEM_REPOSITORY tablespace (recommended)" option is available on the "Select Repository User Tablespaces" page of the Enterprise Manager Configuration Assistant.
Select this option if you want to create the OEM_REPOSITORY tablespace. Using the Enterprise Manager Configuration Assistant to create the OEM_REPOSITORY tablespace gives that tablespace appropriate attributes/characteristics. Then use it as the user's default tablespace.
Using the Configuration Assistant is the preferred method for creating a tablespace since it creates the tablespace with the proper attributes in any of the supported databases. The attributes of the default tablespace depend on the database version.
To use DBA Studio's Storage Management tool to create a new tablespace, follow the procedure described in this section:
You can start the DBA Studio from the Windows Start Menu->Programs->Oracle-<Oracle_Home_Name>-> Database Administration->DBA Studio.
You can start the DBA Studio from the command line using the command:
oemapp dbastudio
When the login dialog appears, choose Connect directly to databases and press OK.
Using the Configuration Assistant is the preferred method for creating a tablespace since it creates the tablespace with the proper attributes in any of the supported databases. The attributes of the default tablespace depend on the database version.
To use DBA Studio's Storage Management tool to increase the size of an existing tablespace, follow the procedure described in this section:
You can start the DBA Studio from the Windows Start Menu->Programs->Oracle-<Oracle_Home_Name>-> Database Administration->DBA Studio.
You can start the DBA Studio from the command line using the command:
oemapp dbastudio
When the login dialog appears, choose Connect directly to databases and press OK.
An Oracle Management Server will open a number of repository database sessions while processing work on behalf of clients and managed nodes.
The number of sessions required by a single Management Server generally ranges from 3 to 5, depending on the load placed on the Management Server. More repository database sessions may be required under the following circumstances:
If other applications are accessing the same database used for the Enterprise Manager Repository this will increase the session load on the database and should be considered when setting up the database.
If your processes setting is too low for Oracle Enterprise Manager, you will receive an error message similar to the following in the oms.log
file located in the Oracle_OEM_Home/sysman/log
directory.
can't open a session
For large workloads, or for cases where multiple applications are accessing the database where the repository resides, you can increase the processes parameter in the database init.ora to accommodate the workload.
To use Instance Management tool to change your database parameters, follow the procedure described in this section:
You can start the DBA Studio from the Windows Start Menu->Programs->Oracle-<Oracle_Home_Name>-> Database Administration->DBA Studio.
You can start the DBA Studio from the command line using the command:
oemapp dbastudio
When the login dialog appears, choose Connect directly to databases, and press OK.
If you have chosen to store your repository credentials in the omsconfig.properties
file during repository creation, you may want to change the permissions on the file to restrict who can view it.
If you change the file permissions, other users cannot view the file.
Note:
The repository credentials stored in the |
To change the file permissions, at the command prompt, enter:
$ chmod 600 omsconfig.properties
This command sets the read and write permissions only for the owner of the file.
To change the file permissions, perform the following steps.
Oracle_Home/sysman/config
directory, select the omsconfig.properties
file.
You can provide access to multiple usernames.
The two primary factors in determining SGA size are:
The amount of RAM available to the instance is memory dedicated to the repository's instance. This must not include memory needed for other instances and applications on the repository host node. The amount of activity includes all active (submitted) jobs, active (registered) events, hosts monitored, and connected administrators. As activity increases, so will the demands on the instance.
If the instance is dedicated to the Management Server repository, the basic minimums are listed below:
db_block_size = 2048 # EM is a strict OLTP application db_block_buffers = 2048 # **May need increase under heavy load** sort_area_size = 128000 # **May need increase under heavy load** sort_area_retained_size = 128000 # **May need increase under heavy load** log_buffer = 64000 # **May need increase under heavy load**
The Management Server repository transactions tend to be short, so rollback space usually is not a problem. Watch your redo log size and log_buffer size if a high transaction (activity per above) rate is expected.
The job notifications are not being delivered and the Console status remains in scheduled. Sometimes the jobs work and sometimes the jobs fail. Resubmitting one of the jobs results in a "job already submitted" error.
The Intelligent Agent may be delivering job status/output for the job to two different Consoles operating at different IP addresses.
Another Enterprise Manager installation is probably running on another node with the same repository name as the first node. Some job notifications are delivered to the first node and some notifications to the second node, depending on which machine last registered itself. You must check what is running on the nodes and decide which one is your Management Server.
|
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|