Questions tagged [oracle-enterprise-manager]

Oracle Enterprise Manager (OEM or EM) is a set of web-based tools aimed at managing software and hardware produced by Oracle Corporation as well as by some non-Oracle entities.

Filter by
Sorted by
Tagged with
14
votes
5answers
56k views

Oracle 12c Express Enterprise Manager webpage does not load

Problem summary When browsing to the Oracle 12c EM Express webinterface, the page times-out when using a URL like: http(s)://hostname:5500/em http(s)://hostname.domain:5500/em When using a url ...
4
votes
1answer
1k views

Altering the location of Oracle-Suggested Backup

On one database, the Oracle-Suggested Backup scheduled from Enterprise Manager always ends up in the recovery area, despite RMAN configuration showing that device type disk format points elsewhere. ...
4
votes
2answers
6k views

Use EMCLI to update OEM Oracle Home Path

Is is possible to use the Enterprise Manager Command Line Interface (EMCLI) to change the Oracle Home Path? We recently upgraded many databases, listeners, and ASMs, and I'd like to automate this ...
4
votes
0answers
315 views

RMAN-06169, but only when backing up via OEM 13c

When running a Level 1 or Level 0 backup via OEM 13c, the following RMAN error causes the run to fail. (The RMAN script is being ran with proper sysdba credentials from OEM 13c.) RMAN-06169: could ...
3
votes
3answers
5k views

Ways to Schedule Rman backups

I am using oracle 11g database in windows platform. Also, my db is in archivelog mode and I am taking daily RMAN backups. Now, I need to schedule my Rman backups on daily and weekly basis. I read ...
2
votes
1answer
11k views

Oracle 12c - Can not login to Enterprise Manager - XDB Login prompt

I have installed Oracle 12c Standard Edition on one of my Windows 7 LAN desktops. Installation went fine. I created ORCL Container and ORCLPDB pluggable database during install. I can log in to Oracle ...
2
votes
1answer
5k views

Run a SQL statement on all databases monitored by OEM

I want to write a select SQL statement but I want it to run on all databases being monitored by Oracle Enterprise Manager. I also would like to know how to run 'alter statements' on all database ...
2
votes
1answer
3k views

oracle blocking sessions

I am trying to investigate some concurrency issues on Oracle 11 RAC. So far the most helpful tool I have is "blocking sessions" view of the Enterprise Manager, which tells me which query is blocking ...
2
votes
1answer
108 views

Oracle Enterprise Manager 11g: How to see statistics of Interfaces usage?

I need to give our client the following statistics: How many users are using the Interfaces or each interface? What interfaces are mostly used? What are the usual usage time? What kind of actions are ...
2
votes
2answers
9k views

“Unable to display page” with Oracle 12c Enterprise Manager Database Express

i'm using redhat 6, installed 12.1.0.2 of oracle and created a database. database (dev12ee1) is a non-container database, there is also an 11g database on the server (dev11ee1) lsnrctl status shows ...
2
votes
2answers
17k views

How can I find port running Oracle Enterprise Manager

I need to connect to the Oracle Enterprise manager of a remote machine. But I dont know the port on which OEM is running on the remote machine. I have access to the machine from terminal though. Is ...
2
votes
1answer
1k views

Reorganize Objects in OEM - Host Credentials do not have enough privileges

When I try to re-organize objects from OEM (11g) and enter my host credentials (not "oracle"), I get the message: "An error occurred verifying the host credentials. Make sure the credentials are ...
2
votes
0answers
2k views

Why OEM RMAN backup jobs fail after changing the preferred credentials?

