Versions Compared

Old Version 1

changes.mady.by.user Richard Ritchie

Saved on

compared with

New Version Current

changes.mady.by.user Paul Morano

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Create a keystore with the certificates.
  2. Update the sqldeveloper.conf.
  3. Update the connection string (PROTOCOL=TCPS, PORT=2484, SERVICE_NAME=kfs40t_srv.uits.uconn.edu)

OR

Use the attached keystore file,

View file
nameexadata.keystore
height250


Info

#Create the keystore and add the keys.
keytool -genkey -alias exa02db -keyalg RSA -keystore exa02db.keystore -dname "cn=exa02" -keypass r1c3pw -storepass r1c3pw
keytool -selfcert -alias exa02db -keystore exa02db.keystore -keypass r1c3pw -storepass r1c3pw -validity 4000 -keysize 2048
keytool -import -alias exa02db01 -file client_cert_exa02db01.txt -keystore exa02db.keystore -storepass r1c3pw
keytool -import -alias exa02db02 -file client_cert_exa02db02.txt -keystore exa02db.keystore -storepass r1c3pw


#Add these to your sqldeveloper.conf.   (mine is in C:\Library\sqldeveloper\sqldeveloper\bin\sqldeveoper.conf)

AddVMOption -Djavax.net.ssl.trustStore=C:\\Library\\sqldeveloper\\exa02db.keystore

AddVMOption -Djavax.net.ssl.trustStoreType=JKS

AddVMOption -Djavax.net.ssl.trustStorePassword=r1c3pw


#The JDBC Url requires changes to the PROTOCOL, PORT and SERVICE_NAME.

i.e.

(DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCPS)(HOST = exa02-scan.uits.uconn.edu)(PORT = 2484))

  (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = kfs40t_srv.uits.uconn.edu))

)

...