Troubleshooting Non-Default Databases with Ambari
Use these topics to help troubleshoot any issues you might have installing Ambari with an existing Oracle database.
Problem: Ambari Server Fails to Start: No Driver
Check /var/log/ambari-server/ambari-server.log for the following
error:
ExceptionDescription:Configurationerror.Class[oracle.jdbc.driver.OracleDriver]
not found.
The Oracle JDBC.jar file cannot be found.
Solution
Make sure the file is in the appropriate directory on the Ambari server and re-run
ambari-server setup. Review the load database procedure appropriate
for your database type in Using Non-Default Databases - Ambari.
Problem: Ambari Server Fails to Start: No Connection
Check /var/log/ambari-server/ambari-server.log for the following
error:
The Network Adapter could not establish the connection Error Code:
17002
Ambari Server cannot connect to the database.
Solution
Confirm that the database host is reachable from the Ambari Server and is correctly
configured by reading /etc/ambari-server/conf/ambari.properties.
server.jdbc.url=jdbc:oracle:thin:@oracle.database.hostname:1521/ambaridb
server.jdbc.rca.url=jdbc:oracle:thin:@oracle.database.hostname:1521/ambari
Problem: Ambari Server Fails to Start: Bad Username
Check /var/log/ambari-server/ambari-server.log for the following
error:
Internal Exception: java.sql.SQLException:ORA01017: invalid
username/password; logon denied
You are using an invalid username/password.
Solution
Confirm the user account is set up in the database and has the correct privileges. See Step 3 above.
Problem: Ambari Server Fails to Start: No Schema
Check /var/log/ambari-server/ambari-server.log for the following
error:
Internal Exception: java.sql.SQLSyntaxErrorException: ORA00942: table or
view does not exist
The schema has not been loaded.
Solution
Confirm you have loaded the database schema. Review the load database schema procedure appropriate for your database type in Using Non-Default Databases - Ambari.