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:22:10 UTC
[jira] [Resolved] (AMBARI-14125) DB Admin Test connection from
ambari screen does not work for Oracle DB 'SYS' user
[ https://issues.apache.org/jira/browse/AMBARI-14125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrew Onischuk resolved AMBARI-14125.
--------------------------------------
Resolution: Fixed
Committed to trunk and branch-2.1
> 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)