In Oracle Fusion Middleware 12c the sqlplus client does not come packaged with the installation. MyST gives you the option of specifying the client. This article details the steps to deploy SQL with MyST using the SQL*Plus (sqlplus) client in 12c.

Prerequisites

Linux Access

You will need root user access to install SQL*Plus rpm.

SQL*Plus Download

Download the client:

• As of writing the URL is: Instant Client Downloads for Linux x86-64 for 12.2.0.1.0 | Name | File | | ------------- |:-------------:| | Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications | instantclient-basic-linux.x64-12.2.0.1.0.zip (68,965,195 bytes) (cksum - 3923339140) | | Instant Client Package - SQLPlus: Additional libraries and executable for running SQLPlus with Instant Client | instantclient-sqlplus-linux.x64-12.2.0.1.0.zip (904,309 bytes) (cksum - 2291973160) |

Installation

1. Login as the root user
2. Install the client and additional libraries

   yum install oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
   yum install oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
   

MyST Configuration

1. Add a global variable for the SQLPlus product home:
   NOTE: The default directory that Oracle will install SQLPlus is /usr/lib/oracle/12.2/client64
2. Run a MyST update action on the platform instance to the expected revision
3. Ensure your application metadata contains the sql client:
   
   
4. For MyST CLI this will be:

   core.deployment[SQLArtifact].param[client]=sqlplus