ORDS, SODA & JSON in the Database

1 error has occurred

Your session has timed out.

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Standalone ORDS and Autonomous Database on Oracle Cloud

DomenDolarDec 11 2019 — edited Dec 18 2019

We are using Oracle Cloud services.

First we created Autonomous Database (Database Version: 18c). From the web client we downloaded wallet (tab DB Connection - wallet name wallet_RASD.zip) to connect to the database with a remote SQL client (SQL Developer). We can connect to database with this wallet with no problem.

Then we created Oracle Cloud Instance (VM.Standard.E2.1.Micro), where we put ORDS (ords-19.1.0.092.1545). We also put wallet_RASD.zip to the instance and unzip it. For ORDS we configured connection to the database in defaults.xml:

<entry key="db.connectionType">customurl</entry>

<entry key="db.customURL">jdbc:oracle:thin:@rasd_medium?TNS_ADMIN=/home/opc/u01/wallet_RASD</entry>

For running ORDS on Instance we are using Java version jre1.8.0_151 and we run ords like:

/home/opc/u01/jre1.8.0_151/jre1.8.0_151/bin/java -Djavax.net.debug=all -Duser.timezone="+2:00" -jar /home/opc/u01/ords/ords-19.1.0.092.1545/ords.war standalone

And the problem comes. When we run ords we are getting an error handshake_failure. We tried may things and no luck. Any idea?

---THE LOG FROM ORDS ----

[opc@ords-rasd-v1 ~]$ /home/opc/u01/jre1.8.0_151/jre1.8.0_151/bin/java -Djavax.net.debug=all -Duser.timezone="+2:00" -jar /home/opc/u01/ords/ords-19.1.0.092.1545/ords.war standalone
2019-12-05 13:28:38.081:INFO::main: Logging initialized @6936ms to org.eclipse.jetty.util.log.StdErrLog
Dec 05, 2019 1:28:38 PM
INFO: HTTP and HTTP/2 cleartext listening on port: 8080
Dec 05, 2019 1:28:38 PM
INFO: Disabling document root because the specified folder does not exist: \u01\ords\conf\ords\standalone\doc_root
2019-12-05 13:28:42.113:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2019-02-20T15:50:58.683Z; git: 3285c4dd4bb00caddcded77f8e44e72c61b9ab72; jvm 1.8.0_151-b12
2019-12-05 13:28:42.307:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2019-12-05 13:28:42.307:INFO:oejs.session:main: No SessionScavenger set, using defaults
2019-12-05 13:28:42.308:INFO:oejs.session:main: node0 Scavenging every 660000ms
Dec 05, 2019 1:28:43 PM
INFO: Configuration properties for: |your_app_schema||
cache.caching=false
cache.directory=/tmp/apex/cache
cache.duration=days
cache.expiration=7
cache.maxEntries=500
cache.monitorInterval=60
cache.procedureNameList=
cache.type=lru
db.connectionType=customurl
db.customURL=jdbc:oracle:thin:@rasd_medium?TNS_ADMIN=/home/opc/u01/instantclient_19_3_rasd/instantclient_19_3_rasd
db.password=******
db.username=your_app_schema
debug.debugger=true
debug.printDebugToScreen=false
error.externalPath=/u01/ords/conf/ords/error-pages
error.keepErrorMessages=true
error.maxEntries=50
jdbc.DriverType=thin
jdbc.InactivityTimeout=180
jdbc.InitialLimit=1
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=10
jdbc.MaxStatementsLimit=10
jdbc.MinLimit=1
jdbc.statementTimeout=900
log.logging=false
log.maxEntries=50
misc.compress=
misc.defaultPage=!welcome.webclient
resource.templates.enabled=true
security.crypto.enc.password=******
security.crypto.mac.password=******
security.disableDefaultExclusionList=false
security.maxEntries=2000
security.validationFunctionType=plsql

