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
Last updated on JUNE 19, 2017
Applies to:Oracle Warehouse Builder - Version 22.214.171.124 and later
Information in this document applies to any platform.
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?
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