Edit D:\rfid\database\database\doc\owb.112\e10579\control_ctr_mgmt.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Language" content="en" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta name="robots" content="all" scheme="http://www.robotstxt.org/" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = document) - Version 5.1" /> <meta name="Date" content="2009-07-31T16:48:24Z" /> <meta name="doctitle" content="Oracle® Warehouse Builder Installation and Administration Guide 11g Release 2 (11.2) for Windows and Linux" /> <meta name="partno" content="E10579-01" /> <meta name="docid" content="WBINS" /> <link rel="Start" href="../../index.htm" title="Home" type="text/html" /> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="Stylesheet" href="../../dcommon/css/blafdoc.css" title="Default" type="text/css" /> <script type="text/javascript" src="../../dcommon/js/doccd.js"> </script> <link rel="Contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="Index" href="index.htm" title="Index" type="text/html" /> <link rel="Prev" href="multi_design_mgmt.htm" title="Previous" type="text/html" /> <link rel="Next" href="runtime_mgmt.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10579.pdf" title="PDF version" type="application/pdf" /> <title>Managing the Control Center and Repository</title> </head> <body> <div class="header"> <div class="zz-skip-header"><a name="top" id="top" href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><b>Oracle® Warehouse Builder Installation and Administration Guide<br /> 11<i>g</i> Release 2 (11.2) for Windows and Linux</b><br /> Part Number E10579-01</td> <td valign="bottom" align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="multi_design_mgmt.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="runtime_mgmt.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td align="right" valign="top" style="font-size: 90%"><a href="../e10579.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --><a id="CHDHFAGC" name="CHDHFAGC"></a><a id="WBINS16000" name="WBINS16000"></a> <h1 class="chapter"><span class="secnum">9</span> Managing the Control Center and Repository</h1> <p>Users often need to manage OWB Control Center service and repository. To do this, you can use the utilities in the <code><span class="codeinlineitalic">OWB_HOME</span></code><code>/owb/rtp/sql</code> directory by accessing them at the command prompt. This section describes the available resources and tools, and the necessary management tasks.</p> <p>This section contains the following topics:</p> <ul> <li> <p><a href="#CHDCCGFC">Overview of OWB Control Center and Repository Management</a></p> </li> <li> <p><a href="#CJABFJII">OWB Administrative Utilities</a></p> </li> </ul> <a id="CHDCCGFC" name="CHDCCGFC"></a><a id="WBINS16088" name="WBINS16088"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Overview of OWB Control Center and Repository Management</h2> <p>The OWB Control Center, Control Center service, and OWB repository occasionally require administration tasks that go beyond the OWB Control Center Manager GUI.</p> <p>These tasks can be divided into the following groups:</p> <ul> <li> <p><a href="#CHDICGBH">Starting and Stopping the Control Center Service</a></p> </li> <li> <p><a href="#CHDECAGC">Displaying and Managing Control Center Configuration</a></p> </li> <li> <p><a href="#CHDCBHDA">Managing Control Center Deployment and Execution Jobs</a></p> </li> <li> <p><a href="#CHDHGCCA">OWB Repository and Location Administration Utilities</a></p> </li> </ul> <p>Details about each group of tasks and the associated commands are provided in the following sections.</p> <div class="infoboxnotealso"> <p class="notep1">See also:</p> <ul> <li> <p>An architectural overview including each of the major OWB architectural components in <span class="italic">Oracle Warehouse Builder Concepts</span></p> </li> <li> <p>Process of submitting deployment and execution requests to the Control Center Service in <span class="italic">Oracle Warehouse Builder Concepts</span></p> </li> <li> <p>Information on deployment and execution jobs in <span class="italic">Oracle Warehouse Builder Concepts</span></p> </li> <li> <p>Commands used for managing the Control Center Agent, described in <a href="runtime_mgmt.htm#CIHIHFGG">Chapter 10, "Managing the Control Center Agent"</a></p> </li> </ul> </div> <a id="CHDICGBH" name="CHDICGBH"></a><a id="WBINS16089" name="WBINS16089"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Starting and Stopping the Control Center Service</h3> <p>A group of commands starts and stops the control center service, displays its current availability, and troubleshoots a range of issues.</p> <p>This group includes the following commands:</p> <ul> <li> <p><a href="#CJAFIIDF">"service_doctor"</a> displays a variety of OWB repository and Control Center service diagnostics.</p> </li> <li> <p><a href="#CJADBFJF">"show_service"</a> displays the status of the Control Center service as either <code>Available</code> or <code>Not Available</code>.</p> </li> <li> <p><a href="#CJAHEGHI">"start_service"</a> starts a Control Center service.</p> </li> <li> <p><a href="#CJABCGHG">"stop_service"</a> stops a Control Center service.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CHDECAGC" name="CHDECAGC"></a><a id="WBINS16090" name="WBINS16090"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Displaying and Managing Control Center Configuration</h3> <p>Another group of commands displays and modifies the properties of the Control Center, thereby modifying its behavior.</p> <p>This group includes the following commands:</p> <ul> <li> <p><a href="#CJADGCII">"display_platform_property"</a> displays the value of a platform property</p> </li> <li> <p><a href="#CJAHIABF">"set_ccs_home"</a> sets the properties associated with a Control Center Service</p> </li> <li> <p><a href="#CJABCAHA">"set_platform_property"</a> sets the value of a platform property</p> </li> <li> <p><a href="#CJADJEFD">"set_platform_property_from_file"</a> sets the value of a platform property from a specified file location</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CHDCBHDA" name="CHDCBHDA"></a><a id="WBINS16091" name="WBINS16091"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Managing Control Center Deployment and Execution Jobs</h3> <p>The third group of commands overrides default handling of an OWB deployment or execution requests by the Control Center, deactivates or aborts a job, or expedites handling of a specific request.</p> <p>This group includes the following commands:</p> <ul> <li> <p><a href="#CJAGIJCG">"abort_exec_request"</a> terminates a run that is currently busy.</p> </li> <li> <p><a href="#CJACHCIB">"abort_unit_request"</a> terminates a deployment job at the unit level.</p> </li> <li> <p><a href="#CJAJCFEE">"deactivate_all"</a> deactivates all incomplete deployment and execution jobs.</p> </li> <li> <p><a href="#CJAHFDDG">"deactivate_deployment"</a> deactivates a deployment job.</p> </li> <li> <p><a href="#CJABDHGE">"deactivate_execution"</a> deactivates an execution job.</p> </li> <li> <p><a href="#CJAFGJAG">"expedite_exec_request"</a> expedites a running job</p> </li> <li> <p><a href="#CJAGAFGH">"list_requests"</a> lists the details of any active deployment or execution requests</p> </li> <li> <p><a href="#CJADBDGC">"print_exec_details"</a> prints the audit execution hierarchy and details about executions to a text file</p> </li> <li> <p><a href="#CJAIBECE">"print_running_exec_details"</a> prints the audit execution hierarchy and details about the incomplete executions to a text file</p> </li> <li> <p><a href="#CJAEICFG">"sqlplus_exec_background_template"</a> runs the specified object in the background, as a non-blocking call.</p> </li> <li> <p><a href="#CJAFCHAD">"sqlplus_exec_template"</a> runs the specified object as a blocking call</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CHDHGCCA" name="CHDHGCCA"></a><a id="WBINS16092" name="WBINS16092"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">OWB Repository and Location Administration Utilities</h3> <p>The OWB repository and locations sometimes require direct manipulation. Also, run-time audit data accumulates in the OWB repository, and some users may want to purge historical run-time audit data, to improve performance.</p> <p>This fourth group includes the following commands:</p> <ul> <li> <p><a href="#CJAHCBDE">"delete_warehouse_object"</a> deletes a warehouse object from a location in the repository</p> </li> <li> <p><a href="#CJAFJAEA">"grant_error_table_privileges"</a> enables the Repository Browser to view and purge error tables</p> </li> <li> <p><a href="#CJAICAHF">"grant_upgrade_privileges"</a> grants the required roles and privileges for upgrade deployment actions to a specific user</p> </li> <li> <p><a href="#CJAGDGCC">"UpdateControlCenter"</a> sets the host, port, and service parameters for the Control Center in the OWB Client Repository.</p> </li> <li> <p><a href="#CJABGGIG">"UpdateLocation"</a> sets the host, port, and service parameters for the location in the OWB Client Repository.</p> </li> <li> <p><a href="#CJAEFFIB">"purge_audit_template"</a> purges either deployment or execution audit data</p> </li> <li> <p><a href="#CJAICBGC">"reset_repository"</a> resets the registration details of an OWB repository</p> </li> <li> <p><a href="#CJAEJCIB">"rtrepos_report"</a> displays the details of the Control Center and its registered locations</p> </li> <li> <p><a href="#CJAHBJAH">"set_repository_password"</a> sets the password for the OWB repository</p> </li> </ul> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="CJABFJII" name="CJABFJII"></a><a id="WBINS16093" name="WBINS16093"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">OWB Administrative Utilities</h2> <p>The following information is an alphabetical list of OWB administrative utilities.</p> <a id="CJAGIJCG" name="CJAGIJCG"></a><a id="WBINS16094" name="WBINS16094"></a> <div class="sect2"> <h3 class="sect2">abort_exec_request</h3> <p>The <code>abort_exec_request.sql</code> script terminates a run that is currently busy.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/abort_exec_request.sql <span class="italic">auditId</span> <span class="italic">workspace</span>; </pre> <ul> <li> <p>For an <code>auditId</code> that represents a running job, this script aborts the job cleanly. The <code>auditId</code> may be obtained by running the <code>list_requests.sql</code> script; see <a href="#CJAGAFGH">"list_requests"</a>.</p> </li> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJACHCIB" name="CJACHCIB"></a><a id="WBINS16095" name="WBINS16095"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">abort_unit_request</h3> <p>The <code>abort_unit_request.sql</code> script terminates a deployment job at the unit level. A deployment unit is a collection of objects that are being deployed to the same location with the same deployment action.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/abort_unit_request.sql <span class="italic">auditId</span> <span class="italic">workspace</span>; </pre> <ul> <li> <p>For an <code>auditId</code> that represents a deployment unit job, this script aborts the job cleanly. The <code>auditId</code> may be obtained by running the <code>list_requests.sql</code> script; see <a href="#CJAGAFGH">"list_requests"</a>.</p> </li> <li> <p>he <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAJCFEE" name="CJAJCFEE"></a><a id="WBINS16096" name="WBINS16096"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">deactivate_all</h3> <p>The <code>deactivate_all.sql</code> script deactivates all incomplete deployment and execution jobs.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/deactivate_all.sql <span class="italic">workspace</span>; </pre> <ul> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAHFDDG" name="CJAHFDDG"></a><a id="WBINS16097" name="WBINS16097"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">deactivate_deployment</h3> <p>The <code>deactivate_deployment.sql</code> script deactivates a deployment job.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/deactivate_deployment.sql <span class="italic">auditId </span><span class="italic">workspace</span>; </pre> <ul> <li> <p>For an <code>auditId</code> that represents a deployment job, this script deactivates the job and all its unit jobs cleanly. The <code>auditId</code> may be obtained by running the <code>list_requests.sql</code> script; see <a href="#CJAGAFGH">"list_requests"</a>.</p> </li> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJABDHGE" name="CJABDHGE"></a><a id="WBINS16098" name="WBINS16098"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">deactivate_execution</h3> <p>The <code>deactivate_execution.sql</code> script deactivates an execution job.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/deactivate_execution.sql <span class="italic">auditId </span><span class="italic">workspace</span>; </pre> <ul> <li> <p>For an <code>auditId</code> that represents an execution job, this script deactivates the job cleanly. The <code>auditId</code> may be obtained by running the <code>list_requests.sql</code> script; see <a href="#CJAGAFGH">"list_requests"</a>.</p> </li> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAHCBDE" name="CJAHCBDE"></a><a id="WBINS16099" name="WBINS16099"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">delete_warehouse_object</h3> <p>The <code>delete_warehouse_object.sql</code> script deletes a warehouse object.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/delete_warehouse_object.sql <span class="italic">object</span> <span class="italic">location</span><span class="italic"> workspace</span>; </pre> <ul> <li> <p>The named object is deleted.</p> </li> <li> <p>The <code>location</code> is where the object may be found.</p> </li> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJADGCII" name="CJADGCII"></a><a id="WBINS16100" name="WBINS16100"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">display_platform_property</h3> <p>The <code>display_platform_property.sql</code> script displays the value of a platform property. These properties control the behavior of the control center service.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/display_platform_property.sql <span class="italic">property</span>; </pre> <ul> <li> <p>The script assumes that at most one <code>property</code> with the given name exists. To set the property, see <a href="#CJABCAHA">"set_platform_property"</a>.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAFGJAG" name="CJAFGJAG"></a><a id="WBINS16101" name="WBINS16101"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">expedite_exec_request</h3> <p>The <code>expedite_exec_request.sql</code> script expedites a running job by moving it to the top of the list of pending jobs.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with execute, deploy, and administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/expedite_exec_request.sql <span class="italic">authId</span> <span class="italic">returnNumber</span> <span class="italic">returnCode</span> <span class="italic">workspace</span>; </pre> <ul> <li> <p>For an <code>auditId</code> that represents a deployment job, this script expedites the job cleanly. The <code>auditId</code> may be obtained by running the <code>list_requests.sql</code> script; see <a href="#CJAGAFGH">"list_requests"</a>.</p> </li> <li> <p>The <code>returnNumber</code> and <code>returnCode</code> are the result values assigned to the job, and have the following values:</p> <ul> <li> <p><code>0 = OK</code></p> </li> <li> <p><code>1 = OK_WITH_WARNINGS</code></p> </li> <li> <p><code>3 = FAILURE</code></p> </li> </ul> </li> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAFJAEA" name="CJAFJAEA"></a><a id="WBINS16102" name="WBINS16102"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">grant_error_table_privileges</h3> <p>The <code>grant_error_table_privileges.sql</code> script enables the Repository Browser to view and purge error tables. It grants <code>SELECT</code> and <code>DELETE</code> privileges on the specified table to the <code>OWBSYS</code> user.</p> <p>Connect as the user who owns the error table. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/grant_error_table_privileges.sql <span class="italic">tableName</span>; </pre> <ul> <li> <p>In this script, <code>tableName</code> is the name of the error table, such as <code>TABLE1_ERR</code>.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAICAHF" name="CJAICAHF"></a><a id="WBINS16103" name="WBINS16103"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">grant_upgrade_privileges</h3> <p>The <code>grant_upgrade_privileges.sql</code> script grants the required roles and privileges for upgrading deployment actions to a specific user.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with execute, deploy, and administrative privileges, such as <code>SYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/grant_upgrade_privileges.sql <span class="italic">userName</span>; </pre> <ul> <li> <p>In this script, <code>userName</code> is the name of the schema or user who has the new upgrade privileges.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAGAFGH" name="CJAGAFGH"></a><a id="WBINS16104" name="WBINS16104"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">list_requests</h3> <p>The <code>list_requests.sql</code> script lists the details of any active deployment or execution requests. A deployment is a collection of deployment units, which are collections of objects deployed by the same deployment action to the same location. Each deployment or execution is uniquely identified by an audit ID that may be used as a parameter to other SQL scripts, such as <a href="#CJAHFDDG">"deactivate_deployment"</a>, <a href="#CJABDHGE">"deactivate_execution"</a>, and so on.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with execute, deploy, and administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/list_requests.sql <span class="italic">workspace</span>; </pre> <ul> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJADBDGC" name="CJADBDGC"></a><a id="WBINS16105" name="WBINS16105"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">print_exec_details</h3> <p>The <code>print_exec_details.sql</code> script prints the audit execution hierarchy and details about the various executions associated with an <code>auditId</code> to a file called <code>exec_details.txt</code>.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with execute, deploy, and administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/print_exec_details.sql <span class="italic">auditId</span> <span class="italic">workspace</span>; </pre> <ul> <li> <p>The <code>auditId</code> represents an execution job about which this script print the job details. The auditId may be obtained by running the script <code>list_requests.sql</code>; see <a href="#CJAGAFGH">"list_requests"</a>.</p> </li> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAIBECE" name="CJAIBECE"></a><a id="WBINS16106" name="WBINS16106"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">print_running_exec_details</h3> <p>The <code>print_running_exec_details.sql</code> script prints the audit execution hierarchy and details about the various incomplete executions that were started after the specified date associated with an <code>auditId</code> to a file called <code>exec_details.txt</code>.</p> <p>Connect as <code><span class="codeinlineitalic">workspaceOwner</span></code> or <code><span class="codeinlineitalic">workspaceUser</span></code> with execute, deploy, and administrative privileges. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/print_running_exec_details.sql <span class="italic">auditId</span> <span class="italic">workspace</span>; </pre> <ul> <li> <p>The <code>auditId</code> represents an execution job about which this script print the job details. The auditId may be obtained by running the script <code>list_requests.sql</code>; see <a href="#CJAGAFGH">"list_requests"</a>.</p> </li> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAEFFIB" name="CJAEFFIB"></a><a id="WBINS16107" name="WBINS16107"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">purge_audit_template</h3> <p>The <code>purge_audit_template.sql</code> script purges either deployment audit data or execution audit data.</p> <p>Connect as <code>workspaceOwner</code> or <code>workspaceUser</code> with administrative privileges. The script is of the form:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/purge_audit_template.sql <span class="italic">workspace</span> {DEPLOYMENT | EXECUTION} {<span class="italic">sql_predicate</span> | ALL | DATE_RANGE} [<span class="italic">start_date</span> <span class="italic">end_date</span>]; </pre> <ul> <li> <p>The <code>workspace</code> is the workspace where the job is running, and should be declared as <code><span class="codeinlineitalic">workspaceOwner.workspaceName</span></code>. If using only the <code><span class="codeinlineitalic">workspaceName</span></code>, <code><span class="codeinlineitalic">workspaceOwner</span></code> defaults to current user.</p> </li> <li> <p>The <code>audit_type</code> is one of:</p> <ul> <li> <p><code>DEPLOYMENT</code> for deployment audit data; see columns in <code>ALL_RT_AUDIT_DEPLOYMENTS</code> view</p> </li> <li> <p><code>EXECUTION</code> for execution audit data; see columns in <code>ALL_RT_AUDIT_EXECUTIONS</code> view</p> </li> </ul> </li> <li> <p>The <code>condition</code> can be one of:</p> <ul> <li> <p><code>sql_predicate</code>, such as <code>"number_script_run_errors > 0"</code>; this must comply with SQL syntax rules</p> </li> <li> <p><code>ALL</code>, for purging all deployment or execution data</p> </li> <li> <p><code>DATE_RANGE</code>, for purging data within a specified data range</p> </li> </ul> </li> <li> <p>If <code>DATE_RANGE</code> is used, <code>start_date</code> is the start of date range (such as <code>TO_DATE('01-Jan-08')</code> and <code>end_date</code> is the end of the date range (such as <code>SYSDATE</code>).</p> </li> </ul> <p>There are several ways to invoke this script, as demonstrated in these examples:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sqlpurge_audit_template.sql <span class="italic">workspace</span> DEPLOYMENT ALL null null SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sqlpurge_audit_template.sql <span class="italic">workspace</span> EXECUTION "number_task_errors > 0" null null SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sqlpurge_audit_template.sql <span class="italic">workspace</span> EXECUTION DATE_RANGE TO_DATE('01-Jan-2008') SYSDATE </pre></div> <!-- class="sect2" --> <a id="CJAICBGC" name="CJAICBGC"></a><a id="WBINS16108" name="WBINS16108"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">reset_repository</h3> <p>The <code>reset_repository</code>.sql script resets the registration details for an OWB repository. It also stores the specified password as the password for the repository; see <a href="#CJAHBJAH">"set_repository_password"</a>. Note that after the registration details are reset, you must register the passwords for all previously registered locations.</p> <p>Connect as repository owner, <code>OWBSYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/reset_repository.sql <span class="italic">password</span> </pre></div> <!-- class="sect2" --> <a id="CJAEJCIB" name="CJAEJCIB"></a><a id="WBINS16109" name="WBINS16109"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">rtrepos_report</h3> <p>The <code>rtrepos_report.sql</code> script displays the details of the Control Center and its registered locations. It provides information before using the <code>location_util.bat</code> script to alter some of the stored credentials.</p> <p>Connect as repository owner, <code>OWBSYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/rtrepos_report.sql </pre></div> <!-- class="sect2" --> <a id="CJAFIIDF" name="CJAFIIDF"></a><a id="WBINS16110" name="WBINS16110"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">service_doctor</h3> <p>The <code>service_doctor.sql</code> script displays diagnostics about the OWB repository and its Control Center Service.</p> <p>Connect as repository owner, <code>OWBSYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/service_doctor.sql </pre></div> <!-- class="sect2" --> <a id="CJAHIABF" name="CJAHIABF"></a><a id="WBINS16111" name="WBINS16111"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">set_ccs_home</h3> <p>The <code>set_ccs_home.sql</code> script sets the properties associated with a Control Center Service to recognize the location of the where to pick up the Instance Number, Version and Server Side Home. These parameters are not included in an OWB Installation when the "Allow Local Control Center Service" option is set.</p> <p>Connect as repository owner, <code>OWBSYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/set_ccs_home.sql <span class="italic">instance</span> <span class="italic">version</span> <span class="italic">server_home</span> </pre> <ul> <li> <p>The <code>instance</code> is the service node instance that you are updating</p> </li> <li> <p>The <code>version</code> is the OWB version that you are using</p> </li> <li> <p>The <code>server_home</code> is the OWB Home on the server computer, where the OWB install components are located.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJABCAHA" name="CJABCAHA"></a><a id="WBINS16112" name="WBINS16112"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">set_platform_property</h3> <p>The <code>set_platform_property.sql</code> script sets the value of a platform property. These properties controls the behavior of the Control Center Service.</p> <p>Note that the script assumes that the specified property must exist and its value is mutable.</p> <p>Connect as repository owner, <code>OWBSYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/set_platform_property.sql <span class="italic">property</span> <span class="italic">property_value</span> </pre> <ul> <li> <p>The <code>property</code> is the name of the property that is changed</p> </li> <li> <p>The <code>property_value</code> is the name of the new value of the property</p> </li> <li> <p>To return a list of the properties, execute the following query:</p> <pre xml:space="preserve" class="oac_no_warn">select property_path from wb_rt_platform_properties where is_mutable <> 0 </pre></li> </ul> </div> <!-- class="sect2" --> <a id="CJADJEFD" name="CJADJEFD"></a><a id="WBINS16113" name="WBINS16113"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">set_platform_property_from_file</h3> <p>The <code>set_platform_property_from_file.sql</code> script sets the value of a platform property to the contents of the <code><span class="codeinlineitalic">file_name</span></code> found in the <code><span class="codeinlineitalic">directory</span></code>. These properties controls the behavior of the Control Center Service.</p> <p>Note that the script assumes that the specified property must exist and its value is mutable.</p> <p>Connect as Control Center owner. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/set_platform_property_from_file.sql <span class="italic">property</span> <span class="italic">directory file_name</span> </pre> <ul> <li> <p>The <code>property</code> is the name of the property that is changed.</p> </li> <li> <p>The <code>directory</code> is the path where the new value for the property can be found.</p> </li> <li> <p>The <code>file_name</code> is the name of the file that contains the new value of the property.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJAHBJAH" name="CJAHBJAH"></a><a id="WBINS16114" name="WBINS16114"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">set_repository_password</h3> <p>The <code>set_repository_password.sql</code> script sets the password for the OWB repository. This password is used by the Control Center Service at startup time.</p> <p>Connect as repository owner, <code>OWBSYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/set_repository_password.sql <span class="italic">password</span> </pre> <ul> <li> <p>The <code><span class="codeinlineitalic">password</span></code> is the new password value.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CJADBFJF" name="CJADBFJF"></a><a id="WBINS16115" name="WBINS16115"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">show_service</h3> <p>The <code>show_service.sql</code> script displays the status of the Control Center Service, which provides access to the deployment and execution features of an OWB repository. The valid return values for the status of the Control Service Center are <code>Available</code> or <code>Not Available</code>. To change the status of the Control Center Service, use the SQL scripts <code><a href="#CJAHEGHI">start_service</a></code> and <code><a href="#CJABCGHG">stop_service</a></code> as appropriate.</p> <p>Connect as repository owner, <code>OWBSYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/show_service.sql </pre></div> <!-- class="sect2" --> <a id="CJAEICFG" name="CJAEICFG"></a><a id="WBINS16116" name="WBINS16116"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">sqlplus_exec_background_template</h3> <p>The <code>sqlplus_exec_background_template.sql</code> script runs the specified object in the background, not blocking the caller. To get the task status and return result, check public views, of the type <code>ALL_RT_*</code>. Use the script <a href="#CJAFCHAD">"sqlplus_exec_template"</a> to run the object in the foreground, which blocks the caller until the completion of the task. In its unchanged form the script takes the three keys required to identify the executable task. The task runs in the background with the default parameters configured prior to deployment. The <code>custom_params</code> (defined on the object in the OWB Designer) and <code>system_params</code> values override the default input parameters of the task. The script returns the following values: <code>1</code> if task reports <code>SUCCESS</code>, <code>2</code> if <code>WARNING</code>, <code>3</code> if <code>ERROR</code>.</p> <p>Connect as <code>workspaceOwner</code> or <code>workspaceUser</code> with execute privilege. The script is of the form:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_background_template.sql <span class="italic"> workspace</span> <span class="italic">location_name </span> {PLSQLMAP | SQLLOADERCONTROLFILE | PROCESSFLOW | ABAPFILE | DATAAUDITOR | SCHEDULEDJOB} [parent/]<span class="italic">task_name</span> <span class="italic">system_params</span> <span class="italic">custom_params</span> </pre> <ul> <li> <p>The <code>workspace</code> is nominated in the parameters, and should be declared as <code>workspaceOwner</code>.<code>workspaceName</code>; if using only <code>workspaceName</code>, <code>workspaceOwner</code> defaults to user.</p> </li> <li> <p>The <code>location_name</code> is the physical name of the location to which the task is deployed.</p> </li> <li> <p>The <code>task_type</code> has the following options:</p> <ul> <li> <p><code>PLSQLMAP</code> is used for OWB PL/SQL mapping.</p> </li> <li> <p><code>SQLLOADERCONTROLFILE</code> is used for OWB SQL*Loader mapping.</p> </li> <li> <p><code>PROCESSFLOW</code> is used for OWB ProcessFlow.</p> </li> <li> <p><code>ABAPFILE</code> is used for OWB SAP mapping.</p> </li> <li> <p><code>DATAAUDITOR</code> is used for OWB DataAuditor mapping.</p> </li> <li> <p><code>SCHEDULEDJOB</code> is used for an OWB scheduled job.</p> </li> <li> <p><code>CTMAPPING</code> is used for OWB Code Template mapping.</p> </li> </ul> </li> <li> <p>The <code>task_name</code> is the physical name of the deployed object; it can be optionally qualified by the name of the deployed parent, like the ProcessFlow package name. A module name cannot be used because it is not a deployable object.</p> </li> <li> <p>The <code>custom_params</code> (defined on the object in the OWB Designer) and <code>system_params</code> values override the default input parameters of the task</p> </li> </ul> <p>There are several ways to invoke this script; note that <code>system_params</code> and <code>custom_params</code> are not used in these examples:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_background_template.sql <span class="italic">workspace</span> <span class="italic">warehouse</span> PLSQL <span class="italic">mapping</span> "," "," SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_background_template.sql <span class="italic">workspace</span> <span class="italic">platform_schema</span> SQL_LOADER <span class="italic">load</span> "," "," SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_background_template.sql <span class="italic">workspace</span> <span class="italic">workflow</span> PROCESS <span class="italic">process_1</span> "," "," SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_background_template.sql <span class="italic">workspace</span> <span class="italic">platform_schema</span> SAP <span class="italic">sap_1</span> "," "," SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_background_template.sql <span class="italic">workspace</span> <span class="italic">warehouse</span> DATA_AUDITOR <span class="italic">data_auditor_1</span> "," "," </pre> <p>Note: The comma character can be escaped using the backslash character (<code>\,</code>); likewise the backslash character can be escaped by using two backlash characters (<code>\\</code>). A single-quote character must be replaced by a sequence of four single-quote characters (<code>''''</code>).</p> </div> <!-- class="sect2" --> <a id="CJAFCHAD" name="CJAFCHAD"></a><a id="WBINS16117" name="WBINS16117"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">sqlplus_exec_template</h3> <p>The <code>sqlplus_exec_template.sql</code> script runs the specified object and blocks the caller until the task is completed. To get the task status and return result, check public views of the type <code>ALL_RT_*</code>. Use the script <a href="#CJAEICFG">"sqlplus_exec_background_template"</a> to run the object in the background, without blocking the caller throughout the completion of the task. The script takes the three keys required to identify the executable task. The task runs with the default parameters configured prior to deployment. The <code>custom_params</code> (defined on the object in the OWB Designer) and <code>system_params</code> values override the default input parameters of the task. The script returns the following values: <code>1</code> if task reports <code>SUCCESS</code>, <code>2</code> if <code>WARNING</code>, <code>3</code> if <code>ERROR</code>.</p> <p>Connect as <code>workspaceOwner</code> or <code>workspaceUser</code> with execute privilege. The script is of the form:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_template.sql <span class="italic"> workspace</span> <span class="italic">location_name </span> {PLSQLMAP | SQLLOADERCONTROLFILE | PROCESSFLOW | ABAPFILE | DATAAUDITOR | SCHEDULEDJOB} [parent/]<span class="italic">task_name</span> <span class="italic"> system_params</span> <span class="italic">custom_params</span> </pre> <ul> <li> <p>The <code>workspace</code> is nominated in the parameters, and should be declared as <code>workspaceOwner</code>.<code>workspaceName</code>; if using only <code>workspaceName</code>, <code>workspaceOwner</code> defaults to user.</p> </li> <li> <p>The <code>location_name</code> is the physical name of the location to which the task is deployed.</p> </li> <li> <p>The <code>task_type</code> has the following options:</p> <ul> <li> <p><code>PLSQLMAP</code> is used for OWB PL/SQL mapping.</p> </li> <li> <p><code>SQLLOADERCONTROLFILE</code> is used for OWB SQL*Loader mapping.</p> </li> <li> <p><code>PROCESSFLOW</code> is used for OWB ProcessFlow.</p> </li> <li> <p><code>ABAPFILE</code> is used for OWB SAP mapping.</p> </li> <li> <p><code>DATAAUDITOR</code> is used for OWB DataAuditor mapping.</p> </li> <li> <p><code>SCHEDULEDJOB</code> is used for an OWB scheduled job.</p> </li> <li> <p><code>CTMAPPING</code> is used for OWB Code Template mapping.</p> </li> </ul> </li> <li> <p>The <code>task_name</code> is the physical name of the deployed object; it can be optionally qualified by the name of the deployed parent, like the ProcessFlow package name. A module name cannot be used because it is not a deployable object.</p> </li> <li> <p>The <code>custom_params</code> (defined on the object in the OWB Designer) and <code>system_params</code> values override the default input parameters of the task</p> </li> </ul> <p>There are several ways to invoke this script; note that <code>system_params</code> and <code>custom_params</code> are not used in these examples:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_template.sql <span class="italic">workspace</span> <span class="italic">warehouse</span> PLSQL <span class="italic">mapping</span> "," "," SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_template.sql <span class="italic">workspace</span> <span class="italic">platform_schema</span> SQL_LOADER <span class="italic">load</span> "," "," SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_template.sql <span class="italic">workspace</span> <span class="italic">workflow</span> PROCESS <span class="italic">process_1</span> "," "," SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_template.sql <span class="italic">workspace</span> <span class="italic">platform_schema</span> SAP <span class="italic">sap_1</span> "," "," SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/sqlplus_exec_template.sql <span class="italic">workspace</span> <span class="italic">warehouse</span> DATA_AUDITOR <span class="italic">data_auditor_1</span> "," "," </pre> <p>Note: The comma character can be escaped using the backslash character (<code>\,</code>); likewise the backslash character can be escaped by using two backlash characters (<code>\\</code>). A single-quote character must be replaced by a sequence of four single-quote characters (<code>''''</code>).</p> </div> <!-- class="sect2" --> <a id="CJAHEGHI" name="CJAHEGHI"></a><a id="WBINS16118" name="WBINS16118"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">start_service</h3> <p>The script <code>start_service.sql</code> starts a Control Center Service that is managed by the database. A Control Center Service, when available, provides access to the deployment and execution features of an OWB repository. To determine if the Control Center Service is available, use the <a href="#CJADBFJF">show_service</a> script; the return values are either <code>Available</code> or <code>Not Available</code>. To stop the service, use the <a href="#CJABCGHG">stop_service</a> script. When the service is invoked using this script, a monitoring job is created; it restarts the service if it fails, or if the database is brought back online. Alternatively, a Control Center Service can be started in a different <code><span class="codeinlineitalic">OWB_HOME</span></code>, on another host; the service is available only when that host is available and provided the service has been started and not stopped.</p> <p>Connect as repository owner, <code>OWBSYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/start_service.sql </pre></div> <!-- class="sect2" --> <a id="CJABCGHG" name="CJABCGHG"></a><a id="WBINS16119" name="WBINS16119"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">stop_service</h3> <p>The script <code>stop_service.sql</code> stops a Control Center Service that is managed by the database. A Control Center Service, when available, provides access to the deployment and execution features of an OWB repository. To determine if the Control Center Service is available, use the <a href="#CJADBFJF">show_service</a> script; the return values are either <code>Available</code> or <code>Not Available</code>. To start the service, use the <a href="#CJAHEGHI">start_service</a> script. When the service is stopped using this script, the monitoring job is removed; the service remains disabled until it is re-started by the <a href="#CJAHEGHI">start_service</a> script.</p> <p>Connect as repository owner, <code>OWBSYS</code>. Run the script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> @<span class="italic">drive</span>:<span class="italic">OWB_HOME</span>/owb/rtp/sql/stop_service.sql </pre></div> <!-- class="sect2" --> <a id="CJAGDGCC" name="CJAGDGCC"></a><a id="WBINS16120" name="WBINS16120"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">UpdateControlCenter</h3> <p>This sql script sets the <code>host:port:service</code> parameters for a control center in the OWB Client Repository. The connection type must be <code>host:port:service</code> .</p> </div> <!-- class="sect2" --> <a id="CJABGGIG" name="CJABGGIG"></a><a id="WBINS16121" name="WBINS16121"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">UpdateLocation</h3> <p>This sql script sets the <code>host:port:service</code> parameters for a location in the OWB Client Repository. The connection type must be <code>host:port:service</code>. The location may be registered or unregistered.</p> </div> <!-- class="sect2" --></div> <!-- class="sect1" --></div> <!-- class="ind" --> <div class="footer"> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="33%" /> <col width="*" /> <col width="33%" /> <tr> <td align="left"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="multi_design_mgmt.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="runtime_mgmt.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td style="font-size: 90%" align="center" class="copyrightlogo"><img width="144" height="18" src="../../dcommon/gifs/oracle.gif" alt="Oracle" /><br /> Copyright © 2000, 2009, Oracle and/or its affiliates. All rights reserved.<br /> <a href="../../dcommon/html/cpyr.htm">Legal Notices</a></td> <td align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> </div> <noscript> <p>Scripting on this page enhances content navigation, but does not change the content in any way.</p> </noscript> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de