You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

TCPS Sql Developer and OCI Base database - unable to connect TCPS

in Database 2 comments

I just set the Oracle base database using TLS by following this article -

Authenticate Oracle Database 23ai with Microsoft Entra ID and

Brad's Blog: Entra ID Integration For SQLDeveloper
Document 2922041.1

What am I missing?


However I can connect using Sql Plus using TCPS but not with SQL Developer, I am using Windows 11
I created self signed certificate on the server and copied the files to my windows 11 machine to C:\oracle\certificates folder
TNSNames.ora

Option 1
(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCPS)(HOST=<Host>)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=<ServiceName>))(SECURITY=(MY_WALLET_DIRECTORY=C:\Oracle\certificates)))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!