Skip Headers
Oracle® Warehouse Builder Installation and Administration Guide
11g Release 1 (11.1) for Windows and UNIX

Part Number B31280-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

6 Troubleshooting a Warehouse Builder Installation

Refer to this chapter in the event that you encounter errors or problems with an installation. This chapter includes the following topics:

General Steps for Troubleshooting Warehouse Builder

This section includes the following topics:

  1. Review this chapter for a solution to the problem.

    If Warehouse Builder displays an error message, refer to "Error Messages Related to Installation".

    In the absence of an error message, refer to "Troubleshooting Installation Problems That Do Not Display Error Messages".

  2. Check for additional information about the problem by "Reviewing Log Files".

  3. If the problem remains unresolved, search for a solution at

  4. Review the Oracle Warehouse Builder Release Notes, part number B40098 for installation notes or known issues.

  5. If you are unable to resolve the problem in the previous steps, contact Oracle Support.

Error Messages Related to Installation

This section includes the following topics:

Causes and Actions

No fonts were found in '<drive>:\Program Files\ Qarbon\viewlet Builder3jre\lib\fonts'
Cause: 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.
Action: Re-install Jinitiator.
OWBSYS is not granted access to owb home/owb/bin/admin/ Please run UnifiedRepos/reset_owbcc_home.sql specifiying the path of the Oracle Home from which the Control Center Service is being run.
Cause: When running the script reset_owbcc_home.sql and prompted for the owb home, you typed an invalid path for owb home.
Action: Run the script again and type the correct path.

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.

On Unix, the correct path to enter is the path for the owb home directory. On Windows, to determine the correct path for the owb home directory, examine the path displayed as part of the default Windows command prompt, and replace the backslashes with Unix-style forward-slashes. Do not supply a trailing slash. For example, if the Windows command prompt is:


then the text you type is:


SYS user does not have SYSDBA privileges.
Cause: In a standard database installation, the SYS user has SYSDBA credentials and REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE. You can verify the credentials by issuing the following connect statement:

SQL> CONNECT sys@tns_name_of_db AS SYSDBA;

Enter password: sys_password

If your database is configured with REMOTE_LOGIN_PASSWORDFILE=NONE, then the statement fails.

Action: If the statement fails, then you have the following options:
  • Reconfigure your database with

    REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE and create a password file if none exists.

  • If the preceding is not an option, reconfigure your database with


RTC-5301: The Control Center Service is not currently available.
Cause: 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.
Action: You can start a service on the server host by using the script start_service.sql.

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 or local_service_login.bat as appropriate. Use this script as follows: [-startup | -closedown] owb home

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.

Use the script show_service.sql to determine the status of the service.

Control center service log file reports "DBMS_OBFUSCATION" or "No key is found."
Cause: The encryption of the passwords is out of sync with the client.
Action: Reset the repository and restart the control center service. To reset the repository, run owb/rtp/sql/reset_repository.sql.
API5022: Cannot Connect to the Specified Repository
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.
Cause: The package NAMESPACESERVICEIMPL may be invalid. This occurs after a database export or import from the Warehouse Builder repository schema if the repository owner has no SELECT privilege on SYS.V_$SESSION. You can diagnose the cause as follows:
  1. In SQL*Plus, connect to the Warehouse Builder repository schema.

  2. Enter the following command at the SQL prompt:

  3. If Warning: Package body altered with compilation errors appears, enter the following command at the SQL prompt:

    show errors;
  4. The following errors mean that the Warehouse Builder repository owner has no SELECT privilege on SYS.V_$SESSION.

    PL/SQL: SQL statement ignored
    PLS-00201: Identifier 'SYS.V_$SESSION' must be declared
Action: Complete the following steps:
  1. In SQL*Plus, connect as the SYS user.

  2. At the SQL prompt, enter the following command:

    grant SELECT on V_$SESSION to Warehouse Builder_Repository_Owner;
  3. Connect to the Repository_Owner.

  4. Enter the following command at the SQL prompt:

    alter package NAMESPACESERVICEIMPL compile;
