[
https://issues.apache.org/jira/browse/AMBARI-14125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15033871#comment-15033871
]
Hudson commented on AMBARI-14125:
---------------------------------
FAILURE: Integrated in Ambari-trunk-Commit #3943 (See
[https://builds.apache.org/job/Ambari-trunk-Commit/3943/])
AMBARI-14125. DB Admin Test connection from ambari screen does not work
(aonishuk:
[http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=95a71a68f6f8d9ad3df1a573262f330d65a45111])
* ambari-server/src/main/resources/custom_actions/scripts/check_host.py
* ambari-server/src/test/python/custom_actions/TestCheckHost.py
> DB Admin Test connection from ambari screen does not work for Oracle DB 'SYS'
> user
> ----------------------------------------------------------------------------------
>
> Key: AMBARI-14125
> URL: https://issues.apache.org/jira/browse/AMBARI-14125
> Project: Ambari
> Issue Type: Bug
> Reporter: Andrew Onischuk
> Assignee: Andrew Onischuk
> Fix For: 2.2.0
>
>
> 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')
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
