Managing Oracle Instance Part 2.docx

Managing Oracle Instance Part 2.docx - Muhammad Fikri Bin...

This preview shows page 1 - 2 out of 3 pages.

Muhammad Fikri Bin Idrus Saidi Managing Oracle Instance Part 2 -Alert log -Data dictionary -Dynamic performance views ORACLE ALERT LOG -XML formatted file -Error message generated by ORACLE database -is stored in automatic diagnostic repository(ADR) -Default location is : ORACLE_BASE\diag\rdbms\(db name)\(database sid)\trace\alert_SID.log -records database administrator looking for every day is : 1.Errors (ORA-somecode) 2.Initalization parameters :non-def init params (non default initialization parameters) 3.Administration operation (data definition language(ddl) this is object creation statement :create alter drop table) -How to examine: -ORACLE enterprise manager graphical interface -text/XML editor :wordpad ,gedit, vi Trace File -Written by : server processes and background processes -report status over time: environment information, activity information, error information -helpful for troubleshooting -location of ADR per server is specified using a single initialization parameter : DIAGNOSTIC_DEST -ADR provides :
Image of page 1

Want to read all 3 pages?

Image of page 2

Want to read all 3 pages?

You've reached the end of your free preview.

Want to read all 3 pages?

  • Fall '17
  • DR RAJA RINA
  • Optimal Flexible Architecture, -oracle enterprise manager, ORACLE ALERT LOG, big consumer DPV

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern