8
votes
Oracle 12c - Can not login to Enterprise Manager - XDB Login prompt
You should enable global port for EM Express to Manage a CDB and the PDBs, execute:
exec dbms_xdb_config.SetGlobalPortEnabled(TRUE)
- 181
8
votes
Run a SQL statement on all databases monitored by OEM
First you need to set the preferred credentials for the targets. After that, you can use emcli for this. In the below example I have a group called sandbox_databases containing 3 databases:
$ emcli ...
- 40.4k
2
votes
Accepted
Can I create alert on ora-20118 from Enterprise Manager?
You could use DBMS_SYSTEM.KSDWRT to write the error to the alert log when you catch the relevant exception.
Then you can configure Enterprise Manager to alert on that error code. You've two options ...
- 2,078
2
votes
Oracle 12c Express Enterprise Manager webpage does not load
After contacting Oracle support, I've -kinda- been able to figure out what was going on. This server has 4 network adaptors, 1 adaptor connected to the network, and 3 unconfigured adaptors connected ...
- 821
2
votes
Oracle Enterprise Manager Database Express shows common users only
Since you are connected to the root container you only get list of common users.
First of all connect to the PDB and check whether http/https port is configured or not.
SQL> conn sys@orapdb1 as ...
- 8,604
2
votes
Accepted
Oracle Enterprise Manager 11g: How to see statistics of Interfaces usage?
If you are talking about Listener statistics on Oracle Enterprise Manager then-
1) Click on Listener name on Home screen of OEM.
2) Then Click on 'Established Connections per minute' under 'State' ...
- 8,604
2
votes
SQL to get performance metrics shown in EM Express 12C Resources
STATSPACK comes out of the box with Oracle Database Standard Edition. It works by comparing two snapshots.
https://docs.oracle.com/cd/E13160_01/wli/docs10gr3/dbtuning/statsApdx.html
Install:
cd $...
- 615
2
votes
Accepted
Renew Certificate in Oracle Enterprise Cloud Control OMS Manager Console
The wallet used by OMS has a fixed location: <WEBTIER INST HOME>/config/OHS/ohs?/keystores/console/.
In your case it should be under /u01/app/oracle_em/gc_inst/user_projects/domains/GCDomain/...
- 40.4k
2
votes
Accepted
Can I Configure Enterprise Manager Cloud Control on Standard Edition
Is it possible to configure enterprise manager cloud control on Oracle 12c Standard edition?
Infrastructure Repository Databases
The infrastructure repositories for RMAN, Oracle Enterprise Manager
...
- 40.4k
2
votes
"Unable to display page" with Oracle 12c Enterprise Manager Database Express
Try browsing to
https://[IP-address]/em
For me this works, but everything is -very- -very- slow (a few minutes just to load the login page).
I'm suspecting the slowness has something to do with ...
- 821
1
vote
Renew Certificate in Oracle Enterprise Cloud Control OMS Manager Console
Another way when using official CA and certificate signed by CA.
Here are steps to secure OEM console using https(tls):
Certificate has to be converted into pkcs12 format.
Then imported into auto-...
- 1,554
1
vote
Oracle 12c - Logically There Is A Redo Group But Not Physically - Database Can't Open
I am sure that nobody has deleted the file because I checked it with
the history command on linux system.
That does not guarantee anything.
You lost your current logfile group. The steps for recovery ...
- 40.4k
1
vote
Oracle 12c - Logically There Is A Redo Group But Not Physically - Database Can't Open
... there is a redo group 3 logically but there is no physically file.
Not a good place to be.
I am sure that nobody has deleted the file because I checked it with the history command on linux ...
- 8,259
1
vote
Accepted
Oracle EM 13c automatically logged in as dbsnmp
Found the answer myself.
Login with the custom super administrator account
Setup -> Security -> Preferred Credential
Select "Database Instance"
Click on "Manage Preferred Credentials" button ...
- 143
1
vote
Oracle 12c EM error on login
This is a shortened, but public version of an MOS (My Oracle Support) note:
WHEN LOGIN VIA EM EXPRESS, ORA-979 IS RAISED (Doc ID 2390782.1)
Here we can find this information:
CHANGES
...
- 40.4k
1
vote
Oracle Internal Error
The wording on this error might as well be:
ORA-00600: "Something" is broken in the database.
It "recently" gained a close "cousin":
ORA-07445: "Something" is broken, but not necessarily in ...
- 8,259
1
vote
Oracle Top CPU Consuming SQL is "select longdbcs from javasnm$ where short = :1"
From what I remember about javasnm$, it is a table that stores long names of java objects, as oracle objects can only be up to 30 characters (stored in field SHORT). Most java objects are over 30 ...
- 489
1
vote
Accepted
Oracle enterprise manager showing wrong port after change
Sometimes it helps to de-install the enterprise manager and then re-install it using the emca command. We'll leave that for the worst case.
Using EMCA After Changing the Database Listener Port
If ...
- 17.3k
1
vote
SQL to get performance metrics shown in EM Express 12C Resources
For CPU would the following work?
CREATE GLOBAL TEMPORARY TABLE TS_SYSTEM_EVENT ON COMMIT DELETE ROWS AS
SELECT
EVENT,
TOTAL_WAITS,
TOTAL_TIMEOUTS,
TIME_WAITED,
TIME_WAITED_MICRO
...
- 175
1
vote
Ways to Schedule Rman backups
Personally I would schule it using the Windows Scheduler. You might want to get robocopy if you are copying your backup files to another server. Having an email client that you can send emails from ...
- 1,520
1
vote
Accepted
Cannot change password from Oracle EM
That's not the best practice to use SYS user to use in Enterprise Manager. And you can change password for the user like SYSTEM or SYSMAN using OEM but not for SYS user.
You can change the password ...
- 8,604
1
vote
Run a SQL statement on all databases monitored by OEM
Depending on your version of OEM (we have 13.5 RU 3), you can use a job to execute a SQL Script against any target database you tell it to.
Go to Enterprise -> Job -> Activity
Click the Create ...
- 31
1
vote
Email notifications from OEM
I had a similar issue when we needed to add a new hired administrator to receive the alerts.
The steps:
Add the e-mail to the 'Enterprise Manager Password & Email'
Check the incidents rules who ...
- 11
1
vote
Email notifications from OEM
Yes, you have to fill in the notification schedule. This site defines to whom the mail will be sent on which time and day. If you shut down your database at a time, where no mail-address is set in the ...
- 11
1
vote
Can you view the Oracle listener status from OEM?
Yes, we can view the listener status from OEM (Oracle Enterprise Manager).
I am uploading the two screen shot related to listener in Oracle 11g,OEM(Oracle Enterprise Manager) status.
and the current '...
- 6,377
1
vote
How do I track down wait events for a specific transaction in Oracle Enterprise Manager?
The ASH report shows top wait events, top SQL and top sessions. Using Enterprise Manager, you can generate the ASH report by navigating to the performance page and then clicking 'Run ASH Report'. On ...
- 8,604
1
vote
Top Activity in OEM reports that dbms_scheduler jobs run as the job_creator user?
You have to distinct between the user of the current session you used for logon and the name of the database user whose privileges are currently active (see also About Definer's Rights and Invoker's ...
- 2,923
Only top scored, non community-wiki answers of a minimum length are eligible