-
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.
-
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|