Krishna Nazare wrote:provide pfile with any/all non-default parameter values & then do as below
For our product's backend database (oracle 11g r2), we have to set several tuning parameters. Some of these parameters will be in effect only after the instance is restarted. Is there a way these parameters can be set/preset during instance creation itself, or some other means, so that the additional restart can be avoided.
If this gives a value , good enough you surely need to bounce the db.. otherwise , if this gives a blank output , then do as what sir SB has suggested in the above post. Create a spfile from your pfile and then stop and start.
show parameter spfile
Krishna Nazare wrote:What I'm missing is WHY?
This was useful. What i tried was that during instance creation i can run custom script. As part of custom script, i set the parameters and the script restarts the database instance. With that i am able to set the parameters and get the values set.
We are trying to automate and create the instance without manual intervention in cloud deployment. These two steps had to be carried out manually after creating the instance. With this, there is no need for additional manual steps.You can add all parameters to init or pfile.ora file you are using to create the instance.