Dec 05, 2019 1:28:43 PM
WARNING: *** jdbc.MaxLimit in configuration |your_app_schema|| is using a value of 10, this setting may not be sized adequately for a production environment ***
Dec 05, 2019 1:28:43 PM
WARNING: *** jdbc.InitialLimit in configuration |your_app_schema|| is using a value of 1, this setting may not be sized adequately for a production environment ***
***
found key for : orakey
chain [0] = { fingerprint = 4f9ddb2c3057dd9c732225316cdb843f, notBefore = Fri Oct 18 21:14:20 GMT 2019, notAfter = Sun Oct 17 21:14:20 GMT 2021, holder = CN=8817DF1CE3224D51B79CA588DF29D22F,DNQ=V1, issuer = C=US,ST=California,L=Redwood Shores,O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA,CN=Autonomous Data Warehouse Cloud CA, serialNo = 0, sigAlgOID = SHA256withRSA, key = { modulus = 16421655703222039104307172358182928905893259615283592973778487728599880655129196720303797023898793771902064358832731600445252402584968906950238761042541370761003304597612845153672698897235415852656234812264403925653905257027399301564004250997783353239087397509075793793705731338922988507942405151452490562356142735469833608452698406644032016589020838291512266691524877256534717695700907206666325916415168832851021620831461779216424938209374688096932919929276672049794980058262451828230861354273634557533077131998900879474672367079240141083316534460151822476931367156271131481767492503588551932307639359874705471646749, exponent = 65537 } }
chain [1] = { fingerprint = 3b402617399d29277049f2c9b8785d5c, notBefore = Tue Mar 20 21:43:22 GMT 2018, notAfter = Sun Mar 19 21:43:22 GMT 2023, holder = C=US,ST=California,L=Redwood Shores,O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA,CN=Autonomous Data Warehouse Cloud CA, issuer = C=US,ST=California,L=Redwood Shores,O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA,CN=Autonomous Data Warehouse Cloud CA, serialNo = 55843902675228620721666414001792414831, sigAlgOID = SHA256withRSA, key = { modulus = 21988985300941462836043273287765596507228743484074803899992652999755111683725754105707881699920503047299647966492431581891631461325921573628686591194743737367602223159238028680115508378642792999570196427643642953346027432141281541053783891226064526484436369719911606245717932237672967606140777769350436193340316845757369471413512753254045195407591793396350853414810858093775899164614638371531977276806269938819428237135937777180427443376523918809898129406775459764074968897928764758579749711111366612010324072011969797602163397417511722937880077399159504107490745530972907275396944622722714231371582591737702253520871, exponent = 65537 } }
***
adding as trusted cert:
   Subject: C=US, ST=California, L=Redwood Shores, O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA, CN=Autonomous Data Warehouse Cloud CA
   Issuer: C=US, ST=California, L=Redwood Shores, O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA, CN=Autonomous Data Warehouse Cloud CA
   Algorithm: RSA; Serial number: 0x2a0324f9d8e745793477e1293252f46f
   Valid from Tue Mar 20 21:43:22 GMT 2018 until Sun Mar 19 21:43:22 GMT 2023

adding as trusted cert:
   Subject: CN=8817DF1CE3224D51B79CA588DF29D22F, DNQ=V1
   Issuer: C=US, ST=California, L=Redwood Shores, O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA, CN=Autonomous Data Warehouse Cloud CA
   Algorithm: RSA; Serial number: 0x0
   Valid from Fri Oct 18 21:14:20 GMT 2019 until Sun Oct 17 21:14:20 GMT 2021

adding as trusted cert:
   Subject: CN=DigiCert Global Root CA, OU=www.digicert.com, O=DigiCert Inc, C=US
   Issuer: CN=DigiCert Global Root CA, OU=www.digicert.com, O=DigiCert Inc, C=US
   Algorithm: RSA; Serial number: 0x83be056904246b1a1756ac95991c74a
   Valid from Fri Nov 10 00:00:00 GMT 2006 until Mon Nov 10 00:00:00 GMT 2031

adding as trusted cert:
   Subject: CN=DigiCert SHA2 Secure Server CA, O=DigiCert Inc, C=US
   Issuer: CN=DigiCert Global Root CA, OU=www.digicert.com, O=DigiCert Inc, C=US
   Algorithm: RSA; Serial number: 0x1fda3eb6eca75c888438b724bcfbc91
   Valid from Fri Mar 08 12:00:00 GMT 2013 until Wed Mar 08 12:00:00 GMT 2023

