Solved

Oracle Warehouse Builder Installation Issues

Posted on 2009-04-04
3
889 Views
Last Modified: 2013-12-18
I'm using Oracle 10g XE and Oracle Datawarehouse Builder for 10g. I'm on windows xp sever. I'm trying to set up the owner and user in the Repository Assistant.  The installation process stops at 50%.  This is the information I entered on prior page

Here are my settings:
HostName: localhost
Oracle service Name: XE
PORT: 1521
Warehouse repository owner: system
password: ground0
Warehouse repository
user: uncc
password:user


I'm given this exception error "The Warehouse Builder repository owner installation failed on user UNCC. Exception occured in 'processSQLDBA Token'(../..rtasst/platform_system_rights.sql): java.sql.SQLException: ORA-O1919:role 'JAVAIDPRIV' does not exist.

UNCC has admin rights like SYS

You click OK to that error and you get another one
INS0029: Error occurred during installation. Check the log file D:\oracle\product\10.2.0\db_1\owb\UnifiedRepos\log_090404_192757.00 log for details

Attached is the log file.  
log-090404-192757.000.log
0
Comment
Question by:percivalevans
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Accepted Solution

by:
xtreemnet earned 500 total points
ID: 24143759
Did you find any solution to this problem?
0
 

Author Comment

by:percivalevans
ID: 24179244
No, I re-created the database in MS SQL 2005. Using BI with Visual Studio 2005.
0
 

Author Comment

by:percivalevans
ID: 24788721
The questions posted need to auto delete themselves after a certain time period.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question