[
https://issues.apache.org/jira/browse/AMBARI-26665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Manish M Pillai updated AMBARI-26665:
-------------------------------------
Status: Patch Available (was: Open)
> Oracle DDL script uses unsupported BIGINT data type
> ---------------------------------------------------
>
> Key: AMBARI-26665
> URL: https://issues.apache.org/jira/browse/AMBARI-26665
> Project: Ambari
> Issue Type: Bug
> Reporter: Arvind Kandpal
> Assignee: Manish M Pillai
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Ambari-DDL-Oracle-CREATE.sql uses BIGINT for three columns:
> - registries.id
> - mpacks.id
> - mpacks.registry_id
> Oracle does not support the BIGINT data type, so the registries and
> mpacks tables are not created when the script runs. The tables that
> depend on them are not created either, and Ambari Server fails to start
> on Oracle.
> The rest of the Oracle DDL uses NUMBER(19) for these kinds of columns.
> Steps to reproduce:
> 1. Run Ambari-DDL-Oracle-CREATE.sql with sqlplus on Oracle.
> 2. Creating the registries and mpacks tables fails with an invalid
> datatype error.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