Ignoring unavailable cipher suite: TLS_DHE_DSS_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_DH_anon_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_DH_anon_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_DHE_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_ECDSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_RSA_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_DHE_DSS_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDH_ECDSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_RSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_ECDSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_anon_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDH_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_DHE_RSA_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_DHE_DSS_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_DHE_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_DH_anon_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_DHE_DSS_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_DHE_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_ECDSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_RSA_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_DHE_DSS_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDH_ECDSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_RSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_ECDSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDH_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_DHE_RSA_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_DHE_DSS_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_DHE_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_DHE_DSS_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_DHE_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_ECDSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_RSA_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_DHE_DSS_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDH_ECDSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_RSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_ECDSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_ECDH_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDH_RSA_WITH_AES_256_GCM_SHA384
Ignoring unavailable cipher suite: TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384
Ignoring unavailable cipher suite: TLS_DHE_RSA_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_DHE_DSS_WITH_AES_256_CBC_SHA256
Ignoring unavailable cipher suite: TLS_DHE_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA
Ignoring unavailable cipher suite: TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
trigger seeding of SecureRandom
done seeding SecureRandom
Using SSLEngineImpl.
Allow unsafe renegotiation: false
Allow legacy hello messages: true
Is initial handshake: true
Is secure renegotiation: false
Ignoring unsupported cipher suite: TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_RSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_DHE_RSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_DHE_DSS_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_RSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_DHE_RSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_DHE_DSS_WITH_AES_128_CBC_SHA256 for TLSv1.1
%% No cached client session
*** ClientHello, TLSv1.2
RandomCookie: GMT: 1558775310 bytes = { 237, 237, 89, 72, 211, 101, 102, 71, 255, 128, 161, 108, 10, 201, 97, 23, 192, 188, 101, 36, 197, 2, 15, 62, 215, 8, 2, 238 }
Session ID: {}
Cipher Suites: [TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256, TLS_RSA_WITH_AES_128_CBC_SHA256, TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256, TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256, TLS_DHE_RSA_WITH_AES_128_CBC_SHA256, TLS_DHE_DSS_WITH_AES_128_CBC_SHA256, TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA, TLS_RSA_WITH_AES_128_CBC_SHA, TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA, TLS_ECDH_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_DSS_WITH_AES_128_CBC_SHA, TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256, TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256, TLS_RSA_WITH_AES_128_GCM_SHA256, TLS_ECDH_ECDSA_WITH_AES_128_GCM_SHA256, TLS_ECDH_RSA_WITH_AES_128_GCM_SHA256, TLS_DHE_RSA_WITH_AES_128_GCM_SHA256, TLS_DHE_DSS_WITH_AES_128_GCM_SHA256, TLS_ECDHE_ECDSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDH_ECDSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDH_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA, TLS_EMPTY_RENEGOTIATION_INFO_SCSV]
Compression Methods: { 0 }
Extension elliptic_curves, curve names: {secp256r1, secp384r1, secp521r1, sect283k1, sect283r1, sect409k1, sect409r1, sect571k1, sect571r1, secp256k1}
Extension ec_point_formats, formats: [uncompressed]
Extension signature_algorithms, signature_algorithms: SHA512withECDSA, SHA512withRSA, SHA384withECDSA, SHA384withRSA, SHA256withECDSA, SHA256withRSA, SHA256withDSA, SHA224withECDSA, SHA224withRSA, SHA224withDSA, SHA1withECDSA, SHA1withRSA, SHA1withDSA
Extension server_name, server_name: [type=host_name (0), value=adb.eu-frankfurt-1.oraclecloud.com]
***
[write] MD5 and SHA1 hashes: len = 210
0000: 01 00 00 CE 03 03 5D E9   06 0E ED ED 59 48 D3 65 ......].....YH.e
0010: 66 47 FF 80 A1 6C 0A C9   61 17 C0 BC 65 24 C5 02 fG...l..a...e$..
0020: 0F 3E D7 08 02 EE 00 00   3A C0 23 C0 27 00 3C C0 .>......:.#.'.<.
0030: 25 C0 29 00 67 00 40 C0   09 C0 13 00 2F C0 04 C0 %.).g.@...../...
0040: 0E 00 33 00 32 C0 2B C0   2F 00 9C C0 2D C0 31 00 ..3.2.+./...-.1.
0050: 9E 00 A2 C0 08 C0 12 00   0A C0 03 C0 0D 00 16 00 ................
0060: 13 00 FF 01 00 00 6B 00   0A 00 16 00 14 00 17 00 ......k.........
0070: 18 00 19 00 09 00 0A 00   0B 00 0C 00 0D 00 0E 00 ................
0080: 16 00 0B 00 02 01 00 00   0D 00 1C 00 1A 06 03 06 ................
0090: 01 05 03 05 01 04 03 04   01 04 02 03 03 03 01 03 ................
00A0: 02 02 03 02 01 02 02 00   00 00 27 00 25 00 00 22 ..........'.%.."
00B0: 61 64 62 2E 65 75 2D 66   72 61 6E 6B 66 75 72 74 adb.eu-frankfurt
00C0: 2D 31 2E 6F 72 61 63 6C   65 63 6C 6F 75 64 2E 63 -1.oraclecloud.c
00D0: 6F 6D                                              om
main, WRITE: TLSv1.2 Handshake, length = 210
[Raw write]: length = 215
0000: 16 03 03 00 D2 01 00 00   CE 03 03 5D E9 06 0E ED ...........]....
0010: ED 59 48 D3 65 66 47 FF   80 A1 6C 0A C9 61 17 C0 .YH.efG...l..a..
0020: BC 65 24 C5 02 0F 3E D7   08 02 EE 00 00 3A C0 23 .e$...>......:.#
0030: C0 27 00 3C C0 25 C0 29   00 67 00 40 C0 09 C0 13 .'.<.%.).g.@....
0040: 00 2F C0 04 C0 0E 00 33   00 32 C0 2B C0 2F 00 9C ./.....3.2.+./..
0050: C0 2D C0 31 00 9E 00 A2   C0 08 C0 12 00 0A C0 03 .-.1............
0060: C0 0D 00 16 00 13 00 FF   01 00 00 6B 00 0A 00 16 ...........k....
0070: 00 14 00 17 00 18 00 19   00 09 00 0A 00 0B 00 0C ................
0080: 00 0D 00 0E 00 16 00 0B   00 02 01 00 00 0D 00 1C ................
0090: 00 1A 06 03 06 01 05 03   05 01 04 03 04 01 04 02 ................
00A0: 03 03 03 01 03 02 02 03   02 01 02 02 00 00 00 27 ...............'
00B0: 00 25 00 00 22 61 64 62   2E 65 75 2D 66 72 61 6E .%.."adb.eu-fran
00C0: 6B 66 75 72 74 2D 31 2E   6F 72 61 63 6C 65 63 6C kfurt-1.oraclecl
00D0: 6F 75 64 2E 63 6F 6D                               oud.com
[Raw read]: length = 5
0000: 15 03 03 00 02                                     .....
[Raw read]: length = 2
0000: 02 28                                              .(
main, READ: TLSv1.2 Alert, length = 2
main, RECV TLSv1.2 ALERT: fatal, handshake_failure
main, fatal: engine already closed. Rethrowing javax.net.ssl.SSLException: Received fatal alert: handshake_failure
main, fatal: engine already closed. Rethrowing javax.net.ssl.SSLException: Received fatal alert: handshake_failure
main, called closeOutbound()
main, closeOutboundInternal()
main, SEND TLSv1.2 ALERT: warning, description = close_notify
main, WRITE: TLSv1.2 Alert, length = 2
[Raw write]: length = 7
0000: 15 03 03 00 02 01 00                               .......
***
found key for : orakey
chain [0] = { fingerprint = 4f9ddb2c3057dd9c732225316cdb843f, notBefore = Fri Oct 18 21:14:20 GMT 2019, notAfter = Sun Oct 17 21:14:20 GMT 2021, holder = CN=8817DF1CE3224D51B79CA588DF29D22F,DNQ=V1, issuer = C=US,ST=California,L=Redwood Shores,O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA,CN=Autonomous Data Warehouse Cloud CA, serialNo = 0, sigAlgOID = SHA256withRSA, key = { modulus = 16421655703222039104307172358182928905893259615283592973778487728599880655129196720303797023898793771902064358832731600445252402584968906950238761042541370761003304597612845153672698897235415852656234812264403925653905257027399301564004250997783353239087397509075793793705731338922988507942405151452490562356142735469833608452698406644032016589020838291512266691524877256534717695700907206666325916415168832851021620831461779216424938209374688096932919929276672049794980058262451828230861354273634557533077131998900879474672367079240141083316534460151822476931367156271131481767492503588551932307639359874705471646749, exponent = 65537 } }
chain [1] = { fingerprint = 3b402617399d29277049f2c9b8785d5c, notBefore = Tue Mar 20 21:43:22 GMT 2018, notAfter = Sun Mar 19 21:43:22 GMT 2023, holder = C=US,ST=California,L=Redwood Shores,O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA,CN=Autonomous Data Warehouse Cloud CA, issuer = C=US,ST=California,L=Redwood Shores,O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA,CN=Autonomous Data Warehouse Cloud CA, serialNo = 55843902675228620721666414001792414831, sigAlgOID = SHA256withRSA, key = { modulus = 21988985300941462836043273287765596507228743484074803899992652999755111683725754105707881699920503047299647966492431581891631461325921573628686591194743737367602223159238028680115508378642792999570196427643642953346027432141281541053783891226064526484436369719911606245717932237672967606140777769350436193340316845757369471413512753254045195407591793396350853414810858093775899164614638371531977276806269938819428237135937777180427443376523918809898129406775459764074968897928764758579749711111366612010324072011969797602163397417511722937880077399159504107490745530972907275396944622722714231371582591737702253520871, exponent = 65537 } }
***
adding as trusted cert:
   Subject: C=US, ST=California, L=Redwood Shores, O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA, CN=Autonomous Data Warehouse Cloud CA
   Issuer: C=US, ST=California, L=Redwood Shores, O=Oracle Corporation Autonomous Data Warehouse Cloud Self-signed CA, CN=Autonomous Data Warehouse Cloud CA
   Algorithm: RSA; Serial number: 0x2a0324f9d8e745793477e1293252f46f
   Valid from Tue Mar 20 21:43:22 GMT 2018 until Sun Mar 19 21:43:22 GMT 2023

trigger seeding of SecureRandom
done seeding SecureRandom
Using SSLEngineImpl.
Allow unsafe renegotiation: false
Allow legacy hello messages: true
Is initial handshake: true
Is secure renegotiation: false
Ignoring unsupported cipher suite: TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_RSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_DHE_RSA_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_DHE_DSS_WITH_AES_128_CBC_SHA256 for TLSv1
Ignoring unsupported cipher suite: TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_RSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_DHE_RSA_WITH_AES_128_CBC_SHA256 for TLSv1.1
Ignoring unsupported cipher suite: TLS_DHE_DSS_WITH_AES_128_CBC_SHA256 for TLSv1.1
%% No cached client session
*** ClientHello, TLSv1.2
RandomCookie: GMT: 1558775311 bytes = { 255, 134, 101, 199, 95, 243, 249, 239, 33, 210, 206, 36, 62, 96, 55, 79, 129, 7, 87, 217, 20, 83, 224, 4, 77, 15, 91, 225 }
Session ID: {}
Cipher Suites: [TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256, TLS_RSA_WITH_AES_128_CBC_SHA256, TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256, TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256, TLS_DHE_RSA_WITH_AES_128_CBC_SHA256, TLS_DHE_DSS_WITH_AES_128_CBC_SHA256, TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA, TLS_RSA_WITH_AES_128_CBC_SHA, TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA, TLS_ECDH_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_DSS_WITH_AES_128_CBC_SHA, TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256, TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256, TLS_RSA_WITH_AES_128_GCM_SHA256, TLS_ECDH_ECDSA_WITH_AES_128_GCM_SHA256, TLS_ECDH_RSA_WITH_AES_128_GCM_SHA256, TLS_DHE_RSA_WITH_AES_128_GCM_SHA256, TLS_DHE_DSS_WITH_AES_128_GCM_SHA256, TLS_ECDHE_ECDSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDH_ECDSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDH_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA, TLS_EMPTY_RENEGOTIATION_INFO_SCSV]
Compression Methods: { 0 }
Extension elliptic_curves, curve names: {secp256r1, secp384r1, secp521r1, sect283k1, sect283r1, sect409k1, sect409r1, sect571k1, sect571r1, secp256k1}
Extension ec_point_formats, formats: [uncompressed]
Extension signature_algorithms, signature_algorithms: SHA512withECDSA, SHA512withRSA, SHA384withECDSA, SHA384withRSA, SHA256withECDSA, SHA256withRSA, SHA256withDSA, SHA224withECDSA, SHA224withRSA, SHA224withDSA, SHA1withECDSA, SHA1withRSA, SHA1withDSA
Extension server_name, server_name: [type=host_name (0), value=adb.eu-frankfurt-1.oraclecloud.com]
***
[write] MD5 and SHA1 hashes: len = 210
0000: 01 00 00 CE 03 03 5D E9   06 0F FF 86 65 C7 5F F3 ......].....e._.
0010: F9 EF 21 D2 CE 24 3E 60   37 4F 81 07 57 D9 14 53 ..!..$>`7O..W..S
0020: E0 04 4D 0F 5B E1 00 00   3A C0 23 C0 27 00 3C C0 ..M.[...:.#.'.<.
0030: 25 C0 29 00 67 00 40 C0   09 C0 13 00 2F C0 04 C0 %.).g.@...../...
0040: 0E 00 33 00 32 C0 2B C0   2F 00 9C C0 2D C0 31 00 ..3.2.+./...-.1.
0050: 9E 00 A2 C0 08 C0 12 00   0A C0 03 C0 0D 00 16 00 ................
0060: 13 00 FF 01 00 00 6B 00   0A 00 16 00 14 00 17 00 ......k.........
0070: 18 00 19 00 09 00 0A 00   0B 00 0C 00 0D 00 0E 00 ................
0080: 16 00 0B 00 02 01 00 00   0D 00 1C 00 1A 06 03 06 ................
0090: 01 05 03 05 01 04 03 04   01 04 02 03 03 03 01 03 ................
00A0: 02 02 03 02 01 02 02 00   00 00 27 00 25 00 00 22 ..........'.%.."
00B0: 61 64 62 2E 65 75 2D 66   72 61 6E 6B 66 75 72 74 adb.eu-frankfurt
00C0: 2D 31 2E 6F 72 61 63 6C   65 63 6C 6F 75 64 2E 63 -1.oraclecloud.c
00D0: 6F 6D                                              om
main, WRITE: TLSv1.2 Handshake, length = 210
[Raw write]: length = 215
0000: 16 03 03 00 D2 01 00 00   CE 03 03 5D E9 06 0F FF ...........]....
0010: 86 65 C7 5F F3 F9 EF 21   D2 CE 24 3E 60 37 4F 81 .e._...!..$>`7O.
0020: 07 57 D9 14 53 E0 04 4D   0F 5B E1 00 00 3A C0 23 .W..S..M.[...:.#
0030: C0 27 00 3C C0 25 C0 29   00 67 00 40 C0 09 C0 13 .'.<.%.).g.@....
0040: 00 2F C0 04 C0 0E 00 33   00 32 C0 2B C0 2F 00 9C ./.....3.2.+./..
0050: C0 2D C0 31 00 9E 00 A2   C0 08 C0 12 00 0A C0 03 .-.1............
0060: C0 0D 00 16 00 13 00 FF   01 00 00 6B 00 0A 00 16 ...........k....
0070: 00 14 00 17 00 18 00 19   00 09 00 0A 00 0B 00 0C ................
0080: 00 0D 00 0E 00 16 00 0B   00 02 01 00 00 0D 00 1C ................
0090: 00 1A 06 03 06 01 05 03   05 01 04 03 04 01 04 02 ................
00A0: 03 03 03 01 03 02 02 03   02 01 02 02 00 00 00 27 ...............'
00B0: 00 25 00 00 22 61 64 62   2E 65 75 2D 66 72 61 6E .%.."adb.eu-fran
00C0: 6B 66 75 72 74 2D 31 2E   6F 72 61 63 6C 65 63 6C kfurt-1.oraclecl
00D0: 6F 75 64 2E 63 6F 6D                               oud.com
[Raw read]: length = 5
0000: 15 03 03 00 02                                     .....
[Raw read]: length = 2
0000: 02 28                                              .(
main, READ: TLSv1.2 Alert, length = 2
main, RECV TLSv1.2 ALERT: fatal, handshake_failure
main, fatal: engine already closed. Rethrowing javax.net.ssl.SSLException: Received fatal alert: handshake_failure
main, fatal: engine already closed. Rethrowing javax.net.ssl.SSLException: Received fatal alert: handshake_failure
main, called closeOutbound()
main, closeOutboundInternal()
main, SEND TLSv1.2 ALERT: warning, description = close_notify
main, WRITE: TLSv1.2 Alert, length = 2
[Raw write]: length = 7
0000: 15 03 03 00 02 01 00                               .......
Dec 05, 2019 1:28:47 PM
WARNING: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: IO Error Received fatal alert: handshake_failure, Authentication lapse 0 ms.
java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: IO Error Received fatal alert: handshake_failure, Authentication lapse 0 ms.
         at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)
         at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)
         at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:944)
         at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1979)
         at oracle.ucp.jdbc.PoolDataSourceImpl.access$500(PoolDataSourceImpl.java:199)
         at oracle.ucp.jdbc.PoolDataSourceImpl$30.build(PoolDataSourceImpl.java:4438)
         at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1935)
         at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1898)
         at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1883)
         at oracle.dbtools.common.config.db.ConfiguredPoolDataSourceImplLoader.load(ConfiguredPoolDataSourceImplLoader.java:150)
         at oracle.dbtools.common.config.db.ConfiguredPoolDataSourceLoaderImpl.load(ConfiguredPoolDataSourceLoaderImpl.java:16)
         at oracle.dbtools.common.config.db.RefreshablePoolDataSourceFactory.load(RefreshablePoolDataSourceFactory.java:28)
         at oracle.dbtools.common.config.db.DatabasePoolLoader.load(DatabasePoolLoader.java:34)
         at oracle.dbtools.common.config.db.DatabasePoolLoader.load(DatabasePoolLoader.java:7)
         at oracle.dbtools.common.config.db.ConfiguredPoolDataSourceLoader.load(ConfiguredPoolDataSourceLoader.java:39)
         at oracle.dbtools.common.config.db.DatabasePoolLoader.load(DatabasePoolLoader.java:42)
         at oracle.dbtools.common.config.db.DatabasePoolLoader.load(DatabasePoolLoader.java:7)
         at oracle.dbtools.common.config.db.RefreshablePoolDataSources$PoolFromDataSourceIdentifierLoader.call(RefreshablePoolDataSources.java:144)
         at oracle.dbtools.common.config.db.RefreshablePoolDataSources$PoolFromDataSourceIdentifierLoader.call(RefreshablePoolDataSources.java:133)
         at oracle.dbtools.common.functions.Functions$3.get(Functions.java:41)
         at oracle.dbtools.common.functions.MaybeValidImpl.load(MaybeValidImpl.java:215)
         at oracle.dbtools.common.functions.MaybeValidImpl.<init>(MaybeValidImpl.java:20)
         at oracle.dbtools.common.functions.MaybeValidImpl.<init>(MaybeValidImpl.java:14)
         at oracle.dbtools.common.functions.MaybeValidImpl$LoaderImpl.load(MaybeValidImpl.java:280)
         at oracle.dbtools.common.functions.MaybeValidCache$MaybeValidCacheLoader.call(MaybeValidCache.java:329)
         at oracle.dbtools.common.functions.MaybeValidCache$MaybeValidCacheLoader.call(MaybeValidCache.java:318)
         at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4876)
         at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3528)
         at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2277)
         at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2154)
         at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2044)
         at com.google.common.cache.LocalCache.get(LocalCache.java:3952)
         at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4871)
         at oracle.dbtools.common.functions.MaybeValidCache.get(MaybeValidCache.java:87)
         at oracle.dbtools.common.config.db.RefreshablePoolDataSources.pool(RefreshablePoolDataSources.java:69)
         at oracle.dbtools.common.config.db.DatabasePools.pool(DatabasePools.java:242)
         at oracle.dbtools.common.config.db.DatabasePools.validity(DatabasePools.java:207)
         at oracle.dbtools.common.config.db.DataSourceIdentifiers.lambda$validity$0(DataSourceIdentifiers.java:36)
         at oracle.dbtools.common.functions.MaybeValidImpl.load(MaybeValidImpl.java:215)
         at oracle.dbtools.common.functions.MaybeValidImpl.<init>(MaybeValidImpl.java:20)
         at oracle.dbtools.common.functions.MaybeValidImpl.<init>(MaybeValidImpl.java:14)
         at oracle.dbtools.common.functions.MaybeValidImpl$LoaderImpl.load(MaybeValidImpl.java:280)
         at oracle.dbtools.common.functions.MaybeValidImpl$LoaderImpl.load(MaybeValidImpl.java:250)
         at oracle.dbtools.common.config.db.DataSourceIdentifiers.validity(DataSourceIdentifiers.java:53)
         at oracle.dbtools.common.config.db.DataSourceValidation.startup(DataSourceValidation.java:44)
         at oracle.dbtools.common.app.PluginLifeCycles.startup(PluginLifeCycles.java:39)
         at oracle.dbtools.common.app.ApplicationContext.<init>(ApplicationContext.java:82)
         at oracle.dbtools.common.app.ApplicationContext.<init>(ApplicationContext.java:50)
         at oracle.dbtools.entrypoint.WebApplicationEntryPoint.contextInitialized(WebApplicationEntryPoint.java:90)
         at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:957)
         at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:552)
         at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:922)
         at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:364)
         at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:852)
         at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:278)
         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
         at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:138)
         at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117)
         at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
         at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:168)
         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
         at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:138)
         at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117)
         at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
         at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:138)
         at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:108)
         at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
         at org.eclipse.jetty.server.handler.StatisticsHandler.doStart(StatisticsHandler.java:256)
         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
         at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:138)
         at org.eclipse.jetty.server.Server.start(Server.java:415)
         at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:108)
         at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
         at org.eclipse.jetty.server.Server.doStart(Server.java:382)
         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
         at oracle.dbtools.standalone.StandaloneConfiguration.start(StandaloneConfiguration.java:279)
         at oracle.dbtools.standalone.Standalone.execute(Standalone.java:508)
         at oracle.dbtools.cmdline.Commands.execute(Commands.java:202)
         at oracle.dbtools.cmdline.Commands.main(Commands.java:184)
         at oracle.dbtools.cmdline.Commands.main(Commands.java:372)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:498)
         at oracle.dbtools.jarcl.Entrypoint.invoke(Entrypoint.java:66)
         at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:77)
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: IO Error Received fatal alert: handshake_failure, Authentication lapse 0 ms.
         at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
         at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59)
         at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:134)
         at oracle.ucp.common.Database.createPooledConnection(Database.java:256)
         at oracle.ucp.common.Topology.start(Topology.java:242)
         at oracle.ucp.common.Core.start(Core.java:2272)
         at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:669)
         at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129)
         at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:940)
         ... 84 more
