move SPFILE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: move SPFILE

Hybrid View

  1. #1
    Join Date
    Aug 2003
    Posts
    54

    move SPFILE

    Is there any problem if we move the SPFILE to different location???


    what if we only say STARTUP, will Oracle know where to look for SPFILE, is there any drawback to move the SFILE????

    thanks

  2. #2
    Join Date
    Oct 2002
    Location
    Ljubljana,Slovenia
    Posts
    28
    metalink.oracle.com

    Doc ID : Note:166601.1
    Subject: How to migrate from a pfile to a spfile
    Aleš Orehek

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    migrating from a pfile to an spfile isnt the question. It was how to move the location of an spfile

  4. #4
    Join Date
    Oct 2002
    Location
    Ljubljana,Slovenia
    Posts
    28
    migrating from a pfile to an spfile isnt the question. It was how to move the location of an spfile
    Doc ID: Note:166601.1

    You can also specify the SPFILE in a PFILE. This is the only way to start the instance with an SPFILE in a non default location. The entry in the PFILE would look like: SPFILE = /database/startup/spfileora1.ora
    Last edited by AOrehek; 09-26-2003 at 09:43 AM.
    Aleš Orehek

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I haven't tried it. But think you can do this as follows.

    Code:
    1. Create a new initSID.ora file using the current spfile.
    
    2. Start your instance using the initSID.ora file
    
    3. Create the new spfile on the new location
    
    4. Now rename the old spfile on the default location to spfileSID.old
       Edit the spfile location in the initSID.ora file to point to the
       new SPFILE
    
    5. Try starting the instance without specifying the any parameters.
       I think the system would fetch the spfile from the new location
       and start the instance.
    This would require a couple of shutdown and startup on the instance.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

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


Click Here to Expand Forum to Full Width