Home » RDBMS Server » Server Administration » Switch database from pfile to spfile. (Oracle 11g)
Switch database from pfile to spfile. [message #525123] Thu, 29 September 2011 04:37 Go to next message
shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore
Junior Member

Hello Experts,

I have a database started using pfile and spfile parameter shows NULL from command prompt as below:

******************************************************************
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
*****************************************************************

Now when I want to change/switch database to start using SPFILE, can I do it with out restarting (shutdown and startup)the database.

Thanks in advance.

Thanks
Shamsh Pervaiz
Re: Switch database from pfile to spfile. [message #525126 is a reply to message #525123] Thu, 29 September 2011 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 57609
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Parameter file is read at startup.
You cannot start without first shutting down.
So the answer to the question is...

Regards
Michel
Re: Switch database from pfile to spfile. [message #525131 is a reply to message #525126] Thu, 29 September 2011 05:37 Go to previous message
shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore
Junior Member

Thanks for quick response.

Shamsh Pervaiz
Previous Topic: ASM rebalance operation never end
Next Topic: recompile package lead to hang
Goto Forum:
  


Current Time: Fri Apr 18 06:36:34 CDT 2014

Total time taken to generate the page: 0.06439 seconds