Hi, can you please share the SQL query used in the ME? Please note that the query must return only one single row for the ME to work.

Thanks for your feedback. Glad that it worked.

Hi @rtmartins - Yes, you can create two separate templates for primary and for standby but you have to apply it manually after each role change to avoid missing alerts. Monitoring settings are automatically swapped by OEM during a role change so that's a better option.

Hi @rtmartins - Yes, you can create two separate templates for primary and for standby but you have to apply it manually after each role change to avoid missing alerts. Monitoring settings are automatically swapped by OEM during a role change so that's a better option.

Hi @rtmartins - Yes, you can create two separate templates for primary and for standby but you have to apply it manually after each role change to avoid missing alerts. Monitoring settings are automatically swapped by OEM during a role change so that's a better option.

I'm glad it helped!

Thanks for your feedback. Glad I could help!

@parvazcse - Thanks for your feedback. Yes, you must enable the log_archive_dest_state_2=ENABLE which I did at around 8:30 minute mark of the video. The setting DEFER is just temporarily done for demonstration purpose.

Thanks a lot

Thank you for your feedback.

@praveenakk2404 - Thanks for your honest opinion. With due respect to comments from viewers like you, I no more add background music to my videos. This video is an old one, I tried removing the music but could not succeed without compromising the overall quality of the video. I apologize for the inconvenience.

@aravinds2871 - Thanks for your interest on my videos. RAC is coming up early 2025.

@jeevanhm - Thanks for your question. Kerberos is not required in the method I am showing in this Part-2 so it is not discussed anywhere in this tutorial. It is covered in Part-3 where we talk about password-less database connection with an AD user. Please do not skip the video as a missing step will waste a lot of your time in troubleshooting.

Thanks looking forward to go through part 3 video

Nice session

Thanks for your feedback.

Thanks for your interest. The Part-2 is going to be released tonight, November 24th, at 8:30 pm EST. If you subscribed my channel, you will get the notifications.

@swapnilkathar9001 - The Part-2 is going to be released tonight, November 24th, at 8:30 pm EST. If you subscribed my channel, you will get the notification. The Part-3 is still in progress and scheduled to be released after 2 weeks.

Please assist

@aravinds2871 - Thanks for your question. Your export syntax looks incorrect. It should be as below: export <PATH or your environment variable>=<the paths you want to specify separated by :> Please also avoid any unnecessary or manually entered line breaks.

​@@YouVolve It works now, thanks!

Thanks for letting me know.

@aravinds2871 - Thanks for your question. Please follow the link below for the steps to share file and folders between the host and the guest machine; VirtualBox VMs - How to Create a Shared Folder Between the Host and the Guest kzbin.info/www/bejne/p6rTcmZolMmWl5Y

@swathikummari4906 - Thanks for your question. Yes, you are right. It will be really hectic to apply patches on OEM agents if there are a lot of them. To address that issue, there is a feature called Gold Agent Image in OEM which can be used for mass deployment of agent. Please watch the 3-Part series on agent GI where I am explaining how to achieve mass install, upgrade & patching of agents in a few click of buttons: kzbin.info/aero/PLgWj5dy2RoFZbUEyL_bWyvDGQ01DB-uQL With agent GI, a DBA's work becomes so easy and quick..🙂.

Thanks for your encouraging words, I appreciate you taking the time to watch.

Glad you like them!

@MohammedMohiuddin-h2r - Thanks for your question. Monitoring Templates are specific to target type. Make sure that the new metric you added to the template is compatible with the target type for that template. For example a 'file system' metric seems to be appropriate for a host target but may not be for a listener or a database target.

@@YouVolve Yes monitoring template ("new fileystem" metric) is for type "host" & I am applying it to a target "host", however its not reflecting on target, other metrics & its thresholds get updated when template is applied

Can you please share the steps you are following. What is your OEM version? Is there really a metric called “new filesystem” for host targets?

You’re welcome 😊

Thanks for your interest. Part-1 was published only 3 days back. I am working on the part-2 and will be published within 2 weeks.

@sonaticha1683 - Thanks for your feedback. Yes, you are right, "CURRENT_ARC_SIZE_GB" value is partial for the day on which the ME is running and as per the frequency. If the ME is set to run every 4 hours, then in the first run it will calculate only the archivelogs generated during 00:00 - 04:00 hours, in the second run it will calculate the archivelogs generated during 00:00 - 08:00 hours etc. But as a DBA you cannot wait for the end of the day to compare the volume and generate the alert. So, the ME will keep taking into consideration more archivelog volume generated for the day as it runs. So, unless there is really a concerning amount of archivelogs are not generated during the initial hours, you are less likely to get an alert during early in the morning..🙂.