Caused by: java.sql.SQLRecoverableException: IO Error: IO Error Received fatal alert: handshake_failure, Authentication lapse 0 ms.
         at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:821)
         at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:782)
         at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
         at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:390)
         at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:279)
         at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1659)
         at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1653)
         at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:103)
         ... 90 more
Caused by: java.io.IOException: IO Error Received fatal alert: handshake_failure, Authentication lapse 0 ms.
         at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:817)
         ... 98 more
Caused by: java.io.IOException: IO Error Received fatal alert: handshake_failure
         at oracle.net.nt.SSLSocketChannel.unwrap(SSLSocketChannel.java:528)
         at oracle.net.nt.SSLSocketChannel.unwrapHandshakeMessage(SSLSocketChannel.java:487)
         at oracle.net.nt.SSLSocketChannel.doSSLHandshake(SSLSocketChannel.java:436)
         at oracle.net.nt.SSLSocketChannel.write(SSLSocketChannel.java:126)
         at oracle.net.ns.NIOPacket.writeToSocketChannel(NIOPacket.java:308)
         at oracle.net.ns.NIOConnectPacket.writeToSocketChannel(NIOConnectPacket.java:235)
         at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:114)
         at oracle.net.ns.NSProtocol.connect(NSProtocol.java:318)
         at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1481)
         at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:540)
         ... 98 more
