----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/40819/#review108476 -----------------------------------------------------------
Ship it! Ship It! - Dmitro Lisnichenko On Dec. 1, 2015, 1:03 p.m., Andrew Onischuk wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/40819/ > ----------------------------------------------------------- > > (Updated Dec. 1, 2015, 1:03 p.m.) > > > 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 > >
