Oracle 12c upgrade steps using Ambari 2.1.2.1

[#1]

Installed Oracle 12c instant client on all masters. What are the steps to push ojdbc7.jar to all services that uses Oracle DB such as oozie, hive, ranger?

[#2 · Accepted solution]

@wayne2chicago The following command appears to be missing from the 2.1.2.1 documents for Oracle use. Execute this command to make Ambari aware of the new driver and database so the configs can be pushed out. I also prefer to copy the ojdbc7.jar file to all the cluster nodes before I issue the command. Just in case.

ambari-server setup --jdbc-db=oracle --jdbc-driver=/usr/share/java/ojdbc7.jar

[#3]

Terry,

Thanks for your quick response.

[#4]

Do we have to shutdown ambari-server and all DB related services before running the command?

[#5]

@wayne2chicago

There is no need to shutdown the DB related services. The jar's are used only by the Client services like Ambari or Hive. You might have to restart Ambari / Hive or anything that uses the Oracle 12c database.