Runtime Assistant fails with LoadJava Error.
Cause: This can occur if the Oracle Database does not have the JServer option installed.
Action: Make sure that the Oracle Database has JServer option installed.
Error when specifying a SYSDBA user.
Oracle Warehouse Builder Assistants require you to provide SYSDBA credentials when installing the Oracle Warehouse Builder Design Repository or Runtime components.
Cause: In a standard database installation, the SYS user has SYSDBA credentials. You can verify this from SQL*Plus by issuing the following connect statement:

connect sys/sys_password@TNS_NAME_OF_DB as sysdba;

In a standard database installation, the preceding connect statement works because REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE and the default password file is created by the installation process.

If your database is configured with

REMOTE_LOGIN_PASSWORDFILE=NONE, then the following statement fails:

connect sys/sys_password@TNS_NAME_OF_DB as sysdba;

In this case, you have two options.

Action: Reconfigure your database with

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE and create a password file if none exists.

Action: If the preceding is not an option, then reconfigure your database with

O7_DICTIONARY_ACCESSIBILITY=TRUE. With this setting, the statement

connect sys/sys_password@TNS_NAME_OF_DB enables the Warehouse Builder Assistants to connect to SYS user.

Regional Name and Address Data Libraries Are Not Available.
Cause: The Name and Address regional data libraries may not have been installed in the correct location.
Action: Ensure that you have successfully extracted regional data to the NAS_DATA directory.
  1. From your owb home, start the Name and Address Server:

    For Windows: Run owb\bin\win32\NAStart.bat.

    For UNIX: Run owb/bin/unix/

  2. Open the log file: owb\bin\admin\NASvr.log.

    The log contains a list of installed countries.

    If there is no such list, verify that you have extracted the regional library data to the correct location. If you have extracted the data to the wrong location, you can either reinstall the data, or modify the owb\bin\admin\ file to indicate the correct file path. If you modify the file, stop and restart the Name and Address Server as follows:

    For Windows: Start the server by running owb\bin\win32\NAStart.bat. Stop the server by running owb\bin\win32\NAStop.bat.

    For UNIX: Start the server by running owb/bin/unix/ Stop the server by running owb/bin/unix/

  3. Once you have verified the installation, you can stop the Name and Address Server if you wish, because it is automatically started at the execution of any mapping that employs the Name and Address operator.

Lineage and impact analysis reports: Extensive tablespace requirements for materialized views.
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.
Cause: Insufficient space has been allocated to the Warehouse Builder repository schema.
Action: 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 Autoextend On.
Java out of memory error occurs during a batch operation.
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.
Cause: There is not enough virtual memory. The Warehouse Builder client runs with a maximum heap size, as defined by the -mx parameter in the owbclient.bat file. The -Dlimit parameter in the owbclient.bat 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 -mx parameter value, set the -Dlimit parameter to the same value, or at least to 90% of the value. Note that setting the -Dlimit to a low value can have a negative impact on the performance of Warehouse Builder.
Action: Increase the -Dlimit parameter in Warehouse Builder as follows:
  1. Exit Warehouse Builder.

  2. Open this file in a text editor:

    For Windows: Open the $OWBHOME\bin\win32\ombplus.bat.

    For UNIX: Open the $OWBHOME\bin\win32\

  3. Change the -Dlimit parameter to 334.

  4. Save and close the file.

  5. Restart Warehouse Builder.

ORA-01925: Maximum of 30 enabled roles exceeded
This error occurs when installing a repository or a target schema.
Cause: 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 MAX_ENABLED_ROLES parameter, this error occurs.
Action: Increase the value of the MAX_ENABLED_ROLES parameter in the init.ora file. When you deinstall a repository or a target schema, delete the associated roles as well.
INS0009: Unable to connect to the database. Verify the connect information.
This error occurs when you try to connect to a database.
INS0022: A spawned program error.
Cause: This error message can result from a server issue when installing Warehouse Builder runtime components on an HP-UX operating system.
Action: To identify the server issue, complete the following steps:
  1. From SQL*Plus, connect to a SYS user.

    Create user test_lj identified by test_lj;
    Grant connect, resource to test_lj;
  2. Create owb home/owb/bin/unix/ with the following contents:

    ../unix/loadjava -thin -verbose -order -resolve -user 
  3. Change directory to owb home/owb/bin/unix/.

  4. Run

