Parameter Files

Table of Contents

STARTUP RULE OF PRECEDENCE

At instance startup, the rule of precedence is the following:

To use an init<SID>.ora when an spfile exists, use the pfile clause with the startup command. For example:

      startup pfile=/u01/oracle/dbs/init<SID>.ora

This option is not available for an spfile. Oracle will display the following error message if attempted:

      startup spfile=/u01/oracle/dbs/spfile<SID>.ora
      SP2-0714:
      invalid combination of STARTUP options

If the pfile clause is not used for instance startup, the init<SID>.ora is searched for in the following default locations:

Page tags: database init.ora parameter server spfile

page revision: 3, last edited: 29 Sep 2010 17:08

Click here to edit contents of this page.

Click here to toggle editing of individual sections of the page (if possible). Watch headings for an "edit" link when available.

Append content without editing the whole page source.

Check out how this page has evolved in the past.

If you want to discuss contents of this page - this is the easiest way to do it.

View and manage file attachments for this page.

A few useful tools to manage this Site.

See pages that link to and include this page.

Change the name (also URL address, possibly the category) of the page.

View wiki source for this page without editing.

View/set parent page (used for creating breadcrumbs and structured layout).

Notify administrators if there is objectionable content in this page.

Something does not work as expected? Find out what you can do.

General Wikidot.com documentation and help section.

Wikidot.com Terms of Service - what you can, what you should not etc.

Wikidot.com Privacy Policy.