Dmytro Sen created AMBARI-17622:
-----------------------------------
Summary: Ambari server schema upgrade failed from 2.1.1 with
ORA-12516 error
Key: AMBARI-17622
URL: https://issues.apache.org/jira/browse/AMBARI-17622
Project: Ambari
Issue Type: Bug
Components: ambari-upgrade
Affects Versions: 2.4.0
Reporter: Dmytro Sen
Assignee: Dmytro Sen
Priority: Blocker
Fix For: 2.4.0
Steps
Deploy HDP-2.3.0.0 cluster with Ambari 2.1.1 (Oracle DB, unsecure, HA cluster).
Note - the DB instance is dedicated for this cluster and Ambari server and not
shared
Upgrade Ambari to 2.4.0.0-726.x86_64
Result
Error during Ambari DB schema upgrade. Logs show the below
{code}
01 Jul 2016 11:47:17,686 ERROR [main] DBAccessorImpl:107 - Error while creating
database accessor
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol
stack
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at
org.apache.ambari.server.orm.DBAccessorImpl.<init>(DBAccessorImpl.java:87)
01 Jul 2016 11:47:17,697 ERROR [main] DBAccessorImpl:107 - Error while creating
database accessor
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol
stack
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
01 Jul 2016 11:47:17,699 ERROR [main] SchemaUpgradeHelper:369 - Unexpected
error, upgrade failed
com.google.inject.ProvisionException: Guice provision errors:
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