ORA-12154: TNS: Could not resolve service name.
This error occurs when you try to connect to a database.
ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor.
This error occurs when you try to connect to a database.
Cause: If you used the Oracle Net Easy Configuration or Oracle Net Assistant tools to create the Net Service Name entry, and you used the default option (Service Name) on the newly created Net Service Name, the parameter SERVICE_NAME is added to the TNSNAMES.ORA as a subclause to the CONNECT_DATA section in the Net Service Name entry. This replaces the (SID=SIDname) subclause in the previous versions of Oracle Database8i (8.1.x).
Action: Implement the TNSNAMES.ORA file as follows:
  1. Use the GLOBAL_DBNAME parameter in the LISTENER.ORA for each SID that you want to identify as a separate service. Use the value of this parameter as the value of the SERVICE_NAME parameter. You need to activate any changes you make to LISTENER.ORA for this purpose by stopping and restarting the listener process.

  2. Use the values of the parameters existing in the INIT.ORA, namely SERVICE_NAMES and DB_DOMAIN, to determine the value of the SERVICE_NAME that you must use in TNSNAMES.ORA. The valid construction of this value is SERVICE_NAMES.DB_DOMAIN with the period separating the two INIT.ORA values. If your SERVICE_NAMES is BIKES and your DB_DOMAIN is COM, then your SERVICE_NAME is BIKES.COM.

  3. If there is no DB_DOMAIN parameter set in your INIT.ORA, or if there is no GLOBAL_DBNAME in the LISTENER.ORA, then you can use the SERVICE_NAMES from the INIT.ORA in your TNSNAMES.ORA for the SERVICE_NAME parameter.

    For example, if INIT.ORA contains SERVICE_NAMES = "TEST817" and db_domain is not set, then the TNSNAMES.ORA entry is: CONNECT_DATA =(SERVICE_NAME = "TEST817")).

  4. If you have multiple values specified in the SERVICE_NAMES parameter in the init.ora, you can use one of them. If SERVICE_NAMES is not set, then you can use DB_NAME.DB_DOMAIN parameters from the INIT.ORA file.

  5. If SERVICE_NAMES and DB_DOMAIN is not set in the INIT.ORA and there is no GLOBAL_DBNAME in the LISTENER.ORA,then your SERVICE_NAME in TNSNAMES.ORA file is be DB_NAME.

PL/SQL: ORA-04052: Error occurred when looking up remote object
This error occurs when you have upgraded to <Oracle Database version> and are trying to redeploy mappings without first redeploying connectors.
Cause: While upgrading the 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 into SQL*Plus as a SYS user and entering the following command: SELECT * FROM GLOBAL_NAME; If the Global Name of the old database does not match that of the new database, then a domain mismatch is causing this error.
Action: Either add the domain name to the Global Name in your new database by issuing a command similar to the following statement: ALTER DATABASE RENAME GLOBAL_NAME TO xxx10G.US.ORACLE.COM; or redeploy your connectors. Refer to Oracle Warehouse Builder User's Guide for information on deploying connectors.
IMP-00003: ORACLE error 30371 encounteredORA-30371: column cannot define a level in more than one dimension
This error occurred when you were importing your target schema during migration.
Cause: The Warehouse Builder target schema is created with the select_catalog_role 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.
Action: Connect as a SYS user to the existing version of the Oracle Database from which you exported the target schemas. Enter the following statement in

SQL*Plus: revoke select_catalog_role from OLD_Target_Schema;

Export the target schema into an Oracle .DMP file again, and then import the file into the Oracle Database.

Unable to connect to SQL*Plus in <Oracle Database version>
Cause: Your Oracle home or Path is not set correctly, or your Net Service Names are not configured.
Action: Ensure your Oracle home and Path are set correctly, and your Net Service Names are configured in the Oracle Database.
  • Ensure that ORACLE_HOME and PATH are set correctly. Your Oracle home directory must to point to the owb home. Set your PATH variable to include the owb home\bin directory before any other Oracle products.

  • Ensure that the TNSNames.ora file is configured correctly:

    For Windows: From the Oracle Database program group, start Net Configuration Assistant and select Local Net Service Name Configuration to configure TNSNames.ora.

    For UNIX: Set ORACLE_HOME and PATH to the owb home for Warehouse Builder 11g Release 1 (11.1), then run owb home/bin/netca to start Net Configuration Assistant. Select Local Net Service Name Configuration to configure TNSNames.ora.

