How to manually modify DB initialization parameters by creating pfile from spfile

pfile is the initialization parameters of DB in plain text, while spfile is the binary one, so to be able to change it, you have to:

  1. Extract the pfile from the spfile:
    “create pfile=’my_path/file_name.ora‘ from spfile;”
  2. Shutdown the DB:
    “shutdown immediate;”
  3. Edit the pfile applying the new parameters with “vi”, “notepad” or any plain text editor
  4. Startup the DB from the pfile:
    “startup pfile=’my_path/file_name.ora‘;”
  5. Generate spfile from pfile:
    “create spfile from pfile=’my_path/file_name.ora‘”

Source: http://www.dba-oracle.com/concepts/pfile_spfile.htm

About SoCRaT

Systems Engineer, OSS & Linux Geek
This entry was posted in Oracle and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s