1. Using Oracle Database Exadata Express Cloud Service
  2. Connect Tools and Utilities
  3. Connect SQL*Plus

Connect SQL*Plus

You can connect to your Oracle Database Exadata Express Cloud Service with SQL*Plus from an Oracle Database Client or an Oracle Instant Client.

Topics

Connect Using SQL*Plus from Oracle Instant Client

These instructions explain how to install Oracle Instant Client and connect to the Oracle Database Exadata Express Cloud Service using SQL*Plus. These instructions are also valid for any OCI based driver that uses Oracle Instant Client.

To install, configure and connect:
  1. Download the Client Credentials zip file from the Exadata Express service console. See Enable Oracle Net Services (SQL*Net) Access for Client Applications.

  2. Obtain SQL*Plus Instant Client by downloading the sqlplus and basic packages for the desired architecture from Instant Client Downloads. The various options include Microsoft Windows x64 or Windows 32-bit, Linux x86-64, Solaris x86-64, and Solaris SPARC 64-bit.

    Note:

    The smaller basiclite package may be used instead of basic. The smaller package contains only English error messages and has support for Unicode, ASCII, and Western European character sets.
  3. Unzip the downloaded package into a single directory, for example to C:\instantclient_12_1 or /home/myuser/instantclient_12_1.

  4. Set your environment's library loading path to the directory created in Step 3. If you are on a Linux client, set LD_LIBRARY_PATH and if you are on a Windows client, set the PATH variable.
    1. On non-Windows platforms, create a symbolic link as: 
      cd /home/myuser/instantclient_12_1
ln -s libclntsh.so.12.1 libclntsh.so
      and set the library and executable paths as:
       export LD_LIBRARY_PATH=/home/myuser/instantclient_12_1:$LD_LIBRARY_PATH
 export PATH=/home/myuser/instantclient_12_1:$PATH

      Note:

      Instead of setting LD_LIBRARY_PATH, you can create an ldconfig configuration file, if there is no other Oracle software that will be impacted.
    2. If you are on a Windows client, append C:\instantclient_12_1 to the PATH variable in the "System variables" section of the Environment Variables pane.

  5. Unzip the downloaded Client Credentials zip file into a directory. For example, move the files to C:\netadmin or /home/myuser/netadmin directory.

    Note:

    Secure the files so that only users who are authorized to connect to theExadata Express service have access to them. By default, Oracle recommends granting permissions only to the owner of the files.
  6. Edit the unzipped sqlnet.ora file, and change the WALLET_LOCATION to the unzipped directory.
    For example in Linux, change
    WALLET_LOCATION = (SOURCE = (METHOD = file)
(METHOD_DATA = (DIRECTORY=?/network/admin)))
    to
    WALLET_LOCATION = (SOURCE = (METHOD = file)
(METHOD_DATA = (DIRECTORY="/home/myuser/netadmin")))

  7. Set the TNS_ADMIN environment variable to the directory with the unzipped files.
    1. If you are on a non-Windows client, set the TNS_ADMIN environment variable to the directory with the unzipped files. For example, in the shell you intend to run your application in, execute export TNS_ADMIN=/home/myuser/netadmin
    2. If you are on a Windows client, create a new user variable TNS_ADMIN in the Environment Variables pane and set it to the directory containing the unzipped files, for example C:\netadmin.

    Note:

    This command can also be added to login files such as $HOME/.bashrc
  8. Start SQL*Plus and connect to your service.

    For example if the user 'CJ' had been granted access to the database, then run SQL*Plus in a terminal as, sqlplus cj@dbaccess

Connect Using SQL*Plus from Oracle Database Client

These instructions explain how to install Oracle Database Client and connect to the Oracle Database Exadata Express Cloud Service using SQL*Plus. These instructions are also valid for any OCI based driver that use Oracle Database Client.

To install, configure and connect:
  1. Download the Client Credentials zip file from the Exadata Express service console. See Enable Oracle Net Services (SQL*Net) Access for Client Applications.

  2. Install Oracle Database Client 12.1.0.2 from Oracle Database Software Downloads on the Oracle Technology Network.

    Note:

    Take a backup of the tnsnames.ora and sqlnet.ora files in the ORACLE_HOME/network/admin directory of your client. These files will be overwritten.
  3. Unzip the downloaded Client Credentials zip file into ORACLE_HOME/network/admin subdirectory.

  4. If you are on a Windows client, change the DIRECTORY entry in SQLNET.ORA by replacing forward slash (/) with back slash (\).

  5. Start SQL*Plus and connect to your service.
    For example: sqlplus pdb_admin@dbaccess

    Enter password: password