ORA-04020 deadlock detected while trying to lock object or ORA-04021 timeout occurred while waiting to lock object
When creating runtime objects, the Runtime Assistant halts and produces these errors in the error log when trying to lock sys.dbms_aq.
Cause: User sessions may be pinning Advanced Queue objects.
Action: First, log in to SQL*Plus as a SYS user and run a query to identify which user sessions are pinning the Advanced Queue packages, using the following query as an example:

column s.sid format a5;

column s.serial# format a8;

column s.username format a10;

column objectname format a10;

select distinct




x.kglnaobj as objectname


dba_kgllock l,

v$session s,

x$kgllk x


l.kgllktype = 'Pin' and

s.saddr = l.kgllkuse and

s.saddr = x.kgllkuse and

x.kglnaobj in ('DBMS_AQ', 'DBMS_AQADM');

The following is an example of the output you receive:


--- ------- -------- ----------

9 29623 RTU_4942 DBMS_AQ

Noting the SID and Serial Number, issue the following command to kill the user sessions:


For example, type the following to kill the session listed in the sample output for this error:


ORA-04088: error during execution of trigger 'DVSYS.DV_BEFORE_DDL_TRG'
Cause: When you attempt to create a Warehouse Builder repository on an Oracle Database the includes the Oracle Data Vault option, you may encounter and error such as ORA-04088.
Action: Disable the triggers DV_BEFORE_DDL_TRG and DV_AFTER_DDL_TRG.

Troubleshooting Installation Problems That Do Not Display Error Messages

This section includes causes and actions for the following installation problems:

Causes and Actions

Warehouse Builder Clients that Previously Launched Now Momentarily Display the Splash Screen and Fail to Start
Cause: 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.

If the client is installed on Windows and you launched the client from the Start menu, you may not see any error messages.

Action: Manually start the client by typing at the DOS prompt run owb home\owb\owbclient.bat. You are likely to encounter an error message such as No fonts were found in '<drive>:\Program Files\ Qarbon\viewlet Builder3jre\lib\fonts'.
Newly Installed Warehouse Builder Clients Fail to Start and Previously Launched Oracle Products Fail to Start
Cause: 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.
Action: Verify the that the path for owb home\bin is listed correctly in the Environmental Variables.
A Warehouse Builder Client Freezes or Hangs
Cause: Client software may freeze or hang due to various causes.
Action: If a Warehouse Builder client appears to freeze or hang, perform a stack trace as follows:
  1. At the DOS command prompt, enter:

    cd owb home\owb\bin\win32\

  2. Run owbclient.bat.

  3. When the program hangs, press Ctrl+Break.

    This produces the thread-dump. Contact Oracle Support and provide them with this information to help identify the problem.

Reviewing Log Files

This section contains information on inspecting log files for Warehouse Builder.

Log File Locations

  • Warehouse Builder Repository Assistant:

    owb home\UnifiedRepos\log_timestamp.log

  • Warehouse Builder Control Center Service:

    owb home\log\Repository_Name\log.xx on the Oracle Database server

  • Warehouse Builder Design Center: Specify the location on the Preferences tab.

Additional Error Logging for Errors and Other Unexpected Behavior

If Warehouse Builder is producing errors or exhibiting other unexpected results, additional error logging can help you and Oracle Support identify the cause.

For additional error logging:

  1. At the command prompt, navigate to:

    For Windows: owb home\owb\bin\win32

    For UNIX: owb home/owb/bin/unix

  2. Run one of the execution files as listed in Table 1-9 and pipe the output to a log file.

    For example, type: owbclient.bat 1>out.log 2>error.log

  3. Examine the resulting log file.

    Use this log when contacting Oracle Support.

Checking Java Virtual Machine (JVM)

To check, verify, or reinstall the Java Virtual Machine (JVM) server in the database, refer to Oracle MetaLink:

  1. In your Web browser, go to:

  2. Log in to OracleMetaLink, or register as a new user.

  3. Type the following terms into the Search field, separating each term by semicolons):


  4. Press Enter.

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.