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.
64
questions
0
votes
0
answers
26
views
Monitoring Oracle aq
I'm working with Oracle AQ which runs an enequeue-operation in a table trigger(after insert). The table also has an audit log table trigger(AFTER DELETE OR INSERT OR UPDATE). The audit table show the ...
- 121
1
vote
1
answer
293
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. ...
- 11
0
votes
1
answer
597
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
2
answers
570
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 ...
- 25
0
votes
1
answer
91
views
Oracle Enterprise Manager 13c - query used in metric
I got task - "send me the query used in this metric?"
It is related to Job with status "FAILED".
I find this failed Job but can't find with which query this metric detect this ...
- 3
0
votes
0
answers
79
views
Can't remove Agent Software from OEM13c
I have "applied" Agent Software in my Oracle Cloud Control 13c. Agent was installed on previous servers and work fine. But now when I want to install it on new configured server, OEM tell me that "...
- 11
0
votes
1
answer
1k
views
Oracle DB | Issue with agent and OMS connection
We performed a "P2V" migration to a local VMware host last night to get an old physical Oracle server over to a new virtual home (we covered all the licensing aspects, we're OK there). Prior to ...
- 133
0
votes
1
answer
131
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 ...
- 143
0
votes
0
answers
305
views
Cannot connect securely to enterprise manager
I'm working on my classwork and had a problem with connecting to the enterprise manager. After running the DBCA the address given to me was https://10.0.2.15:5500/em, pulling it up on IE I get cannot ...
0
votes
1
answer
289
views
error writing input to commandERROR: Invalid username and/or password
This is the error I have been getting on my RMAN notifcations on my backup jobs for the last day or so. The title is exactly how the message is formatted.
~~~End Step Output/Error Log~~~
Error Log:...
- 343
0
votes
1
answer
319
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 ...
- 125
0
votes
1
answer
106
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 ...
- 39
0
votes
1
answer
329
views
How to run EM of Oracle 11g, if i haven't emctl, netmgr, dbca, OracleDBConsole<SID>?
I don't know what is wrong with my Oracle 11g, but it is missing a lot of things. After reinstallation it stays the same. My overall path is like C:\oraclexe\app\oracle and after it there are folders ...
1
vote
1
answer
919
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 ...
- 121
4
votes
0
answers
364
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 ...
- 61
0
votes
0
answers
375
views
Enterprise manager failed to start in oracle 10g
I am using oracle 10g with 4 instance with same server but one of them has failed to start Oracle Enterprise Manager and rest of three are working fine.
Starting Oracle Enterprise Manager 10g ...
- 71
0
votes
1
answer
755
views
Oracle 11gR2 Enterprise manager problem
I joined a company as a fresher DBA and in testing server there is weird problem.
My listener is running very well and developers can connect remotely to database but whenever I tried to start ...
- 39
0
votes
0
answers
2k
views
Oracle Enterprise Manager 12c Cloud: Cannot secure agent mid-installation
Oracle support isn't being much help currently, so figured I would turn to you all. I am installing OEM in my Solaris 10 test environment. I have almost finished installing the OMS, but it bombs when ...
- 173
1
vote
1
answer
687
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 ...
- 145
0
votes
1
answer
837
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?
- 424
2
votes
1
answer
12k
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 ...
- 121
0
votes
1
answer
174
views
EMCA insists that it cannot connect to the service
Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first ...
- 343
0
votes
2
answers
546
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 ...
- 284
0
votes
1
answer
5k
views
Cannot start Oracle Enterprise 13C after stopping OMS [closed]
Oracle Software versions installed:
Oracle Grid infrastructure 12C release 2 [12.2.0.1]
Oracle Database 12C release 1 [12.1.0.2.0]
12.1.0.2.0_Database_Template_with_cdbpdb_for_EM13_2_0_0_0_Linux_x64....
2
votes
2
answers
21k
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 ...
- 141
3
votes
3
answers
6k
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 ...
- 152
2
votes
1
answer
115
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 ...
- 123
0
votes
1
answer
841
views
How to add newly discovered cell node as member of exadata storage server grid in oem12c?
I have successfully discovered a new storage node in oem using emcli
./emcli add_target -type=oracle_exadata -name="da13cel04.myhost.com" -host="da13db01.myhost.com" -properties="CellName:da13cel04....
0
votes
1
answer
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 ...
- 103
-1
votes
1
answer
191
views
Oracle Enterprise Manager Database Express shows common users only
Users page under security menu in Oracle EM Database Express shows common users only as shown in the following screenshot.
All pluggable databases are opened and can be accessed using SQL*PLUS.
2
votes
2
answers
6k
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 ...
1
vote
1
answer
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 '...
- 21
0
votes
1
answer
386
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;
/
- 1,667
0
votes
2
answers
4k
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?
- 261
1
vote
1
answer
261
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 ...
- 261
0
votes
1
answer
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 ...
- 1,098
0
votes
0
answers
415
views
Are all Oracle DB Control features available in Enterprise Manager Express or Cloud Control?
I'm having a hard time figuring out if the new replacements for DB Control (Express and Cloud Control) support all of the features that were available in DB Control. I know Express is very limited, so ...
- 790
15
votes
5
answers
59k
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 ...
- 790
0
votes
1
answer
3k
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 ...
1
vote
1
answer
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,814
1
vote
1
answer
259
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 ...
- 111
2
votes
2
answers
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 ...
- 532
1
vote
1
answer
2k
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 ...
- 41
1
vote
1
answer
178
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 ...
- 266
1
vote
0
answers
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 ...
- 127
4
votes
2
answers
7k
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 ...
- 501
1
vote
3
answers
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 ...
- 159
0
votes
2
answers
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 ...
- 101
0
votes
1
answer
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 ...
- 103
0
votes
0
answers
1k
views
Install JDBC driver 4.0 for SQL Server
How can I confirm that JDBC is running and properly configured/registered in the system? I followed the installation instructions but I believe there has to be more to it than what the instructions ...
- 101