Using Ambari with Oracle

cp ojdbc11.jar /usr/share/java/ chmod 644 /usr/share/java/ojdbc11.jar

sqlplus / as sysdba

>show con_name CON_NAME ------------------------------ CDB$ROOT SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB1 READ WRITE NO >ALTER SESSION SET CONTAINER=ORCLPDB1; >CREATE USER ambari IDENTIFIED BY bigdata default tablespace "USERS" temporary tablespace "TEMP"; >GRANT unlimited tablespace to ambari; >GRANT create session to ambari; >GRANT create TABLE to ambari; >GRANT create SEQUENCE to ambari;

[root@odp ~]# ambari-server setup Using python /usr/bin/python Setup ambari-server Checking SELinux... WARNING: Could not run /usr/sbin/sestatus: OK Customize user account for ambari-server daemon [y/n] (n)? y Enter user account for ambari-server daemon (root): Adjusting ambari-server permissions and ownership... Checking firewall status... Checking JDK... [1] Oracle JDK 1.8 + Java Cryptography Extension (JCE) Policy Files 8 [2] Custom JDK ============================================================================== Enter choice (1): 2 WARNING: JDK must be installed on all hosts and JAVA_HOME must be valid on all hosts. WARNING: JCE Policy files are required for configuring Kerberos security. If you plan to use Kerberos,please make sure JCE Unlimited Strength Jurisdiction Policy Files are valid on all hosts. Path to JAVA_HOME: /usr/lib/jvm/java-11-openjdk-amd64 Validating JDK on Ambari Server...done. Check JDK version for Ambari Server... JDK version found: 11 Minimum JDK version is 11 for Ambari. Skipping to setup different JDK for Ambari Server. Checking GPL software agreement... GPL License for LZO: https://www.gnu.org/licenses/old-licenses/gpl-2.0.en.html Enable Ambari Server to download and install GPL Licensed LZO packages [y/n] (n)? n Completing setup... Configuring database... Enter advanced database configuration [y/n] (n)? y Configuring database... ============================================================================== Choose one of the following options: [1] - PostgreSQL (Embedded) [2] - Oracle [3] - MySQL / MariaDB [4] - PostgreSQL [5] - Microsoft SQL Server (Tech Preview) [6] - SQL Anywhere [7] - BDB ============================================================================== Enter choice (1): 2 Hostname (localhost): <IP_address> Port (1521): Database name (ambari): <ambari-db-name> Username (ambari): <db-ambari-user-name> Enter Database Password (password): <ambari-user-password> Configuring ambari database... Enter full path to custom jdbc driver: /usr/share/java/ojdbc11.jar Configuring remote database connection properties... WARNING: Before starting Ambari Server, you must run the following DDL directly from the database shell to create the schema: /var/lib/ambari-server/resources/Ambari-DDL-Oracle-CREATE.sql Proceed with configuring remote database connection properties [y/n] (y)? y Extracting system views... Error extracting ambari-views-package-2.7.6.0.0.jar ....ambari-admin-2.7.6.0.0.jar Ambari repo file doesn't contain latest json url, skipping repoinfos modification Adjusting ambari-server permissions and ownership... Ambari Server 'setup' completed successfully.

SQL> conn ambari/bigdata@ORCLPDB1 Connected. SQL> SELECT table_name, owner FROM all_tables ORDER BY owner, table_name;

SQL> @/var/lib/ambari-server/resources/Ambari-DDL-Oracle-CREATE.sql Table created. Table created. .. 1 row created. 1 row created. .. .. Index created. Index created.

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

[root@odpnew-1-test ~]# ambari-server start Using python /usr/bin/python Starting ambari-server Ambari Server running with administrator privileges. Organizing resource files at /var/lib/ambari-server/resources... Ambari database consistency check started... Server PID at: /var/run/ambari-server/ambari-server.pid Server out at: /var/log/ambari-server/ambari-server.out Server log at: /var/log/ambari-server/ambari-server.log Waiting for server start......................................... Server started listening on 8080 DB configs consistency check: no errors and warnings were found. Ambari Server 'start' completed successfully.