@@YouVolve Thank you for the reply. Yes, you are right, it makes sense to check the amount of the archive log even during the day and if the increase is really worrying, be informed in time. Thanks for the explanation🙂.

Thanks for your feedback.

Hi Andre, Thanks for your feedback. By default OEM does not send alerts on utilization for tablespaces with auto-extensible datafiles. But you can create a Metric Extension (ME) to send such alerts. Please watch the video below to learn how to create an ME for special purposes: kzbin.info/www/bejne/gqDJeoeIaJiWfNU In your case you have to use the SQL below in the ME to create an incident on utilization for tablespaces with auto-extensible datafiles: With t as (SELECT tablespace_name, round(sum(MAXBYTES/1024/1024)) max_mb, round(sum(BYTES/1024/1024)) current_mb, round(sum(USER_BYTES/1024/1024)) data_mb FROM dba_data_files where AUTOEXTENSIBLE='YES' group by tablespace_name ), t2 AS (select tablespace_name, MAX(round((data_mb/decode(max_mb,0,1,max_mb))*100)) Usage_pc, ROW_NUMBER() OVER (ORDER BY MAX(round((data_mb/decode(max_mb,0,1,max_mb))*100)) DESC) RN from t GROUP BY tablespace_name) select tablespace_name,Usage_pc from t2 where rn=1 Please note that ME can accept a SQL who returns only one single row. So, the SQL is written in a way to return only the tablespace with highest utilization. Also you have to define two columns in the ME as the SQL returns two values. First the tablespace name and second the utilization percentage. You have to adjust the thresholds in the column definition to generate the appropriate alert. Hope this will help.

@@YouVolve Hi Manash, Many thanks for your prompt reply and very helpful support.☺

Glad that it helped.

@AltafHussain-xv4fs - Thanks for your question. For host file system monitoring, you don't need a Metric Extension. If you add the host as a managed target, OEM will automatically start monitoring the file systems. You can customize it if you want.

@AltafHussain-xv4fs - Thanks for your question. Once you receive an alert from the ME, you can use the SQL below to identify the sessions/SQLs generating high redo in the DB from where the alert came. Video on how to create the ME and send OEM alert for high archive log generation: kzbin.info/www/bejne/gqDJeoeIaJiWfNU SQL to detect top sessions/SQLs: select A.statistic#,NAME,round(VALUE/1024/1024) REDO_MB,b.sid,c.serial#,a.inst_id,C.status,c.username,c.sql_id,c.program from gv$statname a, gv$sesstat b,gv$session c where a.statistic# = b.statistic# and a.name = 'redo size' and a.inst_id=b.inst_id and b.inst_id=c.inst_id and c.type<>'BACKGROUND' and VALUE>=1048576 and b.sid=c.sid order by value desc

@krishanumishra7729 - Please remove whatever version you installed previously. Then install 8.0.27 or 8.0.28 freshly. It worked for most of the people. Also make sure platform bits are same for the database as well as the connector software.

@venkateshyalla8965 - Thanks for your feedback. Yes, I am working on RAC. It will be published soon.

@ajayalo-m8j - Can you please re-phrase your question and put a little more detail so I am able to understand what you are looking for?

@AltafHussain-xv4fs - Thanks for your feedback. Yes you can check which session/user/query is generating most of the redo.

@@YouVolve Please share the query or steps.

AWS free tier is valid for 1 year. You can use it for learning and practice. Although not all features are available in the free tier, it is enough for learning purpose.

@venkkatmerla4389 - Your question is not very clear to me. But I am trying to answer my best. First be sure to understand what Monitoring Template, Incident Rule and Metric Collections these 3 things refer to. You cannot define thresholds in a incident ruleset as it is for defining the rules for actions to be taken based on severity of an incident. Like what to do when there a Critical incident or what to do when a Warning incident etc. How to determine if an incident is a Critical or Warning is defined in the "Metric and Collection Settings" for the database or target. There you will get the option to define the thresholds for different severities. What kind of alert are you trying to configure in OEM. If you want to alert when a certain % of the processes have been utilized or you want an alert if a database has a process parameter set or changed to less than a certain value? In the first case Metric and Collection Settings already has the metric defined under Database Limits, you just need to define Warning and Critical % values. In the second case, there is no inbuilt metric so you have to create a Metric Extension for that. Please watch this video which will clear up the concepts: kzbin.info/www/bejne/oGrFcmCulsyjqbs

Hi Manash, I am testing one process parameter configuration in one of my environment, I just want to copy rule set which are available in the prod OEM to other OEM is that possible? Kindly help me with your inputs

@venkkatmerla438 - Yes, you can copy a rule set from one OEM to another provided they are of the same version using the Export/Import options. To do that, select the rule set line then under Actions menu select the Export option. That will create an XML file with the name of the rule set and download automatically. You can then copy that xml file to another OEM system and import it using the Import option under the Actions menu in the target OEM system.

