Saturday, December 22, 2007

The Server Parameter File in a Real Application Clusters Environment


The purpose of this bulletin is to demonstrate the usage of the server
parameter file, a new feature in 9i, in a Real Application Clusters


This Article is for database administrators of ORAC environments looking to
implement the server parameter file feature in their Application Clusters


In 9i there is a new feature called the server parameter file that will allow
you to store a binary copy of your initialization parameter file. This feature
will allow you to make permanent dynamic changes to parameters within the
database while allowing you to change certain parameters in memory only. For
Oracle Real Application Clusters you can use one server parameter file and
share it between instances.

Creating a server parameter file in a Real Application Clusters Environment:

1. Create a text parameter file that seperates parameters between global and
instance specific parameters. For the instance specific parameters, specify
SID.parameter and for the global parameters just use parameter=. For example:

# Example of Global Parameters

db_name = "V9I"
control_files = ("/ora9i/oradata/V9I/v910ctl1", "/ora9i/oradata/V9I/v910ctl2")

# Example of Instance Specific Parameters for Node 1:

V9IM.instance_name = V9IM
V9IM.instance_number = 1
V9IM.thread =1
V9IM.rollback_segments = (rbs01_t1, rbs02_t1, rbs03_t1, rbs04_t1, rbs05_t1)

# Example of Instance Specific Parameters for Node 2:

V9IZ.instance_name = V9IZ
V9IZ.instance_number = 2
V9IZ.thread =2
V9IZ.rollback_segments = (rbs01_t2, rbs02_t2, rbs03_t2, rbs04_t2, rbs05_t2)

2. Create a raw partition for your spfile using platform specific commands.

3. Start up the instance if it is not already started and issue the following
statement to create your spfile on your raw partition:

create spfile='/dev/vx/rdsk/Stripe12/v910init'
from pfile='/ora9i/oradata/V9I/pfile/spfileV9I.ora';

4. For easy manageability you can create an initSID.ora file in your local
$ORACLE_HOME/dbs directory that points to your spfile:


5. At this point you should be able to start up using your spfile:

SQL> shutdown immediate
SQL> startup

6. You can then backup the file you used to create your spfile to avoid

% mv /ora9i/oradata/V9I/pfile/spfileV9I.ora /ora9i/oradata/V9I/pfile/spfile.bak

Creating a pfile from your spfile:

With the spfile feature you can dump the contents of your spfile back into a
text initialization file. For Example:

create pfile='/ora9i/oradata/V9I/pfile/spfileV9I.ora'
from spfile='/dev/vx/rdsk/Stripe12/v910init';

You can use this feature to backup your spfile.

Viewing parameters in the spfile:

select from v$spparameter;

Changing spfile parameters dynamically:

You can change spfile parameters with alter system commands. You can specify
the scope to determine whether to change the parameter in memory, in your
spfile, or both. Some static parameters like db_name will not allow you to
change the parameter in memory. You can also define the SID to change
instance specific paramters.

o scope can be set to memory, spfile, or both
o sid can be set to define one specific instance

For example:

SQL> alter system set job_queue_processes=30 scope=both sid='V9IZ';

To reset parameters back to their default settings you can issue:

SQL> alter system reset job_queue_processes scope=both sid='V9IZ';


Anonymous said...

I want to buy a second hand iphone (not the iphone 3g). How much should I expect to pay for it?
[url=]unlock iphone[/url]

oakleyses said...

tory burch outlet, polo ralph lauren, ugg boots, chanel handbags, tiffany jewelry, longchamp outlet, longchamp pas cher, gucci handbags, sac longchamp pas cher, uggs on sale, jordan pas cher, michael kors pas cher, ray ban sunglasses, oakley sunglasses, polo outlet, louboutin pas cher, longchamp outlet, burberry pas cher, louis vuitton, cheap oakley sunglasses, replica watches, replica watches, longchamp outlet, christian louboutin outlet, prada handbags, oakley sunglasses wholesale, louis vuitton outlet, oakley sunglasses, ray ban sunglasses, louis vuitton, prada outlet, nike outlet, louis vuitton outlet, christian louboutin, nike free run, nike roshe, ugg boots, nike air max, polo ralph lauren outlet online, kate spade outlet, christian louboutin uk, tiffany and co, nike free, oakley sunglasses, jordan shoes, louis vuitton outlet, nike air max, ray ban sunglasses

oakleyses said...

nike tn, ralph lauren uk, true religion outlet, nike air max uk, burberry handbags, michael kors, abercrombie and fitch uk, nike blazer pas cher, oakley pas cher, timberland pas cher, hogan outlet, uggs outlet, michael kors outlet online, replica handbags, sac vanessa bruno, true religion outlet, converse pas cher, guess pas cher, ray ban pas cher, ray ban uk, true religion outlet, michael kors outlet, mulberry uk, nike roshe run uk, hollister uk, coach outlet, kate spade, nike air max, new balance, true religion jeans, north face, coach outlet store online, uggs outlet, michael kors outlet online, polo lacoste, michael kors outlet, lululemon canada, nike air force, vans pas cher, michael kors outlet, hollister pas cher, michael kors outlet online, sac hermes, michael kors, burberry outlet, michael kors outlet online, north face uk, nike air max uk

oakleyses said...

converse, louboutin, soccer jerseys, ferragamo shoes, hermes belt, longchamp uk, p90x workout, north face outlet, baseball bats, instyler, nike trainers uk, babyliss, mont blanc pens, soccer shoes, nfl jerseys, valentino shoes, oakley, hollister clothing, abercrombie and fitch, chi flat iron, ralph lauren, nike air max, north face outlet, gucci, ray ban, vans, beats by dre, herve leger, jimmy choo outlet, giuseppe zanotti outlet, mac cosmetics, ghd hair, reebok outlet, nike roshe run, hollister, mcm handbags, timberland boots, nike air max, lululemon, bottega veneta, insanity workout, nike huaraches, vans outlet, hollister, iphone cases, wedding dresses, new balance shoes, converse outlet, asics running shoes, celine handbags

oakleyses said...

marc jacobs, ugg,uggs,uggs canada, louis vuitton, swarovski, barbour uk, montre pas cher, moncler outlet, louis vuitton, canada goose outlet, louis vuitton, pandora charms, wedding dresses, juicy couture outlet, moncler, canada goose outlet, louis vuitton, canada goose uk, ugg uk, canada goose, ugg pas cher, coach outlet, hollister, moncler, canada goose outlet, ugg, pandora jewelry, moncler outlet, karen millen uk, pandora jewelry, links of london, louis vuitton, canada goose, canada goose, swarovski crystal, moncler uk, moncler, moncler, doudoune moncler, juicy couture outlet, canada goose jackets, thomas sabo, replica watches, ugg,ugg australia,ugg italia, barbour, pandora uk, supra shoes, lancel, toms shoes