ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Onischuk (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMBARI-14125) DB Admin Test connection from ambari screen does not work for Oracle DB 'SYS' user
Date Tue, 01 Dec 2015 11:03:11 GMT
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)

Mime
View raw message