Caused by: javax.net.ssl.SSLException: Received fatal alert: handshake_failure
         at sun.security.ssl.Alerts.getSSLException(Alerts.java:208)
         at sun.security.ssl.SSLEngineImpl.fatal(SSLEngineImpl.java:1666)
         at sun.security.ssl.SSLEngineImpl.fatal(SSLEngineImpl.java:1634)
         at sun.security.ssl.SSLEngineImpl.recvAlert(SSLEngineImpl.java:1800)
         at sun.security.ssl.SSLEngineImpl.readRecord(SSLEngineImpl.java:1083)
         at sun.security.ssl.SSLEngineImpl.readNetRecord(SSLEngineImpl.java:907)
         at sun.security.ssl.SSLEngineImpl.unwrap(SSLEngineImpl.java:781)
         at javax.net.ssl.SSLEngine.unwrap(SSLEngine.java:624)
         at oracle.net.nt.SSLSocketChannel.unwrap(SSLSocketChannel.java:524)
         ... 107 more

Dec 05, 2019 1:28:47 PM
WARNING: The pool named: |your_app_schema|| is invalid and will be ignored: null
Dec 05, 2019 1:28:47 PM
INFO: Oracle REST Data Services initialized
Oracle REST Data Services version : 19.1.0.r0921545
Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT

2019-12-05 13:28:47.996:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@27efef64{/ords,null,AVAILABLE}
2019-12-05 13:28:48.006:INFO:oejs.AbstractConnector:main: Started ServerConnector@6a400542{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}
2019-12-05 13:28:48.006:INFO:oejs.Server:main: Started @16862ms
^C2019-12-05 13:29:13.190:INFO:oejs.AbstractConnector:Thread-2: Stopped ServerConnector@6a400542{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}
2019-12-05 13:29:13.190:INFO:oejs.session:Thread-2: node0 Stopped scavenging
2019-12-05 13:29:13.197:INFO:oejsh.ContextHandler:Thread-2: Stopped o.e.j.s.ServletContextHandler@27efef64{/ords,null,UNAVAILABLE}

This post has been answered by thatJeffSmith-Oracle on Dec 12 2019

Jump to Answer

Processing

Added on Dec 11 2019

9 comments

1,331 views

ORDS, SODA & JSON in the Database

Standalone ORDS and Autonomous Database on Oracle Cloud

Comments

Post Details