@@YouVolve thank you Manas

Please use version 8.0.28 or 8.0.27

It worked when i downloaded 8.0.28, if anyone not getting please do try with this version

Great, thanks for the confirmation.

@gulgamramesh1666 - Thanks for your trust but I apologize. I do not provide any phone consultation as such. Lot of my viewers are requesting for the same and I have to be equal for all. You may contact me over KZbin comments for questions relevant to my videos and I answer them to my best within 24 hours. You can also keep in touch via LinkedIn. But questions related to my videos will be answered only via KZbin comments.

@gulgamramesh1666 - An ME is not going to populate any normal user table as such. But if you have enabled the option "Alerting and Historical Trending" while defining the ME, then the ME will also store the data it has collected from the target in the repository which can be accessed from the table/view sysman.mgmt$metric_current using a SELECT query and checking the ME name in the WHERE clause against the column metric_name and column_label for the column defined. Something like: SELECT target_name, column_label, VALUE FROM sysman.mgmt$metric_current WHERE metric_name LIKE 'ME$XXX' AND metric_label = 'XXX' AND column_label = 'Receiving Colm Defined in ME'

@joseluisdelarosa728 - Thanks for your interest. I get very less response on high level topics like that which makes me feel the time and effort I put to create the video is not worth 🙂. But I assure you, Exadata on a VM is still in my To-Do list but don't have a timeline yet.

Glad it was helpful!

@VaibhavKumbharikar - Thanks for your question. If you are using latest version of the VBox software, then installation of the Guest Additions is very easy. Once you start the Linux VM, click on the "Insert Guest Additions CD Image" item under the Devices menu of the VM's top menu bar. Once you click that, a dialogue box will appear asking to run the installation software automatically. Just press the "Run" button. If the automatic dialogue box does not appear, then double click on the CD icon that appears on the desktop to open its contents and run the one appropriate for your platform like Linux, Windows, Solaris etc. You have to do this using root user and you have restart the machine after the installation for the guest addition to take effect.

@LearningDBwithMemoji - Thanks for your feedback. Please note that OEM MEs are meant to send alerts in short meaningful way as otherwise it will lose focus. Based on the severity determined by the ME, the OEM ruleset sends an alert to phone/PagerDuty (Critical) or over email (Warning). As there may be hundreds of session/SQLs running over the critical threshold in a database with a bad application. If the alert contains the information about all of them, then think how long and boring the message over phone will be. I believe, the DBA on-call will not have that level of patience to listen to the full list, instead he or she will be more interested to hear a message like "5 sessions running longer than 15 minutes in database xxx" - something like that. Once the DBA gets such a message, he or she can go to the database and use the first SQL that I have shared through my google drive (link in the description of the video) to find out which one to kill or spare. Alternately, if you really want the list of long running sessions over an email, you can setup a cron or batch job using the fist SQL. Condition to trigger the email will be the same as used the 2nd SQL for the ME. So, once the on-call DBA receives a phone alert, at the same time an email with the list of sessions will also arrive. Please let me know if that helps.

@naseerakbari4949 - Thanks for your feedback. If direct SSH does not work for you, you can use ssh-key also. In this video, when I am explaining the second method of agent installation, that is the push method from OEM console, you will see I am creating the named credential for "oracle" user with the password. In the second tab named "Ssh Key Credential" of the same Create New Named Credential box, you can specify Private/Public keys you created. It will work the same way.

@nadunsamarasinghe5592 - Thanks for your feedback. Yes, RAC Node rolling upgrade of OS is possible. Oracle allows different releases and kernel version (of the same OS and CPU architecture) for a small amount of time during upgrade. Please check the OL/RHEL supported upgrade path. Although I have not tested but I believe for 7.7 also leapp can be used. Pay attention to the pre-upgrade step and address all critical issues.

Thanks for your feedback

Hello @swathikummari4906 - Please my answers below: - MOS credentials are not mandatory for OEM to function. - If you are following the steps in my tutorial, no additional post installation steps are required. - There are many different methods of agent installation. It does not have to be push/pull method only Tutorial for manual agent installation: kzbin.info/www/bejne/eXPMg2eYZ6esqdE Tutorial for agent installation using Gold Image: kzbin.info/www/bejne/jHbRnYd5m5eZqqc Hope this will help.

Thanks

@dhineshraja3474 - Thanks for your question. Oracle has published ODAC with the required set of libraries for third party software like PowerBI to be able to connect to an Oracle database as these software are not designed to access the traditional Oracle Client/Server libraries. Please go through description of the video where I have shared the link to download ODAC and install instructions will be there with the downloaded package itself. Please let me know if you still face any issues.

Please check my previous response.