Connecting with Oracle SQLcl
Oracle SQL Developer Command-Line (SQLcl) can connect to Oracle Database Exadata Express Cloud Service. Security is enforced by using an Oracle Wallet, which can be downloaded from the database service. Steps to do this and run SQLcl are shown below.
Obtain SQLcl by downloading the ZIP archive:
Unzip the packages into the desired application directory, for example
On Windows, append
C:\sqlcl\bin 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
In the Exadata Express console Enable SQL*Net access.
Unzip the client wallet
client_credentials.zip file and move the contents to a directory. For example move the files to
Store the Oracle Wallets and JKS files (*.sso, *.p12, *.jks) securely 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 owner of the files.
Start SQLcl without a connection using the /nolog flag and configure the wallet like: