Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

ORAchk & EXAchk What’s New in 12.2.0.1.3

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

–Automated risk identification and proactive notification before business is impacted

–Health Checks based on most impactful reoccurring problems across Oracle customer base

–Runs in your environment – no need to send anything to Oracle

–Scheduled email Health Check reports

–Findings can be integrated into other tools of choice

Why Oracle ORAchk & EXAchk

Engineered Systems

Non Engineered Systems

Oracle EXAchk

Oracle ORAchk

Common Framework

Lightweight & non intrusive Oracle Stack Health Checks

2

Oracle Database Appliance is the only Oracle Engineered System, which uses ORAchk. For all other Engineered Systems use EXAchk

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

What’s new

Upgrade to Database 12.2 with confidence

Improve performance of SQL queries

Tailor Collection Manager email notifications & control sample data

Prevent Clusterware related outages and corruptions

Guard against an Exadata critical issues

Avoid SuperCluster critical issue

1

2

4

3

6

5

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

What’s new

Upgrade to Database 12.2 with confidence

Improve performance of SQL queries

Tailor Collection Manager email notifications & control sample data

Prevent Clusterware related outages and corruptions

Guard against an Exadata critical issues

Avoid SuperCluster critical issue

1

2

4

3

6

5

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

• New checks to help when upgrading the database to 12.2

• Both pre and post upgrade verification to prevent problems related to:

• OS configuration

• Grid Infrastructure & Database patch prerequisites

• Database configuration

• Cluster configuration

Upgrade to Database 12.2 with confidence

-u –o pre

-u –o post

Pre upgrade

Post upgrade

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

What’s new

Upgrade to Database 12.2 with confidence

Improve performance of SQL queries

Tailor Collection Manager email notifications & control sample data

Prevent Clusterware related outages and corruptions

Guard against an Exadata critical issues

Avoid SuperCluster critical issue

1

2

4

3

6

5

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

• Many new checks focus on known issues in 12c Optimizer as well as SQL Plan Management

• These checks target problems such as: – Wrong results returned

– High memory & CPU usage

– Errors such as ORA-00600 or ORA-07445

– Issues with cursor usage

– Other general SQL plan management problems

All contained in the dba profile:

Improve performance of SQL queries

-profile dba

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

What’s new

Upgrade to Database 12.2 with confidence

Improve performance of SQL queries

Tailor Collection Manager email notifications & control sample data

Prevent Clusterware related outages and corruptions

Guard against an Exadata critical issues

Avoid SuperCluster critical issue

1

2

4

3

6

5

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

• Email notification can now be customized based on one or more business units.

• Under Business Unit Specific Collection Notifications, choose the business unit that you want notifications for

• Defaults to all business units for users with existing notification configured

Tailor Collection Manager email notifications

Administration > Configure Email > Email Notification

Preferences

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Purge Sample Data Load Sample Data

Control Sample Data for the Collection Manager

Administration > Delete Old Data

Configure Email > Configure Mail Server/Notification/Purge Job

Configure Email > Configure Mail Server/Notification/Purge Job

Use either method

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

What’s new

Upgrade to Database 12.2 with confidence

Improve performance of SQL queries

Tailor Collection Manager email notifications & control sample data

Prevent Clusterware related outages and corruptions

Guard against an Exadata critical issues

Avoid SuperCluster critical issue

1

2

4

3

6

5

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Prevent Clusterware related outages and corruptions

• OCR (Oracle Cluster Registry) subnet records can become stale due to subnet configuration changes – Stale subnet records can lead to various startup problems

• Vulnerability to certain OS bugs can lead to corruption in clustered databases

• Checks included to verify network configuration and OS patching

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

What’s new

Upgrade to Database 12.2 with confidence

Improve performance of SQL queries

Tailor Collection Manager email notifications & control sample data

Prevent Clusterware related outages and corruptions

Guard against an Exadata critical issues

Avoid SuperCluster critical issue

1

2

4

3

6

5

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

• Detection for Exadata critical issues

• Other Exadata best practices

Guard against an Exadata critical issues

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

What’s new

Upgrade to Database 12.2 with confidence

Improve performance of SQL queries

Tailor Collection Manager email notifications & control sample data

Prevent Clusterware related outages and corruptions

Guard against an Exadata critical issues

Avoid SuperCluster critical issue

1

2

4

3

6

5

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

• Detection for a critical issue

• Other SuperCluster best practice checks

Avoid SuperCluster critical issue

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

More Info:

ORAchk: Doc 1268927.2 EXAchk: Doc 1070954.1

17

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Safe Harbor Statement

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Confidential – Oracle Internal/Restricted/Highly Restricted 18

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal/Restricted/Highly Restricted 19