Delphix Products

Expand all | Collapse all

Is it correct that Delphix restrict to change init parameters

Jump to Best Answer
  • 1.  Is it correct that Delphix restrict to change init parameters

    Posted 04-04-2017 11:08:00 AM
    How Delphix create pointer for spfile and init.ora file, because init.ora reside in Oracle_home/dbs and spfile reside in DxFS
    #Virtualization


  • 2.  RE: Is it correct that Delphix restrict to change init parameters

    Posted 04-04-2017 11:23:00 AM
    Hi, At creation time delphix will use a temporary init insied $OH/dbs that points out to an spfile hosted under delphix storage. Eg : oracle@linuxtarget dbs]$ cat initBGL.ora spfile='/mnt/provision/BGL/datafile/spfile.ora' [oracle@linuxtarget dbs]$ Once the database is created delphix will issue an alter to set the spfile hosted under delphix to be the default spfile. SQL> sho parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /mnt/provision/BGL/datafile/sp file.ora SQL> Regards, Mouhssine


  • 3.  RE: Is it correct that Delphix restrict to change init parameters

    Posted 04-04-2017 11:26:00 AM
    so if we will execute command create pfile from spfile , so it will not create init.ora in OH/dbs...and also we can not alter static parameters


  • 4.  RE: Is it correct that Delphix restrict to change init parameters

    Posted 04-04-2017 11:29:00 AM
    suppose if we want to increase sga_max_size after provision so how can we increase it


  • 5.  RE: Is it correct that Delphix restrict to change init parameters

    Posted 04-04-2017 12:28:00 PM
    Hi, Static and dynamic parameters can be modified inside spfile. You have just to use correct scope with the alter commande. Scope=memory, scope=spfile or scope=both Regards, Mouhssine


  • 6.  RE: Is it correct that Delphix restrict to change init parameters

    Posted 04-04-2017 01:06:00 PM
    Thanks much.


  • 7.  RE: Is it correct that Delphix restrict to change init parameters

    Posted 04-04-2017 01:07:00 PM
    one more question..can we add more redo log groups after provision


  • 8.  RE: Is it correct that Delphix restrict to change init parameters

    Posted 04-05-2017 06:57:00 PM

    You will not be able to change the online redo log size and groups using the Delphix interface after the VDB is provisioned. 

    Although you can directly log on to the VDB to change your redo log size or number of redo log groups after the VDB is provisioned, your changes will disappear when the VDB is refreshed or rewound. They will be replaced by the Delphix settings you entered previously during provisioning



  • 9.  RE: Is it correct that Delphix restrict to change init parameters
    Best Answer