1.1. Using Ambari with Oracle

To set up Oracle for use with Ambari:

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. Select Oracle Database 11g Release 2 - ojdbc6.jar.
3. Copy the .jar file to the Java share directory.
```
cp ojdbc6.jar /usr/share/java/
```
4. Make sure the .jar file has the appropriate permissions - 644.

Create a user for Ambari and grant it permissions.

Using the Oracle database admin utility:

# 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;
QUIT;

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

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.
When setting up the Ambari Server, select Advanced Database Configuration > Option [2] Oracle and enter the information use the username/password credentials you created in step 2.

Legal notices