Mac platform

This guide covers two methods for connecting to a Tessell Oracle database service over SSL/TLS on macOS: SQL Developer (JDBC/JKS) and Python.

---

How do I connect using SQL Developer?

1. Download SQL Developer.
2. Download the SSL/TLS certificate from My Services → Overview → CA Certificate.
3. Import the certificate into a JKS keystore:

keytool -import -alias testalias -file TessellCA.crt -keypass keypass -keystore test.jks -storepass test@123

1. Open ~/.sqldeveloper/22.2.1/product.conf and add the JKS path to the SQL Developer JVM options:

AddVMOption -Djavax.net.ssl.trustStore=/Users/<user>/Desktop/test.jks
AddVMOption -Djavax.net.ssl.trustStoreType=JKS
AddVMOption -Djavax.net.ssl.trustStorePassword=test@123

1. Restart SQL Developer.
2. Add a new connection and configure it for TCPS:

Figure 1 — SQL Developer new connection dialog with TCPS settings

1. Set the Custom JDBC URL:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(PORT=1521)(HOST=oraclesi19c<service name>-ppmno.qabyoaupg001.tsl-barc.cloud))(CONNECT_DATA=(SERVICE_NAME=orcl))(SECURITY=(ssl_server_cert_dn="CN=oraclesi19c<service name>-ppmno.qabyoaupg001.tsl-barc.cloud")))

1. Verify the connection mode by running:

SELECT sys_context('USERENV', 'NETWORK_PROTOCOL') as network_protocol,
       sys_context('USERENV', 'AUTHENTICATION_METHOD') as authentication_method
FROM dual;

Figure 2 — Verification query confirming TCPS protocol

---

How do I connect using Python?

Mac x86

The setup is identical to the Linux platform guide.

Apple M* Chip

The latest Oracle Instant Client libraries are not available for Apple M* (ARM). You must run under Rosetta to use x86_64 libraries.

Step 1 — Install tools (Rosetta terminal)

1. Download Mac x86 Oracle Instant Client from Oracle Instant Client Downloads (macOS Intel x86) and unzip it.
2. Download and unzip SQLcl.

Step 2 — Set up Oracle wallet

Follow the same wallet setup steps as the Linux platform guide.

SQL*Plus steps are also the same as Linux — ensure you run the x86 sqlplus client from a Rosetta-enabled terminal.

Step 3 — Connect using Python (Rosetta terminal)

import oracledb
import cryptography
import os

cs = '''<user>/<password>@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(HOST = oraclessl<service name>dnd-efwyu.qarel.tsl-barc.cloud)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = <service name>))(SECURITY = (SSL_SERVER_CERT_DN = "CN=oraclessl<service name>dnd-efwyu.qarel.tsl-barc.cloud")))'''

oracledb.init_oracle_client(lib_dir="/Users/<user>/orainscli/instantclient_19_8/")

connection = oracledb.connect(user="<user>", password="<password>", dsn=cs)

cursor = connection.cursor()
cur = cursor.execute(
    "SELECT sys_context('USERENV', 'NETWORK_PROTOCOL') as network_protocol, "
    "sys_context('USERENV', 'AUTHENTICATION_METHOD') as authentication_method FROM dual"
)
print(cur.fetchall())

connection.close()