Use these entries to help you 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. See Step
1 above.
Check /var/log/ambari-server/ambari-server.log for the
following errror:
The Network Adapter could not establish the connection Error Code: 17002
Ambari Server cannot connect to the database.
Confirm 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/ambaridb 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.
Confirm the user account is set up in the database and has the correct privileges. See Step 3 above.
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. See Step 4 above.
