Re: Oracle Warehouse Builder

From: Joost Bataille <jREMOVETHISbataille>
Date: Tue, 21 Jan 2003 10:09:06 +0100
Message-ID: <b0j2ni$pvmaa$1_at_ID-171327.news.dfncis.de>


"snanda" <member22848_at_dbforums.com> wrote in message news:2400572.1042762953_at_dbforums.com...
>
> The exact error is:
> API5022: Cannot connect to the specified repository.
> Verify connection information. Cache Loading Error: null
>
> ***********************
> Using Oracle 9i Dev Suite
> Connecting to Oracle 8i Enterprise Edition Release 8.1.7.0.0

I know nothing about Warehouse Builder but did a search on Metalink (http://metalink.oracle.com) with your error message "API5022: Cannot connect to the specified repository"

I had two hits:

doc: 197508.1

"Currently, granting a database user access to the OWB repository directly, via a role, or via synonyms results in the following error when attempting to connect: 'API5022: Cannot connect to the specified repository. Verify connection information' Only the Repository owner can connect."

and Doc: 221386.1

fact: Oracle Warehouse Builder 9.0.2

symptom: Connecting to Repository fails with error
symptom: Api5022: Cannot Connect To The Specified Repository.
symptom: Verify Connection Information

cause: The Package NAMESPACESERVICEIMPL is invalid. This can occur when having performed a Database Export/Import from the OWB repository schema. How
to diagnose the cause, see below:
  1. Using SQL*plus connect to the OWB Repository schema
  2. SQL> alter package NAMESPACESERVICEIMPL compile body;

Warning: Package Body altered with compilation errors.

3. SQL> show errors
Errors for PACKAGE BODY NAMESPACESERVICEIMPL:

LINE/COL ERROR

-------- -----------------------------------------------------------------
363/1 PL/SQL: SQL Statement ignored
365/6 PLS-00201: identifier 'SYS.V_$SESSION' must be declared

This shows that the OWB Repository Owner has no SELECT privilege on SYS.V_$ SESSION. fix:

  1. Using SQL*plus connect with SYS
  2. SQL> grant select on V_$SESSION to <owb repository owner>
  3. Connect with OWB Repository Owner
  4. SQL> alter package NAMESPACESERVICEIMPL compile;

Check out Metalink and register, it's free and the don't spam. Before posting you can always check and search the archives of this newsgroup at
http://groups.google.com/groups?hl=en&group=comp.databases.oracle.tools

Hope this helps, regards.

--
Joost Bataille
University of Amsterdam ICT centre
Received on Tue Jan 21 2003 - 10:09:06 CET

Original text of this message