ambari-dev mailing list archives

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

    [ 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)

Mime
View raw message