We’re rewarding the question askers & reputations are being recalculated! Read more.
7

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 login -username=sysman $ emcli execute_sql -sql="select count(*) from dba_users" -targets="sandbox_databases:group" And the output is: *************************...


5

Assuming you are licensed to use the AWR, you could query either the gv$active_session_history view for more recent data or dba_hist_active_sess_history for older data. gv$active_session_history will have a snapshot of what every active session was doing at the top of each second and will hold that data for a few hours. dba_hist_active_sess_history will ...


4

You should enable global port for EM Express to Manage a CDB and the PDBs, execute: exec dbms_xdb_config.SetGlobalPortEnabled(TRUE)


3

I cannot say for sure why RMAN behaves in this way, but as a workaround you can edit the resulting script within the same workflow in EM before the job is created: ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/disk1/%d_backups/%U'; This will ensure the backups are placed in the destination you specified regardless of RMAN settings in control file saved ...


2

The link below is from oracledistilled.com and goes through Enterprise Manager >> Data Movement. Clone a Database to Another Host using Enterprise Manager 11gR1 Grid Control It is very well explained with good screen shots and walks through Cloning i.e. another function under 'Data Movement' >> 'Export Export to File'. Under host credentials the normal ...


2

"Logon Per Sec" and "Logon Per Tx" can be found in OEM REPOSITORY (e.g. look in sysman.mgmt$metrics_daily view, the metric_name = 'instance_throughput' and metric_column like 'logons%'). The other metric will also be there, these are maintained in OEM REPO not in individual targets.


2

In OEM 12c Enterprise Manager, you can change both the body and the subject of email alerts through the web-based EM console. Once logged in, you should see menu options in the top right corner like "Setup" and "Help" with down arrows indicating a drop-down menu. Click "Setup" -> "Notifications" -> "Customize Email Formats..." From here, you can select ...


2

That figure is the share of the overall CPU utilization for each process. In your case, it means that that specific oracle process is responsible for 100% of your current CPU utilization - i.e., you have no other applications that are eating CPU. So 100% of your ~1-core load is generated by that specific Oracle process. There is an example in the ...


2

There is a Readme for each Oracle Template download. Here is the related part from the Readme for your template: 5. O/S passwords: The passwords for the "root" and "oracle" O/S users are "welcome1" 6. All Enterprise Manager Cloud Control passwords are "welcome1"


2

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 the certificate. Why the IP-address works and the hostname doesn't... probably some configuration issue. At least now anyone with more experience has something ...


2

It seems that it's not possible, but, for the record, here's to get get the information via SQL. SELECT CASE INSTR ( cm_target_name, '_' ) WHEN 0 THEN cm_target_name ELSE SUBSTR ( cm_target_name, 0, INSTR ( cm_target_name, '_') - 1 ) END database_name, property_value FROM sysman.cm$em_tprops_ecm_view WHERE cm_target_type = 'oracle_database' AND ...


2

0> "and set 5500 was impossible due to the error - 5500 seemed busy" This means that the port 5500 is already "in use". Well, I bet it is not in use but Oracle thinks that. There are a lot of ports reserved in /etc/services. Open the file and change the following lines: fcp-addr-srvr1 5500/tcp # fcp-addr-srvr1 fcp-addr-srvr1 5500/udp ...


2

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 sysdba Connected. SQL> select dbms_xdb_config.gethttpsport() from dual; DBMS_XDB_CONFIG.GETHTTPSPORT() ------------------------------ 0 In ...


2

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 here: Modify the regex for the existing error log analysis to cover this error code. This would be much easier, but might be a little inflexible. Write a Metric ...


2

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 $ORACLE_HOME/rdbms/admin/ sqlplus "/ as sysdba" @spcreate.sql Take a snapshot: sqlplus perfstat/<password> execute statspack.snap(i_snap_level=>7); ...


2

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 Cloud Control, AWR Warehouse, and Global Data Services Catalog can be shared in one database, or deployed in separate databases. Enterprise Edition must ...


1

The port configuration is documented in the following file: $ORACLE_HOME/install/portlist.ini If Enterprise Manager has been installed then setting off the following command will show the status of the Enterprise Manager: ./emctl status dbconsole If you are receiving the following message: ./emctl: not found. ...then you might not have Enterprise ...


1

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 DOS can be helpful. But otherwise you would just write .BAT files and or a Powershell file. You want a process that creates a backup log and checks that log for ...


1

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 of SYS user using SQL*PLUS command called password which send the password in encrypted form instead of plain text. [oracle@ora12c ~]$ sqlplus sys@oracdb as ...


1

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 schedule, OEM will not send any mails. You can fill in multiple mail addresses in the field for the schedule to have multiple persons receiving alert mails. ...


1

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 'Up Status' of Listener. Note: I have highlighted some part due to security reason.


1

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 thhe performance page, you can also click the 'Top Activity' link. On the Top Activity page, you can then choose a time interval by dragging the shaded area(may ...


1

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 Rights). The Scheduler jobs are running under Definer's Rights. You can get the name of the database user whose privileges are currently active by SYS_CONTEXT('...


1

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 to an iSCSI storage. The problem seems to be caused by the web-client, or EM server (not sure here) trying to send the webpage request to the wrong adaptor. ...


1

You need to start the service, e.g. net start OracleDBConsoleorcl The service name might be different on your system, but it usually starts with OracleDBConsole and then contains the service name of your database. If you want it to always run, set the service start automatically through the control panel.


1

Plugins are deployed on the OMS and the agents as well. First you should upgrade the plugin on the OMS, then on the agents. You don't need to upgrade between versions sequentially, you can upgrade to the highest available. Yes, there are. Currently 12.1.0.5 is the latest version, and there are quarterly PSUs as well. Check the below MOS note: Oracle ...


1

You may need to resecure the agent. Here is a link that should help. http://jhdba.wordpress.com/2008/12/10/clearing-an-enterprise-manager-agent-that-fails-to-upload/


1

We finally deleted the files manually and OEM is fine. We ran this query to get the delete scripts: SELECT 'alter diskgroup ' || gname || ' drop file ''+' || gname || Sys_connect_by_path(aname, '/') || ''';' a FROM (SELECT b.name gname, a.parent_index pindex, a.name ...


1

Assuming your DB target name as seen in EM is ORCL11.WORLD and you want to set it's Monitoring Configuration's Oracle Home to /oracle/product/11.2.0.4, the syntax would be the following: emcli modify_target -type='oracle_database' -name='ORCL11.WORLD' -properties='OracleHome:/oracle/product/11.2.0.4' Probably would be similar approach for Listeners, ASM, ...


Only top voted, non community-wiki answers of a minimum length are eligible