Oracle 1Z0-902 Exam - Topic 8 Question 68 Discussion

Actual exam question for Oracle's 1Z0-902 exam

Question #: 68
Topic #: 8

You use Enterprise Manager to monitor all the components of your Exadata Database Machine.

Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.

In which two sources would you find diagnostic messages related to this problem?

Aalert logs for Enterprise Manager

Balert logs for the ASM instances

CEnterprise Manager Alerts on the Exadata Storage Server Grid home page

DEnterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances

Ealert logs for the prod database instances

Show Suggested Answer

Suggested Answer: B, E

According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not.

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-administering-asm.html

by Lacey at Aug 02, 2025, 08:49 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-902 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Blair

3 months ago

I think the Enterprise Manager Alerts could also have useful info.

upvoted 0 times

...

Louisa

3 months ago

Wait, are you sure about the ILOM logs? Seems off.

upvoted 0 times

...

Aleta

3 months ago

I agree, ASM logs are key for disk issues.

upvoted 0 times

...

Rochell

4 months ago

Definitely check the alert logs for the ASM instances.

upvoted 0 times

...

Olene

4 months ago

Don't forget to look at the prod database instance logs too!

upvoted 0 times

...

Dominque

4 months ago

I’m a bit confused about the ILOM home page alerts; I don’t recall if they would show anything specific about the asmdisks being offline.

upvoted 0 times

...

Ailene

4 months ago

I feel like the alert logs for the ASM instances are definitely relevant, but I also wonder if the prod database instance logs would have any useful information.

upvoted 0 times

...

Tesha

5 months ago

I remember practicing a question similar to this, and I think the Enterprise Manager Alerts on the Exadata Storage Server might also provide useful insights.

upvoted 0 times

...

Goldie

5 months ago

I think the ASM instance alert logs could be a good place to check for those disk issues, but I'm not entirely sure if they would have all the details we need.

upvoted 0 times

...

Galen

5 months ago

I'm feeling pretty confident about this one. The key is to focus on the specific problem described - asmdisks going offline in the prod database. The alert logs for the ASM instances and the prod database instances are where I'd expect to find the most useful information.

upvoted 0 times

...

Dannie

5 months ago

This seems straightforward to me. The alert logs for the ASM instances and the Enterprise Manager alerts on the Exadata Storage Server Grid home page are the two most likely places to find the relevant diagnostic messages.

upvoted 0 times

...

Kanisha

5 months ago

I'm a bit confused by all the different components and log sources mentioned in the question. I'll need to make sure I understand the relationships between Enterprise Manager, the ASM instances, the Exadata Storage Server, and the database instances.

upvoted 0 times

...

Gabriele

5 months ago

Okay, let's see. We know the issue is with some asmdisks going offline in a RAC database called prod. So I'm thinking the alert logs for the ASM instances and the prod database instances would be the most relevant places to look for diagnostic messages.

upvoted 0 times

...

Novella

6 months ago

Hmm, this looks like a tricky one. I'll need to carefully review the information about the Exadata Database Machine and the different log sources to determine the correct answer.

upvoted 0 times

...

Lezlie

6 months ago

I bet the database admins are gonna be scratching their heads on this one. Hopefully they've got some popcorn ready for the alert log reading marathon!

upvoted 0 times

...

Sharen

6 months ago

I believe the diagnostic messages might also be in the alert logs for the prod database instances.

upvoted 0 times

...

Long

7 months ago

I agree with Anthony, but I also think they could be in the Enterprise Manager Alerts on the Exadata Storage Server Grid home page.

upvoted 0 times

...

Margurite

7 months ago

C and D are also good options. The Exadata Storage Server Grid and ILOM pages might have some helpful connectivity alerts.

upvoted 0 times

Hannah

6 months ago

That's a good idea. I also look at the Enterprise Manager Alerts on the Exadata Storage Server Grid home page.

upvoted 0 times

...

Loren

6 months ago

I usually check the alert logs for the ASM instances when I encounter diskgroup issues.

upvoted 0 times

...

Anthony

8 months ago

I think the diagnostic messages could be in the alert logs for the ASM instances.

upvoted 0 times

...

Gail

8 months ago

B and E for sure. The ASM alert logs and the database alert logs would have all the juicy details on those offline disks.

upvoted 0 times

...