Warning: This one may be longer than normal
How many times have you ran an exachk, produced the text file, and then had to either read the file on the compute node or copy it to your local machine? Well there is another way to view the report of the EXACHK; it can even be ran on a timely basis so you have current EXACHK information on a regular basis. What I’m talking about is using Oracle Enterprise Manager 12c for scheduling and producing the exachks.
If you look at the Oracle Enterprise Manager 12c (OEM) documentation, you will eventually find information on the plug-in for “Oracle Engineered System Healthchecks”. I’ll make it easy for you, here it is. This plug-in allows OEM to process the XML output from the Exachk tool, which is part of the OEM by default. This approach can be used to automate the assessment of Exadata V2, X2-2, X2-8, SPARC Supercluster, Exalogic, Exalytics, and Availability machine system for known configuration problems and best practices.
So why would you want to use OEM to review Exachk items? The OEM interface allows you to view the output from an interface that is easy to view. It allows you to setup metrics against the report to keep track of the health of your engineered system. Lastly, the report can be scheduled to run on a predetermined timeframe so you don’t forget to run it.
Prerequisites
As with anything Oracle there are prerequisites that need to be meet. Fro the healthcheck plug-in there are four simple ones.
- Review Oracle Exadata Best Practices and Oracle Database Machine Monitoring Best Practices (757552.1/1110675.1)
- Verify and enable the Exachk Tool. The plug-in supports Exachk 2.2.2 and later
- Operating systems and platforms (docs has the list, here)
- Oracle Enterprise Manager 12c (12.1.0.3)
Plug-In
Once the prerequisites have been confirmed, then you will need to deploy the plug-in. Before the plug-in can be deployed, in most environments, it needs to be applied to the software library. To download or apply the plug-in to the software library, this is done from the Setup –> Extensibility –> Self Update menu. Figure 1, shows that the plug-in has already been downloaded and applied to the software library.
Figure 1: Plug-in applied to software library
Add Healthcheck Targets
Ever wonder what the “Add Targets Declaratively by Specifying Target Monitoring Properties” when adding target manually is used for? Well, this is one of those times where you get to use it. When adding Healthcheck targets, you will use the Setup –> Add Targets –> Add Targets Manually menu items. When you reach the Add Targets Manually page, select the “Add Targets Declaratively by Specifying Target Monitoring Properties” option; then select “Oracle Engineered System Healthchecks” from the drop down menu, then add the monitoring agent for one of the compute nodes in the Exadata machine. Lastly click the Add Manually button. Once all this is completed, you should end up on the “Add Oracle Engineered System Healthchecks” page (Figure 2).
Figure 2: Add Oracle Engineered System Healthchecks page
A few things to notice on this page. First the Target Name, this can be any name you want to give the healthcheck target. It will be used to look the target up in the All Targets page. Other than All Targets, there is no direct way to get to the healthcheck targets (I’ve looked, still searching).
In the properties dialog area, notice the Max Interval Allowed. This is the number of days between consecutive Exachk runs. You can make this longer or shorter; depends on you environment. 31 is the default and recommended by Oracle.
The Exachk Results Directory is where OEM will read the Exachk information from. In most of the environments, I usually use /home/oracle. Fill in what you need.
Prerequisites for Exachk Tool
I know, I know, thought you took care of the prerequisites earlier before starting. Well, this is another set of prerequisites. This time, you need to make changes to the .profile (.bash_profile) for the Oracle use. There are two entries that you need to add to the .profile. Table 1 below provides the details and values that should be set with these parameters.
Table 1: Environment parameters for profiles
| Parameter | Value | Why |
| RAT_COPY_EM_XML_FILES |
1 |
Setting this environment variable will enable copying of results between all nodes in the cluster |
| RAT_OUTPUT | <exachk output directory> | Location where results will be copied to for all nodes in the cluster. |
Run Exachk Tool
Here comes the fun part; you get to run the Exachk tool. When I say run, I mean configure it to run in the back ground on the Exadata Machine. What there is a way to keep Exachk running in the background?…Yep!
The way this is done is by using the daemon (-d start) option to keep it running (Listing 1). Although the Exachk process will start to run as a daemon, you will still be prompted for the information required. Once you have provided all the information (password and such), the daemon will remember this until the daemon is stopped.
Listing 1: Start Exachk as daemon
./exachk –d start
Now with Exachk running in the background as a process; how do you get Exachk to run? Well, you initially have to run Exachk. When you do, everything you entered at the prompts previously will be used.
To run Exachk in silent mode, use the –daemon option. For the purpose of OEM, it is best to gather all the information the report can obtain. From the command prompt run Exachk (Listing 2).
Listing 2: Run Exachk silently
./exachk –daemon –a
Metrics Collected
Now that the Exachk is done running, you want to see the results in OEM. In order to do this, you need to tell the agent to upload the results. Over time, the results will be uploaded; however, on the initial setup, you will want to run the upload process manually. Listing 3 provides the command used to force the upload.
Listing 3: Force agent to upload Exachk results
./emctl control agent runCollection <target_name>:oracle_exadata_hc ExadataResults
Checking to see what is in OEM
Now that everything has been configured, Exachk ran and the management agent uploaded it, where can you see the results of this configuration?&n
bsp; The easiest way to see is from All Targets –> Engineered Systems –> Oracle Engineered System Healthchecks. Then you need to click on the target name.
Once you are on the healthchecks page, you will notice a lot of information. There are 3 main areas: Summary, Incidents and Problems, and Results Summary. This is all the information that the Exachk report generated and the management agent uploaded. Figure 3 is a small snapshot of the overall screen.
Figure 3: partial view of healthchecks page
Summary
Once again, Oracle Enterprise Manager 12c, has proven to be a tool that can do more than is expected. Although, us command line junkies who like to run reports and various other items from the command line may look down on this; the Healthcheck plug-in is a cool way to review Exachk information. Also a slick way to remember to run it each month….because it is scheduled.
Enjoy!
twitter: @dbasolved
blog: http://dbasolved.com
Please follow and like:
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Be critical. One-night time stands are definitely not widespread in China – the ladies from this country desire severe relationships, so displaying your serious attentions will add you some factors. They are not as liberated because the western tradition, where the one-night stand is widespread. Compared with western society, which values “individuality,†Qian stated Chinese or Asian culture can be more “family-oriented†and below such settings, getting married or not isn’t just a difficulty for the children but also their mother and father. “In my analysis, many Chinese immigrants in Vancouver discovered the place to be remoted and tough to even discover a friend,†stated Qian. Be part of right now to search out enticing Chinese language singles. In response to some research, about one in 4 folks meet their love on-line in the present day and the ratio is rising frequently. Cameras women really do not like it and attempt to get rid of the maddening interlocutor. It’s necessary to remember that Chinese language mail order wives are women from a particular cultural setting and so they love issues that different Chinese women like. This has benefits for each women and men: males can fully meet their requirements and ladies communicate with those who have actually severe intentions and are prepared for worldwide relationships.
There aren’t many Chinese sites that present free textual content chat, audio chat and streaming webcam chat, which allows you to know for sure that the person you are chatting with is definitely the individual within the account they have listed. These are scammers. It’s weird that each of you just met online they usually want to know very personal information instantly. Yes, compared to fly over to Asia seeking love, it is a wise choice to enroll an Asian courting site and date single Asian ladies who’re additionally discover a relationship online. However generally it will not ship you matches and you cannot discover one by your self, because it isn’t YOU but chnlove review eHarmony to decide who it is best to date! Whether or not you’re dating in China right now, or planning a visit there soon – VIDA can show you how to meet the kind of engaging, clever, and intriguing people you actually need to date.
China Passions is likely one of the few Chinese neighborhood websites that is 1) FREE and 2) works as either a relationship site or a social networking site (or as type of a hybrid of both), providing you with the opportunity to seek out others in the Chinese language neighborhood to connect with round shared pursuits. Find the power to grow to be the top of the family! Cards find members in your space, this Chinese dating site makes use of a playing cards function that locates your browser based mostly on Wi-Fi indicators after which without different singles in your region. There’s even an annual “mass marriage†occasion for members. There’s a devoted buyer assist team that can make your on-line dating experience even higher. Fashionable relationship platforms supply each alternative to create a severe relationship: detailed profiles, picture albums, chat, e mail service, video calls, sending actual gifts, and even organizing conferences. Moreover, objective-made platforms embrace well-elaborated options explicitly designed for Chinese American singles to carry their on-line journey to the entire new degree.
Chinese language girls and men are open to relationships with foreigners, and the majority have a decent degree of English, so discovering common ground is simple. The movie is centered round a middle-aged Chinese immigrant named Evelyn Wang (played by Yeoh) who’s swept up into an insane adventure in which she alone can save existence by exploring different universes and connecting with the lives she might have led. Although some readers may miss it, I think those that learn the blog very closely will discover that this British girl was courting a Chinese language man only as a challenge in connection with writing a general column about interracial dating. If you’re able to learn a couple of articles on cultural peculiarities of Chinese mail order brides, then such drawback won’t influence your dating experience. It will show your lady that you simply respect her tradition and language and that you’re actually severe about learning more from time to time. For comparability’s sake, America’s common courting show The Bachelor, on ABC (DIS), attracts an viewers of about 7.Seventy five million for every episode, or 2.6% of America’s whole population.