Salesforce

Builder error when creating CKB database hosting on Oracle 12cR2 (12.2)

Printable View
« Go Back

Information

 
TitleBuilder error when creating CKB database hosting on Oracle 12cR2 (12.2)
SummaryWhen creating a CKB database in Builder hosting on an Oracle 12cR2 Database, receive a grant SELECT privilege on v_$system_parameter error despite that SELECT privilege on the table has been granted to the schema user
URL NameBuilder-error-when-creating-CKB-database-hosting-on-Oracle-12cR2-12-2
Resolution
Category Management 2017.1
  • Patch, ITX-49750 Builder support for building a database using Oracle 12.2, resolves the error as shown on this article

Category Management 9.1 and 2016.1
  • Do not use Oracle Database 12c Release 2 (12.2) as it is not certified and supported
  • For Oracle 12c, only Release 1 (12.1) is supported
ProductsCategory Knowledge Base
ModuleBuilder
Version9.1, 2016.1, 2017.1
Error Message Code
CKB needs to check the number of enabled user roles in the current Oracle database instance.  Please contact the Oracle DBA to grant only the SELECT privilege on SYS.V_$SYSTEM_PARAMETER to the login user.

User-added image
Cause
The MAX_ENABLED_ROLES initialization parameter is removed and desupported in Oracle 12c Release 2 (12.2)
Additional Information
  • This is applicable regardless of CDB or non-CDB architecture of Oracle database
  • SELECT privilege on sys.V_$SYSTEM_PARAMETER has been granted to the CKB schema owner and the error persists
  • This query would return a row executing it on an Oracle 12.1 database but it returns no row from an Oracle 12.2 database
SELECT * FROM sys.V_$SYSTEM_PARAMETER
WHERE name = 'max_enabled_roles'
Publication StatusPublished
Powered by