DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Create spfile

  1. #1
    Join Date
    Jan 2003
    Posts
    40

    Lightbulb Create spfile

    I have created a db in oracle 9i, when a export pfile to spfile and then I startup database don´t recognize control files.
    Anybody knows something
    I only can start database using pfile.
    Thanks everybody

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: Create spfile

    Originally posted by salvareztur
    I have created a db in oracle 9i, when a export pfile to spfile and then I startup database don´t recognize control files.
    Anybody knows something
    I only can start database using pfile.
    Thanks everybody
    how did u export pfile to spfile
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    connect as sysdba and
    CREATE SPFILE FROM PFILE='/u01/.........';

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Re: Create spfile

    Originally posted by salvareztur
    I have created a db in oracle 9i, when a export pfile to spfile and then I startup database don´t recognize control files.
    Anybody knows something
    I only can start database using pfile.
    Thanks everybody
    Check if it is pointing to correct SPFILE

  5. #5
    Join Date
    Jan 2003
    Posts
    40
    I have made.
    create spfile='/oradmin/xxx/spfileDbd.ora' from pfile='/oradmin/xxx/inidDb.ora'

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    move the spfile to ORACLE_HOME/dbs if unix and $ORACLE_HOME/database if windows
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Originally posted by salvareztur
    I have made.
    create spfile='/oradmin/xxx/spfileDbd.ora' from pfile='/oradmin/xxx/inidDb.ora'
    When you create a non-default spfile, you need to specify the SPFILE name in the PFILE, i.e init.ora, The parameter name to be specified in init.ora is SPFILE

    SPFILE = 'current SPFILE name', in your case, it would be
    SPFILE = /oradmin/xxx/spfileDbd.ora

    Now....

    1. Specify this parameter in your PFILE as

    SPFILE = /oradmin/xxx/spfileDbd.ora

    2. Create the SPFILE as

    CREATE SPFILE='/oradmin/xxx/spfileDbd.ora' FROM PFILE='/oradmin/xxx/inidDb.ora'

    3. Shutdown the database
    4. and now try to start the database...

    For more info refer to initialisation parameter SPFILE or non-default SPFILE specification...

    HTH

    Sameer

  8. #8
    Join Date
    Jan 2003
    Location
    india(bangalore )
    Posts
    14

    hello

    hello

    you can create a pfile from spfile . it like this

    create pfile ='file path name '
    from spfile ='filepath name '


    and then try to make to changes ot it and and teh again tyr to creat a spfilefrom the pfile
    abdulkhadeer

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