Can I provision Oracle Database without starting it?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Doesn't Need an Answer
Hello everybody,

is it possible to provision a VDB without starting it? I'd like to mount NFS only to watch inside directories and get the spfile. But even though I provision a VDB with the advanced option "Open database after provisioning" checked off, Delphix starts Oracle process anyway, resulting with provisioning failed and I can't read NFS directories.

Thank you.
Gianpiero
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 2,336 Points 2k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
Hi,

To me the workaround could be a hook that stops the vdb once the provisioning finished

Regards,

Mouhssine
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 2,336 Points 2k badge 2x thumb
No problem, for misleading, maybe it's due to my poor english.

If I leave the "open database" checked, the process fails and the NFS directories don't exist and so I can't get the spfile. 
We're facing with some problem during the provision. So the oracle support guys of the customer is asking us the spfile, but if the NFS directories cannot be mounted, we can't get the spfile.

Regards.
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 2,336 Points 2k badge 2x thumb
An upgrade. I think that the spfile will be created after Oracle will have started. I guess that the spfile will be created from the pfile (init parameters). In fact in the first step of the provisioning wizard, in the advanced options, one can modify the init parameters. So the spfile will be created from the init parameters. And so we have to provide to oracle support guys the init parameters instead. What do you think?
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
Hi,

Oh now i have the complete view, you can check please what problem is if you download the tar of engine logs.

Did you run the hostcheker

Mouhssine
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 2,336 Points 2k badge 2x thumb
We already studied the support logs. The problem seems to be Oracle related: ORA-600, no Delphix related. But the ORA-600 is too generic. So the customer asked the oracle support for an help. We delivered the alert logs. 

The ORA 600 is similar to HTTP status response 500: internal server error. It is like: "Houston, we have a problem", "Ok, what is the problem?", "We don't know!".
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
not sure i understood what you are doing there ??

Are you upgrading you existing pracle vdb ??

From what version to what ??

Mouhssine