Connecting with SQL*Plus 12.2
SQL*Plus 12.2 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.
Obtain SQL*Plus 12.2 Instant Client by downloading the 'sqlplus' and 'basic' packages for the desired architecture:
Alternatively, use these links for Oracle Instant Client 12.1 packages suitable for use with Exadata Express Cloud Service.
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.
Unzip the 'sqlplus' and 'basic' (or 'basiclite') packages into the same directory, for example to
On Windows, add
C:\instantclient_12_2 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 12.2, install the VS 2013 Redistributable. For Instant Client 12.1, install the VS 2010 Redistributable. Use a 64-bit or 32-bit Redistributable to match your Instant Client architecture.
On non-Windows platforms, create a symbolic link like:
cd /home/myuser/instantclient_12_2 ln -s libclntsh.so.12.1 libclntsh.so
And set the library and executable paths:
export LD_LIBRARY_PATH=/home/myuser/instantclient_12_2:$LD_LIBRARY_PATH export PATH=/home/myuser/instantclient_12_2:$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_12_2 > /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.
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.
network/admin subdirectories in the Instant Client directory and unzip the client credentials there, for example so the files are in the
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.
Run SQL*Plus and connect using the Oracle network service name used in the unzipped
tnsnames.ora file. For example if the user 'CJ' had been granted access to the database, then run SQL*Plus in a terminal like: sqlplus cj@dbaccess
See Creating Database Schemas if you need to create a user.