[
https://issues.apache.org/jira/browse/RANGER-5002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Madhan Neethiraj updated RANGER-5002:
-------------------------------------
Attachment: RANGER-5002.patch
> Installation with Oracle failed during schema vx_principal creation
> -------------------------------------------------------------------
>
> Key: RANGER-5002
> URL: https://issues.apache.org/jira/browse/RANGER-5002
> Project: Ranger
> Issue Type: Bug
> Components: admin
> Affects Versions: 2.5.0
> Reporter: Mahalingam
> Priority: Major
> Attachments: RANGER-5002.patch, ranger_core_db_oracle.sql
>
>
> During the installation of the apache Ranger we got the following exception:
> Environment Setup: Apache Ranger 2.5.0
> Database: Oracle 19c
>
>
> {code:java}
> 2024-11-09 23:25:46,863 [JISQL] /usr/lib/jvm/java-17-openjdk-amd64/bin/java
> -Djava.security.egd=file:///dev/urandom -cp
> /usr/share/java/ojdbc10.jar:/opt/ranger/ranger-2.5.0-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver oraclethin -cstring
> jdbc:oracle:thin:@//***:1521/*** -u 'usename' -p '********' -noheader -trim
> -input
> /opt/ranger/ranger-2.5.0admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
> -c \;
> SQLException : SQL state: 42000 java.sql.SQLSyntaxErrorException: ORA-00932:
> inconsistent datatypes: expected - got CLOB ErrorCode: 932
> SQLException : SQL state: 42000 java.sql.SQLSyntaxErrorException: ORA-00932:
> inconsistent datatypes: expected - got CLOB ErrorCode: 932
>
>
> 2024-11-09 23:25:51,191 [E] ranger_core_db_oracle.sql file import failed!
>
>
> 2024-11-09 23:25:51,192 [I] Unable to create DB schema, Please drop the
> database and try again
>
> 2024-11-09 23:25:51,192 [JISQL] /usr/lib/jvm/java-17-openjdk-amd64/bin/java
> -Djava.security.egd=file:///dev/urandom -cp
> /usr/share/java/ojdbc10.jar:/opt/ranger/ranger-2.5.0-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver oraclethin -cstring
> jdbc:oracle:thin:@//**:1521/**** -u 'username' -p '********' -noheader -trim
> -c \; -query "delete from x_db_version_h where version = 'CORE_DB_SCHEMA'
> and active = 'N' and updated_b y=***';"
>
> 2024-11-09 23:25:52,978 [E] CORE_DB_SCHEMA import failed!
> {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
