Formats three formats for JDBC Thin Driver

Format one: Oracle JDBC Thin using a ServiceName:

Jdbc:oracle:thin:@//Example:jdbc:oracle:thin:@//192.168.2.1:1521/xe

Note The format here, which is followed by//, which is the main difference from using SIDS.

This format is recommended by Oracle because the SID for each node is different for the cluster, but the service_name can contain all nodes.

Format two: Oracle JDBC Thin using an SID:

Jdbc:oracle:thin:@example:jdbc:oracle:thin:192.168.2.1:1521:x01a

Note:support for SID was being phased out. Oracle recommends this users switch over to Usingservice names.

Format three: Oracle JDBC Thin using a tnsname:

Jdbc:oracle:thin:@<tnsname>
Example:jdbc:oracle:thin: @GL

Note:
Support for TNSNames is added in the driver release 10.2.0.1

Formats three formats for JDBC Thin Driver