Edit D:\rfid\database\database\doc\owb.112\e10579\appendix_troubleshooting.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:28Z" /> <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="security_mgmt.htm" title="Previous" type="text/html" /> <link rel="Next" href="index.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10579.pdf" title="PDF version" type="application/pdf" /> <title>Troubleshooting the Installation and Setup</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="security_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="index.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="WBINS16307" name="WBINS16307"></a><a id="sthref736" name="sthref736"></a> <h1 class="appendix"><span class="secnum">A</span> Troubleshooting the Installation and Setup</h1> <p>This section describes some troubleshooting tasks you may need to perform during installation and setup of Oracle Warehouse Builder.</p> <p>This section includes the following topics:</p> <ul> <li> <p><a href="#i1008897">"General Steps for Troubleshooting Warehouse Builder"</a></p> </li> <li> <p><a href="#CCHBDGGF">"Inspecting Log Files in Warehouse Builder"</a></p> </li> <li> <p><a href="#i1008919">"Error Messages Related to Installation"</a></p> </li> <li> <p><a href="#CCHEDJDD">"Troubleshooting Other Installation Problems"</a></p> </li> <li> <p><a href="#i1010133">"Checking Java Virtual Machine (JVM)"</a></p> </li> </ul> <ul> <li> <p><a href="#i1010132">"Generating Log Files for a Specific Warehouse Builder Component"</a></p> </li> <li> <p><a href="#CHDGHIJJ">"Checking the System Path of Oracle Warehouse Builder"</a></p> </li> <li> <p><a href="#CHDEDEHC">"Configuring OWB for RAC"</a></p> </li> </ul> <a id="i1008897" name="i1008897"></a><a id="WBINS16308" name="WBINS16308"></a> <div class="sect1"> <h2 class="sect1">General Steps for Troubleshooting Warehouse Builder<a id="sthref737" name="sthref737"></a><a id="sthref738" name="sthref738"></a></h2> <p>Take the following steps to troubleshoot errors in Warehouse Builder:</p> <ol> <li> <p>Review this section for a possible solution to the problem.</p> <p>If Warehouse Builder displays an error message during the installation process, then refer to <a href="#i1008919">"Error Messages Related to Installation"</a>. If you did not note the error number, you can review the <a href="#CHDBHADE">"Log Files for Installation Errors"</a>.</p> <p>In the absence of an error message, refer to <a href="#CCHEDJDD">"Troubleshooting Other Installation Problems"</a>.</p> </li> <li> <p>Check for additional information about the problem by <a href="#CCHBDGGF">"Inspecting Log Files in Warehouse Builder"</a>.</p> </li> <li> <p>If the problem remains unresolved, search for a possible solution at My Oracle Support at <code><a href="https://metalink.oracle.com/">https://metalink.oracle.com/</a></code>.</p> </li> <li> <p>Review the Oracle Warehouse Builder Release Notes for installation notes or known issues.</p> </li> <li> <p>If you are unable to resolve the problem in the previous steps, contact Oracle Support.</p> <p>Oracle Support may ask you to complete the steps in <a href="#i1010132">"Generating Log Files for a Specific Warehouse Builder Component"</a>.</p> </li> </ol> </div> <!-- class="sect1" --> <a id="CCHBDGGF" name="CCHBDGGF"></a><a id="WBINS16309" name="WBINS16309"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Inspecting Log Files in Warehouse Builder<a id="sthref739" name="sthref739"></a><a id="sthref740" name="sthref740"></a><a id="sthref741" name="sthref741"></a><a id="sthref742" name="sthref742"></a><a id="sthref743" name="sthref743"></a><a id="sthref744" name="sthref744"></a><a id="sthref745" name="sthref745"></a><a id="sthref746" name="sthref746"></a><a id="sthref747" name="sthref747"></a></h2> <p>This section outlines all the different types of error messages that are logged by Warehouse Builder and how to access them.</p> <p>Warehouse Builder logs the following types of errors:</p> <ul> <li> <p><a href="#CHDBHADE">Log Files for Installation Errors</a></p> </li> <li> <p><a href="#CHDGFIHC">Log Files for Metadata Import and Export Errors</a></p> </li> <li> <p><a href="#CHDIEHDH">Log File for Validation Errors</a></p> </li> <li> <p><a href="#CHDJIDBG">Log File for Generation Errors</a></p> </li> <li> <p><a href="#CHDGCACI">Log Files for Deployment and Execution Errors</a></p> </li> <li> <p><a href="#CHDJAAGI">Log File for Name and Address Server Errors</a></p> </li> </ul> <a id="CHDBHADE" name="CHDBHADE"></a><a id="WBINS16310" name="WBINS16310"></a> <p class="subhead2">Log Files for Installation Errors</p> <p>When you run Oracle Universal Installer to install Warehouse Builder, the installation error logs are automatically stored in:</p> <p>C:\ProgramFiles\Oracle\Inventory\logs\installActions<timestamp>.log</p> <p>When you run the Warehouse Builder Repository Assistant, the workspace installation error logs are stored in:</p> <p><code><span class="codeinlineitalic">OWB_HOME\UnifiedRepos\log_timestamp.log</span></code></p> <p>See <a href="#i1008919">"Error Messages Related to Installation"</a> for suggested actions for commonly encountered errors during installation.</p> <a id="CHDGFIHC" name="CHDGFIHC"></a><a id="WBINS16311" name="WBINS16311"></a> <p class="subhead2">Log Files for Metadata Import and Export Errors</p> <p><span class="bold">Metadata Import:</span> When you import a project or specific objects into your workspace using the Metadata Import Utility, Warehouse Builder records details of the import process in a log file. You can specify the name and location of this log file from the Metadata Import dialog box.</p> <p><span class="bold">Metadata Export:</span> When you export a Warehouse Builder project or specific objects using the Metadata Export Utility, Warehouse Builder records the details of the export in a log file. You can specify the name and location of this log file from the Metadata Export dialog box.</p> <a id="CHDIEHDH" name="CHDIEHDH"></a><a id="WBINS16312" name="WBINS16312"></a> <p class="subhead2">Log File for Validation Errors</p> <p>In Warehouse Builder, you can validate all objects by selecting the objects from the console tree and then selecting <span class="bold">Validate</span> from the Object menu. After the validation is complete, the validation messages are displayed in the Validation Results window.</p> <p>You can also validate mappings from the Mapping Editor by selecting <span class="bold">Mapping,</span> then <span class="bold">Validate.</span> The validation messages and errors are displayed in the Validation Results window.</p> <p>On the Validation tab of the Validation Results window, double-click an object name in the Object column to display the editor for that object. You can fix errors in the editor. Double-click a message in the Message column to display the detailed error message in a message editor window. To save the message to your local system, select <span class="bold">Code</span> in the menu bar, then select <span class="bold">Save as File</span>.</p> <p>Warehouse Builder saves the last validation messages for each previously validated objects. You can access these messages at any time by selecting the object from the console tree in the Project Navigator, select <span class="bold">View</span> from the menu bar, and then click <span class="bold">Validation Messages.</span> The messages are displayed in the Validation Results window.</p> <a id="CHDJIDBG" name="CHDJIDBG"></a><a id="WBINS16314" name="WBINS16314"></a> <p class="subhead2">Log File for Generation Errors</p> <p>After you generate scripts for Warehouse Builder objects, the Generation Results window displays the generation results and errors. Double-click an error under the Messages column on the Validation tab to display a message editor that enables you to save the errors to your local system.</p> <p>After you generate scripts for Warehouse Builder objects, the Generation Results window displays the generation results and errors. Double-click an error under the Messages column on the Validation tab to display a message editor that enables you to save the errors to your local system.</p> <a id="CHDGCACI" name="CHDGCACI"></a><a id="WBINS16316" name="WBINS16316"></a> <p class="subhead2">Log Files for Deployment and Execution Errors</p> <p>You can store execution or deployment error and warning message logs on your local system by specifying a location for them. In the Project Navigator, select the project. Then from the Tools menu, select <span class="bold">Preferences</span>. In the Preferences dialog box, click the Logging option in the object tree to the left. In the list box on the right, you can set the log file path, file name and maximum file size. You can also select the types of logs you want to store.</p> <p>You can view this log of deployment and error messages from the Warehouse Builder console by selecting <span class="bold">View</span> from the menu bar, and then <span class="bold">Messages Log.</span> This Message Log dialog box is read-only.</p> <p>Errors related to the Control Center Service are stored at the following path:</p> <p><code><span class="codeinlineitalic">OWB_HOME\log\Repository_Name\log.xx</span></code> on Oracle Database server.</p> <p>Errors related to transforming or loading data are stored in the Control Center audit tables. You can access these error reports using the Repository Browser. The Browser provides detailed information about past deployments and executions. Click the Execution tab in the Execution reports to view error messages and audit details.</p> <a id="CHDJAAGI" name="CHDJAAGI"></a><a id="WBINS16317" name="WBINS16317"></a> <p class="subhead2">Log File for Name and Address Server Errors</p> <p>If you are using the Name and Address cleansing service provided by Warehouse Builder, you can encounter related errors.</p> <p>Name and address server start up and execution errors can be located at:</p> <p><code><span class="codeinlineitalic">OWB_HOME</span></code><code>\owb\bin\admin\NASver.log</code></p> <p>If your Name and Address server is enabled in:</p> <p><code><span class="codeinlineitalic">OWB_HOME</span></code><code>\owb\bin\admin\NameAddr.properties:TraceLevel=1</code>,</p> <p>then it produces the log file <code>NASvrTrace.log.</code></p> </div> <!-- class="sect1" --> <a id="i1008919" name="i1008919"></a><a id="WBINS16318" name="WBINS16318"></a> <div class="sect1"> <h2 class="sect1">Error Messages Related to Installation</h2> <p>This section includes the following topics:</p> <ul> <li> <p><a href="#CHDJIDED">No fonts were found in '<drive>:\Program Files\ Qarbon\viewlet Builder3jre\lib\fonts'</a></p> </li> <li> <p><a href="#CCHHHBGI">OWBSYS is not granted access to OWB_HOME/owb/bin/admin/rtrepos.properties: Please run UnifiedRepos/reset_owbcc_home.sql specifiying the path of Oracle Home from which the Control Center Service is being run.</a></p> </li> <li> <p><a href="#CIHJHAGC">SYS user does not have SYSDBA privileges.</a></p> </li> <li> <p><a href="#CHDGCIDH">RTC-5301: The Control Center Service is not currently available.</a></p> </li> <li> <p><a href="#i1011722">API5022: Cannot Connect to the Specified Repository</a></p> </li> <li> <p><a href="#CHDEJDGD">Run-time Assistant fails with LoadJava Error.</a></p> </li> <li> <p><a href="#i1010170">Error when specifying a SYSDBA user.</a></p> </li> <li> <p><a href="#i1010179">Regional Name and Address Data Libraries Are Not Available.</a></p> </li> <li> <p><a href="#CHDGGHHF">Lineage and impact analysis reports: Extensive tablespace requirements for materialized views.</a></p> </li> <li> <p><a href="#i1011809">Java out of memory error occurs during a batch operation.</a></p> </li> <li> <p><a href="#i1011911">ORA-01925: Maximum of 30 enabled roles exceeded</a></p> </li> <li> <p><a href="#i1013366">INS0009: Unable to connect to the database. Verify the connect information.</a></p> </li> <li> <p><a href="#tahiti1480216"><span class="bold">INS0022: A spawned program error.</span></a></p> </li> <li> <p><a href="#i1013367">ORA-12154: TNS: Could not resolve service name.</a></p> </li> <li> <p><a href="#i1013016">ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor.</a></p> </li> <li> <p><a href="#tahiti1030825">PL/SQL: ORA-04052: Error occurred when looking up remote object</a></p> </li> <li> <p><a href="#tahiti1031058">IMP-00003: ORACLE error 30371 encounteredORA-30371: column cannot define a level in more than one dimension</a></p> </li> <li> <p><a href="#tahiti1031200">Unable to connect to SQL*Plus in <Oracle Database version></a></p> </li> <li> <p><a href="#tahiti1031954">ORA-04020 deadlock detected while trying to lock object or ORA-04021 timeout occurred while waiting to lock object</a></p> </li> <li> <p><a href="#tahiti1491610">ORA-04088: error during execution of trigger 'DVSYS.DV_BEFORE_DDL_TRG'</a></p> </li> <li> <p><a href="#CCHGHJEH">DPF-0029: Source <Table_Name> must have less than 165 attributes</a></p> </li> </ul> <a id="WBINS16319" name="WBINS16319"></a> <p class="subhead2">Causes and Actions</p> <a id="i1010359" name="i1010359"></a> <div class="msgset"><a id="tahiti1470665" name="tahiti1470665"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="CHDJIDED" name="CHDJIDED"></a>No fonts were found in '<drive>:\Program Files\ Qarbon\viewlet Builder3jre\lib\fonts'</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> After installing Warehouse Builder client components, you installed another software program that relies on Jinitiator and overwrote Java objects necessary of Oracle products. This may prevent you from launching Warehouse Builder or any other Oracle product that depends on Java objects.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Re-install Jinitiator.</div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1494894" name="tahiti1494894"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="CCHHHBGI" name="CCHHHBGI"></a>OWBSYS is not granted access to OWB_HOME/owb/bin/admin/rtrepos.properties: Please run UnifiedRepos/reset_owbcc_home.sql specifiying the path of Oracle Home from which the Control Center Service is being run.</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> When running the script <code>reset_owbcc_home.sql</code> and prompted for the <code><span class="codeinlineitalic">OWB_HOME</span></code>, you typed an invalid path for <code><span class="codeinlineitalic">OWB_HOME</span></code>.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Run the script again and enter the correct path. <p>On all platforms, including both Windows and Unix, the path you enter must use forward slashes, and is case-sensitive. The case of the path entered here must match exactly the case of the path for the Warehouse Builder home as known by the operating system.</p> <p>On Unix, the correct path to enter is the path for the <code><span class="codeinlineitalic">OWB_HOME</span></code> directory. On Windows, to determine the correct path for the <code><span class="codeinlineitalic">OWB_HOME</span></code> directory, and examine the path displayed as part of the default Windows command prompt.</p> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1019067" name="tahiti1019067"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="CIHJHAGC" name="CIHJHAGC"></a>SYS <a id="sthref748" name="sthref748"></a><a id="sthref749" name="sthref749"></a><a id="sthref750" name="sthref750"></a>user does not have SYSDBA privileges.</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> In a standard database installation, the <code>SYS</code> user has <code>SYSDBA</code> credentials and <code>REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE</code>. You can verify the credentials by issuing the following connect statement: <p>SQL> <code>CONNECT sys@tns_name_of_db AS SYSDBA;</code></p> <p>Enter password: sys_password</p> <p>If your database is configured with <code>REMOTE_LOGIN_PASSWORDFILE=NONE</code>, then the statement fails.</p> </div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> If the statement fails, then you have the following options: <ul> <li> <p>Reconfigure your database with</p> <p><code>REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE</code> and create a password file if none exists.</p> </li> <li> <p>If the preceding is not an option, reconfigure your database with</p> <p><code>O7_DICTIONARY_ACCESSIBILITY=TRUE</code>.</p> </li> </ul> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1473361" name="tahiti1473361"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="CHDGCIDH" name="CHDGCIDH"></a>RTC-5301: The Control Center Service is not currently available.</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> A Control Center Service must be running to enable the Control Center to manage deployments and executions. The service connects to the Control Center using JDBC and can be run from any Warehouse Builder home. Normally the service is runs on the server host.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> You can start a service on the server host by using the script <code>start_service.sql</code>. <p>If it is not possible to run the service on the server host, then start the Control Center Service on the local computer using the script <code>local_service_login.sh</code> or <code>local_service_login.bat</code> as appropriate. Use this script as follows:</p> <p><code>local_service_login.sh [-startup | -closedown]</code> <code><span class="codeinlineitalic">OWB_HOME</span></code></p> <p>In this mode, the Control Center Service runs on the local computer and is available only when that computer is available and can connect to the Control Center.</p> <p>Use the script <code>show_service.sql</code> to determine the status of the service.</p> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1473731" name="tahiti1473731"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref751" name="sthref751"></a>Control center service log file reports "DBMS_OBFUSCATION" or "No key is found."</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> The encryption of the passwords is out of sync with the client.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Reset the repository and restart the control center service. To reset the repository, run <span class="italic">owb/rtp/sql/reset_repository.sql</span>.</div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="i1011722" name="i1011722"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref752" name="sthref752"></a>API5022: Cannot <a id="sthref753" name="sthref753"></a><a id="sthref754" name="sthref754"></a>Connect to the Specified Repository</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">This error occurs when you try to connect to the a repository after having performed a database export or import from the Warehouse Builder repository schema.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> The package <code>NAMESPACESERVICEIMPL</code> may be invalid. This occurs after a database export or import from the Warehouse Builder repository schema if the repository owner has no <code>SELECT</code> privilege on <code>SYS.V_$SESSION</code>. You can diagnose the cause as follows: <ol> <li> <p>In SQL*Plus, connect to the Warehouse Builder repository schema.</p> </li> <li> <p>Enter the following command at the SQL prompt:</p> <pre xml:space="preserve" class="oac_no_warn">ALTER PACKAGE NAMESPACESERVICEIMPL compile body; </pre></li> <li> <p>If <span class="bold">Warning: Package body altered with compilation errors</span> appears, enter the following command at the SQL prompt:</p> <pre xml:space="preserve" class="oac_no_warn">show errors; </pre></li> <li> <p>The following errors mean that the Warehouse Builder repository owner has no <code>SELECT</code> privilege on <code>SYS.V_$SESSION</code>.</p> <pre xml:space="preserve" class="oac_no_warn">PL/SQL: SQL statement ignored PLS-00201: Identifier 'SYS.V_$SESSION' must be declared </pre></li> </ol> </div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Complete the following steps: <ol> <li> <p>In SQL*Plus, connect as the <code>SYS</code> user.</p> </li> <li> <p>At the SQL prompt, enter the following command:</p> <pre xml:space="preserve" class="oac_no_warn">grant SELECT on V_$SESSION to Warehouse Builder_Repository_Owner; </pre></li> <li> <p>Connect to the <code><span class="codeinlineitalic">Repository_Owner</span></code>.</p> </li> <li> <p>Enter the following command at the SQL prompt:</p> <pre xml:space="preserve" class="oac_no_warn">alter package NAMESPACESERVICEIMPL compile; </pre></li> </ol> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1019093" name="tahiti1019093"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="CHDEJDGD" name="CHDEJDGD"></a><a id="sthref755" name="sthref755"></a><a id="sthref756" name="sthref756"></a><a id="sthref757" name="sthref757"></a><a id="sthref758" name="sthref758"></a><a id="sthref759" name="sthref759"></a><a id="sthref760" name="sthref760"></a>Run-time Assistant fails with LoadJava Error.</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> This can occur if the Oracle Database does not have the JServer option installed.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Make sure that the Oracle Database has JServer option installed.</div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="i1010170" name="i1010170"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref761" name="sthref761"></a>Error when specifying a SYSDBA user.</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">Oracle Warehouse Builder Assistants require you to provide SYSDBA credentials when installing the Oracle Warehouse Builder Design Repository or run-time components.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> In a standard database installation, the <code>SYS</code> user has <code>SYSDBA</code> credentials. You can verify this from SQL*Plus by issuing the following connect statement: <p><code>connect sys/</code><code><span class="codeinlineitalic">sys_password</span></code><code>@</code><code><span class="codeinlineitalic">TNS_NAME_OF_DB</span></code> <code>as sysdba;</code></p> <p>In a standard database installation, the preceding connect statement works because <code>REMOTE_LOGIN_PASSWORDFILE</code>=<code>EXCLUSIVE</code> and the default password file is created by the installation process.</p> <p>If your database is configured with</p> <p><code>REMOTE_LOGIN_PASSWORDFILE</code>=<code>NONE</code>, then the following statement fails:</p> <p><code>connect sys/</code><code><span class="codeinlineitalic">sys_password</span></code><code>@</code><code><span class="codeinlineitalic">TNS_NAME_OF_DB</span></code> <code>as sysdba;</code></p> <p>In this case, you have two options.</p> </div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Reconfigure your database with <p><code>REMOTE_LOGIN_PASSWORDFILE</code>=<code>EXCLUSIVE</code> and create a password file if none exists.</p> </div> <!-- class="msgaction" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> If the preceding is not an option, then reconfigure your database with <p><code>O7_DICTIONARY_ACCESSIBILITY</code>=<code>TRUE</code>. With this setting, the statement</p> <p><code>connect sys/</code><code><span class="codeinlineitalic">sys_password</span></code><code>@</code><code><span class="codeinlineitalic">TNS_NAME_OF_DB</span></code> enables the Warehouse Builder Assistants to connect to <code>SYS</code> user.</p> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="i1010179" name="i1010179"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref762" name="sthref762"></a>Regional <a id="sthref763" name="sthref763"></a><a id="sthref764" name="sthref764"></a>Name and Address Data Libraries Are Not Available.</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> The Name and Address regional data libraries may not have been installed in the correct location.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Ensure that you have successfully extracted regional data to the <code>NAS_DATA</code> directory. <ol> <li> <p>From the <code><span class="codeinlineitalic">OWB_HOME</span></code>, start the Name and Address Server:</p> <p><span class="bold">For Windows,</span> run <code>owb\bin\win32\NAStart.bat</code>.</p> <p><span class="bold">For Linux,</span> Run <code>owb/bin/unix/NASTART.sh</code>.</p> </li> <li> <p>Open the log file: <code>owb\bin\admin\NASvr.log</code>.</p> <p>The log contains a list of installed countries.</p> <p>If there is no such list, then verify that you have extracted the regional library data to the correct location. If you have extracted the data to the wrong location, then you can either reinstall the data, or modify the <code>owb\bin\admin\NameAddr.properties</code> file to indicate the correct file path. If you modify the <code>NameAddr.properties</code> file, then stop and restart the Name and Address Server as follows:</p> <p><span class="bold">For Windows,</span> start the server by running <code>owb\bin\win32\NAStart.bat</code>. Stop the server by running <code>owb\bin\win32\NAStop.bat</code>.</p> <p><span class="bold">For UNIX,</span> start the server by running <code>owb/bin/unix/NAStart.sh</code>. Stop the server by running <code>owb/bin/unix/NAStop.sh</code>.</p> </li> <li> <p>Once you have verified the installation, you can stop the Name and Address Server if you want, because it is automatically started at the execution of any mapping that employs the Name and Address operator.</p> </li> </ol> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1019134" name="tahiti1019134"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="CHDGGHHF" name="CHDGGHHF"></a>Lineage<a id="sthref765" name="sthref765"></a><a id="sthref766" name="sthref766"></a> and <a id="sthref767" name="sthref767"></a><a id="sthref768" name="sthref768"></a>impact analysis reports: Extensive tablespace requirements for materialized views.</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">The first time you refresh a materialized view, it is populated from the Oracle Warehouse Builder repository. The materialized view can occupy up to twice the amount of space allocated to the entire Warehouse Builder repository.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> Insufficient space has been allocated to the Warehouse Builder repository schema.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> If the Warehouse Builder repository schema is created in a tablespace that is dedicated to its use, these issues are easier to monitor. Ensure that sufficient free space exists on the physical drive for tablespace expansion. Within Oracle Enterprise Manager, ensure that the tablespace is set to <code>Autoextend On</code>. <div class="infoboxnote"> <p class="notep1">Note:</p> To grant permission to an OWB repository user to use Enterprise Manager for performing tasks, enter the following command in SQL*Plus: <code>GRANT</code> <code>SELECT</code> <code>any</code> <code>dictionary</code> <code>to</code> <code>"&OWB</code> <code>repository user"</code><code>;</code></div> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="i1011809" name="i1011809"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref769" name="sthref769"></a>Java <a id="sthref770" name="sthref770"></a><a id="sthref771" name="sthref771"></a><a id="sthref772" name="sthref772"></a><a id="sthref773" name="sthref773"></a>out <a id="sthref774" name="sthref774"></a><a id="sthref775" name="sthref775"></a><a id="sthref776" name="sthref776"></a><a id="sthref777" name="sthref777"></a>of memory error occurs during a batch operation.</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">Operations requiring large amounts of memory can result in a Java out of memory error, if the system resources (such as virtual memory) are constrained.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> There is not enough virtual memory. The Warehouse Builder client runs with a maximum heap size, as defined by the <code>-mx</code> parameter in the <code>owbclient.bat</code> file. The <code>-Dlimit</code> parameter in the <code>owbclient.bat</code> file specifies the memory threshold (80% of Dlimit) at which the Warehouse Builder memory manager begins to assist Java garbage collection. If you change the <code>-mx</code> parameter value, set the <code>-Dlimit</code> parameter to the same value, or at least to 90% of the value. Note that setting the <code>-Dlimit</code> to a low value can have a negative impact on the performance of Warehouse Builder.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Increase the <code>-Dlimit</code> parameter in Warehouse Builder as follows: <ol> <li> <p>Exit Warehouse Builder.</p> </li> <li> <p>Open this file in a text editor:</p> <p><span class="bold">For Windows,</span> open the <code>$OWBHOME\bin\win32\ombplus.bat</code>.</p> <p><span class="bold">For UNIX,</span> open the <code>$OWBHOME\bin\win32\owbclient.sh</code>.</p> </li> <li> <p>Change the <code>-Dlimit</code> parameter to 334.</p> </li> <li> <p>Save and close the file.</p> </li> <li> <p>Restart Warehouse Builder.</p> </li> </ol> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="i1011911" name="i1011911"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref778" name="sthref778"></a>ORA-01925: Maximum of 30 enabled roles <a id="sthref779" name="sthref779"></a><a id="sthref780" name="sthref780"></a><a id="sthref781" name="sthref781"></a><a id="sthref782" name="sthref782"></a><a id="sthref783" name="sthref783"></a>exceeded</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">This error occurs when installing a repository or a target schema.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> The maximum number of enabled roles in the database has been exceeded. When you create a repository or a target schema, new roles are created in the database assigned to the schema in question. When the number of roles exceeds the value of the <code>MAX_ENABLED_ROLES</code> parameter, this error occurs.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Increase the value of the <code>MAX_ENABLED_ROLES</code> parameter in the <code>init.ora</code> file. When you deinstall a repository or a target schema, delete the associated roles as well.</div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="i1013366" name="i1013366"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref784" name="sthref784"></a>INS0009: <a id="sthref785" name="sthref785"></a>Unable to connect to the database. Verify the connect information.</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">This error occurs when you try to connect to a database.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> See the cause for <a href="#i1013016">ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor.</a></div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Follow the instructions for <a href="#i1013016">ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor.</a></div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1480216" name="tahiti1480216"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref786" name="sthref786"></a><span class="bold">INS0022: A spawned program error.</span></span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> This error message can result from a server issue when installing Warehouse Builder run-time components on an HP-UX operating system.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> To identify the server issue, complete the following steps: <ol> <li> <p>From SQL*Plus, connect to a <code>SYS</code> user.</p> <pre xml:space="preserve" class="oac_no_warn">Create user test_lj identified by test_lj; Grant connect, resource to test_lj; </pre></li> <li> <p>Create <code><span class="codeinlineitalic">OWB_HOME</span></code><code>/owb/bin/unix/test.sh</code> with the following contents:</p> <pre xml:space="preserve" class="oac_no_warn">../unix/loadjava -thin -verbose -order -resolve -user 'test_lj/test_lj@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hpdgpa3)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=dgpadw)))' ../../lib/int/rtpserver.jar </pre></li> <li> <p>Change directory to <code><span class="codeinlineitalic">OWB_HOME</span></code><code>/owb/bin/unix/</code>.</p> </li> <li> <p>Run <code>test.sh</code>.</p> </li> </ol> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="i1013367" name="i1013367"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref787" name="sthref787"></a>ORA-12154: TNS: <a id="sthref788" name="sthref788"></a>Could not resolve service name.</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">This error occurs when you try to connect to a database.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> You defined a Warehouse Builder location and specified connection information using SQL*Net. However, the required TNS name is not accessible.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> To set up a TNS name for use during deployment in general and for execution of mappings and process flows, the TNS name needs to be accessible from the <code><span class="codeinlineitalic">OWB_HOME</span></code> being used to run the control center service. To ensure access, run the Net Configuration Assistant from the <code><span class="codeinlineitalic">OWB_HOME</span></code> and then restart the control center service. <p>To set up a TNS name for use by database links, the TNS name needs to be accessible from the database server home. To ensure access, run the Net Configuration Assistant from the database server home.</p> </div> <!-- class="msgaction" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> See the cause for <a href="#i1013016">ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor.</a></div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Follow the instructions for <a href="#i1013016">ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor.</a></div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="i1013016" name="i1013016"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref789" name="sthref789"></a>ORA-12514: TNS: <a id="sthref790" name="sthref790"></a><a id="sthref791" name="sthref791"></a><a id="sthref792" name="sthref792"></a><a id="sthref793" name="sthref793"></a>listener could not resolve SERVICE_NAME given in connect descriptor.</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">This error occurs when you try to connect to a database.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> If you used Oracle Net Easy Configuration or Oracle Net Assistant to create the Net Service Name entry, and you used the default option (Service Name) on the newly created Net Service Name, then the parameter <code>SERVICE_NAME</code> is added to the <code>TNSNAMES.ORA</code> as a subclause to the <code>CONNECT_DATA</code> section in the Net Service Name entry. This replaces the <code>(SID=SIDname)</code> subclause in previous releases of the database, for example, Oracle Database8<span class="italic">i</span> (8.1.x).</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Implement the <code>TNSNAMES.ORA</code> file as follows: <ol> <li> <p>Use the <code>GLOBAL_DBNAME</code> parameter in the <code>LISTENER.ORA</code> for each SID that you want to identify as a separate service. Use the value of this parameter as the value of the <code>SERVICE_NAME</code> parameter. You need to activate any changes that you make to <code>LISTENER.ORA</code> for this purpose by stopping and restarting the listener process.</p> </li> <li> <p>Use the values of the parameters that exist in the <code>INIT.ORA</code>, namely <code>SERVICE_NAMES</code> and <code>DB_DOMAIN,</code> to determine the value of the <code>SERVICE_NAME</code> that you must use in <code>TNSNAMES.ORA</code>. The valid construction of this value is <code>SERVICE_NAMES.DB_DOMAIN</code> with the period separating the two <code>INIT.ORA</code> values. If your <code>SERVICE_NAMES</code> is <code>BIKES</code> and your <code>DB_DOMAIN</code> is <code>COM</code>, then your <code>SERVICE_NAME</code> is <code>BIKES.COM</code>.</p> </li> <li> <p>If there is no <code>DB_DOMAIN</code> parameter set in your <code>INIT.ORA</code>, or if there is no <code>GLOBAL_DBNAME</code> in the <code>LISTENER.ORA</code>, then you can use the <code>SERVICE_NAMES</code> from the <code>INIT.ORA</code> in your <code>TNSNAMES.ORA</code> for the <code>SERVICE_NAME</code> parameter.</p> <p>For example, if <code>INIT.ORA</code> contains <code>SERVICE_NAMES = "TEST817"</code> and <code>db_domain</code> is not set, then the <code>TNSNAMES.ORA</code> entry is: <code>CONNECT_DATA =(SERVICE_NAME = "TEST817"))</code>.</p> </li> <li> <p>If you have multiple values specified in the <code>SERVICE_NAMES</code> parameter in the <code>init.ora</code>, then you can use one of them. If <code>SERVICE_NAMES</code> is not set, then you can use <code>DB_NAME.DB_DOMAIN</code> parameters from the <code>INIT.ORA</code> file.</p> </li> <li> <p>If <code>SERVICE_NAMES</code> and <code>DB_DOMAIN</code> is not set in the <code>INIT.ORA</code> and there is no <code>GLOBAL_DBNAME</code> in the <code>LISTENER.ORA</code>, then your <code>SERVICE_NAME</code> in <code>TNSNAMES.ORA</code> file is <code>DB_NAME</code>.</p> </li> </ol> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1030825" name="tahiti1030825"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref794" name="sthref794"></a>PL/SQL: ORA-04052: Error occurred when looking up remote object</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">This error occurs when you have upgraded to <Oracle Database version> and are trying to redeploy mappings without first redeploying connectors.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> While upgrading Oracle Database, you moved your database to a new computer. Your old and new database instances do not have the same domain name. You can verify the cause by logging in to SQL*Plus as a <code>SYS</code> user and entering the following command: <code>SELECT * FROM GLOBAL_NAME;</code> If the Global Name of the old database does not match that of the new database, then a domain mismatch is causing this error.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Either add the domain name to the Global Name in your new database by issuing a command similar to the following statement: <code>ALTER DATABASE RENAME GLOBAL_NAME TO</code> <code><span class="codeinlineitalic">xxx10G.US.ORACLE.COM</span></code><code>;</code> or redeploy your connectors. <p>Refer to <span class="italic">Oracle Warehouse Builder User's Guide</span> for information on deploying connectors.</p> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1031058" name="tahiti1031058"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref795" name="sthref795"></a>IMP-00003: ORACLE error 30371 encounteredORA-30371: column cannot define a level in more than one dimension</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">This error occurred when you were importing your target schema during migration.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> The Warehouse Builder target schema is created with the <code>select_catalog_role</code> privilege. If you have the same dimension object defined in multiple Warehouse Builder target schemas, then Oracle Export creates duplicates in the export file, and this error occurs when you import.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Connect as a <code>SYS</code> user to the existing version of the Oracle Database from which you exported the target schemas. Enter the following statement in <p>SQL*Plus: <code>revoke select_catalog_role from</code> <code><span class="codeinlineitalic">OLD_Target_Schema</span></code><code>;</code></p> <p>Export the target schema into an Oracle <code>.DMP</code> file again, and then import the file into Oracle Database.</p> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1031200" name="tahiti1031200"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref796" name="sthref796"></a>Unable to connect to SQL*Plus in <Oracle Database version></span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> Your Oracle home or Path is not set correctly, or your Net Service Names are not configured.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Ensure your Oracle home and Path are set correctly, and your Net Service Names are configured in Oracle Database. <ul> <li> <p>Ensure that <code><span class="codeinlineitalic">ORACLE_HOME</span></code> and <code>PATH</code> are set correctly. Your Oracle home directory must to point to the <code><span class="codeinlineitalic">OWB_HOME</span></code>. Set your <code>PATH</code> variable to include the <code><span class="codeinlineitalic">OWB_HOME</span></code><code>\bin</code> directory before any other Oracle products.</p> </li> <li> <p>Ensure that the <code>TNSNames.ora</code> file is configured correctly:</p> <p><span class="bold">For Windows,</span> from Oracle Database program group, start <span class="bold">Net Configuration Assistant</span> and select <span class="bold">Local Net Service Name Configuration</span> to configure <code>TNSNames.ora</code>.</p> <p><span class="bold">For UNIX,</span> set <code>ORACLE_HOME</code> and <code>PATH</code> to the <code><span class="codeinlineitalic">OWB_HOME</span></code> for Warehouse Builder 11<span class="italic">g</span> Release 2 (11.2), then run <code><span class="codeinlineitalic">OWB_HOME</span></code><code>/bin/netca</code> to start <span class="bold">Net Configuration Assistant</span>. Select <span class="bold">Local Net Service Name Configuration</span> to configure <code>TNSNames.ora</code>.</p> </li> </ul> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1031954" name="tahiti1031954"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref797" name="sthref797"></a>ORA-04020 deadlock detected while trying to lock object or ORA-04021 timeout occurred while waiting to lock object</span> <!-- class="msg" --></dt> <dd> <div class="msginfo">When creating run-time objects, the Run-Time Assistant halts and produces these errors in the error log when trying to lock <code>sys.dbms_aq</code>.</div> <!-- class="msginfo" --></dd> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> User sessions may be pinning Advanced Queue objects.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> First, log into SQL*Plus as a <code>SYS</code> user and run a query to identify which user sessions are pinning the Advanced Queue packages, using the following query as an example: <pre xml:space="preserve" class="oac_no_warn">column s.sid format a5; column s.serial# format a8; column s.username format a10; column objectname format a10; select distinct s.sid, s.serial#, s.username, x.kglnaobj as objectname from dba_kgllock l, v$session s, x$kgllk x where l.kgllktype = 'Pin' and s.saddr = l.kgllkuse and s.saddr = x.kgllkuse and x.kglnaobj in ('DBMS_AQ', 'DBMS_AQADM'); </pre> <p>The following is an example of the output you may receive:</p> <pre xml:space="preserve" class="oac_no_warn">SID SERIAL# USERNAME OBJECTNAME --- ------- -------- ---------- 9 29623 RTU_4942 DBMS_AQ </pre> <p>Noting the SID and Serial Number, issue the following command to kill the user sessions:</p> <p><code>ALTER SYSTEM KILL SESSION '</code><code><span class="codeinlineitalic">SIDNoted</span></code><code>,</code> <code><span class="codeinlineitalic">SerialNumberNoted</span></code><code>';</code></p> <p>For example, enter the following command to kill the session listed in the sample output for this error:</p> <p><code>ALTER SYSTEM KILL SESSION '9,29623';</code></p> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1491610" name="tahiti1491610"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref798" name="sthref798"></a>ORA-04088: error during execution of trigger 'DVSYS.DV_BEFORE_DDL_TRG'</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> When you attempt to create a Warehouse Builder repository on an Oracle Database that includes the Database Vault option, you may encounter an error such as ORA-04088.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Disable the triggers DV_BEFORE_DDL_TRG and DV_AFTER_DDL_TRG.</div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti2213588" name="tahiti2213588"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref799" name="sthref799"></a>Import wizard throws error ORA-00997 when importing a table.</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> When you import table definitions from an Oracle Database, you may encounter an error such as "Repository Error Message: ORA-00997: illegal use of LONG datatype...". This occurs when the CURSOR_SHARING parameter is set to FORCE or SIMILAR.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Set the database parameter <code>CURSOR_SHARING</code> to <code>EXACT</code>.</div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --></div> <!-- class="msgset" --> <a id="CCHGHJEH" name="CCHGHJEH"></a> <div class="msgset"><a id="tahiti2229062" name="tahiti2229062"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref800" name="sthref800"></a>DPF-0029: Source <Table_Name> must have less than 165 attributes</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> Creating data profiling on a table having more than 165 columns.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Select a subset of columns from the table for profiling, by defining an attribute set. This is a data profiling restriction.</div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --></div> <!-- class="msgset" --></div> <!-- class="sect1" --> <a id="CCHEDJDD" name="CCHEDJDD"></a><a id="WBINS16320" name="WBINS16320"></a> <div class="sect1"> <h2 class="sect1">Troubleshooting Other Installation Problems</h2> <p>This section includes causes and actions for the following installation problems:</p> <ul> <li> <p><a href="#tahiti1480830">Warehouse Builder Clients that Previously Launched Now Momentarily Display the Splash Screen and Fail to Start</a></p> </li> <li> <p><a href="#tahiti1481001">Newly Installed Warehouse Builder Clients Fail to Start and Previously Launched Oracle Products Fail to Start</a></p> </li> <li> <p><a href="#tahiti1481108">A Warehouse Builder Client Freezes or Hangs</a></p> </li> </ul> <a id="WBINS16321" name="WBINS16321"></a> <p class="subhead2">Causes and Actions</p> <div class="msgset"><a id="tahiti1480830" name="tahiti1480830"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref801" name="sthref801"></a>Warehouse Builder Clients that Previously Launched Now Momentarily Display the Splash Screen and Fail to Start</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> If you attempt to start a Warehouse Builder client such as the Design Center and the splash screen displays momentarily but the client fails to start, you may have overwritten required java objects during the subsequent installation of another software product. <p>If the client is installed on Windows and you launched the client from the Start menu, you may not see any error messages.</p> </div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Manually start the client by typing at the DOS prompt <code>run OWB_HOME\owb\owbclient.bat.</code> You are likely to encounter an error message such as <a href="#CHDJIDED">No fonts were found in '<drive>:\Program Files\ Qarbon\viewlet Builder3jre\lib\fonts'</a>.</div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1481001" name="tahiti1481001"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref802" name="sthref802"></a>Newly Installed Warehouse Builder Clients Fail to Start and Previously Launched Oracle Products Fail to Start</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> After installing Warehouse Builder software, an error in the path variable can prevent you from launching Warehouse Builder clients and other Oracle products that previously launched without problems.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> Verify the that the path for <code><span class="codeinlineitalic">OWB_HOME</span></code><code>\bin</code> is listed correctly in the Environmental Variables.</div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --> <a id="tahiti1481108" name="tahiti1481108"></a> <div class="msgentry"> <dl> <dt><span class="msg"><a id="sthref803" name="sthref803"></a>A Warehouse Builder Client Freezes or Hangs</span> <!-- class="msg" --></dt> <dd> <div class="msgexplan"><span class="msgexplankw">Cause:</span> Client software may freeze or hang due to various causes.</div> <!-- class="msgexplan" --></dd> <dd> <div class="msgaction"><span class="msgactionkw">Action:</span> <a id="sthref804" name="sthref804"></a><a id="sthref805" name="sthref805"></a><a id="sthref806" name="sthref806"></a>If a Warehouse Builder client appears to freeze or hang, perform a stack trace as follows: <ol> <li> <p>At the DOS command prompt, enter:</p> <p><code>cd</code> <code><span class="codeinlineitalic">OWB_HOME</span></code><code>\owb\bin\win32\</code></p> </li> <li> <p>Run <code>owbclient.bat</code>.</p> </li> <li> <p>When the program hangs, press <span class="bold">Ctrl</span>+<span class="bold">Break</span>.</p> <p>This produces the thread-dump. Contact Oracle Support and provide them with this information to help identify the problem.</p> </li> </ol> </div> <!-- class="msgaction" --></dd> </dl> </div> <!-- class="msgentry" --></div> <!-- class="msgset" --></div> <!-- class="sect1" --> <a id="i1010133" name="i1010133"></a><a id="WBINS16322" name="WBINS16322"></a> <div class="sect1"> <h2 class="sect1">Checking <a id="sthref807" name="sthref807"></a>Java Virtual Machine (JVM)</h2> <p>To check, verify, or reinstall the Java Virtual Machine (JVM) server in the database, refer to My Oracle Support:</p> <ol> <li> <p>In your Web browser, go to the following URL: <code><a href="http://metalink.oracle.com">http://metalink.oracle.com</a></code>.</p> </li> <li> <p>Log into My Oracle Support, or register as a new user.</p> </li> <li> <p>Enter the following terms into the Search field, separating each term by semicolons):</p> <p><code>INITJVM.SQL;</code> <code>INSTALL;</code> <code>JAVAVM;</code> <code>JVM;</code> <code>VERIFY;</code> <code>SERVER;</code> <code>INSTALL;</code> <code>CLEANUP</code></p> </li> <li> <p>Press <span class="bold">Enter</span>.</p> </li> </ol> <p>This search returns the cleanup notes for the JVM. The number of available documents frequently changes because Oracle Support creates, merges, and deletes various cleanup notes. This string of search words returns the most current and pertinent documents.</p> </div> <!-- class="sect1" --> <a id="i1010132" name="i1010132"></a><a id="WBINS16323" name="WBINS16323"></a> <div class="sect1"> <h2 class="sect1">Generating Log Files for a Specific Warehouse Builder Component</h2> <p>If Warehouse Builder is producing errors or exhibiting other unexpected results, additional error logging can help you and Oracle Support identify the cause.</p> <p><span class="bold">For additional error logging:</span></p> <ol> <li> <p>At the command prompt, navigate to:</p> <p><span class="bold">For Windows,</span> <code><span class="codeinlineitalic">OWB_HOME</span></code><code>\owb\bin\win32</code></p> <p><span class="bold">For UNIX,</span> <code><span class="codeinlineitalic">OWB_HOME</span></code><code>/owb/bin/unix</code></p> </li> <li> <p>Run one of the execution files and pipe the output to a log file.</p> <p>For example, enter: <code>owbclient.bat 1>out.log 2>error.log</code></p> </li> <li> <p>Examine the resulting log file.</p> <p>Use this log when contacting Oracle Support.</p> </li> </ol> </div> <!-- class="sect1" --> <a id="CHDGHIJJ" name="CHDGHIJJ"></a><a id="WBINS16324" name="WBINS16324"></a> <div class="sect1"> <h2 class="sect1">Checking the System Path of Oracle Warehouse Builder</h2> <p>You must ensure that Oracle Universal Installer added the <code>bin</code> directory of the new Oracle Warehouse Builder 11.2 installation to the system path <span class="italic">ahead</span> of other Oracle product <code>bin</code> directories. This is easily checked using the command prompt.</p> <a id="WBINS16325" name="WBINS16325"></a> <p class="subhead2">To verify the system path for Oracle Warehouse Builder on Windows:</p> <ol> <li> <p>In the Command Prompt window, enter <code>path</code>.</p> <pre xml:space="preserve" class="oac_no_warn">C:\><span class="bold">path</span> </pre></li> <li> <p>The system returns the value of the path variable; verify that <code>C:\OWB112</code> precedes other Oracle products.</p> <pre xml:space="preserve" class="oac_no_warn">PATH=C:\OWB112\bin;C:\oracle\product\11.2.0\db_1\bin; ... \ </pre></li> </ol> <a id="WBINS16368" name="WBINS16368"></a> <p class="subhead2">To verify the system path for Oracle Warehouse Builder on Linux:</p> <ol> <li> <p>Echo the <code>PATH</code> variable in your shell.</p> </li> </ol> </div> <!-- class="sect1" --> <a id="CHDEDEHC" name="CHDEDEHC"></a><a id="WBINS16032" name="WBINS16032"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Configuring OWB for RAC</h2> <p>When installing Oracle Warehouse Builder on a RAC cluster, the RAC service names must be unique and match the node that they're running on. This ensures that the Control Center Service uses a database service on the correct node, which in turn ensures access to the correct file system.</p> <p>For example, the <code>wb_rt_service_nodes</code> should be similar to those in <a href="#CHDJJFDF">Table A-1</a>.</p> <div class="tblformal"><a id="WBINS16033" name="WBINS16033"></a><a id="sthref808" name="sthref808"></a><a id="CHDJJFDF" name="CHDJJFDF"></a> <p class="titleintable">Table A-1 Naming RAC Service Nodes</p> <table class="Formal" title="Naming RAC Service Nodes" summary="This table demonstrates how to correctly name RAC service nodes to ensure successfull failover." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="13%" /> <col width="17%" /> <col width="19%" /> <col width="25%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t3">Node</th> <th align="left" valign="bottom" id="r1c2-t3">Instance</th> <th align="left" valign="bottom" id="r1c3-t3">Host</th> <th align="left" valign="bottom" id="r1c4-t3">Port</th> <th align="left" valign="bottom" id="r1c5-t3">Service Name</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t3" headers="r1c1-t3"> <p>1</p> </td> <td align="left" headers="r2c1-t3 r1c2-t3"> <p>1</p> </td> <td align="left" headers="r2c1-t3 r1c3-t3"> <p><code>host_1</code></p> </td> <td align="left" headers="r2c1-t3 r1c4-t3"> <p><code>port_number_1</code></p> </td> <td align="left" headers="r2c1-t3 r1c5-t3"> <p><code>RACSRVC_1</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t3" headers="r1c1-t3"> <p>2</p> </td> <td align="left" headers="r3c1-t3 r1c2-t3"> <p>2</p> </td> <td align="left" headers="r3c1-t3 r1c3-t3"> <p><code>host_2</code></p> </td> <td align="left" headers="r3c1-t3 r1c4-t3"> <p><code>port_number_2</code></p> </td> <td align="left" headers="r3c1-t3 r1c5-t3"> <p><code>RACSRVC_2</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t3" headers="r1c1-t3"> <p>3</p> </td> <td align="left" headers="r4c1-t3 r1c2-t3"> <p>3</p> </td> <td align="left" headers="r4c1-t3 r1c3-t3"> <p><code>host_3</code></p> </td> <td align="left" headers="r4c1-t3 r1c4-t3"> <p><code>port_number_3</code></p> </td> <td align="left" headers="r4c1-t3 r1c5-t3"> <p><code>RACSRVC_3</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></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="security_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="index.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