Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2008
    Posts
    6

    Unanswered: Change spfile location

    Dear frinds ,

    I want to change my spfile default location and change to another location in Oracle10g using Linux platform.
    By default I know it situates in "$ORACLE_HOME/dbs" location , But I want to take it into another location ,so that when i execute "STARTUP" command then it reads spfile form that new location. is it possible to do ?

    plz inform .. ..
    Last edited by shipon; 03-19-08 at 04:30.

  2. #2
    Join Date
    Dec 2007
    Posts
    253
    You would need to create a pfile. have a single parameter in that pfile:
    Code:
    spfile = path/to/your/spfile/spfilename
    Then either give the pfile the appropriate name so that the db automatically reads it at startup OR use the pfile command in your startup statement:
    Code:
    startup pfile = path/to/your/pfile/pfilename
    You CANNOT point to an spfile in the startup command i.e.
    Code:
    startup spfile = path/to/your/spfile/spfilename
    Is NOT valid.
    If you intend running with just a single server parameter file, why do you want to save it in a non-default location

  3. #3
    Join Date
    Mar 2008
    Posts
    6
    Thx pablolee ,

    Actually I have two different AIX server with clustering and also Installed ORacle database . So I need a common 'spfile' so that from each node , I can update any parameter from both node .

    For that reason I need a non-default location for spfile . Can u help me ragarding this purpose ?

  4. #4
    Join Date
    Dec 2007
    Posts
    253
    Clustering (Do you mean RAC? )is outwith my sphere, but I would guess that I already did help you regarding this purpose. (Although I bow to the superior knowledge of pretty much anyone on this particular topic )

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    ln -s /physical/path/to/shared_spfile.ora $ORACLE_HOME/dbs/spfileSID.ora
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Dec 2007
    Posts
    253

    Post

    Like I said:
    I bow to the superior knowledge of pretty much anyone on this particular topic
    Cheers Ana

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •