[AMBARI-17622] Ambari server schema upgrade failed from 2.1.1 with ORA-12516 error

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 2.4.0
• Component/s: ambari-upgrade
• Assignee: Dmytro Sen
• Reporter: Dmytro Sen
• Created: 08/Jul/16 11:22
• Updated: 11/Jul/16 10:09
• Resolved: 11/Jul/16 06:53

Description

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

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:

Issue Links

• links to: Review Board