Oracle startup scripts run but do not appear to finish when run as a postscript (4046589)

Title: Oracle startup scripts run but do not appear to finish when run as a postscript

Date: Sep 07
Product & Version: NVBU all versions
Module & Version: N/A
OS Version: Unix/Linux
Application version: N/A

Description: This FAQ describes why a postscript fails to start an Oracle database after a backup.

Symptoms:

The script appears to run but according to the Netvault:Backup logs it never exits.

It appears as though the Oracle startup scripts do not pass control back to the Netvault script engine. To overcome this we need to "detach" the IO of the startup scripts from the script engine. The way to do this is by using the "at" command. You will need a wrapper script containing the line below and the main script (the contents of your current script) which is referenced in the wrapper script.

The syntax you will need is:
at -f <full-path-name-of-script> now

This will create an "at" job to run "now" and take the commands to run from "full-path-name-of-script".

The method by which a shell is called from a C program (such as Netvault) does not create the same environment as a normal shell. This can have the effect that you see where the script runs but does not appear to finish. In fact it does finish but Netvault never gets to know about it. By detaching the IO of the script we get around this problem.

SFDC solution number:
English version available ID 2562
Version française disponible ID 2563
Deutsche Version verfügbar ID