How to Create the OWBSYS Account When it is not Created in New 11.2 Install Because the OLAP Option is Deselected During Creation of the Database (Doc ID 1262866.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 and later
Information in this document applies to any platform.

Goal

In a new 11gR2 Database install when the OLAP Option is excluded from the database creation since it is not licensed at the location, the OWBSYS and OWBSYS_AUDIT accounts are not present.  

The OWBSYS account is the schema for Oracle Warehouse Builder (OWB) which is created as part of the OLAP installation.

When the OLAP option is deselected when creating a database with DBCA, the OWBSYS account is not created.  This is part of the database creation template.

OWB does not require OLAP to be installed but the OWBSYS and OWBSYS_AUDIT accounts are required to install the OWB repository.  

How can these accounts be created if OLAP is not installed?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms