My Oracle Support Banner

OWB 11.2 Repository Browser Fails To Connect To Repository With ORA-01031: Insufficient Privileges (Doc ID 1679348.1)

Last updated on JANUARY 30, 2018

Applies to:

Oracle Warehouse Builder - Version 11.2 and later
Information in this document applies to any platform.
****Reviewed for Concurrency 11/28/2016***

Symptoms

OWB 11.2 Repository Browser fails to connect to repository with ORA-01031: Insufficient Privileges

dbdev1:/oracle/product/db/11.2.0.3/owb/bin/unix $ ./openRAB.sh
please input the full path of your web browser:(for example: /usr/local/bin/netscape)
/usr/bin/firefox
local browser path: /usr/bin/firefox
local host name: dbdev1.rac.oracle.com
14/05/12 13:56:36 data_source.getHttpSession: >>>>HttpSession lost or first time through : create new HttpSession
14/05/12 13:56:36 UserData.restoreData(...) new snapshot created - values reinitialized
14/05/12 13:56:36 data_source.restoreData(...) new snapshot created - values reinitialized
14/05/12 13:56:55 data_source.testConnection() connection ok: URL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbdev1.rac.oracle.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oracle.world))) with username=owbrep
14/05/12 13:56:55 ---->start to findWorkspaces()
14/05/12 13:56:55 RABLogin.tryAllViewVersion()
14/05/12 13:56:55 ---->Runtime OWBSYS.ALL_RT_INSTALLATIONS.public_view_version = 11.2
14/05/12 13:56:55 ---->Runtime owbsys.workspace_assignment for user_name = owbrepcount = 1
14/05/12 13:56:55 ---->start to useWorkspace(2)
14/05/12 13:56:55 ---->startWorkspace()
14/05/12 13:56:55 ---->sql=call owbsys.wb_workspace_management.set_workspace('ODS1','OWBREP')
14/05/12 13:56:55 RABLogin.startWorkspace() java.sql.SQLException: ORA-01031: insufficient privileges
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1602

14/05/12 13:56:55 ---->hasBrowserPrivilege()
14/05/12 13:56:55 ---->owbsys.hasAccessBrowserPrivilege(owbrep) exception java.sql.SQLException: ORA-20013: The workspace has not been set. Please call wb_workspace_management.set_workspace procedure to set workspace first. Or you can go to OWB Client Console and under menu Tool/Preference you can change your default workspace to a valid workspace within Environment preference group then whenever you login to database your valid default workspace will be automatically set.
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1690
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1725
ORA-06512: at "OWBSYS.HASACCESSBROWSERPRIVILEGE", line 15
ORA-06512: at line 1

14/05/12 13:56:55 ---->owbsys.hasAccessBrowserPrivilege(owbrep) returns -1

 

Same issue occurs when trying to set the workspace from SQL*Plus:

SQL> connect owbrep/<password>
Connected.
SQL> call owbsys.wb_workspace_management.set_workspace('ods1','owbrep');
call owbsys.wb_workspace_management.set_workspace('ods1','owbrep')
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1602

 

Changes

This can occur after a OWB repository has been migrated from one database to another using datapump.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.