[
https://issues.apache.org/jira/browse/AMBARI-14067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jaimin D Jetly resolved AMBARI-14067.
-------------------------------------
Resolution: Done
> wrong DB_JDBC_PATTERNS for Oracle DBs in app.js
> -----------------------------------------------
>
> Key: AMBARI-14067
> URL: https://issues.apache.org/jira/browse/AMBARI-14067
> Project: Ambari
> Issue Type: Bug
> Components: ambari-web
> Affects Versions: 2.1.0, 2.1.1, Ambari-2.1.3
> Environment: Oracle JDBC configuration for Hive and Oozie
> Reporter: Mathias Herzog
> Priority: Critical
>
> Hi
> The Web configuration page for HIVE, YARN and Oozie doesn't render (remains
> white) and the console shows following error:
> Uncaught TypeError: Cannot read property 'replace' of null ->
> this issue happens because of wrong DB_JDBC_PATTERNS if one of the following
> configurations are present for oozie and hive
> dbType = oracle and dbPort != 1521
> or
> dbTyppe = Oracle-RAC
> In this case, the connection string looks like:
> jdbc:oracle:thin:@(DESCRIPTION
> =(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host1.example.com)(PORT=1532))
> (ADDRESS=(PROTOCOL=TCP)(HOST=host2.example.com)(PORT=1532)))(CONNECT_DATA=(SERVICE_NAME=service.X.example.com)))
> suggested fix in database.js
> 1. change port in oracle pattern from 1521 to something generic
> 2. add a new pattern for oracle RAC databases
> 3. maybe fix the port issue for postgres as well (couldn't test that)
> {code:title=app.js|borderStyle=solid}
> DB_JDBC_PATTERNS: {
> mysql: 'jdbc:mysql://{0}/{1}',
> mssql: 'jdbc:sqlserver://{0};databaseName={1}',
> postgres: 'jdbc:postgresql://{0}:5432/{1}',
> derby: 'jdbc:derby:{0}/{1}',
> oracle: 'jdbc:oracle:thin:@(?:\/?\/?)(.*):[0-9]+(:|\/)(.*)',
> rac:
> 'jdbc:oracle:thin:@(?:\/?\/?).*HOST=(\\S*?)\\)\\S+PORT=(\\S*?)\\)\\S+SERVICE_NAME=(\\S*?)\\)',
> sqla: 'jdbc:sqlanywhere:host={0};database={1}'
> },
> {code}
> kind regards
> Mathias
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
