817 to 920 Upgrade - SPFILE - init<SID>.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: 817 to 920 Upgrade - SPFILE - init<SID>.ora

  1. #1
    Join Date
    Jul 2001
    Posts
    108

    817 to 920 Upgrade - SPFILE - init<SID>.ora

    Hello,

    We have performed an upgrade on the oracle database from 8174 to 9202.

    After the upgrade, I have executed the following command to generate the spfile:

    Create spfile from pfile;

    and the above stament processed successfully and a file spfileCN2.ora generated.

    After the above step I issues the startup command to start the database. The database was started, but it is using the initCN2.ora file instead of spfileCN2.ora .
    show parameters spfile ==> value EMPTY

    Now my question is how can I start the database just by issuing the startup command and it should pick up the spfileCN2.ora as a parameter file?

    I really appreciate your response.

    Thanks & regards,
    Nikee
    Last edited by Nikee; 03-26-2004 at 01:15 PM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    sure you didnt do startup pfile=....

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    Re: 817 to 920 Upgrade - SPFILE - init<SID>.ora

    Hi,
    In 9i the default behaviour of startup command is

    1)initspfile.ora
    2)Default Spfile
    3)init.ora
    4)Default init.ora parameter file

    Any of these files should be in $ORACLE_HOME/dbs directory in UNIX and $ORACLE_HOME/database on NT.In your case you created the spfile from the pfile.In order to use spfile i.e spfileCN2.ora make the following an entry in your pfile.Please make the entry as 1st line of init.ora parameter file.

    SPFILE='/oracle/app/product/9.2.0/admin//spfile/spfile.ora'

    So in this case it will first read the spfile specified and start the database.If it doesnot find then ,it will move as per the above sequence given

    Regards
    Rohit S Nirkhe,Oracle/Apps DBA
    OCP 8i,9i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    rubbish, first is spfile

    Code:
    C:\oracle\ora91\database>sqlplus "/ as sysdba"
    
    SQL*Plus: Release 9.2.0.1.0 - Production on Sat Mar 27 12:21:02 2004
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    
    SQL> show parameter spfile
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    spfile                               string
    SQL> create spfile from pfile;
    
    File created.
    
    SQL> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> exit
    Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    
    C:\oracle\ora91\database>dir
     Volume in drive C is HARDDISK
     Volume Serial Number is 044B-1AFA
    
     Directory of C:\oracle\ora91\database
    
    10/11/2003  20:38              .
    10/11/2003  20:38              ..
    20/08/2002  22:59            31,744 oradba.exe
    10/11/2003  20:38              archive
    24/03/2004  22:40             1,869 OraDim.Log
    04/03/2004  23:13             1,536 PWDDEMO.ora
    10/11/2003  21:37               968 INITdemo.ORA
    31/01/2004  13:02             3,228 sqlnet.log
    27/03/2004  12:21             2,560 SPFILEDEMO.ORA
                   6 File(s)         41,905 bytes
                   3 Dir(s)  25,283,657,728 bytes free
    
    C:\oracle\ora91\database>sqlplus "/ as sysdba"
    
    SQL*Plus: Release 9.2.0.1.0 - Production on Sat Mar 27 12:21:36 2004
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    Connected to an idle instance.
    
    SQL> startup
    ORACLE instance started.
    
    Total System Global Area   93395628 bytes
    Fixed Size                   453292 bytes
    Variable Size              75497472 bytes
    Database Buffers           16777216 bytes
    Redo Buffers                 667648 bytes
    Database mounted.
    Database opened.
    SQL> show parameter spfile
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    spfile                               string      %ORACLE_HOME%\DATABASE\SPFILE%
                                                     ORACLE_SID%.ORA
    SQL>
    if you have an spfile it is used. Don't have to have spfile = in the init.ora, it is ignored if there is an spfile!

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