-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/40819/
-----------------------------------------------------------
Review request for Ambari and Dmitro Lisnichenko.
Bugs: AMBARI-14125
https://issues.apache.org/jira/browse/AMBARI-14125
Repository: ambari
Description
-------
Ambari Recommended DB Admin JDBC connection string does not work for **Oracle
DB user having role**.
Please note that issue need to be fixed for Oracle with SID and ServiceName as
well.
Instance:172.22.117.8 (SID)
Instance:172.22.117.82 (Service)
DB Admin Test Connection:Failed
DB Host Value in SID Instance : 172.22.76.238:1521:XE
DB Host Value in Service Instance : 172.22.76.238:1521/XE
**Error Log from 172.22.117.82 instance **
**Case1: Provided DBA user name is 'SYS':**
DB connection check started.
WARNING: File /var/lib/ambari-agent/cache/DBConnectionVerification.jar
already exists, assuming it was downloaded before
WARNING: File /var/lib/ambari-agent/cache/oracle-jdbc-driver.jar already
exists, assuming it was downloaded before
2015-11-26 04:56:34,806 -
call['/usr/lib/jvm/java-1.7.0-openjdk.x86_64/bin/java -cp
/var/lib/ambari-agent/cache/DBConnectionVerification.jar:/var/lib/ambari-agent/cache/oracle-jdbc-driver.jar
-Djava.library.path=/var/lib/ambari-agent/cache
org.apache.ambari.server.DBConnectionVerification
"jdbc:oracle:thin:@//172.22.76.238:1521/XE" SYS [PROTECTED]
oracle.jdbc.driver.OracleDriver'] {}
2015-11-26 04:56:35,615 - call returned (1, 'ERROR: Unable to connect to
the DB. Please check DB connection properties.\njava.sql.SQLException:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER')
**Case2: Provided DBA user name is 'SYS AS SYSDBA':**
Error Log : DB connection check started.
WARNING: File /var/lib/ambari-agent/cache/DBConnectionVerification.jar
already exists, assuming it was downloaded before
WARNING: File /var/lib/ambari-agent/cache/oracle-jdbc-driver.jar already
exists, assuming it was downloaded before
2015-11-25 10:21:50,557 -
call['/usr/lib/jvm/java-1.7.0-openjdk.x86_64/bin/java -cp
/var/lib/ambari-agent/cache/DBConnectionVerification.jar:/var/lib/ambari-agent/cache/oracle-jdbc-driver.jar
-Djava.library.path=/var/lib/ambari-agent/cache
org.apache.ambari.server.DBConnectionVerification
"jdbc:oracle:thin:@//172.22.76.238:1521/XE" SYS AS SYSDBA [PROTECTED]
oracle.jdbc.driver.OracleDriver'] {}
2015-11-25 10:21:50,699 - call returned (1, 'ERROR: Unable to connect to
the DB. Please check DB connection
properties.\njava.lang.ClassNotFoundException: SYSDBA')
Diffs
-----
ambari-server/src/main/resources/custom_actions/scripts/check_host.py 686aec6
ambari-server/src/test/python/custom_actions/TestCheckHost.py 14cb8e3
Diff: https://reviews.apache.org/r/40819/diff/
Testing
-------
mvn clean test
Thanks,
Andrew Onischuk
