2-Managing an Oracle Instance (2)

2-Managing an Oracle Instance (2) - anaging an Oracle...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: anaging an Oracle Instance Tathagata Bhattacharjee Managing an Oracle Instance Presenter Tathagata Bhattacharjee anaging an Oracle Instance Tathagata Bhattacharjee Objectives After completing this lesson, you will be able to do the following: Create and manage initialization parameter files Configure OMF Start up and shut down an instance Monitor and use diagnostic files anaging an Oracle Instance Tathagata Bhattacharjee Initialization Parameter Files Entries are specific to the instance being accessed There are two kinds of parameters: Explicit : Having an entry in the file Implicit : No entry within the file, but assuming the Oracle default values Multiple files can be used for a single database to optimize performance in different situations Changes to the entries in the file take effect based on the type of initialization parameter file used: Static parameter file PFILE Dynamic parameter file - SPFILE anaging an Oracle Instance Tathagata Bhattacharjee Static parameter file PFILE is commonly referred to as initSID.ora Dynamic or Persistent parameter file SPFILE is commonly referred to as spfileSID.ora anaging an Oracle Instance Tathagata Bhattacharjee Parameter File Contents A list of instance parameters The name of the database the instance is associated with Allocation for memory structure of the System Global Area (SGA) What to do with filled online redo log files The names and location of control files Information on undo segments anaging an Oracle Instance Tathagata Bhattacharjee PFILE initSID.ora The PFILE is a text file that can be modified with an operating system editor Modifications to the file are made manually Changes to the file take effect on next startup anaging an Oracle Instance Tathagata Bhattacharjee Rules for Specifying Parameters Specify values in the following format: keyword = value All parameters are optional The server has a default value for each parameter. This value may be OS dependent depending on the parameter Parameters can be specified in any order Comment lines begin with the # symbol Enclose parameters in double quotation marks to include character literals Additional files can be included with the keyword IFILE If OS is case sensitive, then it is also sensitive in filenames in parameter file Multiple values are enclosed in parentheses and separated by commas anaging an Oracle Instance Tathagata Bhattacharjee SPFILE spfileSID.ora Binary file with the ability to make changes persistent across shutdown and startup Maintained by the Oracle server Records parameter value changes made with the ALTER SYSTEM command. Can specify whether the changes being made is temporary or persistent Values can be deleted or reset to allow an instance to revert to default values anaging an Oracle Instance Tathagata Bhattacharjee The default name is in the format spfileSID.ora....
View Full Document

Page1 / 37

2-Managing an Oracle Instance (2) - anaging an Oracle...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online