Preparing to Connect to the Exadata Express Cloud Service

Introduction

This post details common steps required before connections can be made to Exadata Express.

For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on OAC, visit the Analytics Cloud page.

Topics

Obtaining the Exadata Express Credentials

Enabling Client Access

Downloading Service Credentials from Exadata Express

Downloading Java JDK

Overview of Oracle JDBC Drivers

Using the Oracle Call Interface

Obtaining the Exadata Express Credentials

Obtain the cloud services username and password associated with the Exadata Express services account. They are used to access the Instance Services Console.

Obtain the database administrative username (default is admin) and password associated with the Exadata Express instance. These were specified when the instance was created. Refer to Creating a Service Instance for details. Alternatively, obtain a database user (schema) and password created in the instance.

Enabling Client Access

Access the Service Console Page. Refer to Accessing the Service Console for details.

Click the Develop option. Refer to About Develop for details.

Click Client Access from the Client Development section. Refer to About Setup for details.

Click Enable Client Access. Refer to Enabling Oracle Net Services (SQL*Net) Access for Client Applications for details.

Downloading Service Credentials from Exadata Express

Access the Service Console Page. Refer to Accessing the Service Console for details.

Click the Develop option. Refer to About Develop for details.

Click Client Credentials from the Client Development section. Refer to About Setup for details.

Enter a Password to create a password-protected Oracle Wallet and Java Keystore files for the service.Refer to Downloading Client Credentials for details.

Click Download to save a zip file to a secure location that is accessible by your database client(s).

Unzip the contents taking care to retain the zip file. Note: Some client applications require the actual zip file. You may need to re-zip the contents if the zip file is no longer available after downloading.

Downloading Java JDK

The latest version of the Java Development Kit (JDK) may be downloaded from OTN. For example, the latest JDK8 version is at http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Oracle recommends using the latest version as it contains important security updates and bug patches.

Note: Early versions of JDK8 may not work correctly. This post has used versions JDK8u101 and higher.

Downloading Java JCE

Connections to Exadata Express require Java Cryptography Extension (JCE) unlimited strength policy files.

Later releases of JAVA JDK 8 (151+) have the JCE Unlimited Strength Jurisdiction Policy Files installed. Starting with JDK 8u161, the required unlimited strength files are the default. Oracle recommends using JDK 8u161 or higher to take advantage of the default settings

The latest version of the JCE Unlimited Strength Jurisdiction Policy Files may be downloaded from OTN. For example, the latest JCE 8 version is at http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html

For versions prior to JDK 8u151, unzip the JCE download and refer to the README.txt for installation instructions.

Overview of Oracle JDBC Drivers

JDBC drivers come in two flavors: Thin and Oracle Call Interface (OCI).

For driver feature differences, see Overview of Oracle JDBC Drivers https://docs.oracle.com/database/121/JJDBC/overvw.htm#JJDBC28025

Using the Oracle Call Interface

OCI is the comprehensive, high performance, native C language interface to Oracle Database for custom or packaged applications.

The JDBC OCI driver is also an alternative to the JDBC thin driver.

Oracle Instant Client libraries provide the necessary network connectivity, as well as basic and high end data features, to make full use of Oracle Databases. It underlies the Oracle APIs of popular languages and environments including Node.js, Python and PHP, as well as providing access for OCI, OCCI, JDBC, ODBC and Pro*C applications.

The Oracle Instant Client is available on OTN from at http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

For Windows clients download the Windows-64 basic, JDBC and SQL*Plus files at a minimum. Note: Some client applications require the 12.1.x version.

For use in Cloud instances, download the Linux-64 versions.

Summary

This post provided the steps required before client connections can be made to Exadata Express. It demonstrated how to download the client credentials and provided links to download required software. An optional section regarding the use of OCI was presented.

For more OAC, BICS and BI best practices, tips, tricks, and guidance that the A-Team members gain from real-world experiences working with customers and partners, visit Oracle A-Team Chronicles for BICS, and Oracle A-Team Chronicles for OAC

References

Exadata Express Cloud Service

Analytics Cloud

Create an Exadata Express Service

Accessing the Service Console

About Develop

About Setup

Enabling Oracle Net Services (SQL*Net) Access for Client Applications

Downloading Client Credentials

JAVA JDK 8 Downloads

JAVA JCE 8 Downloads

JDBC Driver Features

Oracle Instant Client Downloads

Oracle A-Team Chronicles for BICS

Oracle A-Team Chronicles for OAC

Add Your Comment