Home » RDBMS Server » Server Administration » how to change 9i spfile back to pfile??
how to change 9i spfile back to pfile?? [message #57729] Wed, 02 July 2003 13:32 Go to next message
fengq
Messages: 38
Registered: October 2002
Member
Hi
I have a database runing in 9i server, I want to make the spfile back to pfile like 8i
how could I change it?

thanks
Re: how to change 9i spfile back to pfile?? [message #57730 is a reply to message #57729] Wed, 02 July 2003 13:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
login as sys
create pfile='your_init_file_with_complete_path' from spfile;

Re: how to change 9i spfile back to pfile?? [message #57735 is a reply to message #57730] Wed, 02 July 2003 15:21 Go to previous messageGo to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Mahesh,

Interesting. Worked.
Re: how to change 9i spfile back to pfile?? [message #57741 is a reply to message #57735] Wed, 02 July 2003 20:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it should..
I use this always....
and
i do the changes to initsid.ora 
mount and open the database with this initsid.ora
check...if everything is ok.
if so,
then create the spfile from this initsid.ora
and use spfile...as usual....
else i still have my spfile with my original settings

----------------------------------------------------------------------

sys@mutation_mutation > create pfile='mypfile.ora' from spfile;

File created.

-- this will fail
-- bring down the database and start using initsid.ora

sys@mutation_mutation > create spfile from pfile='mypfile.ora';
create spfile from pfile='mypfile.ora'
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance

sys@mutation_mutation > !ls -lt spfilemutation*
-rw-r-----   1 oracle   dba         2560 Apr 25 14:59 spfilemutation.ora

sys@mutation_mutation > !rm spfilemutation.ora

sys@mutation_mutation > shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@mutation_mutation > startup pfile='mypfile.ora';
ORACLE instance started.

Total System Global Area  202867632 bytes
Fixed Size                   730032 bytes
Variable Size             167772160 bytes
Database Buffers           33554432 bytes
Redo Buffers                 811008 bytes
Database mounted.
Database opened.
sys@mutation_mutation > create spfile from pfile='mypfile.ora';

File created.

sys@mutation_mutation > !ls -lt spfile*
-rw-r-----   1 oracle   dba         2560 Jul  2 22:03 spfilemutation.ora

sys@mutation_mutation >

Re: how to change 9i spfile back to pfile?? [message #57750 is a reply to message #57729] Thu, 03 July 2003 09:03 Go to previous message
fengq
Messages: 38
Registered: October 2002
Member
when I type: startup pfile='eoralceadmincot3pfileinitcot3.ora' it gives me the following error:

LRM-00109: could not open parameter file 'eoralceadmincot3pfileinitcot3.ora'
ORA-01078: failure in processing system parameters

Thanks
Previous Topic: indexes
Next Topic: Creating DB Link
Goto Forum:
  


Current Time: Fri Sep 20 10:42:08 CDT 2024