2.4.3 OCI Connection Type

Connect to a database using OCI. Before connecting to OCI, it is necessary to specify the profile to use. For example, OCI PROFILE frankfurt.

The connection spec parameter has the following form:



Option Description
-oci Specifies an OCI connection type.
-rest, rt Specifies that the connection should be established using REST.
-proxy, p Specifies the network proxy to use.
-verbose, v Requests output of diagnostic information about the connection.


Parameter Description
<connectionspec> Provides the connection specification for the target database.


To connect using an OCID:

SQL> CONNECT ocid1.databasetoolsconnection.oc1.xxxyyyyzz.aabbccd