3. Ambari

  1.  On the Ambari Server machine, install the Oracle JDBC .jar file:

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

      Select Oracle Database 11g Release 2 - ojdbc6.jar

    2. Copy the .jar file to the Java share directory

      cp ojdbc6.jar /usr/share/java
    3. Make sure the .jar file has the appropriate permissions - 644.

  2.  Create the Ambari user, password, and tablespace, and grant the account database permissions:

    # sqlplus sys/root as sysdba
    SQL> create user $AMBARIUSER identified by $AMBARIPASSWORD default 
                     tablespace "USERS" temporary tablespace "TEMP";
    SQL> grant unlimited tablespace to $AMBARIUSER;
    SQL> grant create session to $AMBARIUSER;
    SQL> grant create table to $AMBARIUSER;
    SQL> quit;

    Where $AMBARIUSER is the Ambari user name and $AMBARIPASSWORD is the Ambari user password.

  3.  Load the Ambari Server schema:

    • To set up Ambari Server to load the schema automatically:

      1. Download the Oracle Instant Client (for Linux x-86 or x86-64), Basic and the Instant Client Package - SQL*Plus, version, on the Ambari Server host.

        For information on the Oracle Database Instant Client, see here. To download the x86 client, see here. To download the x86-64 client, see here.

      2. Extract the zip files on your Ambari Server

        mkdir /home/oracle
        cd /home/oracle
        unzip /tmp/instantclient­sqlplus­linux.x64­ 
        unzip /tmp/instantclient­basic­linux.x64­
      3. Update your PATH and LD_LIBRARY_PATH variables. For example, in BASH:

        export PATH=/home/oracle/instantclient_11_2:${PATH}
        export LD_LIBRARY_PATH=/home/oracle/instantclient_11_2:${LD_LIBRARY_PATH}
    • To load the schema manually, create the Ambari Server schema by running a script:


      The file Ambari-DDL-Oracle-CREATE.sql is found in the /var/lib/ambari-server/resources/ directory of the Ambari Server machine, once you have completed the Set Up the Bits step in the install process. .

loading table of contents...