You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Andrew Onischuk (JIRA)" <ji...@apache.org> on 2015/12/01 12:03:11 UTC
[jira] [Created] (AMBARI-14125) DB Admin Test connection from
ambari screen does not work for Oracle DB 'SYS' user
Andrew Onischuk created AMBARI-14125:
----------------------------------------
Summary: 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)