817 to 920 Upgrade - SPFILE

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

sure you didnt do startup pfile=....

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

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!