Home » RDBMS Server » Server Administration » Save Pfile Permanently
Save Pfile Permanently [message #247112] Sun, 24 June 2007 04:37 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I set pfile during startup as I deleted old one. Each time I start the database I have to provide pfile destination. How I can save it permanently.

SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/product/10.2.0/db_2/dbs/initTEST.ora'
SQL> startup pfile='/oracle/app/oracle/product/10.2.0/db_2/dbs/spfileTest.ora';
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1281648 bytes
Variable Size             167772560 bytes
Database Buffers          436207616 bytes
Redo Buffers                7106560 bytes
Database mounted.
Database opened.

SQL> show parameter pfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/product/10.2.0/db_2/dbs/initTEST.ora'




I used,

alter system set spfile='.....';
But it does not work. I need to set before starting up. What is the command as well as procedure..Thanks

[Updated on: Sun, 24 June 2007 04:41]

Report message to a moderator

Re: Save Pfile Permanently [message #247118 is a reply to message #247112] Sun, 24 June 2007 06:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
create spfile from pfile

Regards
Michel
Re: Save Pfile Permanently [message #247169 is a reply to message #247112] Sun, 24 June 2007 22:49 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Thank you so much. You made this forum vivid.
Previous Topic: How can I set HR account unlimited?
Next Topic: ORA-00600:kcbz_check_objd_typ_3
Goto Forum:
  


Current Time: Thu Dec 08 20:10:43 CST 2016

Total time taken to generate the page: 0.07033 seconds