Re: Oracle Warehouse Builder
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:
- Using SQL*plus connect to the OWB Repository schema
- 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:
- Using SQL*plus connect with SYS
- SQL> grant select on V_$SESSION to <owb repository owner>
- Connect with OWB Repository Owner
- 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 centreReceived on Tue Jan 21 2003 - 10:09:06 CET