Use these topics to help troubleshoot any issues you might have installing Ambari with an existing Oracle database.
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.
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.
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.
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
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.
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.
Confirm you have loaded the database schema. Review the load database schema procedure appropriate for your database type in Using Non-Default Databases - Ambari.
