Generate New Database template and users Database Extract script automation (Doc ID 546068.1)

Last updated on JULY 26, 2017

Applies to:

Siebel Remote Server - Version 7.5.3.1 [16161] to 15.0 [IP2015] [Release V7 to V15]
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.7.2.6 [18372] Pub Sect
Database: Oracle 10.1.0.5
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9

This document was previously published as Siebel SR 38-3214471363.

***Checked for relevance on 11-Dec-2015***

Symptoms

Hi,

I am creating a script which will automatically generate a new database extract for the new added users .

There are these tasks to complete this script.
- After creation of the user it will check for the status whether the db template available for that env or not if not it will run the new task db template.
- At last when db template is found it will generate the db extract for the user using srvrmgr command.

Please let us know some scripts and command which will directly ran the task for new db extract and if there is no database template found then what should be the command to find that database template doesn't exist.

Is there any flag set into database/any command which should exactly tell if there is no need to generate database template?

Since we could only find out this by running the database extract and if it fails with the error.

Thanks.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms