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 <ao...@hortonworks.com> on 2015/12/01 12:03:10 UTC
Review Request 40819: DB Admin Test connection from ambari screen
does not work for Oracle DB 'SYS' user
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/40819/
-----------------------------------------------------------
Review request for Ambari and Dmitro Lisnichenko.
Bugs: AMBARI-14125
https://issues.apache.org/jira/browse/AMBARI-14125
Repository: ambari
Description
-------
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')
Diffs
-----
ambari-server/src/main/resources/custom_actions/scripts/check_host.py 686aec6
ambari-server/src/test/python/custom_actions/TestCheckHost.py 14cb8e3
Diff: https://reviews.apache.org/r/40819/diff/
Testing
-------
mvn clean test
Thanks,
Andrew Onischuk
Re: Review Request 40819: DB Admin Test connection from ambari screen
does not work for Oracle DB 'SYS' user
Posted by Dmitro Lisnichenko <dl...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/40819/#review108476
-----------------------------------------------------------
Ship it!
Ship It!
- Dmitro Lisnichenko
On Dec. 1, 2015, 1:03 p.m., Andrew Onischuk wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/40819/
> -----------------------------------------------------------
>
> (Updated Dec. 1, 2015, 1:03 p.m.)
>
>
> Review request for Ambari and Dmitro Lisnichenko.
>
>
> Bugs: AMBARI-14125
> https://issues.apache.org/jira/browse/AMBARI-14125
>
>
> Repository: ambari
>
>
> Description
> -------
>
> 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')
>
>
> Diffs
> -----
>
> ambari-server/src/main/resources/custom_actions/scripts/check_host.py 686aec6
> ambari-server/src/test/python/custom_actions/TestCheckHost.py 14cb8e3
>
> Diff: https://reviews.apache.org/r/40819/diff/
>
>
> Testing
> -------
>
> mvn clean test
>
>
> Thanks,
>
> Andrew Onischuk
>
>