dataonedbmgr.sh reference - NEW! 🚀
Last updated
Last updated
dataonedbmgr.sh is a command that assists the Administrator in updating the Data One database before installing product update packages. This command will analyze and process, in sequence, all the pending installation update packages stored in the <DOIM_HOME>/pkg-repo/tf-inbox folder.
To run SQL scripts from DOIM control node in an assisted way see dataonedbmgr.sh -sqlrun here below.
The database schema and base product data update is driven by the <DOIM_HOME>/config/dataonedb.cfg file. Before running the dataonedbmgr.sh database update command, make sure you carefully fill in all the required parameters as described in the .
NOTE: It is recommended to perform a full database backup before updating your database with dataonedbmgr.sh.
To run SQL scripts from the DOIM control node in an assisted way, make sure you filled it all the required database configuration parameters in <DOIM_HOME>/config/dataonedb.cfg (see the page).
Run the command from <DOIM_HOME>/bin:
./dataonedbmgr.sh -sqlrun
This dataonedbmgr.sh verb runs SQL scripts from DOIM control node.
The command outcome can be checked at several levels of detail:
On the console output, to have a very short outcome indicator
On the global log file <DOIM_HOME>/log/dataonedbmgr.log
On script-specific log files, one for each distinct SQL script <DOIM_HOME>/log/dataonedbmgr_<packagename>_<sqlscriptname>.log
The command processes all the required DDL and DML SQL scripts in sequence. When an error occurs, the command immediately terminates, reporting a detailed error message in the logs.
Once the cause of the error has been analyzed by an Administrator and resolved, the command can be safely run again because all DDL and DML SQL scripts that were successfully processed in a previous run will be automatically skipped.