Oracle Enterprise Manager (OEM) Common problem solving

Oracleenterprisemanager (Oracle Enterprise Manager, abbreviation OEM) provides management services for managing distributed environments through a set of Oracle programs. OEMs include a set of DBA tools, a repository, and a graphical display of the console. The OEM console corresponds to the intelligent agent (intelligentagent) on each server. Intelligent agents can monitor specific events on a system and perform tasks (jobs) just as you would on a system-local. The results of events and jobs are sent back to the console so that all systems can be managed in one place.

Compared with Servermanagermotif, OEMs have the following advantages:

1 from the scope of application, OEMs can monitor and manage multiple databases on multiple systems at the same time, so they are particularly suitable for distributed environments, and Servermanager can only monitor and manage a single database.

2 from the Management object, OEMs can monitor management nodes, database and listener processes (listener), while Servermanager can only monitor the database.

3 from the applicable version, OEMs can monitor the management of oracle7.x and 8.x at the same time, and starting from the 8 version, Servermanager no longer exists.

This article mainly introduces some OEM's frequently asked questions and the solution method.

What is the function of the Q:OEM database tool group?

The A:OEM Database Tools group is a set of tools that enable DBAs to manage Oracle databases through a GUI interface. Includes the following tools:

DataManager (Data Manager): This tool enables you to perform data export/import like loading data.

SchemaManager: This tool enables you to manage objects in a database. Can be used to create, modify, and delete tables,indexes,views,snapshots,sequences, and so on.

SecurityManager (Security Manager): This tool enables you to manage users, roles, permissions, and profiles.

StorageManager (Storage Manager): This tool allows you to create and modify table spaces, data files, and rollback segments.

Instancemanager (instance Manager): This tool allows you to close, start the instance and store and manage database parameters.

Sql*worksheet: This tool enables you to run or create SQL scripts and store them on your hard disk. You can use this tool to reproduce the last executed statement, while checking the execution results that appear on the screen.

Backupmanager (Backup Manager): This tool allows you to manage backup and restore to Oracle7 and Oracle8 databases. In Oracle7 this tool supports Enterprisebackuputility (EBU), in Oracle8 This tool supports recovery manager Recoverymanager.

Softwaremanager (software Manager): This allows you to install remote software to a remote server that supports this feature.

Q: The job status has been submitted and has not changed to a predetermined (scheduled).

A: Jobs are created at the OEM console and sent to an intelligent agent via sql*net. Once an intelligent agent accepts a job request, a notification is sent back to the OEM console, and the status changes to "scheduled". If the status is never changed from submission to reservation, the agent may not receive a job request. Determine if the agent has been started, and determine if the sql*net and OEM are properly configured.

Q: The job status has been scheduled, not changed to run

A: When the agent starts running the job, a notification is sent back to the OEM console, and the status changes to sent or started. If the job status has been scheduled without change, it may be that the agent cannot open a socket back to the OEM console, either because of a TCP/IP problem or because the agent does not have sufficient permissions to derive a process to run the job. Ping the console using the hostname on the server side to determine that there is no problem with TCP/IP, and that the database user running the job has Dba,connect,resource permissions.