No results found

Your search did not match any results.

We suggest you try the following to help find what you're looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.

 

Trending Questions

Connecting with SQL*Plus 18c

SQL*Plus 18c can connect to Oracle Database Exadata Express Cloud Service. Network security is enforced by using an Oracle Wallet, which can be downloaded from the database service.

1. Download and Install SQL*Plus 18c

  • Unzip the 'sqlplus' and 'basic' (or 'basiclite') packages into the same directory, for example to C:\instantclient_18_5 or /home/myuser/instantclient_18_5.
  • On Windows, add C:\instantclient_18_5 to the PATH variable in the "System variables" section of the Environment Variables pane. On Windows 8 this can be accessed by navigating to Control Panel>System>Advanced System Settings>Environment Variables. If you have multiple versions of Oracle libraries installed, make sure the new directory occurs first in the path.
  • On Windows, install a Visual Studio Redistributable from Microsoft. For Instant Client 18c and 12.2, install the VS 2013 Redistributable. Use a 64-bit or 32-bit Redistributable to match your Instant Client architecture.
  • On non-Windows platforms, create a symbolic link for libclntsh.so if one does not already exist, for example:
    
    cd /home/myuser/instantclient_18_5
    ln -s libclntsh.so.18.1 libclntsh.so
    
    And set the library and executable paths:
    
        export LD_LIBRARY_PATH=/home/myuser/instantclient_18_5:$LD_LIBRARY_PATH
        export PATH=/home/myuser/instantclient_18_5:$PATH
    
    Instead of setting LD_LIBRARY_PATH, you could create an ldconfig configuration file
     if there is no other Oracle software that will be impacted:
    
        sudo sh -c "echo /home/myuser/instantclient_18_5 > /etc/ld.so.conf.d/oic.conf"
        sudo ldconfig
     

The Linux 'sqlplus' and 'basic' RPMs can also be used. With these, it is not necessary to create a libclntsh.so symbolic link.

2. Enable Oracle Network Connectivity and Download the Client Wallet

  • In your web browser, navigate to the Exadata Express service console.
  • If Client Access is not currently enabled, click Enable Client Access on the console.
  • Click Download Client Credentials on the console to download client_credentials.zip containing your security credentials and network configuration files that will allow client access to your cloud database. Save this zip file to a secure location.
  • Make network and network/admin subdirectories in the Instant Client directory, if they do not exist, and unzip the client credentials there. For example unzip the wallet so the files are in the directory.
  • C:\instantclient_18_5\network\admin, /home/myuser/instantclient_18_5/network/admin
    or /usr/lib/oracle/18.5/client64/lib/network/admin

    Secure the files so that only users who are authorized to connect to the Exadata Express service have access to them. By default, Oracle recommends granting permissions only to the file owner.

  • Alternatively, put the unzipped wallet files in a secure directory and set the TNS_ADMIN environment variable to that directory name.

3. Run SQL*Plus

See Creating Database Schemas if you need to create a user.