In an Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Running on Oracle Linux 6.5, we configured full RMAN backup schedule using OEM (Oracle Enterprise Manager 11g ...
1
vote
1answer
1k views

is it possible to extract 'LifeCycle Status' using emcli ( Oracle Enterprise Manager )

It's easy to set the LifeCycle status ( and other properties ) with emcli, emcli set_target_property_value -property_records="sometestdatabase:rac_database:LifeCycle Status:Test" but getting the ...
1
vote
3answers
9k views

Oracle 12c Express Enterprise Manager on Centos 6.5 is not reachable

I have Centos 6.5, and installed Oracle 12c. As dbca utility says after configuring new db, EM Express should be available on https://hostname:5500/em In fact, it is not. Neither on localhost nor by ...
1
vote
2answers
3k views

Where does Oracle Enterprise Manager derive the “User Logon Time” metrics from?

Oracle's enterprise manager has a metric named "User Logon Time" and will show an alert if that exceeds a certain threshold. I would like to retrieve the numbers stored for this metrics directly ...
1
vote
1answer
757 views

Oracle Top CPU Consuming SQL is “select longdbcs from javasnm$ where short = :1”

For the Oracle 12c database I've been administrating, I usually carry out the monitoring using Oracle Enterprise Manager Cloud Control 13c. From time to time, the database suffers from performance ...
1
vote
1answer
542 views

Oracle enterprise manager showing wrong port after change

I changed the port that Oracle was using from 1523 to the default 1521. The database is running on the correct port now. I can connect on 1521 and run queries. However the Enterprise Manager is ...
1
vote
1answer
4k views

Email notifications from OEM

I am trying to generate email alerts from OEM to multiple email addresses. I have configured the SMTP server details from 'Setup' screen. And then I have added the email addresses under the '...
1
vote
1answer
192 views

How do I track down wait events for a specific transaction in Oracle Enterprise Manager?

I have an application that makes tens of thousands of calls per day to a stored procedure. Normally this executes in about 50 ms. However, periodically, it takes 2-3 seconds to execute. I have an ...
1
vote
1answer
2k views

Question on Oracle OEM version and plugin version upgrade

I have a OEM 12c (12.1.0.4) running in my setup in which I have registered over 70-80 databases. I see the plugin updates with versions of each target (Oracle database, MS-SQL, MySQL) and I have the ...
1
vote
1answer
170 views

Delete Old Archivelogs from missing database

We have deleted a database but the archive logs remain. We need to delete these as they take a lot of space: Since the database is deleted, it is not in the rman catalogue so I cannot use delete ...
1
vote
1answer
20 views

Oracle Enterprise Manager 11g Database Control - Agent Unreachable

Single instance DB. I can login to Oracle Enterprise Manger (OEM). However, on the Home Page it says: Status - Agent Unreachable Most tasks such as checking RMAN status, adding datafiles, etc. ...
1
vote
1answer
238 views

Oracle Enterprise Manager - stats split by user (schema)

Is there any way to split all the stats by user (schema) when looking at the Performance tab in the Oracle 11g Enterprise Manager? or effectively some other tool to retrieve that information - e.g. a ...
1
vote
0answers
7k views

How to identify concurrency issues in Oracle 11g?

For a short period in time we had a concurrency issue that lead to subsequent faults in our application (Java, Spring, Hibernate). Since we are using dictionary managed tablespaces, I first thought ...
1
vote
0answers
8k views

How to run ORACLE 12C EM?

I have installed and created a database in oracle 12c in ubuntu 14.04 . Now I can login to the CLI using sqlplus \ as sysdba and run sqlcommands , but I can't login to the EM from the web. The name ...
1
vote
0answers
229 views

Sync/Replication of 2 Oracle Databases with NetApp storage

I am working on a high availability setup of Oracle Enterprise Manager. I need the back-end repository replicated (preferably in real time, or something close) to another repository, in which I could ...
1
vote
2answers
15k views

How can i fix the Oracle Enerprise Manager error - Agent is blocked?

I have installed OEM 12c and after restarting my oms the agents got the following error: Heartbeat Status : Agent is blocked Blocked Reason : Plugin mismatch found between agent and repository. I ...
0
votes
2answers
514 views

SQL to get performance metrics shown in EM Express 12C Resources

I would like to start recording some historical performance metrics on my Oracle database server. I can use these metrics to evaluate growth of database resource requirements over time. When it's ...
0
votes
1answer
746 views

Can I Configure Enterprise Manager Cloud Control on Standard Edition

Is it possible to configure enterprise manager cloud control on Oracle 12c Standard edition? Will it administer multiple databases (Non-CDB)? What about administering databases on different servers?
0
votes
1answer
357 views

Can I create alert on ora-20118 from Enterprise Manager?

Can I create an alert on a user-defined ORA- error? I want EM to notify me when the following error happens: begin raise_application_error(-20118, 'myerror'); end; /
0
votes
1answer
3k views

Customizing OEM notification title and body

I am writing a reporting tool that accepts email notifications for incedents , alerts and events coming from the OEM. The tool parses the email title and body to extract information from it. I was ...
0
votes
1answer
2k views

Oracle Enterprise Manage “CPU utilization” is confusing

When I display the CPU utilization in the Enterprise Manager (in the Performance tab), there is a big discrepancy between the graph that shows the utilization and the table that shows the operating ...
0
votes
1answer
4k views

Login / Password for Oracle Enterprise Manager in VM template?

I want to setup Oracle Enterprise Manager to access our development Oracle databases. I downloaded the following VM template from https://edelivery.oracle.com/EPD/Search/handle_go Oracle VM ...
0
votes
1answer
3k views

Exporting and importing a database

I have setup an Oracle 11g Database and have a question about exporting and importing a database. I am using Enterprise Manager and have browsed to the following: Data Movement->Export to Export ...
0
votes
1answer
57 views

Oracle EM 13c automatically logged in as dbsnmp

I created a custom super administrator user in Oracle EM 13C. When this super administrator is accessing a portable container (PDB) it is always logged in as dbsnmp. I cannot find any option to set ...
0
votes
1answer
286 views

Oracle 12c EM error on login

I'm trying to access an Oracle 12c EM and when I try to login it shows me a load error box with the errors that I expose below, which could be happening? Is there a possibility to reconfigure EM ...
0
votes
1answer
88 views

Oracle Internal Error [closed]

Getting oracle Internal error in oracle database 11gr2: ORA 600 [kkpogppi1] It shows everyday in incidents but whenever i check oracle logs it shows nothing and when i open problem details it ...
0
votes
1answer
4k views

Cannot change password from Oracle EM

I am facing an issue as follows: I login to em using SYS as SYSDBA. Enterprise Manager shows information screen saying my password is going to expire. SYS Password will expire on 7th Feb 2017 as ...
0
votes
2answers
3k views

Can you view the Oracle listener status from OEM?

Is it possible to view/monitor the listener status from Oracle Enterprise Manager (OEM)? If so, how is this done?
0
votes
1answer
1k views

Top Activity in OEM reports that dbms_scheduler jobs run as the job_creator user?

The top activity graph in Oracle Enterprise Manager was reporting that certain activity was being performed by certain users at odd hours of the night. Upon researching, this activity was because the ...
0
votes
1answer
2k views

How to start Oracle enterprise manager on Windows 64 bits [closed]

I have installed Oracle 11g on my pc. It has installed fine and everything went fine. After restating pc, https://localhost:1158/em is not connecting. The listener is ok and running fine. How can ...
0
votes
2answers
10k views

Enterprise Manager cannot connect to 11g database instance

In Oracle 11g when we are opening OEM in browser it is showing the following message : "Enterprise Manager is not able to connect the database instance." Listener status is showing Up and Agent ...
0
votes
1answer
2k views

Oracle Enterprise Manager Installation

First I install oracle 11g database with this configuration Step 2 of 9 I selected Create and configure a database Step 3 of 9 I selected Desktop Class Step 4 of 8 Global database name: Blitz ...
0
votes
1answer
64 views

Enterpise Manager 12c to Database 11g

Does Oracle Enterpise Manager 12c can be install with Oracle Database 11g? Because the Oracle Enterprise Manager 11g is no longer available.
0
votes
0answers
18 views

Oracle Enterprise Manager Cloud Control 13.4 - Package Deployment Stuck

We upgraded our Cloud Control from 13.3 to 13.4. I passed as well this step with "Simple Installation" choice, using SYSMAN. I have a user named as CCUSER1. When I want to skip this page ...
0
votes
0answers
20 views

Use DBSNMP for Database Usage Tracking Credentials without adding manually

Enterprise Manager Cloud Control 13c Version 13.3.0.0.0 Oracle BI Publisher 12.1.3.0.0 For each target we have use DBSNMP credentials. We have two type of credentials for each target: Monitoring ...
0
votes
0answers
19 views

Oracle Enterprise Manager 13.3 - OMR Inventory Views PDB GUID

I have only PDB GUID. How I can find PDB name in Oracle Inventory? https://docs.oracle.com/cd/cloud-control-13.3/EMVWS/GUID-93E9DA8F-3560-4A3D-9126-09E8E36EDE64.htm#EMVWS32166 Which view and column? ...
0
votes
1answer
22 views

Enterprise Manager Cloud Control 13c - Email notification should send only once

I have an alert message with tablespace usage that should recheck the status in Cloud Control 13c and send the email only once, but it sends every 30 minutes. It shows me the TS_USAGE error of the ...
0
votes
2answers
181 views

Oracle 12c - Logically There Is A Redo Group But Not Physically - Database Can't Open

I have an Oracle 12c Database for my enterprise manager. I could not connect to enterprise manager because the database was closed. I opened listener. However, the database remained mounted mode. When ...