SQL Developer

Instant Client instantclient-basic-macos.x64-12.2.0.1.0-2.zip

instantclient-sqlplus-win-x86-64-11.1.0.7.0.zip (sorry missed this in the original @"John McGinnis-Oracle" )

SQL Developer sqldeveloper-18.2.0.183.1748-macosx.app.zip

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

I am trying to connect using TCPS through SQL Developer while using the instant client and I get ORA-12560: TNS:protocol adapter error

I have no problem connecting to the same DB with TCP (below are the TNS entries I'm using).

I've got a wallet file and have the wallet path set up in sqlnet.ora (example below).

Have I done something wrong or is this a restriction with the instantclient?

Thanks in advance,

Gus..

--sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
WALLET_LOCATION =
  (SOURCE =
    (METHOD = FILE)
    (METHOD_DATA =
      (DIRECTORY = <my‎_wallet_path>⁨)
    )
  )
SQLNET.AUTHENTICATION_SERVICES = (TCP,TCPS)
SSL_VERSION = 1.0
SSL_CLIENT_AUTHENTICATION = TRUE
SSL_SERVER_DN_MATCH = ON

--tnsnames.ora below
DEV_GEN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCPS)(HOST = <host_name>)(PORT = 1525))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = <service_name>)
    )
    (SECURITY =
      (SSL_SERVER_CERT_DN = "CN=<host_name>")
    )
  )
DEV_TCP_GEN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <host_name>)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = <service_name>)
    )
  )

Message was edited by: Gussay separated the files so none thinks they are in the same file