question Re: Oracle 12c upgrade steps using Ambari 2.1.2.1 in Archives of Support Questions (Read Only)

Oracle 12c upgrade steps using Ambari 2.1.2.1

ScipioTheElder — Fri, 04 Mar 2016 20:56:33 GMT

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?

Re: Oracle 12c upgrade steps using Ambari 2.1.2.1

TerryP — Fri, 04 Mar 2016 22:35:10 GMT

@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

Re: Oracle 12c upgrade steps using Ambari 2.1.2.1

ScipioTheElder — Fri, 04 Mar 2016 23:26:34 GMT

Terry,

Thanks for your quick response.

Re: Oracle 12c upgrade steps using Ambari 2.1.2.1

ScipioTheElder — Sat, 05 Mar 2016 00:24:26 GMT

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

Re: Oracle 12c upgrade steps using Ambari 2.1.2.1

vpoornalingam — Sun, 06 Mar 2016 05:05:48 GMT

@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.