Showing posts with label Oracle ASR. Show all posts
Showing posts with label Oracle ASR. Show all posts

Why Exadata for Oracle Databases?

Many time it comes in our mind that why we should go for Exadata, what benefits we can get if we go for Exadata so here we have given some views based on the Exadata architecture, experience and features. This is the most common question in interview.



No doubt there can be many more advantages than what we have given below as we have only given high level views.

  • Exadata is high performance and high available pre-configured device.
  • It consists of servers,storage networking and software in single pre-configured box which is massively scalable, secure and redundant.
  • Multiple compression tiers are available on Exadata which can help customer to compress data as per business requirement to save storage space.
  • Implementation time is very less compare to non-Exadata systems as it's comes as pre-configured and pre-tested.
  • In case on any issue with the Exadata than we need to communicate with only single vendor which doesn't required to contact multiple vendor like non-Exadata setup so solution of issue could be done quicker.
  • Only DMA (Database Machine Administrator) would be required to manage the Exadata so it can manage with lower TCO which reduce the huge cost of manageability.
  • Exadata provides extreme performance for both DW and OLTP databases which is making it and ideal platform for database consolidation.

What Is ASREXACHK Utility?



ASREXACHECK is the utility which is used to make sure that Exadata machine is communicating with ASR manager.


It checks the ASM configuration and performs the test from Database server and ILOM which sends mail from both to configured mail ID and it will report either succeeded or failure to send email.


The asrexacheck utility checks for known configuration issues as well as checking for any previous hardware faults that may not have been reported by ASR due a misconfiguration on the Exadata nodes.

When performing Preventive Maintenance on Exadata the Oracle will ask to run a PM Health Check script (asrexachk) on the individual systems to check the ASR configuration, as well as the health of the hardware components

Installation


Oracle ASR Logfile Location

Location of ASR log on ASR server

#/var/opt/SUNWsasm/log

#/var/opt/SUNWsasm/log/auditlog