Apache Ambari Administration
Also available as:
PDF
loading table of contents...

Using Ambari with Oracle

To set up Oracle for use with Ambari:

Steps

  1. On the Ambari Server host, install the appropriate JDBC.jar file.

    1. Download the Oracle JDBC (OJDBC) driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.

    2. For Oracle Database 11g: select

      Oracle Database 11g Release 2 drivers > ojdbc6.jar
    3. For Oracle Database 12c: select

      Oracle Database 12c Release 1 drivers > ojdbc7.jar
    4. Copy the .jar file to the Java share directory. For example:

      cp ojdbc7.jar /usr/share/java/
    5. Make sure the .jar file has the appropriate permissions. For example:

      chmod 644 /usr/share/java/ojdbc7.jar
  2. Create a user for Ambari and grant that user appropriate permissions.

    For example, using the Oracle database admin utility, run the following commands:

    # sqlplus sys/root as sysdba 
    CREATE USER <AMBARIUSER> IDENTIFIED BY <AMBARIPASSWORD> default tablespace "USERS" temporary tablespace "TEMP";
    GRANT unlimited tablespace to <AMBARIUSER>;
    GRANT create session to <AMBARIUSER>;
    GRANT create TABLE to <AMBARIUSER>;
    GRANT create SEQUENCE to <AMBARIUSER>;
    QUIT;

    Where <AMBARIUSER> is the Ambari user name and <AMBARIPASSWORD> is the Ambari user password.

  3. Load the Ambari Server database schema.

    1. You must pre-load the Ambari database schema into your Oracle database using the schema script.

      sqlplus <AMBARIUSER>/<AMBARIPASSWORD> < Ambari-DDL-Oracle-CREATE.sql
    2. Find the Ambari-DDL-Oracle-CREATE.sql file in the /var/lib/ambari-server/resources/ directory of the Ambari Server host after you have installed Ambari Server.

  4. When setting up the Ambari Server, select Advanced Database Configuration > Option [2] Oracle and respond to the prompts using the username/password credentials you created in step 2.